Cleaning of data in system

[Former Member]

Hi Apo expert,

In our organization we have detached one unit. Same was working as a location (having different products), now for cleaning purpose we need to delete all the data related with that.

How to go-ahead to do this !

[Former Member · Accepted solution]

Hi

it is not a plain thing to delete a product master/location product in a production system.You have to carry out the following steps:

1.

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.

Product-specific transportation lanes, for which you have set the deletion flag, can be deleted using report /SAPAPO/TR_TRPROD_DELETE

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.

I hope this will help you,

Thanks

Amol

[aparna_ranganathan]

One way to start is to use the wuf transaction in APO for the location in question , find out all dependent objects and start cleaing them up using the appropriate transactions

For example to clean up transaction data you can use /n/sapapo/rlcdel . To cleanup PDS you can use the PDS delete transaction and so on

Thanks

Aparna

[Former Member]

Hi,

Location and product are the master data. To clear off, or delete the master data, we need to delete all the dependent objects first, otherwise system will not allow to delete the master data.

Now to find what are the dependent objects, you need to go to TCode- WUF. select 'location' and mention the location number there and execute. You will get different tabs for different dependent objects.

To delete these objects, you need to execute the relevant deletion program. To delete transaction data, you can use the program- /sapapo/rlcdelete, /sapapo/delete_pp_order, /sapapo/sdorder_del.

To delete the TLanes- go to the TCode for T Lanes deletion

To delete PPM/PDS- go to the TCode for PPM Deletion

Once every dependency is deleted, you can delete the location from the Tcode- /sapapo/loc3.

Remember to delete the CVCs related to the location also.

once the deletion is over, run the CCR report- /sapapo/ccr and then finally the consistency checks