BAPI_GOODSMVT_CREATE工单超领发料程式

本文介绍了一种通过SAP BAPI_GOODSMVT_CREATE接口实现工单超领发料的方法。该方法首先从文件中读取发料数据,并进行必要的数据转换,然后调用BAPI接口完成超领发料的动作。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

原文地址:http://blog.sina.com.cn/s/blog_50e6797e01009fth.html

 

由于工厂需要这样的需求,所以我通过对BAPI_GOODSMVT_CREATE的分析,了解到了工单超领发料动作在这个bapi是怎么实现的了.下面我实现的过程,拿出来和大家一起分享,如果大家还有其他的建议,请告知我,谢谢:

* GMCODE Table T158G - 01 - MB01 - Goods Receipts for Purchase Order
                     02 - MB31 - Goods Receipts for Prod Order
                     03 - MB1A - Goods Issue
                     04 - MB1B - Transfer Posting
                     05 - MB1C - Enter Other Goods Receipt
                     06 - MB11
*
* Domain: KZBEW - Movement Indicator
     Goods movement w/o reference
B - Goods movement for purchase order
F - Goods movement for production order
L - Goods movement for delivery note
K - Goods movement for kanban requirement (WM - internal only)
O - Subsequent adjustment of "material-provided" consumption
W - Subsequent adjustment of proportion/product unit material

*&---------------------------------------------------------------------*
*& Report  ZCNRPP0018                                                  *
*& description: AKMC WO 超领物料自动过帐                              *
*& author  : tom.bai                                                   *
*& date: 20080309                                                      *
*&---------------------------------------------------------------------*

REPORT  ZCNRPP0018                              .

TABLES: RESB,
        RLGRAP,
        AFKO.
* FLAG
DATA: FLAG(4).


DATA:BEGIN OF LT_ITEM OCCURS 0,
      AUFNR LIKE AFKO-AUFNR,
      MATNR LIKE RESB-MATNR,
      ERFMG LIKE RESB-ERFMG.
DATA:END OF LT_ITEM.

*Material Document Header Data

DATA: LT_GM_HEAD TYPE STANDARD TABLE OF BAPI2017_GM_HEAD_01,
      L_GM_HEAD  LIKE BAPI2017_GM_HEAD_01,

* New Key Assignment GM_CODE to Transaction of Inv. Mgmt
      LT_GM_CODE TYPE STANDARD TABLE OF BAPI2017_GM_CODE,
      L_GM_CODE  LIKE BAPI2017_GM_CODE,

      LT_MAT_DOC TYPE STANDARD TABLE OF BAPI2017_GM_HEAD_RET,
      L_MAT_DOC LIKE BAPI2017_GM_HEAD_RET,


      LT_GM_ITEM TYPE STANDARD TABLE OF BAPI2017_GM_ITEM_CREATE,
      L_GM_ITEM LIKE BAPI2017_GM_ITEM_CREATE,

 

      LT_RETURN TYPE STANDARD TABLE OF BAPIRET2,
      L_RETURN  TYPE BAPIRET2,

      L_ERRFLAG(1) TYPE C.
*以发料小于需求量,
DATA: LT_GM_ITEM1 TYPE STANDARD TABLE OF BAPI2017_GM_ITEM_CREATE,
      L_GM_ITEM1 LIKE BAPI2017_GM_ITEM_CREATE.

 

 


SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETERS: P_FILE LIKE RLGRAP-FILENAME DEFAULT 'C:/WOexcess.TXT'.
PARAMETERS: P_INDEX AS CHECKBOX .
SELECTION-SCREEN END OF BLOCK B1.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FILE.
  PERFORM GET_FILE_NAME CHANGING P_FILE.

INITIALIZATION.
  PERFORM INITIAL_ITAB.

START-OF-SELECTION.
  PERFORM GET_DATA.
  PERFORM PROCESS_DATA.
  PERFORM CALL_BAPI_PROCESS.

*&---------------------------------------------------------------------*
*&      Form  GET_FILE_NAME
*&---------------------------------------------------------------------*
      text
*----------------------------------------------------------------------*
     <--P_P_FILE  text
*----------------------------------------------------------------------*
FORM GET_FILE_NAME  CHANGING P_FILE.
  CALL FUNCTION 'WS_FILENAME_GET'
    EXPORTING
      MASK             = '*.txt.'
      MODE             = '0'
      TITLE            = '选取数据文件路径'
    IMPORTING
      FILENAME         = P_FILE
    EXCEPTIONS
      INV_WINSYS       = 1
      NO_BATCH         = 2
      SELECTION_CANCEL = 3
      SELECTION_ERROR  = 4
      OTHERS           = 5.
