Sum in Loop with condition is not functioning.

[suityan98]

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.

[suityan98]

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

[venkateswaran_k]

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

[suityan98]

Thank you. My problem fixed.