NSDM_E_MMBE_MARC_V

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'NSDM_V_MMBE_MARC'
@EndUserText.label:       'MMBE_MARC_V Compatibility View'

@ObjectModel.usageType.sizeCategory: 'L'
@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_MMBE_MARC_V as
select from t001w as a inner join nsdm_e_marc as b 
         on  a.mandt = b.mandt 
         and a.werks = b.werks
                             inner join t001k as c
         on a.mandt = c.mandt
         and a.bwkey = c.bwkey
{
 key b.mandt,
 key b.matnr,
 key b.werks,
 
 b.lvorm,
 b.bwtty,
 b.xchar,
 b.dispo,
 b.trame,
 a.name1,
 a.name2,
 a.stras,
 a.pfach,
 a.pstlz,
 a.ort01,
 a.bwkey,
 a.chazv,
 c.bwmod,
 c.bukrs,
 b.glgmg,
 b.umlmc,
 b.sgt_covs
 
 
 }              
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"NSDM_E_MARC",
"T001K",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/