Skip to Content
author's profile photo Former Member
Former Member

BW technical consultant in APO DP

Hi Friends,

I am BW technical Consultant worked in the areas of SD/MM/HR.

We are going to implement BI 7.0 in the areas of SAP APO DP SNP.

May i know the roles of a BW consultant and i want some material on SAP BW -APO DP SNP .

Eg: How to create Datasource in APO,How to extract the data from APO to BW, What is planning area.....etc

Thanks in advance...



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Dec 26, 2011 at 08:37 AM

    Hi Srinivas,

    Let me share my personal experience.

    I have seen BW people taking care of all BW related aspects in APO, and this differentiation between BW fiunctionality and APO functionality is normally quite strong in the project teams.

    So, this means BW team takes care of getting data from a datasource/source system (whether BW system, flat file, etc) to the APO infocube, from where APO experts would take care that data reaches from the infocube to the planning area correctly. This work is exactly the same as what you would be doing in BW system using standard t-codes like RSA1, etc.

    The other part that BW resources normally take care of in APO is the extraction of data, e.g. data extraction from DP and SNP planning areas, from tables (if data needed in BW for some custom functionality), etc.

    For this part, it would be good if you understand a few basics of APO both in DP and SNP e.g. concept of CVC, how data is stored in DP and SNP in livecache, etc. It would be best if you sit along with an APO resource from your team and get the basic APO understanding.

    For data extraction, you can get help on SAP help portal e.g. for SCM 5.0, the link is:

    Thanks - Pawan

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sri,

      As mentioned earlier, I would recommend you to sit with some APO resource to get some basic high level understanding of APO. It would be tough to give information while writing. SAP help has quite decent information on the extraction topic from my point of view.

      I can share here some things in simple terms that could be helpful for you.

      Data flow wise common flows are:

      History data comes from R/3 to BW, and then from BW to APO cubes, creation of CVC happens for Planning Area and then history is loaded to APO Demand Planning Area.

      After Forecasting (in DP) or Supply Network Planning (SNP) , data containing planning results are extracted from APO using export datasources, and used in BW for reporting as per business requirements.

      Demand Planning Area is quite close to the Infocube in the sense that we have CVCs (characteristic value combinations) and Key Figure data is stored against the CVC. We do forecasting in DP, and then in SNP we would generate receipts for the forecast (from DP), Sales Orders, Deliveries, etc. In SNP, data is stored mostly in something called order series. Most of APO data is stored in livecache which you can say is a very fast RAM, so that planning (which is quite performance intensive) can be done fast.

      From extraction point of view, once you generate the datasource for Planning Area as mentioned in SAP help, then you can use the datasource for extraction like any normal BW datasource. So, in BW, you get data from remote datasource (in APO) and use it as per your reporting requirements. APO has its own mini BW having all the transactions that you have in BW. There are even process chains available in APO.

      Which tables could be relevant would depend on your solution requirement. Ask your APO consultant to show you how to read data in planning views. This is something that you might want to check in case of issues in data. A word of caution here though - the data that you would see in the planning view might not be stored in planning area in the time buckets in the same way, so when you extract data, you might notice some differences. For this, an APO consultant who understands aggregation/disaggregation would be able to help you in understanding the values that you see.

      Thanks - Pawan

  • author's profile photo Former Member
    Former Member
    Posted on Dec 26, 2011 at 08:00 AM

    There are SAP study materials in PDF formats, but those would be copyrighted and not available freely. Then individual training institutes also can be source for study materials. You should check with colleagues.

    But you should start with the SAP Help site, which has extensive source of information on all topics you have mentioned. Here is the link to start with:

    This is the main page for SAP APO. Use the left menu bar to expand individual topics. You can also use the search feature, or Glossary.

    And then you have these SDN forums threads in case of any particular doubts.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.