NSDM_E_V_CF_MSKA

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName:      'NSDM_V_V_CF_MSKA'
@EndUserText.label:            'V_CF_MSKA Compatibility View'
@DataAging.noAgingRestriction: 'false'

@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_CF_MSKA as
select from nsdm_e_mska as a inner join mcha as b 
         on  a.mandt = b.mandt 
         and a.matnr = b.matnr 
         and a.werks = b.werks 
         and a.charg = b.charg 
         inner join mch1 as c 
         on  b.mandt = c.mandt 
         and b.matnr = c.matnr 
         and b.charg = c.charg
               
{
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.kalab as CLABS,
a.kains as CINSM,
a.kaspe as CSPEM,
a.kaein as CEINM, 
a.kavla as CVMLA,
a.kavin as CVMIN,
a.kavsp as CVMSP,
a.kavei as CVMEI,
a.kaspr as SPERC,
b.lvorm as LVORM_0,
c.lvorm as LVORM_1,
b.bwtar,
b.zustd as ZUSTD_0,
c.zustd as ZUSTD_1,
a.lfgja,
a.lfmon, 
b.batch_type as BATCH_TYPE_0,
c.batch_type as BATCH_TYPE_1,
b.sgt_scat

} 

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"NSDM_E_MSKA",
"MCH1",
"MCHA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/