delete itab

[Former Member]

hi all,

Can I write like this :

delete itab where charg not in s_charg.

where

[Former Member]

you could have simply put the statement in a report and tried to activate it. it would have given you the answer whether you can write this or not.

However, the answer is YES you can write a statement like this...

the table specified after IN should have the structure of a seltab with sign, option, low and high

[GauthamV]

hi,

syntax for delete :

Deleting from a Database Table

- DELETE FROM dbtab. or

DELETE FROM (dbtabname).

- DELETE dbtab FROM wa. or

DELETE (dbtabname) FROM wa.

- DELETE dbtab FROM TABLE itab. or

DELETE (dbtabname) FROM TABLE itab.

- DELETE dbtab. or

DELETE *dbtab.

- DELETE dbtab VERSION vers. or

DELETE *dbtab VERSION vers.

Delete from an internal table

- DELETE itab.

- DELETE TABLE itab WITH TABLE KEY k1 = v1 ... kn = vn.

- DELETE TABLE itab [FROM wa].

- DELETE itab INDEX idx.

- DELETE itab FROM idx1 TO idx2.

- DELETE itab WHERE logexp.

- DELETE ADJACENT DUPLICATES FROM itab.

[Former Member]

can you not try yourself. and see if we can write in this fashion or not?

Amit.

[former_member200872]

Hi,

Syntactically it is correct.

[vinod_vemuru2]

Hi Uday,

No. We can't have IN operator with delete where clause.

Why can't u fileter the data while selecting itself.

Thanks,

Vinod.

[Former Member]

Hi,

Yes you can write. its correct statement.

Regards,

Sathish Reddy.

[Former Member]

yes..y can do this..

Pl. check this sample code:

REPORT Z_TEST_JG.

tables: mseg.

data: itab type standard table of mseg.

select-options: s_charg for mseg-charg.

select * from mseg into table itab

up to 100 rows.

check sy-subrc = 0.

delete itab where charg not in s_charg.

[Former Member]

ya it right..

u can write it but in loop-endloop.

Loop at itab.

delete itab where charg not in s_charg.

Endloop.

Edited by: Sachin Gupta on Aug 20, 2008 1:22 PM