SHSM_H_MARC

@AbapCatalog.sqlViewName: 'SHSMHMARC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'matnr'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'CDS View for H_MARC (search help)'

//Please confirm if client MANDT field is required in join condition

define view SHSM_H_MARC 
as select from marc as m left outer join 
               t001w as t on  m.werks = t.werks
association [1..1] to I_Product as _Product on $projection.matnr = _Product.Product
{
  key cast( m.matnr as matnr preserving type ) as matnr,
  key cast( m.werks as werks_d preserving type ) as werks,
  cast( t.name1 as name1 preserving type ) as name1,
  _Product
}