Hi,
I am not sure if Collect is better than Select Sum () in terms of performance.
Please advise.
If Collect is better,
please tell me how to convert the following statement to Collect code:
GET ONHAND QTY FROM TABLE MSPR
----
SELECT SUM( PRLAB )
FROM MSPR INTO SUM_ONHAND
WHERE MATNR = EKPO-MATNR
AND WERKS = EKPO-WERKS.
GET RESERVED QTY (OPEN) FROM TABLE RESB
----
SELECT SUM( ENMNG )
FROM RESB INTO SUM_RESERVE
WHERE MATNR = EKPO-MATNR
AND WERKS = EKPO-WERKS
AND XLOEK = SPACE "DELETION INDICATOR
AND KZEAR = SPACE. "FINAL ISSUE INDICATOR
CALCULATE DIFFERENCE AND FILL V_BACKORDER BASED ON THE CONDITION
----
DIFF_ONHAND_RESERVE = SUM_RESERVE - SUM_ONHAND.
IF DIFF_ONHAND_RESERVE > '0'.
V_BACKORDER = 'BACKORDER'.
ENDIF.