nsdm_e_mstb

DDL: NSDM_DDL_MSTB SQL: NSDM_V_MSTB Type: view

MSTB Compatibility View

nsdm_e_mstb is a CDS View that provides data about "MSTB Compatibility View" in SAP S/4HANA. It reads from 2 data sources (mcha, nsdm_e_mstb_diff) and exposes 12 fields with key fields mandt, matnr, werks, charg, sobkz.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
mcha m inner
nsdm_e_mstb_diff n from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName NSDM_V_MSTB view
EndUserText.label MSTB Compatibility View 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 (12)

KeyFieldSource TableSource FieldDescription
KEY mandt nsdm_e_mstb_diff mandt
KEY matnr nsdm_e_mstb_diff matnr
KEY werks nsdm_e_mstb_diff werks
KEY charg nsdm_e_mstb_diff charg
KEY sobkz sobkz
KEY bwtar mcha bwtar
lfgja
lfmon
cwesb cwesb
ersda nsdm_e_mstb_diff ersda
tbrue tbrue
cwmcwesb /cwm/cwesb 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_MSTB'
@EndUserText.label:            'MSTB Compatibility View'
@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_mstb as
select from nsdm_e_mstb_diff as n inner join mcha as m
      on n.mandt = m.mandt and
         n.matnr = m.matnr and
         n.werks = m.werks and
         n.charg = m.charg
{
key n.mandt, 
key n.matnr, 
key n.werks,
key n.charg,
key sobkz,
key m.bwtar,

cast(substring(gjper, 1, 4) as abap.numc(4)) as lfgja,
cast(substring(gjper, 6, 2) as abap.numc(2)) as lfmon,
cwesb,
n.ersda,
tbrue,
/cwm/cwesb
}

Learn More