I_MaintenanceOrderOperation

@AbapCatalog.sqlViewName: 'IMAINTORDOP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@EndUserText.label: 'Maintenance Order Operation'
@VDM.viewType: #BASIC

@ObjectModel.representativeKey: 'MaintenanceOrderOperation'
@ObjectModel.semanticKey:  [ 'MaintenanceOrder', 'MaintenanceOrderOperation' ]

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.privilegedAssociations: ['_StatusObjectActiveStatus']


define view I_MaintenanceOrderOperation
  as select from I_MaintOrderOperationBasic as _Operation

  association [1..1] to I_MaintOrderOperPlanningValues as _OperationPlanningValues      on  $projection.MaintOrderRoutingNumber    = _OperationPlanningValues.MaintOrderRoutingNumber
                                                                                        and $projection.MaintOrderOperationCounter = _OperationPlanningValues.MaintOrderOperationCounter
  association [0..1] to I_MaintenanceOrder             as _MaintenanceOrder             on  $projection.MaintenanceOrder = _MaintenanceOrder.MaintenanceOrder
  association [0..*] to I_MaintenanceOrderComponent_2  as _MaintenanceOrderComponent    on  $projection.MaintenanceOrder           = _MaintenanceOrderComponent.MaintenanceOrder
                                                                                        and $projection.MaintOrderRoutingNumber    = _MaintenanceOrderComponent.MaintOrderRoutingNumber
                                                                                        and $projection.MaintOrderOperationCounter = _MaintenanceOrderComponent.MaintOrderOperationCounter
  association [0..*] to I_MaintenanceOrderSubOperation as _MaintenanceOrderSubOperation on  $projection.MaintenanceOrder          = _MaintenanceOrderSubOperation.MaintenanceOrder
                                                                                        and $projection.MaintenanceOrderOperation = _MaintenanceOrderSubOperation.MaintenanceOrderOperation
  association [0..1] to I_WorkCenter                   as _WorkCenter                   on  $projection.OperationWorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                                                        and $projection.OperationWorkCenterTypeCode   = _WorkCenter.WorkCenterTypeCode
  association [0..1] to I_Currency                     as _OpExternalProcessingCurrency on  $projection.OpExternalProcessingCurrency = _OpExternalProcessingCurrency.Currency
  association [0..1] to I_StatusObject                 as _StatusObject                 on  $projection.MaintOrderOperationInternalID = _StatusObject.StatusObject
  association [0..1] to I_OperationControlProfile      as _OperationControlKey          on  $projection.OperationControlKey = _OperationControlKey.OperationControlProfile
  association [0..1] to I_MaintOperationSystCondition  as _OperationSystemCondition     on  $projection.OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition
  association [0..1] to I_Plant                        as _Plant                        on  $projection.Plant = _Plant.Plant
  association [0..1] to I_OperationCalculationControl  as _OperationCalculationControl  on  $projection.OperationCalculationControl = _OperationCalculationControl.OperationCalculationControl
  association [0..1] to I_Material                     as _Assembly                     on  $projection.Assembly = _Assembly.Material
  association [0..1] to I_Language                     as _Language                     on  $projection.Language = _Language.Language
  association [0..1] to I_Indicator                    as _OperationHasLongText         on  $projection.OperationHasLongText = _OperationHasLongText.IndicatorValue
  association [0..*] to I_StatusObjectActiveStatus     as _StatusObjectActiveStatus     on  $projection.MaintOrderOperationInternalID = _StatusObjectActiveStatus.StatusObject
  association [0..1] to I_Supplier                     as _Supplier                     on  $projection.OperationSupplier = _Supplier.Supplier
  association [0..1] to I_Equipment                    as _Equipment                    on  $projection.Equipment = _Equipment.Equipment
  association [0..1] to I_FunctionalLocation           as _FunctionalLocation           on  $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
  --association [0..1] to I_Employment                   as _PersonResponsible            on  $projection.OperationPersonResponsible = _PersonResponsible.EmploymentInternalID
  association [0..1] to I_PersonWorkAgreement_1        as _PersonResponsible            on  $projection.OperationPersonResponsible = _PersonResponsible.PersonWorkAgreement

  association [0..1] to I_MaintenanceOrderConfirmation as _MaintenanceOrderConf         on  $projection.MaintOrderConfirmation  = _MaintenanceOrderConf.MaintOrderConf
                                                                                        and $projection.MaintOrderConfCntrValue = _MaintenanceOrderConf.MaintOrderConfCntrValue
  association [0..*] to I_OrderProdnResourceTool       as _MaintOrderProdnRsceTool      on  _MaintOrderProdnRsceTool.OrderInternalBillOfOperations = $projection.MaintOrderRoutingNumber
                                                                                        and _MaintOrderProdnRsceTool.OrderIntBillOfOperationsItem  = $projection.MaintOrderOperationCounter
  association [0..*] to I_CostCenterActivityTypeText   as _CostCenterActivityTypeText   on  $projection.ControllingArea     = _CostCenterActivityTypeText.ControllingArea
                                                                                        and $projection.CostCtrActivityType = _CostCenterActivityTypeText.CostCtrActivityType
  association [0..1] to I_PMContactCardEmployee        as _PMContactEmployee            on  $projection.OperationPersonResponsible = _PMContactEmployee.PersonnelNumber
  association [0..1] to I_WorkAssignment               as _WorkAssignment               on  $projection.OperationPersonResponsible = _WorkAssignment.WorkAssignment
  association [1..1] to I_MaintOperationExecStageCode  as _MaintOperationExecStageCode  on  $projection.MaintOperationExecStageCode = _MaintOperationExecStageCode.MaintOperationExecStageCode

  association [0..1] to I_EAMProcessPhase              as _EAMProcessPhase              on  $projection.MaintOrdOpProcessPhaseCode = _EAMProcessPhase.EAMProcessPhaseCode
  association [0..1] to I_EAMProcessSubPhase           as _EAMProcessSubPhase           on  $projection.MaintOrdOpProcessSubPhaseCode = _EAMProcessSubPhase.EAMProcessSubPhaseCode

