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

http://scn.sap.com/docs/DOC-32025

Part 2

http://scn.sap.com/docs/DOC-32026

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.