topic Re: Sum in Loop with condition is not functioning. in Application Development and Automation Discussions

Sum in Loop with condition is not functioning.

suityan98 — Tue, 19 Jul 2022 06:01:16 GMT

I try to applied loop with condition, but it dont functioning, not sure about what reason cause the where statement ignored by the program, any suggestion on it?

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF TABLE LT_LIPS
      WHERE VGBEL = LT_BCODE_I-VGBEL
      AND VGPOS = LT_BCODE_I-VGPOS.

  LOOP AT LT_BCODE_I INTO LT_BCODE_I WHERE VGBEL = LT_LIPS-VGBEL AND VGPOS = LT_LIPS-VGPOS.
    SUM.
    LT_BCODE_I-MENGE = LT_BCODE_I-MENGE.
  ENDLOOP.

Re: Sum in Loop with condition is not functioning.

venkateswaran_k — Tue, 19 Jul 2022 06:08:55 GMT

Hi suityan98

The SUM will be working along with AT END of.. Example as below

LOOP AT itab INTO wa.
  AT END OF comp2.
    SUM.
    cl_demo_output=>write( wa ).
  ENDAT.
ENDLOOP.

So you need to modify your code as something like below

  LOOP AT LT_BCODE_I INTO LT_BCODE_I WHERE VGBEL = LT_LIPS-VGBEL AND VGPOS = LT_LIPS-VGPOS.
    AT END OF LT_LIPS-VGBEL
    SUM.
    your summ fields...
    ENDAT.
  ENDLOOP.

Regards,Venkat

Re: Sum in Loop with condition is not functioning.

suityan98 — Tue, 19 Jul 2022 06:32:37 GMT

Thank you. My problem fixed.