delete row in ztable

[Former Member]

how i can delete 1 row in ztable

[Former Member]

Hi rani,

1. like this.

delete from t001 where bukrs = '1112'.

regards,

amit m.

[Former Member]

delete from ztable where f1 = ...

delete ztable from warea.

[Santosh_Kezkhepatmelathil]

hi

select the row u want to delete and then goto TableEntry

in the menu bar then click delete.

[former_member186741]

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.

[Former Member]

Hi,

SELECT * FROM ZTABLE INTO TABLE ITAB WHERE 'condition'.

DELETE ZTABLE FROM TABLE ITAB.

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

[rahulkavuri]

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.

[Bema]

delete from ztable where fieldname = value

[Former Member]

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

[Former Member]

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...

[Former Member]

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>