I_MfgOrderComponentLongText

@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #TEXT
@ObjectModel.modelingPattern: #LANGUAGE_DEPENDENT_TEXT
@ObjectModel.supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Manufacturing Order Component - Text'

define view entity I_MfgOrderComponentLongText
    as select from I_OrderComponentLongText as text
        inner join I_OrderComponent         as comp on  comp.Reservation     = text.Reservation
                                                    and comp.ReservationItem = text.ReservationItem
                                                    and comp.RecordType      = text.RecordType

    association [1..1] to I_Language                    as _LongTextLanguage  on  $projection.LongTextLanguage = _LongTextLanguage.Language
--  to root: Header
    association [1..1] to I_ManufacturingOrder          as _MfgOrder          on  $projection.ManufacturingOrder = _MfgOrder.ManufacturingOrder
--  to parent: Operation
    association [1..1] to I_ManufacturingOrderComponent as _MfgOrderComponent on  $projection.Reservation     = _MfgOrderComponent.Reservation
                                                                              and $projection.ReservationItem = _MfgOrderComponent.ReservationItem
                                                                              and $projection.RecordType      = _MfgOrderComponent.ReservationRecordType
{
      // Key

  key comp.Reservation,
      @ObjectModel.text.element: ['MaterialComponentText', 'MaterialComponentSecondText', 'OrderComponentLongText']
  key comp.ReservationItem,
  key comp.RecordType,
      @Semantics.language: true
  key comp.LongTextLanguage,

      // Text

      @Semantics.text: true
      comp.MaterialComponentText,
      @Semantics.text: true
      comp.MaterialComponentSecondText,
      @Semantics.text: true
      text.OrderComponentLongText,

      // for association

      @Consumption.hidden: true
      cast(comp.OrderID as manufacturingorder preserving type) as ManufacturingOrder,

      // Associations

      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _MfgOrder,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]     
      _MfgOrderComponent,
      _LongTextLanguage
}
where 
  (  comp.OrderCategory = '10' or
     comp.OrderCategory = '40' ) and
     comp.MaterialComponentHasLongText = 'X';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ORDERCOMPONENT",
"I_ORDERCOMPONENTLONGTEXT"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MANUFACTURINGORDER",
"I_MANUFACTURINGORDERCOMPONENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/