P_ProdOrdMgmtOp

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_ProdOrdMgmtOp
  as select from I_OrderOperationBasic as afvc
    inner join   I_LogisticsOrder      as aufv on  aufv.OrderInternalBillOfOperations = afvc.OrderInternalID
                                               and aufv.OrderCategory                 = '10'
{
  key afvc.OrderInternalID,
  key afvc.OrderOperationInternalID,
      aufv.OrderID       as ManufacturingOrder,
      aufv.OrderCategory as ManufacturingOrderCategory,
      aufv.Plant         as ProductionPlant,
      aufv.ProductionSupervisor,
      afvc.Sequence,
      afvc.Operation,
      afvc.StandardTextInternalID,
      afvc.OperationText,
      afvc.Language,
      afvc.BillOfOperationsSequence,
      afvc.BillOfOperationsType,
      afvc.BillOfOperationsGroup,
      afvc.BillOfOperationsVariant,
      afvc.BOOOperationInternalID,
      afvc.BillOfOperationsVersion,
      afvc.SuperiorOperationInternalID,
      afvc.OperationControlProfile,
      afvc.WorkCenterInternalID,
      afvc.WorkCenterTypeCode,
      afvc.Plant,
      afvc.ObjectInternalID,
      afvc.MfgOrderOperationIsPhase,
      afvc._OrderInternalID,
      afvc.OrderIntBillOfOpItemOfPhase
}
where
      aufv.OrderCategory               = '10'
  and afvc.SuperiorOperationInternalID is initial //SuperiorOperationInternalID

  and afvc.Sequence                    = '000000'; //Sequence

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"I_ORDEROPERATIONBASIC"
],
"ASSOCIATED":
[
"I_ORDERINTERNALID"
],
"BASE":
[
"I_ORDEROPERATIONBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/