ABAP CDS with parameter
Let’s check an example of CDS with parameters and how they can be called from the program.
@AbapCatalog.sqlViewName: 'ZCDSPARAM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Example of CDS with Parameters'
define view ZCDS_PARAMETERS
with parameters p_lang :spras
as select from t023t {
key t023t.matkl,
t023t.wgbez60,
t023t.spras
}
where t023t.spras = :p_lang
How to do select using such CDS view.
SELECT * FROM zcds_parameters( p_lang = 'E' ) INTO TABLE @DATA(it_TAble1).
If you want to use the CDS with a parameter for fetching data/doing some calculation in another CDS view, the higher level CDS also need to have the same parameter. It is not a technical requirement, rather a logical one.
@AbapCatalog.sqlViewName: 'ZCDSPARAMC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Example of CDS with select from CDS with parameter'
define view zCDS_parameter_call
with parameters p_lang1 :spras
as select from ZCDS_PARAMETERS( p_lang: $parameters.p_lang1 ) {
key matkl as MaterialGroup,
wgbez60 as Description
}
