CRM Tables

CRM Tables

Tables	Description
CRMD_ORDERADM_H	Business Transaction - Header
CRMD_ORDERADM_I	Business Transaction - Item
CRMD_SERVICE_H	Service Process
CRMD_SERVICE_I	Transaction Item - Service
CRMD_CUSTOMER_H	Transaction - Customer Extension
CRMD_CUSTOMER_I	Transaction Item - Customer Extension
CRM_JEST	Individual Object Status
CRM_JCDS	Change Documents for System/User Statuses (Table JEST)

BW Tables

BW Tables

Tables	Description	Tables	Description
AGR_USERS	Assignment of roles to users	RSTS	Table for transfer structures
BTCUEV	User event IDs for background processing	RSLDPIO	Links datasource to infopackages
DD03M	Table fields with data elements, text, and domains	RSLDPIOT	InfoPackage Text Description
E070	Change & Transport System: Header of Requests/Tasks	RSLDPRULE	ABAP source code for InfoPackages
E07T	Change & Transport System: Short Texts for Requests/Tasks	RSLDPSEL	Hardcoded selections in InfoPackages
ROOSFIELD	DataSource Fields	RSMONICDP	Contains the request-id number by data target
RSAABAP	ABAP routine - source code; - CODEID = Enter in Start Routine/End/Expert/Global Rouintes in table RSTRAN	RSPAKPOS	List of InfoPackage Groups / InfoPackages
RSADMINC	Customizing Table General BW	RSSELDONE	InfoPackage selection and job program
RSANT_PROCESSI	Analysis Process TLOGO Index ( APD DSO relation )	RSZELTTXT	Bex Description Table
RSBKDTP	BW: Data Transfer Process Header Data	RSRREPDIR	Directory of all BEX reports
RSBKREQUEST	DTP Request	RSLDPIO	Infopackage / Datasource link
RSDCHABAS	InfoObject details : Basic characteristics (for chars, time-chars and units)	RSBODSLOGSTATE	Changelog Status for ODS Object
RSDODSO	All details of the DSO	RSBODSLOG	Requests in ODS Changelog
RSECVAL	Authorization Value Status	RSBASIDOC	List of Source systems
RSHIEDIRT	Hierarchy Catalog	RSDIOBCIOBJ	InfoObject Catalog
RSHIEDIRT	Hierarchy directory texts	RSZELTXREF	Directory of query element references. If you give the query element ID, it gives the source / Infoprovider information
RSICCONT	Monitor: Saving of the updated IC and ODS per request (Search the request in RSICCONT table and delete the entry from the table. Automatically your request will be deleted from DSO)	SRT_CFG_DEF_ASGN	Assignment of Default LP Name to Proxy Class for WS Client
RSISOSMAP	Mapping Between InfoSources and OLTP Sources	RSQISET	Infosets
RSLDPIO	Log.data packet: No.	TVARVC	Maintain variable values - Use Tcodes STVARV / STVARVC for maintaining values When adding entries, click on "Include changed entries in a transport" check box on the top to collect it in a transport
RSLDPSEL	Selection table for fields scheduler	RSSTATMANPSA	Store for G_T_PART of Request Display in DTA Administration( DMFLAG gives if a specific request is loaded to PSA )
RSOLTPSOURCE	Transfer structure table	DEVACCESS	Table for development user - Has Access codes / Access Key
RSOSSEGMAP	Mappings between infosouece and systems	RSADMINA	Control Table That Customer Can Change - Contains information of system user ( BWREMOTE ) - Maintenance View : RSADMIN
RSPCCHAIN	Process chain	THOL	Public Holidays / THOLT - Texts /
RSPCVARIANT	Generic Variant-Storage of Process Chains	THOLU	Dates of movable public holidays
RSREQDONE	Monitor: Saving of the QM entries (infopak details) PSA Request Status	ROOSGEN	Generated Objects for OLTP Source | Contains datasources in that specific Source system
RSRPARAMETRIZA	Parametrization for a query, workbook, webapplication, pla	RSREQICODS	Monitor: Saving of the updated IC and ODS per request - DSO requests table
RSTSODSREQUEST	Request directory ODS; which request is in which ODS	RSDDAGGRMODSTATE	Status of change run for aggregates - Give the Run number ( can be found in process chain log of ACT ) in CNSID and CLOSEDFL will give status
RSTRAN	Information on Transformations	RSLOGSYSMAP	Mapping of logical systems fir transport of InfoSources
RSUPDROUT	Update rules - ABAP routine - check table	rsdsseg	DataSource - Segments - Has PSA table name of the datasource
RSZELTDIR	Directory of the reporting component elements ( Gives the relation between transport element and the query. Useful when a TR fails with multiple queries. Can look for the object failed over here to get the corresponding Query )	SEOCOMPO	BADI Class/Interface component
TADIR	Directory of Repository Objects	TTZD / TTZDV	Summer time rules (variable dates) - Day light savings tables - Available in BW and Source systems
RSDIOBJ	Directory of all InfoObjects	RSSDLINIT	Last Valid Initializations to an OLTP Source - Delta
RSODSSETTINGS	Settings for an ODS - DSO	RSMDATASTATE_EXT	Additional Summation Status of Data in Data Targets | Total Count of Requests
SXC_CLASS	Exit, implementation side: Class assignment (multiple) - BADI Implementation Name Interface Classes	RSPCCHAIN_SKIP	Skipped processes | This chain will have all the entries where 'skip process' option is used in the PC. 'TO BE SKIPPED' field will be 'X' for active ones.
RSPCPROCESSLOG	Logs for the Chain Runs	BALDAT	Application Log: Log data Jobs running for very long - One reason might be lock on this table