ENDFORM.                    " GET_FILE_NAME
*&---------------------------------------------------------------------*
*&      Form  INITIAL_ITAB
*&---------------------------------------------------------------------*
      text
*----------------------------------------------------------------------*
-->  p1        text
<--  p2        text
*----------------------------------------------------------------------*
FORM INITIAL_ITAB .
  CLEAR:LT_ITEM,L_GM_HEAD,L_GM_CODE,L_MAT_DOC,L_GM_ITEM,L_RETURN.
  REFRESH: LT_ITEM,LT_GM_HEAD, LT_GM_CODE, LT_MAT_DOC ,LT_GM_ITEM, LT_RETURN.
  FLAG = 'YES'.
ENDFORM.                    " INITIAL_ITAB
*&---------------------------------------------------------------------*
*&      Form  GET_DATA
*&---------------------------------------------------------------------*
      text
*----------------------------------------------------------------------*
-->  p1        text
<--  p2        text
*----------------------------------------------------------------------*
FORM GET_DATA .
  CALL FUNCTION 'WS_UPLOAD'
    EXPORTING
      FILENAME     = P_FILE
      FILETYPE     = 'DAT'
    TABLES
      DATA_TAB     = LT_ITEM.
  IF SY-SUBRC NE 0.
    EXIT.
  ELSE.
    LOOP AT LT_ITEM.
      CALL FUNCTION 'CONVERSION_EXIT_MATN1_INPUT'
        EXPORTING
          INPUT      = LT_ITEM-MATNR
        IMPORTING
          OUTPUT     = LT_ITEM-MATNR.
      MODIFY LT_ITEM.
    ENDLOOP.
  ENDIF.

ENDFORM.                    " GET_DATA
*&---------------------------------------------------------------------*
*&      Form  PROCESS_DATA
*&---------------------------------------------------------------------*
      text
*----------------------------------------------------------------------*
-->  p1        text
<--  p2        text
*----------------------------------------------------------------------*
FORM PROCESS_DATA .
  LOOP AT LT_ITEM.
    SELECT SINGLE RSNUM INTO AFKO-RSNUM   "得到预留单号
      FROM AFKO
      WHERE AUFNR = LT_ITEM-AUFNR.
    L_GM_ITEM-RESERV_NO = AFKO-RSNUM.
    L_GM_ITEM-MATERIAL  = LT_ITEM-MATNR.
    L_GM_ITEM-ORDERID   = LT_ITEM-AUFNR.
    L_GM_ITEM-ENTRY_QNT = LT_ITEM-ERFMG.
    APPEND L_GM_ITEM TO LT_GM_ITEM.
    CLEAR :L_GM_ITEM,LT_ITEM.
  ENDLOOP.

  LOOP AT LT_GM_ITEM INTO L_GM_ITEM.
    SELECT SINGLE RSPOS WERKS LGORT ENMNG BDMNG
      INTO (RESB-RSPOS,RESB-WERKS,RESB-LGORT,RESB-ENMNG,RESB-BDMNG) "得到预留单项号,工厂,库位
      FROM RESB
      WHERE RSNUM = L_GM_ITEM-RESERV_NO
        AND MATNR = L_GM_ITEM-MATERIAL.
    IF RESB-ENMNG >= RESB-BDMNG.
      L_GM_ITEM-RES_ITEM = RESB-RSPOS.
      L_GM_ITEM-PLANT = RESB-WERKS.
      L_GM_ITEM-STGE_LOC = RESB-LGORT.
      L_GM_ITEM-MOVE_TYPE  = '261'.
      L_GM_ITEM-ENTRY_UOM  = 'ST'.
      L_GM_ITEM-IND_PROPOSE_QUANX = 'X'.
      MODIFY LT_GM_ITEM FROM L_GM_ITEM.
    ELSEIF RESB-ENMNG < RESB-BDMNG.
      L_GM_ITEM1-ORDERID   = L_GM_ITEM-ORDERID.
      L_GM_ITEM1-MATERIAL  = L_GM_ITEM-MATERIAL.
      L_GM_ITEM1-ENTRY_QNT = L_GM_ITEM-ENTRY_QNT.
      APPEND L_GM_ITEM1 TO LT_GM_ITEM1.
      CLEAR L_GM_ITEM1.
    ENDIF.
  ENDLOOP.
  IF P_INDEX = 'X'.
    LOOP AT LT_GM_ITEM INTO L_GM_ITEM.
      WRITE:/ L_GM_ITEM-ORDERID ,L_GM_ITEM-MATERIAL,L_GM_ITEM-RESERV_NO,L_GM_ITEM-RES_ITEM,L_GM_ITEM-ENTRY_QNT.
    ENDLOOP.

  ENDIF.
