automated excel download

[Former Member]

Hi,

We have a variant that we use to see the details in transaction /sapapo/ppt1. We can download these details to an excel document from there manually.

But, I need a program that I can schedule to download the results of this Production planning table for a particular variant to an excel file, may be to application server?

Is there a way to do this?

Thanks.

[Former Member · Accepted solution]

Hi Visu,

I dont think so it is possible as it is a panning table and picking data from live cache, aslo there is no option of running it in background.

What details you want to download ?may be there is some other way to fetch data.

Manish

[Former Member · Accepted solution]

Thanks Manish and Sai. I want to download the requirements, planned orders and production orders.

As sai said, can't this be done by a Zprogram using a BAPI to read the data and export to excel...some ALV output?

Thanks.

[Former Member · Accepted solution]

Hi Visu,

You can read order based on order category by FM : /SAPAPO/OM_ORDER_GET_DATA and depending on field required by Business can be presented on ALV report , also you can created transaction code for the ALV report.

Also you can read planned order and Prod order from planning book by

BAPI_PBSRVAPS_GETDETAIL Read Data from a Planning Book

BAPI_PBSRVAPS_GETDETAIL2 Read Key Figure Values

Manish

[somnath_manna · Accepted solution]

Visu,

Take a look at the following Wiki pages.

https://wiki.sdn.sap.com/wiki/x/ZIA-Ag From Functional to Technical

https://wiki.sdn.sap.com/wiki/x/6QBXAg Developing a Custom Report to display Production Orders

https://wiki.sdn.sap.com/wiki/x/Hhs APO-Technical

These should provide you enough details to start with the Functional Spec for the ZReport.

Hope this helps.

Somnath

[Former Member]

probably you may need to coordnate with your technical team to develop a ZProgram