Delete all records in multiple tables

[Former Member]

Hi experts,

I know there is a transaction to erase multiple tables in SAP but I don't remember which...

Anyone knows it ? Thanx a lot in advance !

[Former Member]

Hi Marco,

Are you delete you delete standard tables or customized tables.

Just want to know for knowledge purpose.

Usally we use SE14 for deleting tables.

Cheers!!

Balu

[Former Member]

Hi,

You can instead use the function DB_DROP_TABLE

and pass the tablename on loop statement.

You need to use a report then.

But I suppose its too complicated for you.

Try also to customized it into a new transaction for the future use.

Regards,

Kais

[Former Member]

Hi,

Both from Program & Transaction Codes, you can only delete a Single Table/Table Data one at a time...

[former_member194669]

No transaction to delete records from Multiple tables. May be u can use SM30 or SE16N to delete records from a table.

a®

[Former Member]

anything against your employer or client :- )