前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >ABAP 批量创建客户主数据函数SD_CUSTOMER_MAINTAIN_ALL

ABAP 批量创建客户主数据函数SD_CUSTOMER_MAINTAIN_ALL

作者头像
matinal
发布2020-11-30 10:01:56
1.3K0
发布2020-11-30 10:01:56
举报
文章被收录于专栏:SAP TechnicalSAP Technical
代码语言:javascript
复制
  TABLES:T077D,ZCITY,T005S,BNKA,ADRC,KNA1.
  DATA: TMP_KTOKD(4) TYPE N,
        TMP_REGIO(3)  TYPE N.
  DATA: CURLINE LIKE SY-TABIX.

**定义调用bapiSD_CUSTOMER_MAINTAIN_ALL创建的输入参数
  DATA:I_KNA1 TYPE KNA1,
       I_KNB1 TYPE KNB1,
       I_BAPIADDR1 TYPE BAPIADDR1,
       T_XKNBK LIKE FKNBK OCCURS 0 WITH HEADER LINE,
       T_YKNBK LIKE FKNBK OCCURS 0 WITH HEADER LINE,
       T_XKNVA LIKE FKNVA OCCURS 0 WITH HEADER LINE,
       T_XKNVK LIKE FKNVK OCCURS 0 WITH HEADER LINE,
       E_KUNNR LIKE KNA1-KUNNR,
       O_KNA1 LIKE KNA1,
       E_SD_CUST_1321_DONE TYPE C.

 

  LOOP AT T_CUSTOMER.
**--客户主文件的一般数据
      I_KNA1-KUNNR = T_CUSTOMER-KUNNR.          "0003 0004 0009 人工授码
      I_KNA1-KTOKD = T_CUSTOMER-KTOKD.          "客户帐户组
      I_KNA1-LIFNR = T_CUSTOMER-LIFNR.          "供应商或债权人的帐号
      I_KNA1-VBUND = T_CUSTOMER-VBUND.          "贸易伙伴
      I_KNA1-STCEG = T_CUSTOMER-STCEG.          "纳税登记号
      I_KNA1-RPMKR = T_CUSTOMER-RPMKR.          "地区市场
      IF T_CUSTOMER-KTOKD = '0002'.             "国外客户
         I_KNA1-CIVVE = 'X'.
      ENDIF.
**--地址数据
      I_BAPIADDR1-TITLE = T_CUSTOMER-TITLE.     "标题文本
      I_BAPIADDR1-NAME = T_CUSTOMER-NAME.       "名称 1
      I_BAPIADDR1-NAME_2 = T_CUSTOMER-NAME_2.   "名称 2
      I_BAPIADDR1-SORT1 = T_CUSTOMER-SORT1.     "排序字段
      I_BAPIADDR1-STR_SUPPL1 = T_CUSTOMER-STR_SUPPL1.    "街道2
      I_BAPIADDR1-STREET = T_CUSTOMER-STREET.   "街道名
      I_BAPIADDR1-CITY = T_CUSTOMER-CITY.       "城市
      I_BAPIADDR1-COUNTRY = T_CUSTOMER-COUNTRY. "国家代码
      I_BAPIADDR1-REGION = T_CUSTOMER-REGION.   "地区 (州、省、县)
      I_BAPIADDR1-LANGU = T_CUSTOMER-LANGU.     "语言代码
**--客户主数据 (银行细目)
      T_XKNBK-KUNNR = T_CUSTOMER-KUNNR.         "自动授码0001 0002为空 人工先授码0003 0004 0009不为空
      T_XKNBK-BANKS = T_CUSTOMER-BANKS.         "银行国家代码
      T_XKNBK-BANKL = T_CUSTOMER-BANKL.         "银行码
      T_XKNBK-BANKN = T_CUSTOMER-BANKN.         "帐号
      T_XKNBK-KOINH = T_CUSTOMER-KOINH.         "帐户持有人姓名
      APPEND T_XKNBK.
**--客户主装货点
      T_XKNVA-KUNNR = T_CUSTOMER-KUNNR.        "自动授码0001 0002为空 人工先授码0003 0004 0009不为空
      T_XKNVA-ABLAD = T_CUSTOMER-ABLAD.        "卸货点
      T_XKNVA-KNFAK = T_CUSTOMER-KNFAK.        "客户的工厂日历
      APPEND T_XKNVA.
