Skip to Content
Author's profile photo Former Member

Creating Data Source in APO

HI All,

Process of Creating Data Source in APO: –

For loading data in BW we need to create a data source in APO system.

  1. Login to APO system and Go to SAP menu àGo to ‘Administration of Demand Planning and Supply’ as below

1.PNG

II.Then Administration screen will come as below

2.PNG

Here in planning area column you will find all the planning areas, double click on planning area for which you want to create data source.

III.  After selecting a planning area below screen will comeà Go to Extra à Data Extraction Tools tab.

3.PNG

IV. Then below screen will come

  5.PNG

Here select Generate Data Source option.

V. Then system will ask for the Data Source name and settings as below.

11.PNG

The Data Source generated is by default having name starting with 9A, as per standard naming convention.

VII. Settings will do as per below.

No Extraction of Data Records Without Key Fig Value:-

7.PNG

Select this option if you want to prevent the system from transferring data records to Info Objects in the BW if all key figures in the data record have the value zero. Depending on data it will reduce the volume of records which the system transfers, and it will improve performance.

VIII. Block Size For BW Transfer:-

In this Box you have to mention how many records are transferred in one package. While transferring large no of data, it is required that the data need to split into multiple packages to avoid memory problems. Once source system will finish reading the data packages, it will transfer to BW.  With this option it is possible to change the default for all data extraction in the system.8.PNG

IX. Parallel Processing Profile:-

12.PNG

You can ad a parallel processing profile which you have previously created in Customizing (Demand Planning -> Profiles -> Maintain Parallel Processing Profile). This determines how and if the reading and transfer of the packages is split into parallel processes. As such the block sizes that you enter in the parallel processing profile should be significantly smaller than the package sizes above.

X. Give the Name of Data Source and click on Execute option as highlighted below.

13.PNG

XI. When you click on execute option below window will appear

11.PNG

In this select fields which you want.

XII. Click on save option, then below window will appear. Click on Test Data Source

12.PNG

XIII. Then below window will come.

  1. Uncheck the Debug option; otherwise it will go to ABAP Debugger. But if you want to debug then you can check this option.
  2. Provide Planning version value.
  3. If you want to execute with above selection, click on execution.
  4. If you want to display click on display option.

13.PNG

Check above options and if you are getting desired output then click on back.

XIV. Then SNP data extraction window will appear.

15.PNG

In this click on Replicate Data Source option.

XV. Then below window will appear.

16.PNG

  In this select as Data Source option and click on tick. . It will replicate your this new data source with BW system.

XVI. Transport data source.

17.PNG

Click on this option then it will create a data package for your Data source.

XVII. Your Data source is ready as shown in below screen.

20.PNG

Regards,

Mithun

Assigned Tags

      29 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Hi Mithun,

      Fantastic Step by step explanation. Thanks for sharing 🙂

      Regards,

      Suman

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

      Thank you so much Suman, can you please rate it..

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Hi Mithun

      Nicely explained..Thanks for sharing.

      Good one. Keep it up and keep going.

      Regards,

      Krishna Chaitanya

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

      Thank you so much Krishna..

      Author's profile photo Former Member
      Former Member

      Nice Mithun. Clear explanation with good screens. Keep your blogs posting.

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

      Thank you so much Kumar

      Author's profile photo Former Member
      Former Member

      Good document for APO implemention..

      Regards

      Shabnam

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

      Thank you so much Shabanam.

      Author's profile photo Former Member
      Former Member

      Nice Doc Mithun.Keep Posting ..Thanks for Sharing  🙂

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

      Thank you so much Naveen

      Author's profile photo Former Member
      Former Member

      Very well done. I not seen much document from APO side in SDN.

      1st time I had seen document relevant to APO.

      Regards,

      Sushant

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

      Thank you so much Sushant, will shar more documents on APO.........

      Author's profile photo CH Raman
      CH Raman

      Good explanation with nice presentation. Good job Mithun.

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

      Thank you so much, Raman...

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

      Thanks all of you, for your valuable comments... 🙂 🙂 🙂

      Author's profile photo Former Member
      Former Member

      Nice document Mithun, thanks for sharing it. It is the area I never worked on...would be helpful when needed.

      Regards,

      Prasad

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

      Thank you Prasad, glad to know that it is helpful for you... 🙂

      Author's profile photo Aravind Nag M
      Aravind Nag M

      Good One...

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

      Thanks Arvind... 🙂

      Author's profile photo Former Member
      Former Member

      Helpful Document , Thanks For sharing with Screen Shots.

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

      Thanks a lot SG.... 🙂

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Great Document Mithun..I have not seen much documents on APO in SCN..Thanks for sharing it with us.

      Regards,

      AL

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

      Thanks Anshu for your appreciation 🙂

      Author's profile photo Former Member
      Former Member

      really helpful document, thanks for posting such a greate document.

      Regards,

      Pankaj

      Author's profile photo Former Member
      Former Member

      Very nice document.

      But did you try the scenario using parallel processing profile?

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

      Thank you all

      Author's profile photo Chaitanya Reddy
      Chaitanya Reddy

      Hi Mithun,

      I have a issue , when i transported apo datasource to QUA i see that it is not getting assigned to planing area. can you please help me on this

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi,

      Good document with usefulinformation..thanks for sharing!

      Author's profile photo shailesh patil
      shailesh patil

      Useful document