Skip to Content
0
Former Member
Jan 14, 2008 at 05:51 PM

Convert Sum Statement to Collect

317 Views

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.