If a table has millions of records, full deletion becomes time consuming. Try this tip when you need to delete...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.