Fast deletion of SAP table content

Need to quickly delete millions of records in an SAP table? Learn how with this user-submitted tip from SearchSAP.com.

If a table has millions of records, full deletion becomes time consuming. Try this tip when you need to delete...

data quickly -- it works in seconds.

Editor's note: This tip works on an SAP 4.6C, WAS620 and WAS640 system (i.e., all currently suppported SAP platforms). Note that it is a tricky function that should only be used by programmers who know what they are doing.

* Use function from SE14

        call function 'DD_DATABASE_UTILITY'
             exporting
                  fct                     = 'MDF'
                  obj_name                = 'TABLE_NAME'
                  obj_type                = 'TABL'
                  exec_modus              = 'S'
             importing
                  subrc                   = sl_subrc
             exceptions
                  unexpected_error        = 1
                  unsupported_function    = 2
                  unsupported_obj_type    = 3
                  table_is_locked_by_tcnv = 4
                  authority_check_failed  = 5
                  abort_function          = 6
                  conversion_error        = 7
                  others                  = 8.

        if sl_subrc = 0 and sy-subrc = 0.
          write:/ '&1', '- Table Deleted OK'.
          commit work and wait.
        else.
          sl_status = 1.                          "Deletion Failed
          write:/ '&1', '- Table Deletion FAILED'.
        endif.

This was last published in January 2006

Dig Deeper on SAP ABAP

PRO+

Content

Find more PRO+ content and other member only offers, here.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close