Hi
I have following query & calculation in part-1. I want to change part-1 so that i could achieve the same by Part-2. I know Part-2 is not syntactically good, but any suggestion how to make Part-1 as Part-2. Thanks...
Part-1)
-
SELECT Creation_Date
Rcvd_Date
FROM ZPURCHASE
INTO CORRESPONDING FIELDS OF TABLE ITAB
UP TO 3 ROWS
WHERE Customer = '3000'
ORDER BY Rcvd_Date DESCENDING.
LOOP AT ITAB INTO WA.
WRITE:/ WA-Creation_Date,
WA-Rcvd_Date.
ENDLOOP.
v_sumDays = 0.
v_counter = 0.
LOOP AT ITAB INTO WA.
v_noOfDays = WA-Rcvd_Date - WA-Creation_Date.
v_sumDays = v_sumDays + v_noOfDays.
v_counter = v_counter + 1.
ENDLOOP.
v_leadTime = v_sumDays / v_counter.
-
Part-2)
-
SELECT SUM ( Creation_Date - Rcvd_Date ) / COUNT(*)
FROM ZPURCHASE
INTO CORRESPONDING FIELDS OF TABLE ITAB
UP TO 3 ROWS
WHERE Customer = '3000'
ORDER BY Rcvd_Date DESCENDING.
-