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: 

Deleting a Record

Former Member
0 Kudos

How to delete a record from a system table after evaluation?

8 REPLIES 8

Former Member
0 Kudos

cannot do it directly, which table are you talking bout?

0 Kudos

Say for MARA,MAKT

Like i want to delete a material and its entire record.

0 Kudos

You should use the respective BAPI's for doing any king of operations.

BAPI_MATERIAL_SAVE_DATA with a deletion indicator will put the deletion indicator. Master Data is never deleted from the tables, its only a deletion indicator in the database.

Regards,

Ravi

Note :Please mark the helpful answers

0 Kudos

How to check the deletion indicator in BAPI_MATERIAL_SAVE_DATA so as mark a record off.

0 Kudos

Hi,

There is the field DEL_FLAG in the BAPI_MARA which is the parameter of the function.

Set this field and the material will be marked as deleted. You also need to set X in the structure BAPI_MARAX for all the fields that you want to change.

Regards,

Ravi

Note :Please mark the helpful answers and close the thread if the issue is resolved.

Former Member
0 Kudos

Hi,

This is not recommended as it might cause further problems.

rgds,

latheesh

former_member184569
Active Contributor
0 Kudos

HI Anirban,

YOu can delete it through a dummy program.

DELETE FROM mara CLIENT SPECIFIED

WHERE MANDT = '020' AND

matnr = '12245' and

ersda = '20051111' AND

ernam = 'JTHOMAS'.

Regards,

Susmitha.

Mark helpful answers.

Former Member
0 Kudos

Hi,

Write code 'delete from mara where matnr eq 1. (specify the evaluating condition here).

Regards.

Lavanya.