delete all entries from table

[Former Member]

Hi Guys,

How to delete all entries from a table?

is a customer table, and i dont want to delete doing a loop.

because is a huge table.

any ideas?

PS: ..CUSTOMER TABLE...

[Former Member]

hi,

Write a custom program and write the below code ..

delete <ztable>.

Regards,

Santosh

[Former Member]

DELETE Does not work like that.

you need at least one from with a where condition.

I tried

DELETE FROM ztable

client especified

where mandt = sy-mandt.

but is not working.

[Former Member]

try using SE16N or use ,..

delete ZTABLE .

[Former Member]

You can use the statement DELETE

DELETE ZTABLE.

[Former Member]

From SE14.

give table name than edit select redio button delete data .

[Former Member]

Quick way is to use native SQL (ie EXEC SQL ENDEXEC) and the TRUNCATE commaned.

Alternatively use ABAP command DELETE:

DELETE from <tab> client-specified where mandt = '001'.

[Former Member]

Does not work

I solved the problem, but the performance is not as good as i wanted.

SELECT *

INTO CORRESPONDING FIELDS OF ti_ztable

FROM ztable.

DELETE FROM ztable

WHERE key = ti_zce1pisa-key.

ENDSELECT.

[Former Member]

Javier,

have you tried this?

From SE14.

give table name than edit select redio button delete data .

[Former Member]

Of course that is an option,

but i need that in ABAP code. (call transaction for only a delete is 2 much)

tks anyway.

[Former Member]

if you need a condition...you can use a dummy one...

DELETE FROM ztable

where 1 = 1.

[former_member190578]

DELETE FROM ztable where key ne space.

[Former Member]

hi,

Create a table maintainence generator and then goto SM30 and delete the entries from here ...

Regards,

Santosh