NSDM_e_J_3RM_MARCMARA_B

@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'NSDM_V_J_3RM_B'
@EndUserText.label:       'J_3RM_MARCMARA_B 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_B 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
                             inner join t001k as d
         on  a.mandt = d.mandt
         and c.bwkey = d.bwkey
{ 
key a.mandt,
key d.bukrs,
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

}