nsdm_e_mska_agg

DDL: NSDM_DDL_MSKA_AGG SQL: NSDM_V_MSKA_AGG Type: view

MSKA Compatibility View: Aggregation

nsdm_e_mska_agg is a CDS View that provides data about "MSKA Compatibility View: Aggregation" in SAP S/4HANA. It reads from 1 data source (matdoc_extract) and exposes 11 fields with key fields mandt, matnr, werks, lgort, charg.

1 data source(s) 11 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_MSKA_AGG view
EndUserText.label MSKA Compatibility View: Aggregation 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 (11)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY matnr matbf
KEY werks werks
KEY lgort lgort_sid
KEY charg charg_sid
KEY sobkz sobkz
KEY vbeln mat_kdauf
KEY posnr mat_kdpos
KEY lbbsa lbbsa_sid
gjper_max
stock_qty 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_MSKA_AGG'
@EndUserText.label:            'MSKA Compatibility View: Aggregation'
@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_mska_agg as
select from matdoc_extract
{
key mandt,
key matbf     as matnr,  
key werks,
key lgort_sid as lgort,
key charg_sid as charg,
key sobkz,
key mat_kdauf as vbeln,
key mat_kdpos as posnr,

key lbbsa_sid as lbbsa,

max(gjper_curr_per) as gjper_max,
sum(stock_qty_l1)      as stock_qty,
sum(/cwm/stock_qty_l1) as /cwm/stock_qty
}
where mat_kdauf <> ''
  and ((sobkz = 'E' 
        and  (lbbsa_sid = '01' or lbbsa_sid = '02' or lbbsa_sid = '07' or lbbsa_sid = '08'))
   or  (sobkz = 'T' 
        and lbbsa_sid = '07' ))
     
group by mandt, matbf, werks, lgort_sid, charg_sid, sobkz, mat_kdauf, mat_kdpos, lbbsa_sid     

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MATDOC_EXTRACT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More