Extracting Days of supply

[Former Member]

Hai,

I have a requirement where in I have to extract days of supply data from SNP.

"Days of supply" is a keyFigure in interactive planning and gets populated by a macro calculation. Its is not actually part of standard SNP Planning Area and so there is no keyfigure assigned to it.

1. Where is the data saved? Even for it to save, it should have a place holder.

2. How do I extract this "Days of Supply" data? Is it just like DP- generating export datasource and then transferring data between the PA infsource to the cube?

Thank you.

[Former Member · Accepted solution]

Hi Visu,

If I understand you correctly, your "Days of SUpply" KF is an auxilliary KF in a planning book. If this is the case, then you can use BAPI/Function Module BAPI_PBSVARPS_GETDETAIL to read the KF data from your planning book. There is an option in the BAPI to turn-off macro calculation, please don't use it (because i think you need to actually let the macros run).

Hope this helps.

[Former Member · Accepted solution]

Hai Emmanuel,

Thanks for the reply. I think that's the best way. Read the auxiliary KF using this BAPI and populate this data into a key figure in update rules of the cube. You can report on this data. Is that correct?

Thank you.

[Former Member]

Easiest way is to save the results of this macro to a time series key figure.

Ken