10-08-2007 3:11 PM
How to delete all the contents of a Z table and
how to delete selected rows in a z-table.
Thank you
10-08-2007 3: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.
10-08-2007 3: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.
10-08-2007 3:17 PM
I want to add code in my program to let the user delete the contents of the entire z table. and also let the user delete specific rows. This is the requirement. is there is a statement like the refresh statement for internal tables ?
Thank you
10-08-2007 3:20 PM
Krish,
Why dont u generate Table Maintenance and use..... tcode SM30 to maintain....
Chandra.
10-08-2007 3:23 PM
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.
10-08-2007 3: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.
10-08-2007 3:20 PM
Hi Padmam
The statement : DELETE FROM DBTABLE . is asking for a where paramenter, are you sure this is the right statement
10-08-2007 3:30 PM
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.