NSDM_E_MSTB_DIFF
MSTB Compatibility View: Differentiation
NSDM_E_MSTB_DIFF is a CDS View in S/4HANA. MSTB Compatibility View: Differentiation. It contains 5 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| nsdm_e_mstb | view | from | MSTB Compatibility View |
Fields (5)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | charg | charg | 1 |
| KEY | mandt | mandt | 1 |
| KEY | matnr | matnr | 1 |
| KEY | werks | werks | 1 |
| ersda | ersda | 1 |
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'NSDM_V_MSTB_DIFF'
@EndUserText.label: 'MSTB Compatibility View: Differentiation'
@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_diff as
select from nsdm_e_mstb_agg
{
key mandt,
key matnr,
key werks,
key charg,
key sobkz,
max(gjper_max) as gjper,
sum(stock_qty) as cwesb,
sum(/cwm/stock_qty) as /cwm/cwesb,
min(cpudt_min) as ersda,
'X' as tbrue
}
group by mandt, matnr, werks, charg, sobkz
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"NSDM_E_MSTB_AGG"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/