Query for Deployment stock transfers?

[arturo_galvan2]

Hello experts,

I have not worked much in APO as consultant so I ignore a lot of basic things.

Fot now I have an inmediate problem. I can see the Deployment stock transferin /SAPAPO/SDP94 in the TLB view.

I would like to créate a query so I can download this data into a file with a SQ01 . The reason to créate a query is because i can prepare a full variant with file transfer so the some users (which are not so experts in using APO and even computers in general) can download a file withouth multiple clicks.

So I would like to know the database table/s involved that I can use and any hint you can give me.

Basically I need for there demand date date, product, number of pallets, quantity, destination location and basically that would be all.

Thanks

Arturo

[peter_casper · Accepted solution]

Hi Arturo,

this will not work. You can't access the requested data with a "simple" query due to the fact that APO stores the data in an encrypted format in a separate in memory database (usually max db in case you don't run on HANA) called LiveCache.

The best way to achieve your goal will be to use one of the available planning book extractors (in essence a BI extractor) to download the time series data into an InfoCube or DSO from where you can access the data with any ABAP method, incl. also queries.

Cheers, Peter

[arturo_galvan2 · Accepted solution]

Many thanks

[ruchi_das2]

Hi,

You can also try the Receipts view, Transaction -  /SAPAPO/RRP4. You can provide your location and in the resulting layout, apply filters for Deployment stock transfers and pull in the columns for source and target locations.

Regards

AK