nsdm_e_msteh_agg

DDL: NSDM_DDL_MSTEH_AGG SQL: NSDM_V_MSTEH_AGG Type: view

CDS View for Sums on MSTEH per Period

nsdm_e_msteh_agg is a CDS View that provides data about "CDS View for Sums on MSTEH per Period" in SAP S/4HANA. It reads from 1 data source (matdoc_extract) and exposes 10 fields with key fields mandt, matnr, werks, charg, sobkz.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
matdoc_extract matdoc_extract from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName NSDM_V_MSTEH_AGG view
EndUserText.label CDS View for Sums on MSTEH per Period view
DataAging.noAgingRestriction false view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.viewEnhancementCategory #PROJECTION_LIST view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY matnr matbf
KEY werks werks
KEY charg charg_sid
KEY sobkz sobkz
KEY vbeln mat_kdauf
KEY posnr mat_kdpos
KEY gjper gjper
ewesb
/cwm/ewesb 
@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

Learn More