C_MaintJobPckgBuildOperations

@EndUserText.label: 'Operation to Assign to Work Pack'

@AbapCatalog.sqlViewName: 'CMJOBPCKGBOPS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK
//@AccessControl.privilegedAssociations: [ '_MaintenanceOrderOperation', '_MaintOrderOperObjectListLink' ]

@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType:{
  serviceQuality: #D,
  sizeCategory: #XL,
  dataClass: #MIXED
}

@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #NONE

@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true

define view C_MaintJobPckgBuildOperations
  // as select from           I_MaintenanceOrderOperation

   as select from  I_MaintOrderOperAndSubOper as I_MaintenanceOrderOperation

    left outer to one join I_MaintJobPackageOperation on  I_MaintenanceOrderOperation.MaintenanceOrder             = I_MaintJobPackageOperation.MaintenanceOrder
                                                      and I_MaintenanceOrderOperation.MaintenanceOrderOperation    = I_MaintJobPackageOperation.MaintenanceOrderOperation
                                                      and I_MaintenanceOrderOperation.MaintenanceOrderSubOperation = I_MaintenanceOrderOperation.MaintenanceOrderSubOperation

    left outer to one join I_MaintOrderOperTechObj    on  I_MaintenanceOrderOperation.MaintenanceOrder          = I_MaintOrderOperTechObj.MaintenanceOrder
                                                      and I_MaintenanceOrderOperation.MaintenanceOrderOperation = I_MaintOrderOperTechObj.MaintenanceOrderOperation

