SNP- Master Data Clean up Steps

[former_member906762]

Hello Gurus,

We are planning to delete some obsolete products from APO . Can any one please guide with the sequence and the list of all the jobs to delete them . I am aware of deleting the transactional Data and then the master data . But if some one could list the sequence and any house keeping jobs i need to run in between that would be really appreciated.

REgards,

Nick

[Former Member · Accepted solution]

Hi Nick,

Which system you're going to cleanup, any lower environment or any simulation version ?

Here is the list of SAP suggested steps which i got from Note - 571031

a) Remove product from integration model  Use TXN CFM5 to find the IM of the product/location.

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. Please check first if the note 520703 and 492169 are already implemented in the system! Note that this report also checks the content in table /sapapo/ordpart. However, it might be necessary to select the option 'Delete inconsistent records in dependant tables' to remove all data. Therefore, Please make also sure you have the latest version of the Report (see the collective note 553476);

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.

Additionally you can use WUF Transaction to find out and delete the ATP orders available with your master data, use TXN /sapapo/om16 to find out the GUIDs.

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.

Also have a look at this link Helpful report to delete inconsistent transactional data in APO - Supply Chain Management (SCM) - SC...

Hope this Helps

Regards

Vinoth

[RahulHanda]

Nick

Go through the below link which explains prerequisites and actions for different master objects.

Deleting Master Data - Master Data - SAP Library

Check this for transaction data

Delete Transaction Data - Supply Network Planning - SAP Library

Helpful report to delete inconsistent transactional data in APO - Supply Chain Management (SCM) - SC...

I hope this resolves your issue.

Regards

Rahul