matinal：SAP ABAP 获取自建表变更历史记录

最新推荐文章于 2024-05-12 15:01:11 发布

SAPmatinal

最新推荐文章于 2024-05-12 15:01:11 发布

阅读量1.2k

点赞数 20

分类专栏： ABAP技术文章标签：大数据数据库人工智能学习 oracle

本文链接：https://blog.csdn.net/SAPmatinal/article/details/136831966

版权

ABAP技术专栏收录该内容

1021 篇文章 128 订阅

订阅专栏

🚀欢迎来到本文🚀
🍉个人简介：matinal，目前职业是IT行业，一个正在慢慢前行的普通人。
🏀系列专栏：涵盖SAP各模块，Python，Excel，人工智能等
💡 其他专栏：一些平时学习的技术，感兴趣的小伙伴可以看看。

🍔公众号：matinal
🎁希望各位→点赞👍 + 收藏⭐️ + 留言📝
⛱️万物从心起，心动则万物动🏄‍♂️

前言：SAP中有很多标准表的字段变动，会有变更历史记录，这些记录存在于系统中，本文将介绍如何把自开发表的变更记录写入这两个表。

🦙（工作遇到傻逼，千万要远离。道路千万条，远离傻逼第一条）

自定义表

SE11先创建一个自定义表ZTMARA

需要记录变更的字段，数据元素的"更改文档"需要勾选上！！！

创建变更对象

1.打开TCODE: SCDO，输入ZTMARA后，点新建图标

2.在表中输入ZTMARA,勾选内部表/删除文档/插入文档

3.点生成图标，选择类

4.继续点生成

6.点信息图标，双击ZCL_ZTMARA_CHDO，或者SE24直接进

7.ZCL_ZTMARA_CHDO类中已经自动生成了变更记录的write方法，我们再额外增加两个方法和一个数据类型定义

7.1新增类型tt_changenr

TYPES:
tt_changenr TYPE STANDARD TABLE OF cdhdr-changenr WITH EMPTY KEY.

7.2 新增save_single和save_multi方法定义

 CLASS-METHODS save_single
      IMPORTING
        !is_ztmara         TYPE ty_ztmara
      RETURNING
        VALUE(rv_changenr) TYPE cdhdr-changenr .
  CLASS-METHODS save_multi
    IMPORTING
      VALUE(it_ztmara)   TYPE tt_ztmara
    RETURNING
      VALUE(rt_changenr) TYPE tt_changenr .

7.3 save_multi方法实现

 METHOD save_multi.
    CHECK it_ztmara[] IS NOT INITIAL.
    SORT it_ztmara BY matnr.
    DELETE ADJACENT DUPLICATES FROM it_ztmara COMPARING matnr.
    LOOP AT it_ztmara INTO DATA(ls_ztmara).
      DATA(rv_changenr) = save_single( ls_ztmara ).
      IF rv_changenr IS NOT INITIAL.
        APPEND rv_changenr TO rt_changenr.
      ENDIF.
      CLEAR rv_changenr.
    ENDLOOP.
  ENDMETHOD.

7.4 save_single方法实现，

将自动生成的write方法的尾部注释的代码段，拷贝过来，然后取消注释，增加部分处理逻辑，可参考下面这部分为自己新增逻辑代码部分

METHOD save_single.
    "  Code snippets to be used with COPY+PASTE
    "  uncomment the needed parts
    "  change names if needed

    "  Start of default parameter part
    DATA: objectid                TYPE cdhdr-objectid,
          tcode                   TYPE cdhdr-tcode,
          planned_change_number   TYPE cdhdr-planchngnr,
          utime                   TYPE cdhdr-utime,
          udate                   TYPE cdhdr-udate,
          username                TYPE cdhdr-username,
          cdoc_planned_or_real    TYPE cdhdr-change_ind,
          cdoc_upd_object         TYPE cdhdr-change_ind VALUE 'U',
          cdoc_no_change_pointers TYPE cdhdr-change_ind.
    DATA: cdchangenumber          TYPE cdhdr-changenr.
    "  End of default parameter part

    " Begin of dynamic DATA part for class ZCL_ZTMARA_CHDO
    "   table with the NEW content of: ZTMARA
    DATA xztmara TYPE zcl_ztmara_chdo=>tt_ztmara.
    "   table with the OLD content of: ZTMARA
    DATA yztmara TYPE zcl_ztmara_chdo=>tt_ztmara.
    "   change indicator for table: ZTMARA
    DATA upd_ztmara TYPE if_chdo_object_tools_rel=>ty_cdchngindh.

    "     Change Number of Document
    DATA changenumber TYPE if_chdo_object_tools_rel=>ty_cdchangenr.

    " End of dynamic DATA part for class ZCL_ZTMARA_CHDO

