NSDM_e_J_3RM_MARCMARA_W_w

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'NSDM_V_J_3RM_W'
@EndUserText.label:       'J_3RM_MARCMARA_W 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_J_3RM_MARCMARA_W_w as
select from nsdm_e_marc as a inner join mara as b 
         on  a.mandt = b.mandt 
         and a.matnr = b.matnr 
                             inner join t001w as c
         on  a.mandt = c.mandt
         and a.werks = c.werks
{ 
key a.mandt,
key a.matnr, 
key a.werks,

c.bwkey,
b.meins,
b.mtart,
b.matkl,
b.bismt,
a.xchar,
a.trame,
a.umlmc,
a.bwesb,
a.bwtty,
a.ekgrp

}                
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"NSDM_E_MARC",
"MARA",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/