ENDFORM.                    " PROCESS_DATA
*&---------------------------------------------------------------------*
*&      Form  CALL_BAPI_PROCESS
*&---------------------------------------------------------------------*
      text
*----------------------------------------------------------------------*
-->  p1        text
<--  p2        text
*----------------------------------------------------------------------*
FORM CALL_BAPI_PROCESS .

*SET BAPI HEAD
  L_GM_HEAD-PSTNG_DATE = SY-DATUM.
  L_GM_HEAD-DOC_DATE    = SY-DATUM.
  L_GM_HEAD-PR_UNAME    = SY-UNAME.


  IF P_INDEX = 'X'.
    CALL FUNCTION 'BAPI_GOODSMVT_CREATE'
      EXPORTING
        GOODSMVT_HEADER = L_GM_HEAD
        GOODSMVT_CODE   = '03'
        TESTRUN         = P_INDEX
      IMPORTING
        GOODSMVT_HEADRET  = L_MAT_DOC
      TABLES
        GOODSMVT_ITEM     = LT_GM_ITEM
        RETURN            = LT_RETURN.
     LOOP AT LT_RETURN INTO L_RETURN .
       IF L_RETURN-TYPE = 'E'.
         IF SY-TABIX = 1.
           SKIP.
         ENDIF.
         WRITE:/ L_RETURN-TYPE, L_RETURN-ID,L_RETURN-MESSAGE.
         CLEAR L_RETURN.
       ENDIF.
     ENDLOOP.
   ELSEIF P_INDEX NE 'X'.
     CALL FUNCTION 'BAPI_GOODSMVT_CREATE'
        EXPORTING
          GOODSMVT_HEADER = L_GM_HEAD
          GOODSMVT_CODE   = '03'
         TESTRUN         = P_INDEX
        IMPORTING
          GOODSMVT_HEADRET  = L_MAT_DOC
        TABLES
          GOODSMVT_ITEM     = LT_GM_ITEM
          RETURN            = LT_RETURN.
         
         
     LOOP AT LT_RETURN INTO L_RETURN .
       IF L_RETURN-TYPE = 'E'.
         FLAG = 'NO'.
       ENDIF.
     ENDLOOP.
     IF FLAG = 'YES'.
       CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
          EXPORTING
            WAIT = 'X'.
        WRITE:/ L_MAT_DOC-MAT_DOC,L_MAT_DOC-DOC_YEAR.
     ELSEIF FLAG = 'NO'.
       MESSAGE I005(YMESS) WITH 'ERROR'.
     ENDIF.
   ENDIF.
ENDFORM.                    " CALL_BAPI_PROCESS

