NSDM_E_V_MMIM_EN2

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'NSDM_V_MMIM_EN2'
@EndUserText.label:       'V_MMIM_EN2 Compatibility View'

@ObjectModel.usageType.sizeCategory: 'XXL'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #AUTOMATED
@AccessControl.authorizationCheck: #NOT_ALLOWED
@AccessControl.personalData.blocking: #NOT_REQUIRED 
@AbapCatalog.viewEnhancementCategory: #PROJECTION_LIST
define view NSDM_E_V_MMIM_EN2 as
select from nsdm_e_mska as a inner join mara as b 
         on  a.mandt = b.mandt 
         and a.matnr = b.matnr
                             inner join nsdm_e_marc as c
         on  a.mandt = c.mandt
         and a.matnr = c.matnr
         and a.werks = c.werks
                             inner join t001w as d
         on  a.mandt = d.mandt
         and a.werks = d.werks
                             inner join t134m as e
         on  a.mandt = e.mandt
         and d.bwkey = e.bwkey
         and b.mtart = e.mtart
{
key a.mandt,
key a.matnr,
key a.werks,
key a.lgort,
key a.charg,
key a.sobkz,
key a.vbeln,
key a.posnr,

a.lfgja,
a.lfmon,
a.kaill as kzill,
a.kailq as kzilq,
a.kails as kzils,
a.kavll as kzvll,
a.kavlq as kzvlq,
a.kavls as kzvls,
b.mtart,
b.matkl,
c.abcin,
a.kalab as labst,
a.kains as insme,
a.kaspe as speme,
a.kaein as einme

}
where e.mengu = ''