Skip to Content
avatar image
Former Member

Periodical deletion of old SAP table entries (Release 6.20)

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 10, 2012 at 09:56 AM

    Hello David,

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

    deleting entries from a custom table

    Thanks,

    Siva Kumar

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2012 at 04:35 PM

    Hi David,

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

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

    Regards,

    Arjun

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 10, 2012 at 06:48 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2012 at 02:15 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded