2006 May 30 9:26 AM
how i can delete 1 row in ztable
2006 May 30 9:27 AM
Hi rani,
1. like this.
delete from t001 where bukrs = '1112'.
regards,
amit m.
2006 May 30 9:30 AM
delete from ztable where f1 = ...
delete ztable from warea.
hi
select the row u want to delete and then goto TableEntry
in the menu bar then click delete.
1. you can generate table maintenance via se11.
2. if the table is tagged as 'display/maintenance allowed' on the 'delivery and maintenance' tab of se11 you can use se16 to delete rows.
3. you can write an abap to delete rows for you. This can be as simple or complex as you like.
2006 May 30 9:32 AM
Hi,
SELECT * FROM ZTABLE INTO TABLE ITAB WHERE 'condition'.
DELETE ZTABLE FROM TABLE ITAB.
rgds,
latheesh
Message was edited by: Latheesh Kaduthara
2006 May 30 9:33 AM
To delete records from a database table, you use the DELETE statement.
<b>DELETE FROM SFLIGHT WHERE CARRID = ‘LH’ AND CONNID = ‘454’.
Will delete the single record where conditions are met from SFLIGHT.</b>
You can <b>delete the multiple reco</b>rds from database table by putting all the records, which you want to delete in internal table. For example
<b>DELETE SFLIGHT FROM TABLE ITAB.</b>
In this case whatever you have in internal table will be deleted from SFLIHT.
Note: append internal table with all the entries, which you want to delete.
2006 May 30 9:34 AM
delete from ztable where fieldname = value
2006 May 30 9:49 AM
select that record using select single or select up to one rows then collect it to wa.
<b>select single * from ztable into wa where key1 = value key2 = value2.</b>
<b>
delete ztable from wa.</b>
Regards
vijay
2006 May 30 9:50 AM
if ur requirement is to delete records from Ztable while table is undfer loop do it as :
loop at itab into w_itab where a > 100 .
delete from ztable where a = w_itab-a .
endloop .
where a being the field of same data element in these table...
hope this is clear...
thanks...
2006 May 30 9:55 AM
Hi Rani,
Have a look at the following demo programs in SE38.
Reward points to all helpful answers and close the thread.
<b>DEMO_INT_TABLES_DELETE_ADJACEN
DEMO_INT_TABLES_DELETE_FROM
DEMO_INT_TABLES_DELETE_IND_1
DEMO_INT_TABLES_DELETE_IND_2
DEMO_INT_TABLES_DELETE_IND_3
DEMO_INT_TABLES_DELETE_WHERE </b>
Bluesky
