Skip to Content
Author's profile photo Former Member

Extraction Process for IS-U Sales Statistics 0UC_SALES_STATS_02 DataSource.

In my project, after activating the 0UC_SALES_STATS_02 in R/3 system; I tried checking in RSA3. But it showed zero records extracted. Later I tried replicating datasource and created infopackage in BW and ran it, still zero records in PSA.

I found solution for this:

I did some settings in R/3, those are as below:

In t-code SBIW, Settings for application-Specific DataSources (PI) >>Utilities Industries>>Sales Statistics>> Define Performance settings for sales statistics extractor >> Tick the Initial update group is allowed (as shown below)

/wp-content/uploads/2013/11/11_333298.jpg

Later checked in RSA3 in R/3 system by giving some print document, I found data extracted.

/wp-content/uploads/2013/11/2_333338.jpg

/wp-content/uploads/2013/11/3_334105.jpg


Then the task was to pull the data in BW till PSA.

Follow the below steps:

  1. In BW, create an infopackage with full load and you will extract no records and it will remain with a yellow status; which is fine.
  2. Again in BW, run the infopackage with Initial Load (it should extract 1 record and be in status of green).
  3. Now loin to R/3 system and go to t-code EBW_DQ_SS, follow below steps:

               a. Under the “Environment” tab in menu strip, click “Unlock mass activity type”.

                   /wp-content/uploads/2013/11/4_333339.jpg

                b. Under “Program run” tab in menu strip, click “deactivate old run” by giving Date ID and Identification.

                         /wp-content/uploads/2013/11/5_333340.jpg

               c. Now run the mass activity EBW_DQ_SS by clicking “Schedule Program Run”.

                    /wp-content/uploads/2013/11/6_333350.jpg

  4. In BW system, run the Delta load for 0UC_SALES_STATS_02. Now you will see data extracted in PSA.

/wp-content/uploads/2013/11/7_333352.jpg

This is how you can pull the data from IS-U Sales statistics 0UC_SALES_STATS_02 DataSource to BW system till PSA.

Assigned tags

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

      thanks for this useful doc.

      KR,

      Manna Das

      Author's profile photo CH Raman
      CH Raman

      Very useful information. Thanks for sharing poornachandra.

      Thanks

      Author's profile photo Former Member
      Former Member

      Good information....

      Author's profile photo Former Member
      Former Member

      nice work

      Author's profile photo lakkireddy Amarnathreddy
      lakkireddy Amarnathreddy

      thank you lot Poornachandra

      Author's profile photo Former Member
      Former Member

      Hi proona Chandra nice artcal ,when I loading the delta it's green and getting null values ,could please let me know the reason