Code: Alles auswählen.
@AbapCatalog.sqlViewName: 'Z_TESTVIEW_001'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Call of CDS view in report'
Context Materialtext {
zc_mtart : String(04) = 'FERT';
define view Z_TESTVIEW_001 as select from makt as a {
b.matnr,
a.maktx,
b.mtart,
}
inner join mara as b
where a.matnr = b.matnr
and b.mtart = zc_mtart;
}
Folgende Benutzer bedankten sich beim Autor zzcpak für den Beitrag:
SAP_ENTWICKLER
Code: Alles auswählen.
@AbapCatalog.sqlViewName: 'Z_TESTVIEW_001'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Z_TESTVIEW_001N'
define view Z_TESTVIEW_001N
with parameters p_mtart : MTART
as select from makt as a
inner join mara as b
on a.matnr = b.matnr {
b.matnr,
a.maktx,
b.mtart
} where b.mtart = :p_mtart
Code: Alles auswählen.
@AbapCatalog.sqlViewName: 'Z_TESTVIEW_001'
@AbapCatalog.compiler.CompareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Z_TESTVIEW_001N'
define view Z_TESTVIEW_001N
as select from makt as a
inner join mara as b
on a.matnr = b.matnr {
b.matnr,
a.maktx,
b.mtart
} where b.mtart = 'FERT'
Folgende Benutzer bedankten sich beim Autor edwin für den Beitrag:
SAP_ENTWICKLER