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

How to drill down to the product data from planning book

Hello Gurus,

If you see this snapshot, you would notice that there are a few products-location combinations which have Sales Orders, Dist. Recipts planned & confirmed. The challenge is how do I find "which products are these" ?

I tried to randomly click on individual pdt-loc but didn't get lucky.

I tried to put a drill down by used the HAT icon with TOTAL (tick) but it ran for a long long time & fetched nothing.

I tried using /sapapo/rrp1 with past 30 days horizon & plant, but it ran again a long long time & yielded nothing.

Is there a way in APO (similar to ECC, where in I give the plant name in VBAP &/or VBAK & it gives me a list of all products which has an OPEN SALES order) to get to the product which has the open sales order, though some tables?

How can we get to the products which has these Open Sales Orders?


Drill down didn't yield much!

Many many thanks in advance


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Oct 12, 2015 at 04:32 PM

    Hi Sooraj,

    You don't have to click total but you have to click details (all) if you want to load all materials or details (all filter) if you want to select specific (it will give pop-up to select). Thereafter you need to drill down location also same way.

    I would suggest you to first select specific key figures before you do this drill-down by clicking on "key figure selection"

    I hope this would resolve your issue.



    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Sooraj,

      Adding 2 cents to what our expert Rahul already suggested:

      1. You can restrict processing time in planning book data loading by restricting the amount of data (prod-loc combinations) you are loading.

      2. You can further restrict by displaying only those key figures you need to display.

      3. Then instead displaying all products through filter, you may choose the option "Details all (filter)" to select multiple product for display instead of all.

      4. You may use other t-codes like /n/sapapo/rrp1, n/sapapo/rrp4 for reading requirements and receipts but that will be in a different format than that of planning book.



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.