cancel
Showing results for 
Search instead for 
Did you mean: 

Periodical deletion of old SAP table entries (Release 6.20)

Former Member
0 Kudos

Dear experts,

we would like to periodical delete entries from custom SAP tables. Is there any other possibility than creating a custom report and planning a corresponding background job to do this? We would like to use SAP standard transactions if possible.

Best regards,

David

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello David,

Please take a look at below thread. Hope it can help you.

Thanks,

Siva Kumar

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks for your help!

There seems to be no SAP standard program. We created a custom ABAP report and scheduled a job to do the deletion!

Former Member
0 Kudos

Dear David,

If you want to delete entries of custom table periodically, you can do it with help of abapers.

1) there should be time or date field in that table or field for which you will select you need to delete entries.

2) Ask Abaper to make program which will accept variant as table name & days before which you need to delete entries.They will delete all the entries which is before date (system date - one variant suggested ).

3) Shedule this program as batch in sm36 to run periodically.

Hope it helps,

Regards,

Amit Barnawal

Former Member
0 Kudos

Hi David,

You can use SE14 to blow the entries from the tables.

SE14 --> Delete Data --> Activate and Adjust button

Regards,

Arjun