I_ChangeRecordMfgOrder

@AbapCatalog.sqlViewName: 'ICHGRECDPRN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MASTER,
                         sizeCategory: #L}
@VDM.viewType:#COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Change Record Production Order'
define view I_ChangeRecordMfgOrder
  as select from I_MfgOrder as MfgOrder
  /* Commented for Performance improvement
   left outer join I_BillOfOperationsVersion    as BOOVersion  on MfgOrder.ManufacturingOrder = BOOVersion.OrderID
   left outer join P_MfgProcgExecOrdMainStatus2 as OrderStatus on MfgOrder.ManufacturingOrder = OrderStatus.ManufacturingOrder
   association [0..1] to I_StatusCodeText             as _StatusCodeText    on  OrderStatus.StatusCode   = _StatusCodeText.StatusCode
                                                                         and _StatusCodeText.Language = $session.system_language */
  association [1..1] to I_MfgOrderCategory           as _MfgOrderCategory  on  $projection.ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory
  association [0..1] to P_ChangeRecordProdnHold      as _ProdnHold         on  $projection.OrderInternalBillOfOperations = _ProdnHold.OrderInternalID
  association [0..1] to I_ProdnOrderChangeStatusText as _ProdnOrdChgStsTxt on  $projection.OrderChangeStatus = _ProdnOrdChgStsTxt.OrderChangeStatus
                                                                           and _ProdnOrdChgStsTxt.Language   = $session.system_language
{
  key MfgOrder.ManufacturingOrder,
      MfgOrder.ManufacturingOrderText,
      MfgOrder.ManufacturingOrderType,
      MfgOrder.ManufacturingOrderCategory,
      MfgOrder.ProductionPlant,
      /*BOOVersion.OrderID,
      BOOVersion.BillOfOperationsGroup,
      BOOVersion.BillOfOperationsType,
      BOOVersion.BillOfOperationsVariant,

      --Get the maximum/latest routing version
      cast(max(BOOVersion.BillOfOperationsVersion) as plnversn preserving type )  as BillOfOperationsVersion,*/

      MfgOrder.Material,

      --Production Order Status
      //_StatusCodeText.StatusName,


      MfgOrder.OrderInternalBillOfOperations,

      --Order Change Status
      cast(case
        when ( _ProdnHold.OrderCount > 0 and _ProdnHold.ProductionHoldEndDateTime = 0 ) then '1'
        when ( _ProdnHold.OrderCount > 0 and _ProdnHold.ProductionHoldEndDateTime > 0 ) then '2'
        else '0'
      end as mpe_mec_ord_change_status) as OrderChangeStatus,

      _Material,
      _MfgOrderType,
      _MfgOrderCategory,
      _ProdnOrdChgStsTxt
}
/*group by
  MfgOrder.ManufacturingOrder,
  MfgOrder.ManufacturingOrderText,
  MfgOrder.ManufacturingOrderType,
  MfgOrder.ManufacturingOrderCategory,
  MfgOrder.ProductionPlant,
  BOOVersion.OrderID,
  BOOVersion.BillOfOperationsGroup,
  BOOVersion.BillOfOperationsType,
  BOOVersion.BillOfOperationsVariant,
  MfgOrder.Material,
  _StatusCodeText.StatusName,
  MfgOrder.OrderInternalBillOfOperations,
  _ProdnHold.OrderCount,
  _ProdnHold.ProductionHoldEndDateTime;*/
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MFGORDER",
"P_CHANGERECORDPRODNHOLD"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MFGORDERCATEGORY",
"I_MFGORDERTYPE",
"I_PRODNORDERCHANGESTATUSTEXT",
"P_CHANGERECORDPRODNHOLD"
],
"BASE":
[
"I_MFGORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/