P_ProcOrdMgmtOp

@AbapCatalog.sqlViewName: 'PPORMGMTOP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'Process order operation'

@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #CLIENT_DEPENDENT
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view P_ProcOrdMgmtOp
  as select from I_OrderOperationBasic as afvc
    inner join   I_LogisticsOrder      as aufv on  aufv.OrderInternalBillOfOperations = afvc.OrderInternalID
                                               and aufv.OrderCategory                 = '40'
{
  key afvc.OrderInternalID,
  key OrderOperationInternalID,
      aufv.OrderID       as ProcessOrder,
      aufv.OrderCategory as ManufacturingOrderCategory,
      aufv.Plant         as ProductionPlant,
      aufv.ProductionSupervisor,
      Sequence,
      Operation,
      StandardTextInternalID,
      OperationText,
      Language,
      BillOfOperationsSequence,
      afvc.BillOfOperationsType,
      afvc.BillOfOperationsGroup,
      afvc.BillOfOperationsVariant,
      BOOOperationInternalID,
      afvc.BillOfOperationsVersion,
      SuperiorOperationInternalID,
      OperationControlProfile,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      afvc.Plant,
      afvc.ObjectInternalID,
      MfgOrderOperationIsPhase,
      _OrderInternalID,
      OrderIntBillOfOpItemOfPhase
}
where
      aufv.OrderCategory               = '40'
  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":""
}
}*/