nsdm_e_marc_agg

DDL: NSDM_DDL_MARC_AGG SQL: NSDM_V_MARC_AGG Type: view

MARC Compatibility View: Aggregation

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

1 data source(s) 7 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_MARC_AGG view
EndUserText.label MARC 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 (7)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY matnr matbf
KEY werks werks
KEY lbbsa lbbsa_sid
stock_qty
stock_vkwrt
gjper_max 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:          'NSDM_V_MARC_AGG'
@EndUserText.label:                'MARC 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_marc_agg as
select from matdoc_extract        
{
key mandt, 
key matbf  as matnr, 
key werks,

key lbbsa_sid  as lbbsa,

sum(stock_qty_l2)        as stock_qty,
sum(/cwm/stock_qty_l2)   as /cwm/stock_qty,
sum(stock_vkwrt_l2)      as stock_vkwrt,
max(gjper_curr_per)      as gjper_max 
}
where stock_ind_l2 = ''
  and (sobkz = ''
       and (lbbsa_sid = '05' or lbbsa_sid = '06' or lbbsa_sid = '09' or lbbsa_sid = '10'))

group by mandt, matbf, werks, lbbsa_sid       

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

Learn More