I_RFM_ProductCharcValue1Txt

@AbapCatalog.sqlViewName: 'IRFMPRDCHARVAL1T'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK 
@ClientHandling.algorithm: #SESSION_VARIABLE 

@ObjectModel: {
    dataCategory: #TEXT,
    representativeKey: 'ProductCharacteristic1',
    usageType.sizeCategory: #XL,
    usageType.serviceQuality: #B,
    usageType.dataClass: #MASTER
    
    }

@EndUserText.label: 'Product characteristics value 1'

define view I_RFM_ProductCharcValue1Txt as select from mara as M
                                        inner join I_RetailCharacteristicValueT as T 
                                                on M.color       = T.RetailCharacteristicValue
                                               and M.color_atinn = T.CharacteristicInternalID
                                        
{
    key M.matnr         as Product,     
    key M.color         as ProductCharacteristic1,
    @ObjectModel.foreignKey.association: '_Language'
    @Semantics.language: true
    key T.Language,
    @Semantics.text: true
     T.RetailCharacteristicValueDesc as ProductCharacteristic1Desc,

     _Language
}