Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

how to delete master data of materials from sap tables

Former Member

‎01-10-2007 6:50 AM

0 Kudos

how to delete master data of materials from sap tables...its needed now.

i know its not recommended but still we need to do this. give me the best possible approach.

regards,

suneetha

2 REPLIES 2

Former Member

‎01-10-2007 7:05 AM

0 Kudos

Consider using archive object: <b>MM_MATNR</b>.

Transaction: <b>SARA</b>.

Please do not try to use the object if you are not totally sure...

Regards

Eswar

Former Member

‎01-10-2007 7:31 AM

0 Kudos

Hi,

I would suggest you not to write your own code to delete the entries.

BAPI_MATERIAL_DELETE, this would mark all materials selected for deletion. But still the material would exist in SAP.

Another solution: Delete a material manually and in another session execute the transaction SM04. This would display the tables which get locked when you do the operation, Then you can write your own code to delete the material numbers from all the related tables.

Regards

Subramanian