How to read the entire Deployment Planning Book

[Former Member]

Hi,

We are faced with a situation wherein the SNP extractor is not reading those orders which doesn't have a lane and as per SAP it is the standard functionality.

Now all the data is available in the planning book but cannot be extracted.

So my question is that : Is there any BAPI/FM/Report through which we can extract everything which is there for deployment planning book?

If no standard way is there, can anyone provide some pointers/code snippet for achieving this?

Any help would be much appreciated.

[rajkj · Accepted solution]

Hi Debanshu,

I guess you would have used a datasource based on aggregate 9AMALA (Material and Lane). Try to generate another datasource based on 9AMALO (Material and Location). From key figures perspective, these two aggregate are same (in standard SCM server), but differ with characteristics. The one based on 9AMALA has additional characteristics such as 9ALOCFROM, 9ALOCTO, and 9ATTYPE.

If you don't need location from and location to values, then you can access the deployment view data using 9AMALO based datasource.

Thanks,
Rajesh

[former_member209769 · Accepted solution]

Hi Debanshu,

Agree with Rajesh's comments. Try it out. It would work.

For your information, you don't extract data from a planning book or a planning view, data extraction happens from the planning area (I would assume that you are talking about the standard data extraction from planning area).

So, what data you extract is only about choosing the right aggregate to extract data from the planning area.

Thanks - Pawan

[Former Member · Accepted solution]

Hi,

Thanks Pawan and Rajesh.

We already tried the aggregation 9AMALO (Material and Location) but there too we are not getting the from and to location which are critical to reports. Also means of transport is not there. So we need the following characteristics for all the order types (SNP, STR, STO and In-transit):

Product     From Loc     Dest Loc    Means of Transport Start Date     End Date     Qty

Please suggest.

[rajkj · Accepted solution]

Hi Debanshu,

Here is another idea.

Define a dummy product specific t.lane between source and destination locations (/SAPAPO/SCC_TL1). Be sure to block this t.lane so that planning functions won't consider this source of supply.

Extract the data from APO and replace dummy value with any suitable value in BW.

Thanks,
Rajesh

[former_member209769 · Accepted solution]

Hi Debanshu,

All your requirements would not be met by using a single aggregate based extraction. Some data would be available in some aggregates and some in other aggregates. This is standard APO design.

Have multiple extractions based on different aggregates, and then use ABAP codes in routines to get the data for your reports. You could combine data from different extractions to arrive at the data for yoru reports.

Thanks - Pawan