Mapping Between R/3 Source Fields and BI InfoObjects – Part 2

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.