topic Re: Loop on item table in Application Development and Automation Discussions

Loop on item table

Former Member — Thu, 27 Aug 2009 08:23:19 GMT

Hi all,

I want to loop on required records only in Item table (i_vbap). My code as follows


LOOP AT i_vbak
  READ TABLE i_vbap WITH KEY vbeln = i_vbak-vbeln.
  IF sy-subrc = 0.
 LOOP AT i_vbap.
    IF i_vbap-vbeln = i_vbak-vbeln.
      MOVE i_vbap TO i_vbap1.
      APPEND i_vbap1.
    ENDIF.
  ENDLOOP.
ENDLOOP.

in 2nd loop, it is looping all records in i_vbap. but i want to loop only when vbeln = i_vbak-vbeln (as in read statement ).

Plz help me on this. Thanks in advance.

Regards.

Re: Loop on item table

former_member386202 — Thu, 27 Aug 2009 08:25:54 GMT

Hi,

do like this

LOOP AT i_vbak

READ TABLE i_vbap WITH KEY vbeln = i_vbak-vbeln.

IF sy-subrc = 0.

LOOP AT i_vbap where vbeln = i_vbak-vbeln .

IF i_vbap-vbeln = i_vbak-vbeln.

MOVE i_vbap TO i_vbap1.

APPEND i_vbap1.

ENDIF.

ENDLOOP.

Regards,

Prashant

Re: Loop on item table

GauthamV — Thu, 27 Aug 2009 08:26:21 GMT

use like this.


LOOP AT i_vbak
  READ TABLE i_vbap WITH KEY vbeln = i_vbak-vbeln.
  IF sy-subrc = 0.
 LOOP AT i_vbap where vbeln = i_vbak-vbeln..
        MOVE i_vbap TO i_vbap1.
      APPEND i_vbap1.
      ENDLOOP.
ENDLOOP.

Re: Loop on item table

Former Member — Thu, 27 Aug 2009 08:27:00 GMT

Hi,

Try like this,


LOOP AT i_vbak
 LOOP AT i_vbap where vbeln = i_vbak-vbeln.  "------> Remove the read statement and add the condition in loop itself
    IF i_vbap-vbeln = i_vbak-vbeln.
      MOVE i_vbap TO i_vbap1.
      APPEND i_vbap1.
  ENDLOOP.
ENDLOOP.

Regards,

Vikranth

Re: Loop on item table

Former Member — Thu, 27 Aug 2009 08:35:38 GMT

you can use where conditon with loop statement ...press F1 on loop to get more details regarding where clause..