Skip to Content

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

25.PNG

/wp-content/uploads/2012/09/26_140760.png

Here give FIELDNM–> VBELN and Execute.

27.PNG

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

28.PNG

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

29.PNG

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.

30.PNG

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)

31.PNG

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

32.PNG

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

4) Create Transformation between DataSource and DSO.

33.PNG

34.PNG

35.PNG

5) Create DTP

36.PNG

37.PNG

38.PNG

Activate and Execute. Check the DTP Monitor.

39.PNG

Click on ‘Administer DataTargets’

/wp-content/uploads/2012/09/40_140820.png

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.

44.PNG

/wp-content/uploads/2012/09/42_140821.png

/wp-content/uploads/2012/09/43_140822.png

Check in the Active Data Table.

/wp-content/uploads/2012/09/45_140825.png46.PNG

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.

To report this post you need to login first.

2 Comments

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

Leave a Reply