<think>好的,我需要帮用户解决在SAP中使用BAPI_GOODSMVT_CREATE进行采购订单收货冲销的问题。用户需要示例和参数说明,所以我得先回顾一下这个BAPI的用法。 首先,BAPI_GOODSMVT_CREATE通常用于创建物凭证,比如收货、发货等。冲销的话,通常有两种方法:一种是使用冲销凭证,另一种是直接调用冲销的BAPI,比如BAPI_GOODSMVT_CANCEL。不过用户特别提到要用BAPI_GOODSMVT_CREATE,可能他们想通过移动类型直接冲销,比如用102冲销101的收货。 接下来,我需要确认这个BAPI的参数结构。查阅之前的引用资,用户提到的BAPI_GOODSMVT_CREATE的参数包括GOODSMVT_HEADERGOODSMVT_CODE、GOODSMVT_ITEM等。冲销时需要设置移动类型为102,并且参考原始凭证的年份、物凭证和行项目。 然后,示例代码部分需要展示如何填充这些参数。比如,GOODSMVT_CODE设置为'R'表示冲销,移动类型设为102。同时,必须正确引用原始凭证的物凭证编号、会计年度和行项目号。还要注意事务提交后的错误检查,使用BAPI_TRANSACTION_COMMIT提交,并在有错误时回滚。 可能用户会遇到的问题包括参数填写错误、未正确引用原凭证,或者忘记提交事务。所以在注意事项里要强调这些点。此外,引用用户提供的资中的BAPI_GOODSMVT_CANCEL作为另一种方法,但根据用户要求,重点放在CREATE上。 最后,生成相关问题,帮助用户进一步了解其他相关BAPI的使用和错误处理。确保回答结构清晰,步骤明确,参数说明详细,代码示例正确,并且参考了用户提供的引用内容中的正确BAPI名称和用法。</think>### SAP中使用BAPI_GOODSMVT_CREATE进行采购订单收货冲销的解决方案 #### 1. BAPI_GOODSMVT_CREATE功能说明 该BAPI用于创建物凭证(如收货、发货、转移过账等)。冲销操作需通过指定移动类型(如`102`冲销`101`的收货)实现,并关联原始凭证编号[^1]。 #### 2. 关键参数说明 - **`GOODSMVT_CODE`**:操作类型标识符,冲销时需设置为`'R'`(Reverse)[^1]。 - **`GOODSMVT_HEADER`**:凭证头信息,需包含过账日期、凭证日期等。 - **`GOODSMVT_ITEM`**:行项目明细,需指定移动类型、数量、库存地点等。 - **`MATERIALDOCUMENT`**:冲销成功后返回的新物凭证号。 - **`MATDOCUMENTYEAR`**:凭证年度。 #### 3. 冲销操作示例代码 ```abap DATA: lt_goodsmvt_item TYPE TABLE OF bapi2017_gm_item_create, ls_goodsmvt_item LIKE LINE OF lt_goodsmvt_item, ls_goodsmvt_header TYPE bapi2017_gm_head_01, ls_goodsmvt_code TYPE bapi2017_gm_code, lv_matdoc TYPE bapi2017_gm_head_ret-mat_doc, lv_year TYPE bapi2017_gm_head_ret-doc_year, lt_return TYPE TABLE OF bapiret2. " 设置冲销参数 ls_goodsmvt_code-gm_code = 'R'. " 标识冲销操作 " 设置凭证头信息 ls_goodsmvt_header-pstng_date = sy-datum. " 过账日期 ls_goodsmvt_header-doc_date = sy-datum. " 凭证日期 " 设置冲销行项目(假设原始凭证号为5000000123,行项目号为0001) ls_goodsmvt_item-material = 'MAT001'. " 物号 ls_goodsmvt_item-plant = '1000'. " 工厂 ls_goodsmvt_item-stge_loc = '0001'. " 库存地点 ls_goodsmvt_item-move_type = '102'. " 冲销移动类型(原101收货) ls_goodsmvt_item-entry_qnt = 10. " 冲销数量 ls_goodsmvt_item-po_number = '4500000123'. " 采购订单号 ls_goodsmvt_item-po_item = '0001'. " 采购订单行号 ls_goodsmvt_item-ref_doc = '5000000123'. " 原始物凭证号 ls_goodsmvt_item-ref_doc_year = '2023'. " 原始凭证年度 ls_goodsmvt_item-ref_doc_it = '0001'. " 原始凭证行项目 APPEND ls_goodsmvt_item TO lt_goodsmvt_item. " 调用BAPI冲销 CALL FUNCTION 'BAPI_GOODSMVT_CREATE' EXPORTING goodsmvt_header = ls_goodsmvt_header goodsmvt_code = ls_goodsmvt_code IMPORTING materialdocument = lv_matdoc matdocumentyear = lv_year TABLES goodsmvt_item = lt_goodsmvt_item return = lt_return. " 检查结果 IF lv_matdoc IS NOT INITIAL. CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'. WRITE: '冲销成功,新物凭证号:', lv_matdoc. ELSE. CALL FUNCTION 'BAPI_TRANSACTION_ROLLBACK'. WRITE: '冲销失败,错误信息:', lt_return[ 1 ]-message. ENDIF. ``` #### 4. 注意事项 - **移动类型匹配**:冲销必须与原操作移动类型对应(如101收货对应102冲销)。 - **凭证关联性**:需准确填写原始凭证号(`ref_doc`)、年度(`ref_doc_year`)和行号(`ref_doc_it`)。 - **事务提交**:操作成功后需调用`BAPI_TRANSACTION_COMMIT`提交事务[^2]。 - **错误处理**:通过`RETURN`表检查错误码(如`E`或`A`类型消息)。 #### 5. 替代方案 若需直接冲销凭证,可使用`BAPI_GOODSMVT_CANCEL`,通过指定原物凭证号执行冲销[^1]。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值