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

which is the better query ?

23 Views

hi

which is the better query and y

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.

according to me the 1 st one is rite.

point wll b rewarded

Rohan Shetty

Edited by: Rohan Shetty on May 8, 2008 10:32 AM

Edited by: Rohan Shetty on May 8, 2008 10:34 AM