If a table has millions of records, full deletion becomes time consuming. Try this tip when you need to delete...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.