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.