Skip to Content

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.

2C.PNG

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.

6.JPG

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.

3c3.PNG

In the next screen, give fieldname eg.VBELN in FIELDNM and execute.

3c2.PNG

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.

3c.PNG

Within the selection screen you can enter, for eg, R/3 field MATNR if you want to know in which

datasources MATNR is used.

4c.PNG

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.

4c1.PNG

Thank you for reading this document.  Hope you found it helpful.  Please leave your valuable comments and ratings below.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. bo zhang

    Hi there,

         I have checked all table you mentioned in my system. some of there are empty, and for others, only 151 rows around exist for each. could you please confirm why is that?

    Many Thanks,

    Andy

    (0) 
    1. Kumar S

      Hi Zhang,

      If it is empty – Still that object (FIELDNM) related data sources are not transferred to BI.

      If it is showing some rows – That many were transferred.

      Anjali document will be helpful for our quick check. We need to do ECC to BI process in our usual way. If you want more clarifications – create a thread separately.

      (0) 

Leave a Reply