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