SAP R/3 BW Source and SID Table

R/3 Source Table.field - How To Find?
What is the quickest way to find the R/3 source table and field name for a field appearing on the BW InfoSource?

By: Sahil

With some ABAP-knowledge you can find some info: 

1, Start ST05 (SQL-trace) in R/3 
2, Start RSA3 in R/3 just for some records 
3, After RSA3 finishes, stop SQL-trace in ST05 
4, Analyze SQL-statements in ST05 

You can find the tables - but this process doesn't help e.g for the LO-cockpit datasources. 

Explain tables and sid tables.

A basic cube consists of fact table surrounded by dimension table. SID table links these dimension tables to master data tables.

SID is surrogate ID generated by the system. The SID tables are created when we create a master data IO. In SAP BW star schema, the distinction is made between two self contained areas: Infocube & master data tables/SID tables.

The master data doesn't reside in the satr schema but resides in separate tables which are shared across all the star schemas in SAP BW. A numer ID is generated which connects the dimension tables of the infocube to that of the master data tables.

The dimension tables contain the dim ID and SID of a particular IO. Using this SID the attributes and texts of an master data Io is accessed.

The SID table is connected to the associated master data tables via teh char key 

Sid Tables are like pointers in C

The details of the tables in Bw :

Tables Starting with  Description:

M - View of master data table 
Q  - Time Dependent master data table 

H - Hierarchy table 
K - Hierarchy SID table 
I  - SID Hierarchy structure 
J  - Hierarchy interval table 

S  - SID table 
Y  - Time Dependent SID table 
T  - Text Table 

F  - Fact Table - Direct data for cube ( B-Tree Index ) 
E  - Fact Table - Compress cube ( Bitmap Index ) 

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books  - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.