NSDM_E_MSTEH_AGG

CDS View

CDS View for Sums on MSTEH per Period

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

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
nsdm_e_msteh view left_outer CDS View for MSTEH on NSDM_T_MTDCSA 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_MSTEH_AGG'
@EndUserText.label:            'CDS View for Sums on MSTEH 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_msteh_agg  as
select from matdoc_extract 
                         
{
key mandt,
key matbf     as matnr, 
key werks,
key charg_sid as charg,
key sobkz,
key mat_kdauf as vbeln,
key mat_kdpos as posnr,
key gjper,

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

}

where charg_sid <> ''
  and (sobkz = 'E' 
       and lbbsa_sid = '10')
  
group by mandt,
         matbf,
         werks,
         charg_sid,
         sobkz,
         mat_kdauf,
         mat_kdpos,
         gjper    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC_EXTRACT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More