I_ValueChainType

@AbapCatalog: {
  sqlViewName: 'IVCM_CHAINTYPE',
  compiler.compareFilter: true,
  preserveKey: true
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl: {
  authorizationCheck: #NOT_REQUIRED
}

@ObjectModel: {
  usageType: {
    serviceQuality: #B,
    sizeCategory: #M,
    dataClass: #CUSTOMIZING
  },
  representativeKey: 'ValueChainType'
}


@VDM.viewType: #BASIC


@EndUserText.label: 'Value Chain'
define view I_ValueChainType
  as select from vcm_chain_type as ChainType
  association [0..*] to I_ValueChainTypeText as _Text on  $projection.ValueChainType = _Text.ValueChainType //association to the text view

                                                      and $projection.ValueChainTypeVersion = _Text.ValueChainTypeVersion
{
      //ChainType

  @ObjectModel.text.association: '_Text' //field relation to text view    

  key value_chain_type as ValueChainType,
  key version          as ValueChainTypeVersion,
      created_at       as CreationDateTime,
      created_by       as CreatedByUser,
      last_changed_at  as LastChangeDateTime,
      last_changed_by  as LastChangedByUser,
      
      _Text //text association in projection list

}