Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 08, 2007 at 02:17 PM

    HI,

    To Delete all Contents of Z-Table,Use Syntax

    <b>DELETE [FROM] <dbtab>.</b>

    To Delete selected rows of Z-Table,Use Syntax

    <b>DELETE FROM <target> WHERE <cond> .</b>

    Regards,

    Padmam.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • avatar image
    Former Member
    Oct 08, 2007 at 02:15 PM

    Hi,

    You can delete all the entries in the Z table by using TCode SE14.

    Give table name click ion edit button and select Delete data radion button and click on Active and adjust database.

    Thanks,

    Sriram Ponna.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      It is a dialog program , I have to let the user choose whether to add , delete entries in the table by making him choose radio buttons. So I Have to include code in the main program for these functionalities.