05-30-2006 9:26 AM
05-30-2006 9:27 AM
Hi rani,
1. like this.
delete from t001 where bukrs = '1112'.
regards,
amit m.
05-30-2006 9:30 AM
05-30-2006 9:30 AM
hi
select the row u want to delete and then goto TableEntry
in the menu bar then click delete.
05-30-2006 9:30 AM
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.
05-30-2006 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
05-30-2006 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.
05-30-2006 9:34 AM
05-30-2006 9:49 AM
Hi,
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
05-30-2006 9:50 AM
hi
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...
05-30-2006 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>