{
      @ObjectModel.text.element: ['MaintenanceOrderDesc']
      @ObjectModel.foreignKey.association: '_MaintenanceOrder'
  key I_MaintenanceOrderOperation.MaintenanceOrder,
      @ObjectModel.text.element: ['OperationDescription']
  key cast ( I_MaintenanceOrderOperation.MaintenanceOrderOperation as maintenanceorderoperation preserving type )       as MaintenanceOrderOperation,
  
      //I_MaintenanceOrderOperation.MaintenanceOrderSubOperation,

  key cast ( I_MaintenanceOrderOperation.MaintenanceOrderSubOperation as maintenanceordersuboperation preserving type )  as MaintenanceOrderSubOperation,

      @Semantics.text: true
      I_MaintenanceOrderOperation._MaintenanceOrder.MaintenanceOrderDesc,
      @Semantics.text: true
      I_MaintenanceOrderOperation.OperationDescription,

      @ObjectModel.text.element: ['MaintOpExecStageShortText']
      I_MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[ 1:LanguageCode = $session.system_language ].MaintOpExecutionStageName,
      @Semantics.text: true
      I_MaintenanceOrderOperation._MaintOperationExecStageCode._MaintOpExecStageCodeText[ 1:LanguageCode = $session.system_language ].MaintOpExecStageShortText,

      @ObjectModel.text.element: ['WorkCenterText']
      I_MaintenanceOrderOperation._WorkCenter.WorkCenter,
      @Semantics.text: true
      I_MaintenanceOrderOperation._WorkCenter._Text[ 1:Language = $session.system_language ].WorkCenterText,

      @ObjectModel.text.element: ['EquipmentName']
      I_MaintenanceOrderOperation.Equipment,
      @Semantics.text: true
      I_MaintenanceOrderOperation._Equipment._EquipmentText[ 1:Language = $session.system_language ].EquipmentName,

      @ObjectModel.text.element: ['FunctionalLocationName']
      cast( I_MaintenanceOrderOperation.FunctionalLocation as tplnr_unconverted preserving type )                            as FunctionalLocation,
      @Semantics.text: true
      I_MaintenanceOrderOperation._FunctionalLocation._FunctionalLocationText[ 1:Language = $session.system_language ].FunctionalLocationName,

      @ObjectModel.text.element: ['MaintPriorityDesc']
      I_MaintenanceOrderOperation._MaintenanceOrder.MaintPriority,
      I_MaintenanceOrderOperation._MaintenanceOrder._MaintenancePriority.MaintPriorityColorCode,
      @Semantics.text: true
      I_MaintenanceOrderOperation._MaintenanceOrder._MaintenancePriority._Text[ 1:Language = $session.system_language ].MaintPriorityDesc,

      I_MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecStrtDte,
      I_MaintenanceOrderOperation._OperationPlanningValues.OpErlstSchedldExecEndDte,

      I_MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecStrtDte,
      I_MaintenanceOrderOperation._OperationPlanningValues.OpLtstSchedldExecEndDte,

      I_MaintenanceOrderOperation.CostCtrActivityType,

      @Semantics.quantity.unitOfMeasure: 'OperationPlannedWorkUnit'
      I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWork,
      @ObjectModel.text.element: ['UnitOfMeasureName']
      @Semantics.unitOfMeasure: true
      I_MaintenanceOrderOperation._OperationPlanningValues.OperationPlannedWorkUnit,
      @Semantics.text: true
      I_MaintenanceOrderOperation._OperationPlanningValues._PlannedWorkUnitOfMeasure._Text[ 1:Language = $session.system_language ].UnitOfMeasureName,

      @ObjectModel.text.element: ['OperationPersonRespName']
      I_MaintenanceOrderOperation.OperationPersonResponsible,
      @Semantics.text: true
      I_MaintenanceOrderOperation._PersonResponsible.PersonFullName                                                          as OperationPersonRespName,

      @ObjectModel.text.element: ['OperationMaintNotificationText']
      I_MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject.MaintenanceNotification                   as OperationMaintenanceNotif,
      @Semantics.text: true
      I_MaintOrderOperTechObj._MaintOrderOperObjectListLink._MaintenanceItemObject._MaintenanceNotification.NotificationText as OperationMaintNotificationText,

      /* Associations */
      //      _MaintOrderOperTechObj,

      I_MaintenanceOrderOperation._MaintenanceOrder                                                                          as _MaintenanceOrder

}
where
  (
    (
          I_MaintenanceOrderOperation._StatusObjectActiveStatus [1:StatusCode = 'I0117'].StatusCode               is not null
      and I_MaintenanceOrderOperation._MaintenanceOrder._MaintOrderTypeControlParam.MaintOrdTypeHasActvPhaseModel = 'X'
    )
    or(
          I_MaintenanceOrderOperation._StatusObjectActiveStatus [1:StatusCode = 'I0002'].StatusCode               is not null
      and I_MaintenanceOrderOperation._MaintenanceOrder._MaintOrderTypeControlParam.MaintOrdTypeHasActvPhaseModel = ''
    )
  )
  and     I_MaintenanceOrderOperation._StatusObjectActiveStatus [1:StatusCode = 'I0013'].StatusCode               is null
  and     I_MaintJobPackageOperation.MaintenanceJobPackageUUID                                                    is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENT",
"I_EQUIPMENTTEXT",
"I_FUNCTIONALLOCATION",
"I_FUNCTIONALLOCATIONTEXT",
"I_MAINTENANCEITEMOBJECT",
"I_MAINTENANCENOTIFICATION",
"I_MAINTENANCEORDER",
"I_MAINTJOBPACKAGEOPERATION",
"I_MAINTOPERATIONEXECSTAGECODE",
"I_MAINTOPEXECSTAGECODETEXT",
"I_MAINTORDEROPERANDSUBOPER",
"I_MAINTORDEROPEROBJECTLISTLINK",
"I_MAINTORDEROPERPLANNINGVALUES",
"I_MAINTORDEROPERTECHOBJ",
"I_MAINTORDERTYPECONTROLPARAM",
"I_PMNOTIFICATIONPRIORITY",
"I_PMNOTIFICATIONPRIORITYTEXT",
"I_STATUSOBJECTACTIVESTATUS",
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT",
"I_WORKCENTER",
"I_WORKCENTERTEXT",
"I_WORKFORCEPERSON"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER"
],
"BASE":
[
"I_MAINTORDEROPERANDSUBOPER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/