SAP ECC functional tables

Customer Material Information(CMIR):

KNMTK - Customer Material Information: Header

KNMT - Customer Material Information: Item

Bill of Materials (BOM):

MAST - Material

EQST - Equipment

KDST u2013 Sales Order

DOST - Document

STST - Standard Object

TPST u2013 Functional location

STKO u2013 BOM: Header

STZU u2013 STL data

STAS u2013 BOM: Item selection

STOP u2013 BOM: Item data

STPU u2013 BOM: Sub items

Sales Activities & Sales Document (Header):

VBUK u2013 Header Status / Admin data

VBUV u2013 Incompletion log

VBPA u2013 Partner functions

SADR - Address

VBFA u2013 Document flow

VBAK u2013 Sales document: header

VBKD u2013 Sales document: Business data

VAKPA u2013 Partner index

VEDA - Contract

VBKA u2013 Sales Activity document

NAST u2013 Output

JSTO u2013 PP Status

STXH u2013 Text: header

STXL u2013 Text: Lines

Sales document (Item):

VBUP u2013 Item status

VBAP - Sales document: Item data

VBKD - Sales document: Business data

VEBA - Contract

VBLB u2013 Forecast

VBEP - Sales document: Schedule line

VBBE u2013 Individual requirement

VBBS u2013 Summary requirements

VBUV u2013 Incompletion log

VBFA u2013 Document flow

VBPA u2013 Partner functions

JSTO u2013 PP Status

NAST u2013 Output

STXH u2013 Text: Header

STXL u2013 Text: Lines

KONV u2013 Conditions

General:

AGR_USERS - Assignment of roles to users

CDHDR & CDPOS - Change history of master data and documents

TSTC - SAP Transaction Codes, maintained via transaction sm01

NAST - Message status

Shipping:

LIKP - delivery header

LIPS - Delivery item

LINK - inventory document header (WM)

LINP - inventory document item (WM)

VTTK - shipment header

VTTP - shipment item

VTTS - Stage of shipment

VTFA - shipment document flow

VTPA - shipping partner

LTAK - transfer order header

LTAP - transfer order item

VEKP - handling unit header

VEPO - handling unit item

Billing Document:

  VBRK   Billing Document Header

  VBRP   Billing Document Item

