获取生产定单状态的函数

data: t_status (200) type c,
         OR_NO LIKE JEST-OBJNR.
*-- 定义内表itab
data: begin of itab occurs 0,
       AUFNR LIKE AFKO-AUFNR,
       GSTRP LIKE AFKO-GSTRP,
       GAMNG LIKE AFKO-GAMNG,
       RSNUM like AFKO-RSNUM,
       STLBEZ LIKE AFKO-STLBEZ,
       skude  like makt-maktx,
       POSNR LIKE resb-POSNR,
       XFEHL LIKE RESB-XFEHL,
       LGORT like resb-lgort,
       MATNR LIKE RESB-MATNR,
end of itab.
*------------

clear itab.
     refresh itab.
    select  AFKO~AUFNR AFKO~GSTRP AFKO~GAMNG
            AFKO~STLBEZ AFKO~RSNUM resb~werks resb~matnr
            resb~bdmng resb~vmeng  resb~lgort RESB~ENMNG
            AFPO~GSBTR
            AFPO~KDAUF AFPO~KDPOS
            into (itab-AUFNR,itab-GSTRP,itab-GAMNG,
                  itab-STLBEZ,itab-RSNUM,itab-werks,
                  itab-matnr,itab-bdmng,itab-vmeng,itab-lgort,
                  ITAB-ENMNG,
                  ITAB-EINDT,
                  ITAB-KDAUF,ITAB-KDPOS)
           from afko
           inner join resb   on  AFKO~RSNUM = RESB~RSNUM
           INNER JOIN AFPO   ON AFKO~AUFNR = AFPO~AUFNR
           where  AFKO~AUFNR in t_order
           and    AFKO~GSTRP in t_date
           and    resb~XFEHL = 'X'
           and    resb~BDART = 'AR'
           and    resb~werks in T_WERKS
           AND    AFPO~KDAUF IN T_KDAUF
           and    resb~bdmng gt 0.

          OR_NO   = 'OR'.
          OR_NO+2 = itab-AUFNR.
          CALL FUNCTION 'STATUS_TEXT_EDIT'
             EXPORTING
             OBJNR       = OR_NO
             ONLY_ACTIVE = 'X'
             SPRAS       = 'E'
             BYPASS_BUFFER = '1'
          IMPORTING
             LINE = t_status.
            IF  t_STATUS NS 'CNF' OR t_status NS 'MACM'  OR t_STATUS NS 'DLV'.
                  append itab.
            ENDIF.
      endselect.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15117617/viewspace-551897/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/15117617/viewspace-551897/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值