NSDM_E_MSTQH_AGG

CDS View

CDS View for Sums on MSTQH per Period

NSDM_E_MSTQH_AGG is a CDS View in S/4HANA. CDS View for Sums on MSTQH per Period. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
nsdm_e_mstqh view left_outer CDS View for MSTQH on NSDM_T_MTDCSA 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_MSTQH_AGG'
@EndUserText.label:            'CDS View for Sums on MSTQH per Period'
@DataAging.noAgingRestriction: 'false'

@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #AUTOMATED
@AccessControl.authorizationCheck: #NOT_ALLOWED
@AbapCatalog.viewEnhancementCategory: #PROJECTION_LIST
define view nsdm_e_mstqh_agg  as
select from matdoc_extract
                         
{
key mandt,
key matbf     as matnr, 
key werks,
key charg_sid as charg,
key sobkz,
key mat_pspnr as pspnr,
key gjper,

@EndUserText: { label: 'Valuated Goods Receipt Blocked Stock', quickInfo: 'Val. GR Blocked Stck' }
@Semantics.quantity.unitOfMeasure: 'MARA.MEINS'
sum(stock_qty_l1) as qwesb,
sum(/cwm/stock_qty_l1) as /cwm/qwesb

}

where charg_sid <> ''
  and (sobkz = 'Q'
       and lbbsa_sid = '10')
  
group by mandt,
         matbf,
         werks,
         charg_sid,
         sobkz,
         mat_pspnr,
         gjper

Learn More