Skip to Content
Author's profile photo Anjali P

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

This discussion is primarily focused on how to find the corresponding InfoObjects for fields in R/3 and vice versa.  I will be discussing the different SAP tables useful for this scenario and couple of other linked ones accessible from BI.

 

RSTRFIELDSH Table – Shadow table: Transfer Structure Fields

This table has been a lifesaver manytimes.  To access this go to se11 –> give the table name–>display. 

You can also use se16.  In that case you can go for Contents button straightaway.  The structure of the table cannot be viewed here.

Here I am using Tcode – se11

se11.PNG

In the next screen, click on Contents

4.PNG

In the next screen, give the R/3 field name in FIELDNM and execute.

Here the FIELDNM represents the Field name and IOBJNM represents the InfoObject.

2.PNG

The resulting screen shows the corresponding standard InfoObjects created and details like

TRANSTRU – DataSource name

POSIT – Position of the Field in the Structure / Table

DTELNM – Data Element

DATATYPE – Datatype

LENG – Length (No. of Characters)

3.PNG

Here you can see that the standard InfoObject created is 0SALESORG/0DISTR_CHAN and the corresponding datasources used for this.

Alternatively, you can use this table to find all the fields and corresponding InfoObjects for any Standard DataSource.

For this give the datasource name in TRANSTRU and execute.

Capture3.PNG

Here you can see all the fields and their properties in the Standard DataSource.

Capture4.PNG

Hope you find this document helpful.  Please leave your valuable comments and ratings below.

Assigned Tags

      4 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Erdem Uren
      Erdem Uren

      Hi Anjali. İt's great document. But why cant see all datasources in rstrfieldsh table?

      For example 2LIS_11_VAITM or 2LIS_13_VDITM.These datasources no exist in this table.

      Author's profile photo Raman Korrapati
      Raman Korrapati

      Hi Erdem,

      if you replicated/migrated your data source into 7.x then you need to check table RSOSFIELDMAP.

      Anjali doc was useful for 3.x data sources.

      Thanks

      Author's profile photo Erdem Uren
      Erdem Uren

      data soources 7.x. but i can find table rsosfiledmap. ex:2LIS_11_VAITM or 2LIS_13_VDITM

      Author's profile photo Raman Korrapati
      Raman Korrapati

      Yes, for BW 7.x , check table - RSOSFIELDMAP

      for BW 3.x , check table - RSTRFIELDSH