Skip to Content
0
Former Member
Mar 25, 2009 at 04:18 PM

directly checking database values logic

17 Views

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.