cancel
Showing results for 
Search instead for 
Did you mean: 

Deletion of 2 entries(records) from table MDTB. How to proceed.if yes how.

Former Member
0 Kudos

Dear All,

I need to delete 2 records from the table MDTB.

Please suggest me if i can proceed with the same.

If yes .How.

Reason for deletion of records from MDTB: The orders referenced in MD04 have been deleted/archived (but they still appear in MD04).Unfortunately, the person who did the archiving didn't follow the process correctly (they should have run some clean-up programs to clean up MD04 before archiving). Now we are left with orders that don't exist any longer appearing in tables which MD04 reads and this has to be cleaned up.

Please suggest me if as an ABAPer i can proceed with the same.

If yes .How.

Regards,

ABAPer.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member203501
Active Contributor
0 Kudos

you can delete the entries based on the date or based on the user id and based on the order numbers..

go for the syntax for the delete

Former Member
0 Kudos

Ask if any of your BASIS people can do the same, It is not a good practice to delete from program.

Use delete statement only if it has to be done.

Example:

DELETE FROM employees WHERE employee_id = 23

make sure you have given all key fields properly otherwise it will delete other entries as well.