SAP SNP

[Former Member]

I have deleted all inactive products CVC from DP. Now I have only active material in DP. I would like to delete all inactive material form SNP. So I have deleted time series from SNP palling area and deactivate all CIF from R/3 to APO. And create CIF by filtering inactive material. Now I could not able to CREATE time series again because of low memory. My question, I have deleted millions of CVC from DP and assign those products in r/3 as a ZZZ and use filtering ZZZ in CIF. Logically SNP should have a lot of space now. Then why the system is giving me the low memory error. DO I need to also delete all inactive products from SNP? What is the process? Could please help me?

Edited by: PARVES AHMED on Nov 5, 2010 2:28 AM

[Former Member]

Hi

All above reports can be used for mass deletion of orders for all reports. Regarding putting the deletion flag you can use MASSD T-code to put the flag. Once you put the flag you can Use Report /SAPAPO/DELETE_PRODUCTS for deleting the products in Mass.

Please also use Where used transaction ( WUF ) to find out if respective dependent objects on product or locations which has to be deleted.

Thanks

Amol

[Former Member]

Thanks Amol,

While I am deleting order by /SAPAPO/SDORDER_DEL, it is taking too much time. It took 30 hours for deleting 1 material. What should I do?

I can only able to run this report /SAPAPO/DELETE_PRODUCTS with 500 materials per session. It is failing, if I run this report with more than 500 materials. I have to deleted more than a millions inactive products. So what would be a feasible solution? We are using APO 3.1

Thanks mate

[Former Member]

I am getting following error. Could you please give me some idea,I have check mat1, tab classification is totally blank.

Job log overview for job: /SAPAPO/DELETE_PRODUCTS / 10343901

-

---

Date

Time

Message text

Message class

Message no.

Message type

-

---

10.12.2010	10:34:44	Job started	00	516	S
10.12.2010	10:34:44	Step 001 started (program /SAPAPO/DELETE_PRODUCTS, variant &0000000000001, user name MARS)	00	550	S
10.12.2010	10:35:09	Konfig. product 381615 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:13	Konfig. product 381877 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:16	Konfig. product 381878 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:20	Konfig. product 381879 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:24	Konfig. product 381893 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:28	Konfig. product 381896 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:32	Konfig. product 381897 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:36	Konfig. product 381906 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:40	Konfig. product 381938 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:45	Konfig. product 381950 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:48	Konfig. product 381955 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:52	Konfig. product 472291 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:35:56	Konfig. product 586339 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:00	Konfig. product 586340 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:04	Konfig. product 586347 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:08	Konfig. product 586689 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:12	Konfig. product 586691 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:16	Konfig. product 586760 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:20	Konfig. product 586761 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:25	Konfig. product 586762 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:29	Konfig. product 586763 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:33	Konfig. product 587895 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:37	Konfig. product 587901 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:41	Konfig. product 588104 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:46	Konfig. product 588105 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:49	Konfig. product 700465 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:53	Konfig. product 700466 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:36:57	Konfig. product 700813 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:02	Konfig. product 700815 references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:22	Konfig. product APM91676W references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:33	Konfig. product APM12211W references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:33	Prod ALS2128 Vers 000: Orders exist (Use report /SAPAPO/RLCDELETE)	/SAPAPO/MAT	096	S
10.12.2010	10:37:41	Konfig. product APM1198AW references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:46	Konfig. product WWT13W references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:54	Konfig. product APM12341W references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:59	Konfig. product APM12187W references from product . Deletion not possible	/SAPAPO/MAT	283	S
10.12.2010	10:37:59	Prod AN7V001 Vers 000: Orders exist (Use report /SAPAPO/RLCDELETE)	/SAPAPO/MAT	096	S
10.12.2010	10:37:59	Prod AN7V128 Vers 000: Orders exist (Use report /SAPAPO/RLCDELETE)	/SAPAPO/MAT	096	S
10.12.2010	10:42:20	Prod AT1D002/S Vers 000: Orders exist (Use report /SAPAPO/RLCDELETE)	/SAPAPO/MAT	096	S

|10.12.2010|10:42:20|Prod AT1D002/XL Vers 000: Orders exist (Use report /SAPAPO/RLCDELETE) | /SAPAPO/MAT | 09

[Former Member]

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

[Former Member]

Hello Amol,

Thanks for your response.

I have to delete 1 millions of products and location combination from SNP. How can I run the mass maintenance? Could you please give the detail process?

Thanks

Parves