**--客户主要联系伙伴
      T_XKNVK-NAME1 = T_CUSTOMER-NAME1.         "联系人名称
      T_XKNVK-NAMEV = T_CUSTOMER-NAMEV.         "电话
      APPEND T_XKNVK.

      CALL FUNCTION 'SD_CUSTOMER_MAINTAIN_ALL'
       EXPORTING
         I_KNA1                              = I_KNA1
*        I_KNB1                              =
         I_BAPIADDR1                         = I_BAPIADDR1
         I_MAINTAIN_ADDRESS_BY_KNA1          = 'X'
         PI_POSTFLAG                         = 'X'
         I_FROM_CUSTOMERMASTER               = ' '
       IMPORTING
         E_KUNNR                             = E_KUNNR
         O_KNA1                              = O_KNA1
       TABLES
         T_XKNBK                             = T_XKNBK
         T_XKNVA                             = T_XKNVA
         T_XKNVK                             = T_XKNVK
       EXCEPTIONS
         CLIENT_ERROR                        = 1
         KNA1_INCOMPLETE                     = 2
         KNB1_INCOMPLETE                     = 3
         KNB5_INCOMPLETE                     = 4
         KNVV_INCOMPLETE                     = 5
         KUNNR_NOT_UNIQUE                    = 6
         SALES_AREA_NOT_UNIQUE               = 7
         SALES_AREA_NOT_VALID                = 8
         INSERT_UPDATE_CONFLICT              = 9
         NUMBER_ASSIGNMENT_ERROR             = 10
         NUMBER_NOT_IN_RANGE                 = 11
         NUMBER_RANGE_NOT_EXTERN             = 12
         NUMBER_RANGE_NOT_INTERN             = 13
         ACCOUNT_GROUP_NOT_VALID             = 14
         PARNR_INVALID                       = 15
         BANK_ADDRESS_INVALID                = 16
         TAX_DATA_NOT_VALID                  = 17
         NO_AUTHORITY                        = 18
         COMPANY_CODE_NOT_UNIQUE             = 19
         DUNNING_DATA_NOT_VALID              = 20
         KNB1_REFERENCE_INVALID              = 21
         CAM_ERROR                           = 22
         OTHERS                              = 23
                .
*      当前处理出现异常,回滚操作
            IF SY-SUBRC NE 0.
               CALL FUNCTION 'BAPI_TRANSACTION_ROLLBACK'.

               SELECT SINGLE TEXT FROM T100 INTO T_RETURN-MESSAGE
                             WHERE SPRSL = '1'
                               AND ARBGB = SY-MSGID
                               AND MSGNR = SY-MSGNO.
                DO 4 TIMES.
                   SEARCH T_RETURN-MESSAGE FOR '&'.
                   IF SY-SUBRC = 0.
                     CASE SY-INDEX.
                         WHEN 1.
                           REPLACE  '&' WITH SY-MSGV1 INTO T_RETURN-MESSAGE.
                         WHEN 2.
                           REPLACE  '&' WITH SY-MSGV2 INTO T_RETURN-MESSAGE.
                         WHEN 3.
                           REPLACE  '&' WITH SY-MSGV3 INTO T_RETURN-MESSAGE.
                         WHEN 4.
                           REPLACE  '&' WITH SY-MSGV4 INTO T_RETURN-MESSAGE.
                     ENDCASE.
                     CONDENSE T_RETURN-MESSAGE. "replace会将SY-MSGV&50位替换,压缩空格 ERR_TAB-MESSAGE也要足够长
                   ENDIF.
                ENDDO.
                T_RETURN-INDEX = CURLINE.
                T_RETURN-TYPE = 'E'.
                IF T_RETURN-MESSAGE IS INITIAL.
                   T_RETURN-MESSAGE = '客户创建未成功'.
                ENDIF.
                APPEND T_RETURN.
                CLEAR T_RETURN.
            ELSE.
               CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
                EXPORTING
                  WAIT          = 'X'.
               IF SY-SUBRC = 0.
                  T_RETURN-TYPE = 'S'.
                  T_RETURN-MESSAGE = O_KNA1-KUNNR."'客户创建成功'.
                ELSE.
                  T_RETURN-TYPE = 'E'.
                  T_RETURN-MESSAGE = '客户创建未成功'.
                ENDIF.
                T_RETURN-INDEX = CURLINE.
                APPEND T_RETURN.
                CLEAR T_RETURN.

           ENDIF.
        CLEAR:T_CUSTOMER,T_RETURN,
              I_KNA1,I_BAPIADDR1,E_KUNNR,O_KNA1,
              T_XKNBK[],T_XKNVA[],T_XKNVK[].
  ENDLOOP.
本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
原始发表:2020-08-13 ,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档