topic Re: delete itab in Application Development and Automation Discussions

delete itab

Former Member — Wed, 20 Aug 2008 11:03:49 GMT

hi all,

Can I write like this :

delete itab where charg not in s_charg.

where

Re: delete itab

Former Member — Wed, 20 Aug 2008 11:07:09 GMT

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

Re: delete itab

GauthamV — Wed, 20 Aug 2008 11:07:49 GMT

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.

Re: delete itab

Former Member — Wed, 20 Aug 2008 11:09:11 GMT

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

Amit.

Re: delete itab

former_member200872 — Wed, 20 Aug 2008 11:09:21 GMT

Hi,

Syntactically it is correct.

Re: delete itab

vinod_vemuru2 — Wed, 20 Aug 2008 11:09:24 GMT

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.

Re: delete itab

Former Member — Wed, 20 Aug 2008 11:09:57 GMT

Hi,

Yes you can write. its correct statement.

Regards,

Sathish Reddy.

Re: delete itab

Former Member — Wed, 20 Aug 2008 11:11:37 GMT

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.

Re: delete itab

Former Member — Wed, 20 Aug 2008 11:20:46 GMT

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