ECC Tables

ECC Operational Tables

Tables	Description	Tables	Description
CDHDR	Change document header ( Any changes to the document will be documented over here )	RODELTAM	Gives Delta properties for different deltas
CDPOS	Change document items	ROIDOCPRMS	Control parameters for data transfer from the source system - IDOC Configuration
BDCP	Change pointer Table	ROOSSHORTN	DataSource Short Name
BDCP2	Aggregated Change Pointers (BDCP, BDCPS) - Master data delta changes	ROOSPRMSC	Control Parameter Per DataSource Channel - Delta Initialisations
SEOCOMPO	Gives the list of all BADI implementations(Classes) and corresponding methods	TRFCQOUT	tRFC Queue Description (Outbound Queue) - SMQ1
ROOSGENDLM	Generic Delta Management for DataSources ( Gives details of when the last delta was run)	ARFCSSTATE	Description of ARFC Call Status (Send) - SAP Note 378903
TMCEXACT	LO Data Extraction: Activate Data Sources/Update ( When activating new LIS datasource check for inconsistencies.)	CLBW_SOURCES	Data Sources for Classification Data
TCDOB/T	Objects for change document creation
TRFCQOUT	tRFC Queue Description (Outbound Queue)
BWOM_SETTINGS	BW CO-OM: Control Data : This table has all FI related control parameters https://blogs.sap.com/2013/04/02/bwomsettings-for-fi-loads-in-sap-bi/
BWOM2_TIMEST	BW CO-OM: Timestamp Table for Delta Extraction
BWFIAA_AEDAT_AS	FIAA-BW: New and Modified Master Records for Delta Upload
.
.
.
.
.
.
.
.
.

Functional Tables

Tables	Description	Tables	Description
BKPF
BSEG
FAGLFLEXA	General Ledger: Actual Line Items
KNA1	Customer General Data	KNB1	Customer Master u2013 Co. Code Data (payment method, reconciliation acct)
KNB4	Customer Payment History	KNB5	Customer Master u2013 Dunning info
KNBK	Customer Master Bank Data	KNKA	Customer Master Credit Mgmt.
KNKK	Customer Master Credit Control Area Data (credit limits)	KNVV	Sales Area Data (terms, order probability)
KNVI	Customer Master Tax Indicator	KNVP	Customer Partner Function key
KNVD	Output type	KNVS	Customer Master Ship Data
KLPA	Customer/Vendor Link	MARA	Material Master: General
MAKT	Material Master: Short description	MARM	MM Conversion factors
MVKE	Sales <Sales Org, Distr Ch>	MLAN	MM Sales <Country>
MAEX	MM Export Licenses	MARC	Material Plant
MBEW	MM Valuation	MLGN	MM WM Inventory
MLGT	WM Inventory type	MVER	MM Consumption Plant
DVER	MM Consumption MRP Area	MAPR	MM Forecast
MARD	MM Storage Location	MCH1	MM X Plant Batches
MCHA	MM Batches	MCHB	MM Batch Stock
MARCH	MM C Segment : History	MARDH	MM Storage Location Segment History
MBEWH	Material Valuation History	MCHBH	Batch Stocks : History
MKOLH	Special Stocks from Vendor : History	MSCAH	Sales Order Stock at Vendor: History
MSKAH	Sales Order Stock: History	MSKUH	Special Stocks at Customer: History
MSLBH	Special Stocks at Vendor: History	MSPRH	Project Stock: History
MSSAH	Total Sales Order Stocks: History	MSSQH	Total Project Stocks: History
AUFK	Order master data	VBPA	Sales Partner Functions
ADR6	E-Mail Addresses (Business Address Services) Email	VBPA2	Sales document: Partner (used several times)
FPLTC	Payment cards: Transaction data - SD Sales	AEOI	ECH: Object Management Records for Change Master - Change Records - Revisions
AENR	Change Master	NACH	Detailed output data / output Conditions TCode : VV31/32/33
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.