Skip to Content
0
Former Member
May 08, 2008 at 08:31 AM

which is the better query ?

37 Views

hi

which is the better query and you

SELECT SUM( bdmng ) FROM resb INTO BDMNG WHERE AUFPL = WA_EBKN-AUFPL AND APLZL = WA_EBKN-APLZL AND AUFNR = WA_EBKN-NPLNR .

or creating a internal table it_bdmng where a field bdmng is used

den

SELECT AUFPL APLZL AUFNR bdmng FROM resb INTO BDMNG WHERE AUFPL = WA_EBKN-AUFPL AND APLZL = WA_EBKN-APLZL AND AUFNR = WA_EBKN-NPLNR .

loop at it_bdmng.

bdmng = bdmng + it_bdmng-bdmng1.

endloop.

point wll b rewarded

Rohan Shetty