nsdm_e_mssq_agg

DDL: NSDM_DDL_MSSQ_AGG SQL: NSDM_V_MSSQ_AGG Type: view Package: MBND_PUBLIC

MSSQ Compatibility View: Aggregation

nsdm_e_mssq_agg is a CDS View that provides data about "MSSQ Compatibility View: Aggregation" in SAP S/4HANA. It reads from 1 data source (matdoc_extract) and exposes 10 fields with key fields mandt, matnr, werks, sobkz, pspnr. Part of development package MBND_PUBLIC.

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_MSSQ_AGG view
EndUserText.label MSSQ 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 (10)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt
KEY matnr matbf
KEY werks werks
KEY sobkz
KEY pspnr mat_pspnr
KEY lbbsa lbbsa_sid
stock_qty
gjper_max
cpudt_min
kzbws kzbws 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_MSSQ_AGG'
@EndUserText.label:            'MSSQ 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_mssq_agg as
select from matdoc_extract
{
key mandt,
key matbf     as matnr, 
key werks,
key case sobkz when 'R' then 'Q' else sobkz end as sobkz,                       //2971225

key mat_pspnr as pspnr,

key lbbsa_sid     as lbbsa,

sum(case sobkz when 'Q' then stock_qty_l2 else 0 end)        as stock_qty,      //2971225

sum(case sobkz when 'Q' then /cwm/stock_qty_l2 else 0 end)   as /cwm/stock_qty, //2971225

max(gjper_curr_per) as gjper_max,
min(cpudt_l2)          as cpudt_min,

kzbws
}
where stock_ind_l2 = ''
  and ((sobkz = 'Q' or sobkz ='R') and mat_pspnr != '00000000'                  //2971225

       and ( lbbsa_sid = '01' or lbbsa_sid = '02' or lbbsa_sid = '07' or 
             lbbsa_sid = '08' or lbbsa_sid = '06' or lbbsa_sid = '10')
       )

group by mandt, matbf, werks, sobkz, mat_pspnr, lbbsa_sid, kzbws

Learn More