绍兴市网站建设_网站建设公司_小程序网站_seo优化

我理解amdp 类似于数据库存储过程，对一系列简单动作的封装，本文主要讲的是创建cds amdp 给abap调用

CDS代码

class ZCL_AMDP_YYYY_DEMO1 definition

public

final

create public .

public section.

INTERFACES if_amdp_marker_hdb.

DATA lt_ZTYYY_TEST type table OF ZTYYY_TEST.

TYPES:

tt_YYY_TEST TYPE TABLE OF ZTYYY_TEST .

CLASS-METHODS GET_DATA

IMPORTING

VALUE(p_MATNR) TYPE MATNR

VALUE(p_WERKS) TYPE WERKS_D

EXPORTING

VALUE(et_DATA) TYPE tt_YYY_TEST.

protected section.

private section.

ENDCLASS.

CLASS ZCL_AMDP_YYYY_DEMO1 IMPLEMENTATION.

METHOD GET_DATA BY DATABASE PROCEDURE

FOR HDB LANGUAGE SQLSCRIPT "hana脚本语言

OPTIONS READ-ONLY " 只读

"用到的表

USING ZTYYY_TEST .

et_DATA = select * from ZTYYY_TEST

where mandt = session_context('CLIENT')

AND MATNR = :P_MATNR

AND WERKS = :P_WERKS;

* et_DATA =

* SELECT

* *

* FROM :lt_ZTYYY_TEST

* WHERE mandt = session_context('CLIENT')

* AND MATNR = :P_MATNR

* AND WERKS = :P_WERKS;

ENDMETHOD.

ENDCLASS

创建report 消费amdp

REPORT ZYYY_TEST_001.

PARAMETERS :P_MATNR TYPE MATNR, "
p_werks TYPE char4.

START-OF-SELECTION .

ZCL_AMDP_YYYY_DEMO1=>GET_DATA(
exporting
P_MATNR = P_MATNR
P_WERKS = p_werks
importing
ET_DATA = data(lt_data)
).

CL_DEMO_OUTPUT=>DISPLAY_DATA(
exporting
VALUE = lt_data
* NAME = " Name
).

完成