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
Showing results for 
Search instead for 
Did you mean: 

delete a content of field from a database table

Former Member
0 Kudos

Hi All,

i want to delete a content of field mtart from mara where matnr = 0000001.

plz help me out ASAP plz also provide a piece of code for doing so....

Thanks and Regards.

Ashu Singh.

6 REPLIES 6

former_member188685
Active Contributor
0 Kudos

delete from mara where matnr = '0001'.

but if it is mara(standard tabels) table then don't do manual Deletes.

former_member188685
Active Contributor
0 Kudos

use this BAPI BAPI_MATERIAL_DELETE

pass the MATERIAL to this bapi and delete.

former_member188685
Active Contributor
0 Kudos

Convert your post to question.

Former Member
0 Kudos

Hi,

MARA is a Material Master Table, so deleting the Matnr from the database table by query is not good way, because it will effect the entire cycle. So use any standard BAPIs or Function Modules to delete records from any standard tables.

Former Member
0 Kudos

Hi,

You Can Do Like This,

Parameters p_matnr type mara-matnr.

Delete from mara where matnr eq p_matnr.

Try This

Former Member
0 Kudos

update mara set mtart = ' ' where matnr = ' 0000001'.

Reward if useful.