topic Re: Delete Statement in Application Development and Automation Discussions

Delete Statement

Former Member — Wed, 13 Sep 2006 13:50:34 GMT

Hello friends,

I want to delete some rows from an internal table based on a where condition depending on another internal table.

DELETE it_knvp

FOR ALL ENTRIES IN it_vbpa

WHERE kunnr = it_vbpa-kunnr.

In the above code both the internal tables have kunnr.

But the above code is not correct.

Any advice.

Shejal Shetty.

Re: Delete Statement

anversha_s — Wed, 13 Sep 2006 13:53:49 GMT

chk this code.

*it_knvp should be occurs 0 with header line

loop at it_knvp.

read table it_vbpa with key kunnr = it_knvp-kunnr.

if sy-subrc = 0 .

DELETE TABLE it_knvp FROM it_knvp.

endif.

endloop.

rgds

anver

if helped pls mark points

Re: Delete Statement

Former Member — Wed, 13 Sep 2006 13:54:47 GMT

Hi Shejal,

Try this:

loop at it_vbpa.

delete it_knvp where kunnr = it_vbpa-kunnr.

endloop.

Regards,

Vivek

Re: Delete Statement

Former Member — Wed, 13 Sep 2006 13:55:51 GMT

Thanks Anversha,

I am looking for a way to do it without using the loop statement.

Thanks again,

Shejal.

Re: Delete Statement

Former Member — Wed, 13 Sep 2006 13:56:20 GMT

hi,

do this way ..

loop at it_vbpa.

read table it_vbpa  where< Conditions>

if sy-subrc = 0.

delete it_vbpa

endif
endloop.

Re: Delete Statement

Former Member — Wed, 13 Sep 2006 13:57:20 GMT

then use RANGES.

RANGES : R_KUNNR FOR KNA1-KUNNR.

R_KUNNR-SIGN = 'I'.

R_KUNNR-OPTION = 'EQ'.

LOOP AT it_vbpa.

R_KUNNR-LOW = it_vbpa-KUNNR.

APPEND R_KUNNR.

ENDLOOP.

IF you want to delete IT_KNVP records based on IT_VBPA,

1. if record exists in IT_VBPA then if you want to delete IT_KNVP also,then do

DELETE IT_KNVP WHERE KUNNR IN R_KUNNR.

2. IF you want to delete entries from IT_KNVP where KUNNR not in IT_VBPA,then

DELETE IT_VBPA WHERE KUNNR NOT IN R_KUNNR.

regards

srikanth

Message was edited by: Srikanth Kidambi

Re: Delete Statement

anversha_s — Wed, 13 Sep 2006 13:58:02 GMT

hi shejal,

for all entries is not possible in DELETE syntax.

thats y i went for loop.

since it is an internal table, there will not be nay performance issue.

rgds

anver

Re: Delete Statement

Former Member — Wed, 13 Sep 2006 14:01:13 GMT

i dont know the way to work in delete

with "FOR ALL ENTRIES "

i work like this

loop at [first internal table]

read [second table] with key if kunner = kunner

if sy-subrc = 0 .

delete second table index sy-tabix

endif.

endloop

Re: Delete Statement

Former Member — Wed, 13 Sep 2006 14:05:14 GMT

Thanks Everyone for all the advice and suggestions.

Shejal Shetty.