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...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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.