Skip to Content
Author's profile photo Anjali P

Generic Extraction based on a View – Part 4

This is Part 4 of the Generic Extraction.

Part 1 detailed about the steps to be performed in ECC, Part 2 detailed abouts steps in BI till records are fetched successfully to PSA, and

Part 3 till bringing the data records to DSO.  The links to all parts can be found at the bottom of the document.

1) Creating an InfoCube

The next step would be creating an InfoCube

47.PNG

Activate the InfoCube.

2) Create Transformation between DSO and the InfoCube

48.PNG

3) Create the Data Transfer Process

49.PNG

Activate and Execute the DTP as detailed in Part 3

DTP Monitor

/wp-content/uploads/2012/09/50_141074.png

Click on Administer DataTargets

/wp-content/uploads/2012/09/51_141076.png

The load has been successful.  Now you can take the data records for reporting.

Open BEx Query Designer and add the InfoObjects to Rows and Columns as needed.

52.PNG

Execute and view the report.

53.PNG

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

The links to previous parts

Part 1

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

Part 2

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

Part 3

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

Assigned Tags

      17 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raki R
      Raki R

      Anjali....excellent work ....the way described is very intresting...keep post same like Function module if possible???

      Author's profile photo Anjali P
      Anjali P
      Blog Post Author

      Thanks Ravi!!!  Will try to post on function module 🙂

      Cheers,

      Anjali

      Author's profile photo Raki R
      Raki R

      hai anjali...i want  one requirement that based on fucntion moduel extraction...do u hav any experience eith this? just requirement enough....

      Author's profile photo Anjali P
      Anjali P
      Blog Post Author

      Hi Ravi,

      Currently, I am working on Generic Extraction based on function module in HR module. Meanwhile, if you want to try here is a brief requirement.

      Usually we go for function module when we want to extract from different tables.  So create a structure with some fields ( CHAR + KEYFIG) from any two tables eg: VBAK, VBAP.  The only point you have to keep in mind is that it should have a common key field.  Here VBELN is that field.  Now fetch the records for these fields using function module.

      Just published LO MasterData datasource enhancement- have a look!!

      Hope this helps,

      Anjali

      Author's profile photo Raki R
      Raki R

      thnk u so much anjali......and awaiting u r post on FM extraction (this Hr  requirement).

      Thanks and regards,

      Ravi kiran.

      Author's profile photo Martin Grob
      Martin Grob

      nice document thanks

      Author's profile photo Anjali P
      Anjali P
      Blog Post Author

      Thank you Martin!!! Good work in the forums!!

      Author's profile photo Raki R
      Raki R

      These docs are really helpfull anjali.....

      Author's profile photo Former Member
      Former Member

      Great job!!

      Author's profile photo Former Member
      Former Member

      Hi Anjali,

      I must say all the 4 parts of this document is really helpful for every BI practitioners. The way you explained the topic is very good.

      Could you please post same kind of detailed document for LO-Extraction ? 😀

      Best regards

      Albin  

      Author's profile photo Anjali P
      Anjali P
      Blog Post Author
      Author's profile photo Former Member
      Former Member

      Thank you Anjali for sharing knowledge. Keep it up. Your help counts a lot.

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice documentation 🙂

      Regards,

      SM

      Author's profile photo Former Member
      Former Member

      Hi anjali it a very informative doc i have a ques though. Re info cube how did u choose the cube i mean its a standard cube right. if u could pls elaborate on that it would be really helpful.

      Regards,

      Ram

      Author's profile photo Former Member
      Former Member

      Hi Anjali...Excellent documentation with proper screenshots....keep it on....

      Author's profile photo Former Member
      Former Member

      Thanks Anjali,

      You did a very good Job! 🙂

      Author's profile photo Bhavesh Jain
      Bhavesh Jain

      Hi Anjali,

       

      Thank you so much for these documents.

      it really helped me like other.

      Hats Off.