COM_PRODUCT_DELETE_ALL or COM_PRODUCT_DELETE_SINGLE on production system

[Former Member]

Dear experts,

Does anybody use COM_PRODUCT_DELETE_ALL or COM_PRODUCT_DELETE_SINGLE on production system?

I want to know if there are any problems when using them.

We might use them due to material download failure from ERP .

The filters don't work only when creating big amounts of materials by using BAPI.

We have to prepare for the failure in case we can't solve it.

Note 1083822 describes "never run any of the below mentioned deletion reports on the PRODUCTION SYSTEM".

I think it doesn't matter to run them before products are assinged transactions or ibases.

Regards,

Fukuhara Yohei

[Former Member · Accepted solution]

Hi,

We have used this program in development and Test without any issues.

And I Agree with you that unless you have transactions assigned to it. There is no harm in using these methods to delete products.

Try with one product first

Ajay Gupta

[Former Member]

Hi Yohei,

Though SAP recommends this report not to be used in prod environment, we have used it keeping in view the middleware issues as faced by you. There are a couple of points which you have to ensure before executing this.

1) You should be able to replicate the product being deleted using std middleware (probably via a request download) without errors from the ECC system at the EARLIEST

2) No transactions involving this master data should be created during this time (between deletion and re-"initial download")

3)No reports accessing this data have to be executed during this time

4) Any delta changes made to CRM Product and not available in ECC material master data will be lost.

Most of the admin reports, SAP recommends not be executed in prod environment as this MAY result in permanent data loss. one such example is crm_order_delete.

Regds,

Raghu

[Former Member]

Hi,

Thank you Ajay and Raghu.

I'll keep what you pointed out in my mind.

I'm going to use COM_PRODUCT_DELETE_ALL on demo system.

If any bad effect doesn't happen, I'll run it on our client's test system.

I'll post the result after that.

Regards,

Fukuhara Yohei

[Former Member]

Hi,

I managed to run COM_PRODUCT_DELETE_ALL on demo system and test system.

Nothing bad happened at that time.

Regards,

Fukuhara Yohei

[Former Member]

Hi,

Why don't you go for an archiving solution that will also delete the products from the database?

If you use archiving object PRODUCT_MD, you will be archiving (and deleting) the products flagged for archiving (given that the products can be archived).

With the archiving solution, you'll be using 4 SAP standard programs:

• preprocessing program: COM_PRODUCT_SELECTIONS

• write program: COM_PRODUCT_ARC_WRITE

• delete program: COM_PRODUCT_ARC_CHECKBACK

• postprocessing program: COM_PRODUCT_ARC_DELETE

Hope this helps.

[Former Member]

Hi,

I won't archive products,

since it archive flag affects ERP material master.

I want to and download ERP materials without changing them.

Regards,

Fukuhara Yohei