nsdm_e_msidh_agg

DDL: NSDM_DDL_MSIDH_AGG SQL: NSDM_V_MSIDH_AGG Type: view

MSIDH Compatibility View: AGG

nsdm_e_msidh_agg is a CDS View that provides data about "MSIDH Compatibility View: AGG" 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.sqlViewName NSDM_V_MSIDH_AGG view
AbapCatalog.compiler.compareFilter true view
EndUserText.label MSIDH Compatibility View: AGG 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 lifnr lifnr_sid
KEY owner disub_owner_sid
KEY gjper gjper
KEY lbbsa lbbsa_sid
stock_qty 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'NSDM_V_MSIDH_AGG'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'MSIDH Compatibility View: AGG'
@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_msidh_agg  as
select from matdoc_extract                         
{
  key mandt,
  key matbf     as matnr, 
  key werks,
  key charg_sid as charg,
  key sobkz,
  key lifnr_sid as lifnr,
  key disub_owner_sid as owner,
  key gjper,
  key lbbsa_sid as lbbsa,
  
  sum(stock_qty_l1) as stock_qty

}

where lifnr_sid <> ''
  and disub_owner_sid <> ''
  and (sobkz = 'I' or sobkz = 'J')
  and (lbbsa_sid = '01'
    or lbbsa_sid = '02'
    or lbbsa_sid = '08')

group by mandt,
         matbf,
         werks,
         lgort_sid,
         charg_sid,
         sobkz,
         lifnr_sid,
         disub_owner_sid,
         gjper,
         lbbsa_sid  

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

Learn More