NSDM_E_MSTEH_PER

CDS View

CDS View for All Periods for MSTEH

NSDM_E_MSTEH_PER is a CDS View in S/4HANA. CDS View for All Periods for MSTEH. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
nsdm_e_msteh view from CDS View for MSTEH on NSDM_T_MTDCSA

Fields (7)

KeyField CDS FieldsUsed in Views
KEY charg charg 1
KEY mandt mandt 1
KEY matnr matnr 1
KEY posnr posnr 1
KEY sobkz sobkz 1
KEY vbeln vbeln 1
KEY werks werks 1 
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_MSTEH_PER'
@EndUserText.label:            'CDS View for All Periods for MSTEH'
@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_msteh_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_kdauf as vbeln,
key m.mat_kdpos as posnr,
key p.gjper          

}

where m.werks     != ''
  and m.charg_sid != ''
  and m.mat_kdauf != ''
  and m.mat_kdpos != '000000'  
--  and m.bwtar_sid != ''
  and p.record_type = 'PERFY'
  and m.sobkz       = 'E' 
  and m.lbbsa_sid   = '10'

Learn More