NSDM_E_MSTQH_PER
CDS View for All Periods for MSTBH
NSDM_E_MSTQH_PER is a CDS View in S/4HANA. CDS View for All Periods for MSTBH. It contains 6 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| nsdm_e_mstqh | view | from | CDS View for MSTQH on NSDM_T_MTDCSA |
Fields (6)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | charg | charg | 1 |
| KEY | mandt | mandt | 1 |
| KEY | matnr | matnr | 1 |
| KEY | pspnr | pspnr | 1 |
| KEY | sobkz | sobkz | 1 |
| KEY | werks | werks | 1 |
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'NSDM_V_MSTQH_PER'
@EndUserText.label: 'CDS View for All Periods for MSTBH'
@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_mstqh_per as
select distinct from matdoc_extract as p join matdoc_extract as m
on p.bukrs = m.bukrs //2988532
{
key m.mandt,
key m.matbf as matnr,
key m.werks,
key m.charg_sid as charg,
key m.sobkz,
key m.mat_pspnr as pspnr,
key p.gjper
}
where m.werks != ''
and m.charg_sid != ''
and m.mat_pspnr != '00000000'
-- and m.bwtar_sid != ''
and p.record_type = 'PERFY'
and m.sobkz = 'Q'
and m.lbbsa_sid = '10'