ECC Extraction

Posted by on












All the standard business Content DataSource will be Available in Tcode RSA5

We can Activate datasources from RSA5... 

All the Activated Datasources will be listed in RSA6.

After that data will be available in datasource and will be ready for Extraction..

RSA3 is Extraction checker.. to view the availability of Data.



When we get a reporting requirement, first thing we should do is to check Whether any of the business content query meets the requirement... if any query is giving the desired report then we should always do it with business content itself..

follow this link to check the business content queries

http://help.sap.com/saphelp_nw74/helpdata/en/c8/28ba0f00c34f299da32bd91d286fc0/frameset.htm

lets take an example for Customer Overdue

For that check business content, whether standard queries are available or not...

http://help.sap.com/saphelp_nw74/helpdata/en/c9/d9884a155443509916b190785e550c/content.htm?frameset=/en/30/44593167d447198995bed770d70ddf/frameset.htm



Now we know that our query is available in business content... 0FIAR_C30 is our data source...

Lets go and find it in RSA5









Click on our datasource and click activate datasources.


Once datasource is activated, It will be available in RSA6.

Goto RSA6 to check whether it is available .





DataSource is available in RSA6... Now lets check If we have any data in that Datasource..


Goto RSA3









We have 34 records in "Z000" Company code...

Now lets replicate this data to BW..


In BW



First select source system as ECC



Select the correct Application component, and from the context menu select replicate meta data..



Our datasource is created in BW... But its just a structure.. to pull data from ECC to BW.. we need an infopackage..










As we are taking data only for Company code "Z000"... specify that in dataselection..









Now our 34 records from ECC is available in PSA ..

Now 0FIAR_C30 is the cube that needs to be activated..

goto BI CONTENT tab to activate 0FIAR_C30



When we activate cube.. all the necessary objects are also activated..






Execute DTP




Now data is available in cube



As ou query is done on multiprovider, Connect cube to multiprovider



Now run the query to get report

Goto RSRT Tcode







We can also edit this query in query designer if we need any customization...



Best SAP training in Kerala
Best SAP training in Kochi
Best SAP training in Ernakulam
SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana







Comments

  1. UnknownJuly 17, 2013 at 12:19 AM

    superb boss. your blog is mind blowing !!

    ReplyDelete
  2. UnknownJuly 17, 2013 at 1:24 AM

    could you please provide me the path in help.sap to check the business content queries?

    ReplyDelete
    Replies
    1. Mohamed AslamJuly 17, 2013 at 1:26 AM

      http://help.sap.com/saphelp_nw74/helpdata/en/c8/28ba0f00c34f299da32bd91d286fc0/frameset.htm

      you get 3 options..
      FI, HR, Logistics..

      expand these... and you will get all business content queries...

      Delete
  3. UnknownAugust 2, 2013 at 4:46 AM

    Thanks for sharing the information..

    can u explain me the difference between ECC extraction and LO extraction?
    and some more information on LO extraction

    Thanks
    Manish

    ReplyDelete
    Replies
    1. Mohamed AslamAugust 2, 2013 at 5:55 AM

      Thanks...

      LO is also ECC extraction.... In ECC extraction we have
      Application specific extractors and
      Cross Application Extractors

      In Application specific we have

      FI
      HR
      LO


      what we had done in above exercise is from FI...
      LO means logistics, in which SD and MM is coming...
      detailed Extraction on LO will be done in next post...

      Delete
  4. AnonymousSeptember 24, 2013 at 7:36 PM

    HI Aslam,
    Txs for superb blog.
    I am doing a Sample project on HR.
    Could u provide me any links which can help me in understanding HR
    From Extraction to making query.
    Standard,Generic etc.
    Txs friend

    ReplyDelete
    Replies
    1. Mohamed AslamNovember 28, 2013 at 8:09 PM

      Thanks for writing..

      I dont have any documents with me.. will try to post on this blog...

      Delete
    2. umeshDecember 11, 2013 at 3:14 AM

      hi friend.. your blog is excellent...i want to learn start and end routines,post that........

      Delete
    3. Mohamed AslamMarch 2, 2014 at 9:51 PM

      http://easy-learn-bw.blogspot.in/2014/01/transformation-routines.html

      Delete
  5. UnknownApril 23, 2014 at 5:11 AM

    hi Aslam
    great work....super blog .......
    iam working in SAP PLM ,
    iam new to PLM can u please tell me how to extract data from PLM to BW
    and for reporting we are using BCV- business context viewer. can u please tell abt BCV also...

    ReplyDelete
  6. UnknownApril 23, 2014 at 5:15 AM

    HI Aslam
    good work very help full blog.....
    iam working in SAP PLM , and iam new to PLM ,can u please tellme how to extract data from PLM to BW and is it same as ECC ,and for reporting we are using BCV-business context viewer can u tell me abt BCV also
    thanks
    Naren

    ReplyDelete
  7. UnknownJune 22, 2014 at 8:35 PM

    Hi buddy,
    I am new to SAP BI, can you tell me how to extract SD and MM tables from ECC to BI system?
    Should we create info objects and info cubes and master data tables before the extraction of data from ECC?

    ReplyDelete
  8. UnknownJune 22, 2014 at 8:38 PM

    Hi buddy,
    I am need to SAP BI, I know to create info cubes.
    So now, If i want to extract SD and MM tables from ECC should i create the Info Cubes for all the tables?
    Please explain...
    Thanks advance

    ReplyDelete
  9. AnonymousDecember 16, 2014 at 6:24 PM

    Hi,
    it is very nice blog , I need to know more on FI GL extraction steps both on R/3 and BI side , will you post this one.
    Thanks,
    KK

    ReplyDelete
  10. AnushaJanuary 30, 2018 at 4:23 AM

    AWESOME EXPLANATION...TANKQ

    ReplyDelete
  11. UnknownApril 13, 2018 at 12:34 PM

    hi aslam...can u pls provide all useful tcodes in ecc

    ReplyDelete
  12. UnknownMay 29, 2018 at 4:13 AM

    thank u soo much for ur blog...it is really giving confidence in bw

    ReplyDelete

Post a Comment