Skip to Content
Author's profile photo Anjali P

Generic Extraction based on a View – Part 3

This is Part 3 of the Generic Extraction.
Part 1 detailed about the steps to be performed in ECC and Part 2 detailed abouts steps in BI till
records are fetched successfully to PSA.

You can find it here

Part 1

Part 2

Mapping of fields with InfoObjects

SAP has delivered Standard InfoObjects corresponding to the fields in ECC.  We will be using those.

To find out the InfoObjects there are some SAP tables which we can use.  Please refer to my documents on

those SAP tables.  Here I am using the table RSTRFIELDSH.

1) Go to SE11 and give the table name—>Display–> Contents



Here give FIELDNM–> VBELN and Execute.


In the next screen, we can see that 0DOC_NUMBER ( in IOBJNM column) is the Standard InfoObject delivered for VBELN.


Follow the steps to find Standard InfoObjects for all your fields.

Now go to t-code RSORBCT or BI Content under Modeling Tab in RSA1.

Object Types–>InfoObjects–>Select Objects–>Find 0DOC_NUMBER–>Transfer Selections


Like this, transfer all the required InfoObjects and Install.  Please be cautious while doing BI content installation.

Check if any of the InfoObjects are already available in active version and being used in other projects in the BI system. 

Don’t install them again.  (In my case, 0SALESORG and 0CH_ON are already active).  Install the others.


2)  Once this is done, if you want you can create an InfoArea and collect the InfoObjects in Catalogs (optional)

(if its already part of another InfoArea, you won’t be able to collect it here)


3) Create a DataStoreObject.  Context Menu on InfoArea–>Create DataStoreObject


Give infoobjects corresponding to VBELN, POSNR, and PARVW as Keyfields and others in Datafields and activate.

4) Create Transformation between DataSource and DSO.




5) Create DTP




Activate and Execute. Check the DTP Monitor.


Click on ‘Administer DataTargets’


The data is now in the Activation Queue of the DSO, you need to activate it so that the data moves to the Active Data table.




Check in the Active Data Table.


Next you have to create an InfoCube corresponding Transformations and take this records to InfoCube. ( continued in Part 4)

Thank you for taking time out to go through the document.  Hope its been helpful.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very good Artical.


      Author's profile photo Bhavesh Jain
      Bhavesh Jain

      Really Good article.

      This is what I was looking for.

      Thank you so much.