How to delete all contents in the LiveCache

[Former Member]

Hi,

Is there an easy way to delete all LiveCache contents (all SNP and DP data)?

Thanx for quick info

[thanga_prakash]

Hello Lutz,

Try initializing the live cache. Use the report given in the below SAP notes to do the same.

326073 - Starting and stopping liveCache with transaction LC10

Regards,

TP

[former_member187488]

Hi,

To delete liveCache content for DP, de-initialization of DP planning areas is enough.
To delete liveCache content for SNP, perform /sapapo/rlc_delete plus de-initialization of SNP planning areas (only those with liveCache time series KFs).
There're still PPDS orders in liveCache, which should be deleted with different reports.

If you want to clear the liveCache, you can initialize the liveCache.

BR, Ada

[satish_waghmare3]

Program /SAPAPO/TS_PAREA_DE_INITIALIZE  - All time series data gets deleted. Planning area is de-initialized.

Thank you

Satish Waghmare

[Former Member]

Report /SAPAPO/RLCDELETE

[Former Member]

Thanx Mr. Köller.

1. Is the RLCDELETE also covering DP data?

2. I think that the RLCDELETE cannot delete all SNP planning elements, only those created by the planning system. Will it delete elements created in the ERP system as well?

Regards Lutz Reuß

[Former Member]

Hi

RLCDELETE will manily delete order series SNP data from LC.

You can De-initializing the planning area after taking a back-up will get rid of the data in live-cache time series which is valid for DP as well as SNP. For DP once everything is deleted , you can create CVC based on backup data and in case you require to load the data again you can load it.

Thanks

Amol

[Former Member]

Additional information...!

Hi

In APO SNP, if you only delete the time series it will not delete the inactive material from it.

If you go to APO material master i.e. /SAPAPO/MAT1 - Product  you will still find your inactive products. By deleting the time series, you are only deleting the data from time series key figures, but you will still have the data in order series key figures.

You can require to delete these products by mainly using following steps.

a) Remove product from integration model

b) Delete all orders for this product-location which still exist in the APO system by running the reports /SAPAPO/RLCDELETE or /SAPAPO/DELETE_PP_ORDER (this report is not recommanded to be used in product system!!) or transactions /SAPAPO/RRP4 or /SAPAPO/RRP4.

c) Use transaction /sapapo/ccr to delete all objects in APO that are integrated with R/3. The /sapapo/ccr will show the orders as 'Not in an active integration model' and offers to delete the orders in APO

d) Delete the product from ATP tables by running the report /SAPAPO/SDORDER_DEL with the selection according to the product being deleted. (Orders from DB & live cache)

e) Delete all related product substitution and location product substitution using the transaction /SAPAPO/RBA04;

f) Delete the product from all PPMs through the transaction /SAPAPO/SCC05;

g) Remove the product from external procurement using the transaction /SAPAPO/PWBSRC2;

h) Remove the product from transportation lanes through the transaction /SAPAPO/SCC_TL1 or /SAPAPO/SCE; Note: If the lane was created with option 'All products', you should not care about this condition.

i) Remove the product from quota arrangement through the transaction /SAPAP/SCC_TQ1;

j) Remove references from the product master or the location product master using the transaction /SAPAPO/MAT1, tab 'Classification';

k) Remove the planning package from the location product master using the transaction /SAPAPO/MAT1, tab 'PP/DS';

l) Remove the product from RTO;

m) Remove the product from product split.

2. Mark deletion flag

a) In transaction /SAPAPO/MAT1, select the product (and location in case of location product);

b) In the menu bar, choose 'Product' and go to 'Mark for deletion' (Shift+F6);

c) In the popup 'Set deletion Flag' set a flag in the appropriate field: Leave the field 'Product' empty unless you want to delete the product master, i.e. in case a location product must be deleted, the flag has to be set on location only;

d) The deletion can be executed directly or be scheduled for another time.

Use Report /SAPAPO/DELETE_PRODUCTS for deletion.

Once you delete all the products, than you can again open the CIF to bring in the new products.

I hope this will helpful to you.

Thanks

Amol