I_ManufacturingOrderStatusText

@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #TEXT
@Analytics.technicalName: 'IMFGORDERSTSTEXT'
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE, #SEARCHABLE_ENTITY]
@ObjectModel.representativeKey: 'StatusCode'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XXL, dataClass: #MIXED}
@Search.searchable: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Manufacturing Order Status - Text'

define view entity I_ManufacturingOrderStatusText
  as select from I_ManufacturingOrderStatus as stat
    inner join   I_StatusCodeText           as text on  text.StatusCode    = stat.StatusCode
                                                    and text.StatusProfile = stat.StatusProfile

  --  to parent
  association        to parent I_ManufacturingOrderStatus as _ManufacturingOrderStatus on  $projection.ManufacturingOrder = _ManufacturingOrderStatus.ManufacturingOrder
                                                                                       and $projection.StatusCode         = _ManufacturingOrderStatus.StatusCode
  --  to root
  association [1..1] to I_ManufacturingOrder              as _ManufacturingOrder       on  $projection.ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder
{
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MfgOrderStdVH', element: 'ManufacturingOrder' } } ]
      @ObjectModel.foreignKey.association: '_ManufacturingOrder'
  key stat.ManufacturingOrder,
//      @ObjectModel.foreignKey.association: '_StatusCode'

      @ObjectModel.text.element: ['StatusShortName','StatusName']
  key stat.StatusCode,
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
  key cast(text.Language as spras preserving type) as Language,

      @ObjectModel.foreignKey.association: '_StatusProfile'
      stat.StatusProfile,

      @Search: {defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8}
      @Semantics.text: true
      text.StatusShortName                         as StatusShortName,

      @Semantics.text: true
      text.StatusName                              as StatusName,

      // Associations

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _ManufacturingOrder,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _ManufacturingOrderStatus,
//      stat._StatusCode,

      stat._StatusProfile,
      text._Language
};