Skip to Content
0
Former Member
Jul 22, 2010 at 09:41 PM

Consolidating the SELECT Statement --- ABAP

45 Views

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.

-