Hi Experts,
I have a following query in a loop.
LOOP AT it_ekpo.
CLEAR: wrk_invmenge.
SELECT * FROM ekbe
WHERE ebeln = it_ekpo-ebeln
AND ebelp = it_ekpo-ebelp
and budat in bldat_i
AND vgabe = '2'. " for inv based entries
IF ekbe-shkzg = 'H'.
ekbe-menge = ekbe-menge * ( -1 ).
ENDIF.
wrk_invmenge = wrk_invmenge + ekbe-menge.
ENDSELECT.
Now , I want to put this select query like this
if not it_ekpo is initial.
SELECT * FROM ekbe into table it_ekbe
WHERE ebeln = it_ekpo-ebeln
AND ebelp = it_ekpo-ebelp
AND vgabe = '2'. " for inv based entries
endif.
Now , I am reading this internal table it_ekbe and I am not sure how acheive to following condition .
IF ekbe-shkzg = 'H'.
ekbe-menge = ekbe-menge * ( -1 ).
ENDIF.
wrk_invmenge = wrk_invmenge + ekbe-menge.
ENDSELECT.