SAP 04-AMDP CDS Table Function 参考ABAP元素定义变量示例

rogerix4

已于 2023-08-17 09:41:29 修改

阅读量296

点赞数

分类专栏： ABAP AMDP 文章标签：数据库 java 开发语言 AMDP HANA SAP

于 2023-07-20 13:15:44 首次发布

本文链接：https://blog.csdn.net/qq_30797051/article/details/131828100

版权

ABAP AMDP 专栏收录该内容

4 篇文章 8 订阅

订阅专栏

1. 代码

CLASS zamdp_demo DEFINITION
  PUBLIC
  FINAL
  CREATE PUBLIC .

  PUBLIC SECTION.
      interfaces:
        IF_AMDP_MARKER_HDB.

    class-methods:
    get_data_go_back importing value(ip_mandt) type spfli-mandt
                     exporting value(et_mara) type MARA_TT.

       class-methods:
        get_period importing value(ip_mandt) type spfli-mandt
                     exporting value(ev_date) type sy-datum.
  PROTECTED SECTION.
  PRIVATE SECTION.
ENDCLASS.



CLASS zamdp_demo IMPLEMENTATION.
    method get_period by database procedure
                            for hdb language sqlscript
                            options read-only
                            USING ZMMT018.
      DECLARE mytab table( datum  "$ABAP.type( syst_datum )" );

      mytab =  SELECT LAST_CHANGED_DATE as datum
      FROM ZMMT018
      where mandt = :ip_mandt
       AND  MBLNR = '';

      ev_date = :mytab.datum[1];
    ENDMETHOD.
    method get_data_go_back by database procedure
                            for hdb language sqlscript
                            options read-only
                            USING mara
                            ZAMDP_DEMO=>GET_PERIOD.
    DECLARE lv_date "$ABAP.type( syst_datum )";
    call "ZAMDP_DEMO=>GET_PERIOD"( :ip_mandt, :lv_date );

    et_mara =  SELECT * FROM mara WHERE mandt = :ip_mandt AND LAEDA >= :lv_date;
    ENDMETHOD.
ENDCLASS.