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