由交货单到订单的取数分两种情况:
IF WA_BELNR-LFART <> 'ZNLN' AND WA_BELNR-LFART <> 'ZNL'.
SELECT SINGLE
VBELV "订单号
INTO WA_BELNR-VBELNV
FROM VBFA
WHERE VBELN = WA_BELNR-VBELN
AND ( VBTYP_N = 'J' OR VBTYP_N = 'C' ).
SELECT SINGLE BEZEI "订单类型
INTO WA_BELNR-BEZEI1
FROM TVAKT
WHERE AUART = ( SELECT AUART
FROM VBAK
WHERE VBELN = WA_BELNR-VBELNV ).
SELECT SINGLE
ERNAM "制单人
INTO WA_BELNR-ERNAMV
FROM VBAK
WHERE VBELN = WA_BELNR-VBELNV.
ELSE. "如果是调拨类型
SELECT SINGLE
EBELN "采购订单号作订单号
INTO WA_BELNR-VBELNV
FROM EKBE
WHERE BELNR = WA_BELNR-VBELN.
SELECT SINGLE
BATXT
INTO WA_BELNR-BEZEI1
FROM T161T
WHERE BSART = ( SELECT BSART
FROM EKKO
WHERE EBELN = WA_BELNR-VBELNV ).
ENDIF.
评论