nsdm_e_mcssh_agg

DDL: NSDM_DDL_MCSSH_AGG SQL: NSDM_V_MCSSH_AGG Type: view

CDS View for Sums on MCSSH per Period

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

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
matdoc_extract matdoc_extract from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName NSDM_V_MCSSH_AGG view
AbapCatalog.compiler.compareFilter true view
EndUserText.label CDS View for Sums on MCSSH 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 (8)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY matnr matbf
KEY werks werks
KEY sobkz sobkz
KEY kunnr kunnr_sid
KEY gjper gjper
KEY lbbsa lbbsa_sid
stock_qty 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'NSDM_V_MCSSH_AGG'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'CDS View for Sums on MCSSH 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_mcssh_agg
  as select from matdoc_extract
{
  key mandt,
  key matbf             as matnr,
  key werks,
  key sobkz,
  key kunnr_sid         as kunnr,
  key gjper,
  key lbbsa_sid         as lbbsa,

      sum(stock_qty_l1) as stock_qty

}

where
      sobkz     =  'B'
  and kunnr_sid <> ''
  and lbbsa_sid =  '05'

group by
  mandt,
  matbf,
  werks,
  sobkz,
  kunnr_sid,
  gjper,
  lbbsa_sid

Learn More