{
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_MaintenanceOrderStdVH',
                     element: 'MaintenanceOrder' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_MaintenanceOrder'
  key _Operation.MaintenanceOrder,
      @EndUserText.label: 'Operation'
      @ObjectModel.text.element: ['OperationDescription']
  key _Operation.MaintenanceOrderOperation, 
      '0000'                                                                        as MaintenanceOrderSubOperation,
      _Operation.MaintOrderRoutingNumber,
      _Operation.MaintOrderOperationCounter,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_PlantStdVH',
                     element: 'Plant' }
        }]
      @ObjectModel.foreignKey.association: '_Plant'
      _Operation.Plant,
      _Operation.OperationWorkCenterTypeCode,
      _Operation.OperationWorkCenterInternalID,
      @ObjectModel.foreignKey.association: '_OperationControlKey'
      _Operation.OperationControlKey,
      @Semantics.text
      _Operation.OperationDescription,
      _Operation.OperationStandardTextCode,
      @ObjectModel.foreignKey.association: '_Language'
      _Operation.Language,
      _Operation.NumberOfTimeTickets,
      //      afvc.loart                                                                    as WageType,

      //      afvc.qualf                                                                    as Suitability,

      //      afvc.logrp                                                                    as WageGroup,

      _Operation.OperationPurgInfoRecdSearchTxt,
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Supplier_VH',
                     element: 'Supplier' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_Supplier'
      _Operation.OperationSupplier,
      //      @Semantics.quantity.unitOfMeasure: 'OperationBaseUnitOfMeasure'

      //      afvv.bmsch                                                                    as OperationQuantity,

      //      @Semantics.unitOfMeasure: true

      //      afvv.meinh                                                                    as OperationBaseUnitOfMeasure,

      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      @DefaultAggregation: #NONE
      _Operation.OpExternalProcessingPrice,
      _Operation.MaintOrdOpProcgPriceUnitValue as OpExternalProcessingPriceUnit,
      _Operation.CostElement,
      @ObjectModel.foreignKey.association: '_OpExternalProcessingCurrency'
      @Semantics.currencyCode: true
      _Operation.OpExternalProcessingCurrency,
      _Operation.OperationPurchasingInfoRecord,
      _Operation.PurchasingOrganization,
      _Operation.PurchasingGroup,
      _Operation.MaterialGroup,
      _Operation.OpPurchaseOutlineAgreement,
      _Operation.OpPurchaseOutlineAgreementItem,
      _Operation.OperationRequisitionerName,
      _Operation.OperationTrackingNumber,
      @DefaultAggregation: #NONE
      _Operation.NumberOfCapacities,
      _Operation.OperationWorkPercent,
      _Operation.OperationCalculationControl,
      _Operation.ActivityType,
      _Operation.OperationSystemCondition,
      //afvc.vertl                                                                    as DistrCapReqmts,

      _Operation.OperationGoodsRecipientName,
      _Operation.OperationUnloadingPointName,
      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_PersWrkAgrmtSrchHelp',
                     element: 'PersonWorkAgreement' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_PersonResponsible'
     _Operation.OperationPersonResponsible,
      //afvc.fordn                                                                    as FrameworkOrder,

      //afvc.fordp                                                                    as ItemoOfFrameworkOrder,

      //afvv.plifz                                                                    as PlannedDeliveryTimeInDays,

      //@Semantics.quantity.unitOfMeasure: 'NormalDurationUnit'

      //afvv.dauno                                                                    as NormalDurationOfActivity,

      //@Semantics.unitOfMeasure: true

      //afvv.daune                                                                    as NormalDurationUnit,

      //afvv.einsa                                                                    as TypeConstraintStartDate,

      //afvv.einse                                                                    as TypeConstraintFinishDate,

      //@Semantics.quantity.unitOfMeasure: 'UnitForWork'

      //afvv.arbei                                                                    as WorkInvolvedInActivity,

      //      @Semantics.unitOfMeasure: true

      //      afvv.arbeh                                                                    as UnitForWork,

      //      afvv.ntanf                                                                    as ConstraintActivityStartDateBas,

      //      afvv.ntanz                                                                    as ConstraintActivityStartTimeBas,

      //      afvv.ntend                                                                    as ConstraintActivityEndDateBas,

      //      afvv.ntenz                                                                    as ConstraintActivityEndTimeBas,

      //      afvv.aufkt                                                                    as ExecutionFactor,

      // 'Inspection Rounds'-related fields

      _Operation.Equipment,
      _Operation.FunctionalLocation, // <-- This is in internal labelling!

      // afvc.frdlb                                                                    as ExtProcOperationSubcontracting,

      //afvu.ilart_op                                                                 as MaintenanceActivityType,

      _Operation.BusinessArea,
      //afvc.projn                                                                    as WBSElement,

     _Operation.ProfitCenter,
     _Operation.CostingSheet,
      // afvc.zschl                                                                    as Overheadkey,

      _Operation.TaxJurisdiction,
      //afvc.scope                                                                    as ObjectClass,

      _Operation.FunctionalArea,
      //      @Semantics.quantity.unitOfMeasure: 'UnitForOffsetToStart'

      //      afvv.offstb                                                                   as OffsetToSubOperationStart,

      //      @Semantics.unitOfMeasure: true

      //      afvv.ehoffb                                                                   as UnitForOffsetToStart,

      //      @Semantics.quantity.unitOfMeasure: 'UnitForOffsetToFinish'

      //      afvv.offste                                                                   as OffsetToSubOperationFinish,

      //      @Semantics.unitOfMeasure: true

      //      afvv.ehoffe                                                                   as UnitForOffsetToFinish,

      //--[ GENERATED:012:GFBfhxvv7kY4nH9{xKJeWG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_MaterialStdVH',
                     element: 'Material' }
        }]
      // ]--GENERATED

      @ObjectModel.foreignKey.association: '_Assembly'
      _Operation.Assembly, //long one - 40 char

      //      afvc.fldlogsdelivisheldonshore                                                as HoldOnShore,

      @ObjectModel.foreignKey.association: '_MaintOperationExecStageCode'
     _Operation.MaintOperationExecStageCode,
      _Operation.CostCtrActivityType,
     _Operation.ReqgCostCenterControllingArea,
      _Operation.CapacityRequirement,
      _Operation.CapacityRequirementItem,
      _Operation.PurchaseRequisition,
      _Operation.MaintOrderOperationInternalID,
      _Operation.PurchaseRequisitionItem,
      _Operation.MaintOrderConfirmation,
      _Operation.OperationMilestoneUsageCode,
      _Operation.MaintOrderConfCntrValue,
      @ObjectModel.foreignKey.association: '_OperationHasLongText'
      _Operation.OperationHasLongText,
      -- needed for some associations, e.g. activity type
      _Operation.ControllingArea,
      @ObjectModel.foreignKey.association: '_EAMProcessPhase'
      _Operation.MaintOrdOpProcessPhaseCode,
      @ObjectModel.foreignKey.association: '_EAMProcessSubPhase'
      _Operation.MaintOrdOpProcessSubPhaseCode,
      _Operation.MaintOperationalChecklistType,
      // associations :

      _MaintenanceOrderComponent,
      _MaintenanceOrderSubOperation,
      _MaintenanceOrder,
      _StatusObject,
      _OpExternalProcessingCurrency,
      _OperationPlanningValues,
      _WorkCenter,
      _OperationControlKey,
      _OperationSystemCondition,
      _Plant,
      _OperationCalculationControl,
      _Assembly,
      _Language,
      _OperationHasLongText,
      _StatusObjectActiveStatus,
      _Supplier,
      _PersonResponsible,
      _FunctionalLocation,
      _Equipment,
      _MaintenanceOrderConf,
      _MaintOrderProdnRsceTool,
      _CostCenterActivityTypeText,
      _PMContactEmployee,
      _WorkAssignment,
      _MaintOperationExecStageCode,
      _EAMProcessPhase,
      _EAMProcessSubPhase
}