*----------------- 这部分为自己新增逻辑 BEGIN------------------*
    CHECK is_ztmara IS NOT INITIAL.
    DATA ls_yztmara TYPE ztmara.
    objectid = is_ztmara-matnr.
    tcode = sy-tcode.
    utime = sy-uzeit.
    udate = sy-datum.
    username = sy-uname.
*   查原记录
    SELECT SINGLE *
        INTO ls_yztmara
        FROM ztmara
        WHERE matnr = is_ztmara-matnr.
    upd_ztmara = COND #( WHEN is_ztmara-kz IS NOT INITIAL THEN is_ztmara-kz WHEN sy-subrc = 0 THEN 'U' ELSE 'I' ).
    "添加新记录
    APPEND CORRESPONDING ty_ztmara( BASE ( VALUE #( mandt = sy-mandt kz = upd_ztmara ) ) is_ztmara EXCEPT mandt kz ) TO xztmara.
    "添加旧记录
    IF sy-subrc = 0.
      APPEND CORRESPONDING ty_ztmara( BASE ( VALUE #( kz = upd_ztmara ) ) ls_yztmara ) TO yztmara.
    ENDIF.
*----------------- 这部分为自己新增逻辑 END------------------*
    "  Begin of method call part
    "  define needed DATA for error handling
    DATA err_ref TYPE REF TO cx_chdo_write_error.
    DATA err_action TYPE string.

    TRY.
        CALL METHOD zcl_ztmara_chdo=>write
          EXPORTING
            objectid                = objectid
            tcode                   = tcode
            utime                   = utime
            udate                   = udate
            username                = username
            planned_change_number   = planned_change_number
            object_change_indicator = cdoc_upd_object
            planned_or_real_changes = cdoc_planned_or_real
            no_change_pointers      = cdoc_no_change_pointers
            "  End of default method call part
            " Begin of dynamic part for method call
            "   table with the NEW content of: ZTMARA
            xztmara                 = xztmara
            "   table with the OLD content of: ZTMARA
            yztmara                 = yztmara
            "   change indicator for table: ZTMARA
            upd_ztmara              = upd_ztmara
            "     Change Number of Document
          IMPORTING
            changenumber            = cdchangenumber.
      CATCH cx_chdo_write_error INTO err_ref.
        "        MESSAGE err_ref TYPE 'A'.
        "   error information could be determined with default GET_TEXT, GET_LONGTEXT, GET_SOURCE_POSITION methds

    ENDTRY.
    " End of dynamic part for method call
    rv_changenr = cdchangenumber.
  ENDMETHOD.

测试

REPORT zmatinal.
DATA lt_ztmara TYPE STANDARD TABLE OF ztmara.
DATA ls_ztmara TYPE ztmara.
lt_ztmara = VALUE #( (  matnr = 'M001RS' color = '红' size1 = 'S' ztag_price = '100' )
                     (  matnr = 'M001RM' color = '红' size1 = 'M' ztag_price = '100' )
                     (  matnr = 'M001RL' color = '红' size1 = 'L' ztag_price = '100' ) ).

"写新增日志
zcl_ztmara_chdo=>save_multi( CORRESPONDING #( lt_ztmara ) ).
"插入记录
INSERT ztmara FROM TABLE lt_ztmara.
COMMIT WORK AND WAIT.

"写变更日志(公众号：matinal)
ls_ztmara =  VALUE #(  matnr = 'M001RS' color = '黑' size1 = 'S' ztag_price = '150' ) .
zcl_ztmara_chdo=>save_single( CORRESPONDING #( ls_ztmara ) ).
"修改记录
MODIFY ztmara FROM ls_ztmara.
COMMIT WORK AND WAIT.

"写删除日志
ls_ztmara =  VALUE #(   matnr = 'M001RL' color = '红' size1 = 'L' ztag_price = '100'  ).
zcl_ztmara_chdo=>save_single( CORRESPONDING #( BASE ( VALUE #( kz = 'D') ) ls_ztmara ) ).
"删除记录
DELETE ztmara FROM ls_ztmara.
COMMIT WORK AND WAIT.