topic Re: delete statement. in Application Development and Automation Discussions

delete statement.

Former Member — Thu, 05 Oct 2006 18:49:15 GMT

Hello friends,

I have 2 internal tables. IT1_knvp and IT2_knvp.

IT1_knvp contains some data which already exists in it2_KNVP. so i want to delete it1_knvp based on it2_knvp kunn2.

Below is the code i am using but it does not work.

LOOP AT it2_knvp.

LOOP AT it1_knvp.

DELETE it1_knvp

where kunn2 = it2_knvp.

ENDLOOP.

Shejal.

Re: delete statement.

RichHeilman — Thu, 05 Oct 2006 18:51:19 GMT

It appears that you forgot the KUNN2 field in your DELETE statement and you don't need the LOOP at IT1_KNVP

LOOP AT it2_knvp.

    DELETE it1_knvp
         where kunn2 = <b>it2_knvp-kunn2.</b>

ENDLOOP.

REgards,

Rich Heilman

Re: delete statement.

ferry_lianto — Thu, 05 Oct 2006 18:51:22 GMT

Hi,

Please try this.

LOOP AT it2_knvp.

DELETE it1_knvp

where kunn2 = it2_knvp-kunn2.

ENDLOOP.

Regards,

Ferry Lianto

Re: delete statement.

Former Member — Thu, 05 Oct 2006 18:51:39 GMT

Hi Shejal,

DELETE statement will delete all records which satifies that condition. So need of LOOP..ENDLOOP on IT1_KNVP.

Try with this code.

LOOP AT it2_knvp.

DELETE it1_knvp

where kunn2 = it2_knvp-kunn2.

ENDLOOP.

For better Performance,

SORT IT2_KNVP BY KUNN2.

LOOP AT it2_knvp.

AT NEW KUNN2.

DELETE it1_knvp

where kunn2 = it2_knvp-kunn2.

ENDAT.

ENDLOOP.

Thanks,

Vinay

Re: delete statement.

Former Member — Thu, 05 Oct 2006 18:52:45 GMT

Hi,

Try this..

LOOP AT IT2_KNVP.

DELETE IT1_KNVP WHERE KUNN2 = IT2_KNVP-KUNN2.

ENDLOOP.

Thanks,

Naren

Re: delete statement.

Former Member — Thu, 05 Oct 2006 18:56:39 GMT

Assuming there are no more than 1 entry to be deleted from it1_knvp for an entry in it2_knvp, try:


SORT it1_knvp BY kunn2,
     it2_knvp by kunn2.

LOOP AT it2_knvp.
  READ TABLE it1-knvp1 WITH KEY
    kunn2 = it2_knvp-kunn2
    BINARY SEARCH.
  IF sy-subrc = 0.
    DELETE it1_knvp INDEX sy-tabix.
  ENDIF.
ENDLOOP

Rob