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

[former_member192933]

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

In the next screen, click on Contents

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.

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)

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.

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

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