BI USEFUL TABLES

Customer Info objects Tables

/BIC/M - View of Master data Tables
/BIC/P - Master data Table, Time Independent attributes
/BIC/Q - Master data Table, Time Dependent attributes
/BIC/X - SID Table, Time Independent
/BIC/Y - SID Tabel, Time Dependent
/BIC/T - Text Table
/BIC/H - Hierarchy Table
/BIC/K - Hierarchy SID Table

Standard Info objects Tables (Business Content):

Replace "C" with "0" in above tables.
Ex: /BI0/M - View of Master data Tables

Standard Infocube Tables :

/BI0/F - Fact Table(Before Compression)
/BI0/E - Fact Table(After Compression)
/BI0/P - Dimension Table - Data Package
/BI0/T - Dimension Table - Time
/BI0/U - Dimension Table - Unit
/BI0/1, 2, 3, .......A,B,C,D : - Dimension Tables

BW Tables:

BTCEVTJOB - To check List of jobs waiting for events
ROOSOURCE - Control parameters for Data source
ROOSFIELD - Control parameters for Data source
ROOSPRMSC - Control parameters for Data source
ROOSPRMSF - Control parameters for Data source
RSOLTPSOURCE - Replicate Table for OLTP source in BW
RSDMDELTA - Data mart Delta Management
RSSDLINITSEL, RSSDLINITDEL - Last valid Initialization to an OLTP Source 
RSUPDINFO - Infocube to Info source correlation 
RSUPDDAT - Update rules key figures 
RSUPDENQ - Removal of locks in the update rules 
RSUPDFORM - BW: Update Rules - Formulas - Checking Table 
RSUPDINFO - Update info (status and program) 
RSUPDKEY - Update rule: Key per key figure 
RSUPDROUT - Update rules - ABAP routine - check table 
RSUPDSIMULD - Table for saving simulation data update 
RSUPDSIMULH - Table for saving simulation data header information
RSDCUBEIOBJ - Info objects per Infocube
RSIS – Info source Info
RSUPDINFO - Update Rules Info
RSTS - Transfer Rules Info
RSKSFIELD - Communication Structure fields
RSALLOWEDCHAR - Special Characters Table(T Code : RSKC, To maintain)
RSDLPSEL - Selection Table for fields scheduler(Info package's)
RSDLPIO - Log data packet number
RSMONICTAB - Monitor, Data Targets(Infocube/ODS) Table, request related info
RSTSODS - Operational data store for Transfer structure
RSZELTDIR - Query Elements
RSZGLOBV - BEx Variables
RXSELTXREF, RSCOMPDIR - Reports/query relevant tables
RSCUSTV - Query settings
RSDIOBJ – Info objects 
RSLDPSEL - Selection table for fields scheduler(Info package list)
RSMONIPTAB – Info Package for the monitor
RSRWORKBOOK - Workbooks & related query genuine id's
RSRREPDIR - Contains Genuine id, Report Name, Author, etc...
RSRINDEXT - Workbook ID & Name
RSREQDONE - Monitor: Saving of the QM entries
RSSELDONE - Monitor : Selection for expected requests
RSLDTDONE - Texts on the requested info packages & groups
RSUICDONE - BIW: Selection table for user-selection update Infocubes
RSSDBATCH - Table for Batch run scheduler
RSLDPDEL - Selection table for deleting with full update scheduler
RSADMINSV - RS Administration 
RSSDLINIT - Last Valid Initializations to an OLTP Source
BTCEVTJOB -To check event status(scheduled or not)
VARI - ABAP Variant related Table
VARIDESC - Selection Variants: Description
SMQ1 - QRFC Monitor(Out Bound)
SM13 - Update Records status

T Code : LBWQ -> QRFC related Tables

TRFCQOUT,
QREFTID,
ARFCSDATA


Want to learn SAP from Experts? - Archon Solutions

Best SAP training in Kerala

Best SAP training in Kochi

Best SAP training in Ernakulam

SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana