Difference between Time Series Key Figures and Order Based Key Figures

[Former Member]

Hi

What is the Difference between Time Series Key Figures and Order Based Key Figures and how does it affect the data processing(Eg : do standard programs exist to delete time series key figures/order series key figures) etc

[Former Member · Accepted solution]

there was a similar thread recently so a part of the question on how order series KF is read is in the reply there

to delete time series KF you can do a couple of things

1. manually enter zero in the time series KF or Use the distribution function (calculator icon) to put a zero in all the CVCs (which is not a great idea if u have a lot of CVCs)

2. write a macro to make the KF= 0

3. Copy a zero value from a KF to the one you want to make zero using RTS copy

am sure there are a few other ways too

for deleting the oorder series KF, in addition to using the RLCDEL that uma mentioned , you also use few variants depending on what kind of orders they are(in some version Planned orders are not deleted by rlcdel)

for eg /SAPAPO/DELETE_PP_ORDER - for PPDS orders

/SAPAPO/SDORDER_DEL - for SD orders

here are some alternate ways for deleting depending on how they are created

for deleting order type FA for example you can release a zero from DP

for delting orders that were created by BAPIs, rerun the same BAPIs with zero quantity

[somnath_manna]

Hi Sandeep,

These are two common methods of storing transaction data in liveCache.

Timeseries data is stored in the form of CVC-Keyfigure-Time Bucket-UoM-Qty.

Orderseries data is stored in the form of Location-Product Combination-ATP Category-Time Stamp-UoM-Qty.

To give an example

Say final forecast keyfigure data in DP is released to SNP. This essentially converts the Timeseries data (in Final Forecast keyfigure) to Orderseries data (seen in Forecast keyfigure in SNP).

The forecast quantity gets mapped to Order of ATP Category 'FC' against the location-product combination as maintained in the CVC in DP with the Time Stamp being a value at end of the DP timebucket (assuming Period Factor is 1)

I am not sure what you mean by data processing. DP uses Timeseries keyfigure only. Data in Timeseries keyfigure can be deleted wither by executing a macro to zero out the value (can be done at an aggregate level) or by Deleting the Timeseries for the particular version.

As for Order Series data - for those orders created in SNP (like SNP Purchase Req, Planned Orders) you can delete using /SAPAPO/RLCDELETE. But if there is Order data originating from ERP (say Production Orders, Sales Orders) then deletion in APO is complicated. You can use report /SAPAPO/DELETE_PP_ORDER to delete such order data.

Hope this helps.

Thanks,

Somnath

[Former Member]

order series KF are identified by category or categorygroups...

following link gives good idea....

http://help.sap.com/saphelp_scm40/helpdata/en/ae/127c39f303a423e10000000a114084/content.htm

to delete,

goto /n/sapapo/rlcdel..there you can delete both time series as well as order series by selecting appropriate radio button...

program to delete transactional data : /sapapo/rlcdelete

Message was edited by:

Uma Maheswar kumar