SAP CDS 带参数传输的视图

以下为CDS代码

@AbapCatalog.sqlViewName: 'Z_VYYY_CDS_04'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: '加入传参'

@Metadata.ignorePropagatedAnnotations: true

// distinct 去重 一般不用 as select distinct from ska1 as A

define view ZVYYY_CDS_04

with parameters

// @Environment.systemField: 'Z008'

@EndUserText.label: '科目组'

P_ktoks : ktoks

as select from ska1 as A

left outer join skat as T on A.saknr = T.saknr

// and T.spras = '1'

and A.ktopl = T.ktopl

{

key A.ktopl ,

A.saknr ,

A.erdat ,

A.ernam ,

A.xloev ,

A.xspea ,

A.xspeb ,

A.xspep ,

A.ktoks ,

T.spras ,

T.txt20 ,

T.txt50

}

// where A.ktoks = :P_ktoks

where A.ktoks = $parameters.P_ktoks

以下为abap读取代码

REPORT ZYYY_GET_CDS_001.
DATA:LV_KTOKS TYPE KTOKS.
LV_KTOKS = 'Z008'.
SELECT * FROM Z_VYYY_CDS_04( P_ktoks = @LV_KTOKS ) INTO TABLE @DATA(LT_ZYYY_CDS_04) .
cl_demo_output=>DISPLAY(
exporting
DATA = LT_ZYYY_CDS_04 " Text or Data
* NAME =
).