以下为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 =
).