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 }