topic Re: Data deletion in Application Development and Automation Discussions

Data deletion

Former Member — Sun, 03 Jun 2012 22:56:38 GMT

Hi all,

I have one object to delete BOM data from standard SAP tables. User has provided me the txt file of all the material numbers to be deleted.

Whats the best way to do it? How can I handle the foreign key relationship of material?

Any suggestions will be helpful.

Thanks,

kesavadas_thekkillath — Mon, 04 Jun 2012 05:33:02 GMT

In SCN search for the function module to delete the BOM. It has been discussed many times.

Former Member — Mon, 04 Jun 2012 05:40:41 GMT

Hello J Singh,

The best way to delete the BOM using ABAP program is to use BAPI.

'CSAP_MAT_BOM_DELETE' use this BAPI to delete the BOM.

You have to paas only Material No. and BOM usage as import parameter.

You can load text file contains Material no into internal table in abap program. Then loop that internal table and delete one by one material bom.

Former Member — Thu, 07 Jun 2012 16:09:28 GMT

Thank you Dhiraj.