I_ChgImpactRoutingProdnOrd

@AbapCatalog.sqlViewName: 'ICHIMROUPRODOR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Production Orders for Routings'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED}
define view I_ChgImpactRoutingProdnOrd
  as select from    I_MfgOrder             as MfgOrder
  //    inner join      I_ChgImpactOrderStatus    as ChgImpactOrderStatus on ChgImpactOrderStatus.ManufacturingOrder = MfgOrder.ManufacturingOrder

    left outer join P_ChgImpactStatusCodes as ChgImpactStatusCodes on MfgOrder.ManufacturingOrder = ChgImpactStatusCodes.ManufacturingOrder
  association [0..1] to I_BillOfOperationsVersion as _BillOfOperationsVersion on  $projection.BillOfOperationsType    = _BillOfOperationsVersion.BillOfOperationsType
                                                                              and $projection.BillOfOperationsGroup   = _BillOfOperationsVersion.BillOfOperationsGroup
                                                                              and $projection.BillOfOperationsVariant = _BillOfOperationsVersion.BillOfOperationsVariant
                                                                              and $projection.BillOfOperationsVersion = _BillOfOperationsVersion.BillOfOperationsVersion

  association [0..*] to I_StatusCodeText          as _StatusCodeText          on  $projection.StatusCode   = _StatusCodeText.StatusCode
                                                                              and _StatusCodeText.Language = $session.system_language
  //  association [0..1] to I_OrderItem               as _OrderItem               on  $projection.ManufacturingOrder = _OrderItem.OrderID

  //                                                                                 and _OrderItem.OrderItem           = '0001'

  //



{
  key MfgOrder.ManufacturingOrder,
  key MfgOrder.BillOfOperations  as BillOfOperationsGroup,
  key MfgOrder.BillOfOperationsType,
  key MfgOrder.BillOfOperationsVariant,
  key MfgOrder.BillOfOperationsVersion,
      MfgOrder.MfgOrderScheduledStartDate,
      MfgOrder.MfgOrderScheduledEndDate,
      MfgOrder.ProductionPlant,
      MfgOrder.BillOfMaterialCategory,
      MfgOrder.BillOfMaterial,
      MfgOrder.BillOfMaterialVariant,
      MfgOrder.BillOfMaterialVersion,
      MfgOrder.Material,
      //      _OrderItem.EffectivityParameterVariant,

      MfgOrder.EffectivityParameterVariant,
      MfgOrder.LeadingOrder,
      @ObjectModel.text.association: '_StatusCodeText'
      ChgImpactStatusCodes.StatusCode,
      _StatusCodeText.StatusName as StatusName,

      //Fields added for Order Specific Routing

      //Seperated in 1909 FP1

      //      BOOVersion.OrderID,

      //      BOOVersion.BillOfOperationsGroup                                           as OrdSpcfcBOOGroup,

      //      BOOVersion.BillOfOperationsType                                            as OrdSpcfcBOOType,

      //      BOOVersion.BillOfOperationsVariant                                         as OrdSpcfcBOOVariant,//

      //      --Get the maximum/latest routing version

      //      cast(max(BOOVersion.BillOfOperationsVersion) as plnversn preserving type ) as OrdSpcfcBOOVersion,


      _BillOfOperationsVersion,
      _StatusCodeText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDER",
"I_STATUSCODETEXT",
"P_CHGIMPACTSTATUSCODES"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSVERSION",
"I_STATUSCODETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/