SAP ABAP - CDS View Material Stock
@AbapCatalog.sqlViewName: 'ZVMM002'
@AbapCatalog.compiler.compareFilter: true@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View Material Stock'
define view ZCDSMM002 as select from nsdm_v_mkol {
matnr,
werks,
lgort,
charg,
slabs as menge,
sobkz,
lifnr as snumb,
0 as retme,
'' as lgpbe
}
union all select from nsdm_v_msku{
matnr,
werks,
'' as lgort,
charg,
kulab as menge,
sobkz,
kunnr as snumb,
0 as retme,
'' as lgpbe
}
union all select from nsdm_v_mchb{
matnr,
werks,
lgort,
charg,
clabs as menge,
'' as sobkz,
'' as snumb,
cretm as retme,
'' as lgpbe
}
union all select from nsdm_v_mard{
matnr,
werks,
lgort,
'' as charg,
labst as menge,
'' as sobkz,
'' as snumb,
retme,
lgpbe
}
Comments
Post a Comment