This is Part 2/2 of the document discussing the SAP Tables helpful in Mapping Between R/3 Source Fields and BI InfoObjects.
You can find the Part 1/2 here http://scn.sap.com/docs/DOC-31778
1) RSTSFIELD Table - Transfer structure fields
To see, per datasource/transfer structure, to which infoobject the R/3 field is mapped, table RSTSFIELD can be viewed.
To access this go to se11 --> give the table name-->display.
In the next screen, click on Contents.
In the subsequent screen, give MATNR in FIELDNM if you want to know to which InfoObject it is mapped.
You can see that R/3 field MATNR is mapped to infoobject 0MATERIAL within several transfer structures/datasources.
2) RSOSFIELDMAP Table - Mapping Between OLTP Source Fields and InfoObjects
RSOSFIELDMAP is a BW Table which consists of all the mapping details between R/3 source fields and BI InfoObjects.
To access this go to se11 in BI --> give the table name-->display.
In the next screen, click on Contents.
In the next screen, give fieldname eg.VBELN in FIELDNM and execute.
It will display the respective source field names and the data sources where that field is used.
3) RSOLTPSOURCEFIE Table - OLTP Source Fields
This table is useful in checking whether all necessary R/3 fields are already extracted and transferred to BI.
To access this go to se11 in BI --> give the table name-->display.
In the next screen, click on Contents.
Within the selection screen you can enter, for eg, R/3 field MATNR if you want to know in which
datasources MATNR is used.
4) RSISOSMAP Table - Mapping Between InfoSources and OLTP Sources
The mapping between OLTP Sources and BW InfoSources is stored in this table.
To access this go to se11 in BI --> give the table name-->display.
In the next screen, click on Contents. In the next screen, you can either click on execute or give the
OLTP Source name and execute.
Thank you for reading this document. Hope you found it helpful. Please leave your valuable comments and ratings below.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
12 | |
7 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |