Planning Book - Qty Change - Download at SKU level

[satish_waghmare3]

Hello Friends,

There is a requirement on which i need to work on. Following is the scenario -

We have PFAM (Product Family) below which there are SKU's.

The users have a requirements that in DP planning book when the qty is changed at say PFAM level and it gets disaggregated to SKU level.

And there are thousands such SKU's where the qty is now changed, the users want yo instantly download this info into say Excel for further analysis. As this data is is written into LiveCache, what's the best way to download this from LiveCache or otherwise and get in Excel immediately?

I know the BW route but it think required considerable time and some manual action too.

Can you pl suggest any other better solution to fulfill this requirement?

Appreciate your help.

Thanks

Satish Waghmare

[former_member209769]

Hi Satish,

If the data at your SKU level is huge (lot of CVCs and/or Key Figures), best approach is to definitely go for BI reporting route. Also, if this checking requirement is very frequent, it would again be better to get relevant reports in BW. But yes, this would be normally once a day to avoid too much of load on the system due to extraction.

Otherwise, your users could display data at detailed level (and download it), but when data to be displayed would become huge, system will start getting timed out. At some point of time, you would start seeing issues with this approach, so better to avoid it.

Other option could be to create a custom report (and also create a custom transaction for users to use the report). The users could give the relevant selection criteria. In teh background, the report would read the data from DP planning area using standard BAPIs, and the data could either be displayed to the user online, or he could download it (there are standard ALV functionalities for this, which any ABAP person could take care of).

Thanks - Pawan

[satish_waghmare3]

Thanks Pawan. Appreciate your reply.

Will check with ABAP'er regarding standard BAPIs and standard ALV functionalities for reading KF data and displaying it thru custom report.

Thank you

Satish Waghmare.

[former_member209769]

Hi Satish,

BAPI to read data from planning book is BAPI_PBSRVAPS_GETDETAIL2.

Good documentation is available when you see the BAPI in SE37. You could help your ABAPer in understanding how to use the BAPI (he/she would need some functional inputs).

Next part of displaying the data read from livecache should be standard, and ABAPer can display the data as per your requirements.

If you have any issues in using the FM, you could let me know.

Thanks - Pawan

[Former Member]

Satish

In the newer releases of DP (SCM 5.0 onwards I think), you can directly download to Excel from the Planning Book. You may not like the format it's in , so you may still have to work to get it in shape.

The other option is to use a a macro to trigger a ABAP program that extracts data from time series livecache and updates Excel.

This thread might help you find the right BAPI -

RIshi Menon