Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to delete the entire Z table

How to delete all the contents of a Z table and

how to delete selected rows in a z-table.

Thank you

Tags:
Former Member
Former Member replied

Hi,

I'm sure.To Delete all contents use,

<b>DELETE <dbtab>.</b>

U try this Sample Program,

TABLES SPFLI.

DATA: BEGIN OF WA,

CARRID TYPE SPFLI-CARRID,

CONNID TYPE SPFLI-CONNID,

END OF WA.

MOVE 'AA' TO WA-CARRID.

MOVE '0064' TO WA-CONNID.

DELETE SPFLI FROM WA.

MOVE 'LH' TO SPFLI-CARRID.

MOVE '0017' TO SPFLI-CONNID.

DELETE SPFLI.

Regards,

Padmam.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question