I_RoutingOperationSearchModel

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #BASIC
//@Analytics: {dataCategory: #DIMENSION}

@ObjectModel.representativeKey: 'BOOOpInternalVersionCounter'
@Analytics.technicalName: 'IRTGOPBSCESH'
@EndUserText.label: 'Bill of Operations Operation Basic'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #L, dataClass: #MASTER }
define view entity I_RoutingOperationSearchModel
  as select from plpo


  association [1..1] to I_BillOfOperationsType        as _BillOfOperationsType          on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
  association [1..1] to I_BillOfOperationsGroup       as _BillOfOperationsGroup         on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                                        and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
  association [1..1] to I_BOOOperationInternalID      as _BOOOperationInternalID        on  $projection.BillOfOperationsType   = _BOOOperationInternalID.BillOfOperationsType
                                                                                        and $projection.BillOfOperationsGroup  = _BOOOperationInternalID.BillOfOperationsGroup
                                                                                        and $projection.BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID

  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
  association [0..1] to I_WorkCenterType              as _WorkCenterType                on  $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
  association [0..1] to I_WorkCenter                  as _WorkCenter                    on  $projection.WorkCenterTypeCode   = _WorkCenter.WorkCenterTypeCode
                                                                                        and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
  association [1..1] to I_Plant                       as _Plant                         on  $projection.Plant = _Plant.Plant

  association [0..1] to I_ChangeMaster                as _ChangeMaster                  on  $projection.ChangeNumber = _ChangeMaster.ChangeNumber

  association [1..1] to I_OperationControlProfile     as _OperationControlProfile       on  $projection.OperationControlProfile = _OperationControlProfile.OperationControlProfile

  association [1..1] to I_UnitOfMeasure               as _OperationUnit                 on  $projection.OperationUnit = _OperationUnit.UnitOfMeasure
  association [1..1] to I_OperationStandardText       as _OperationStandardText         on  $projection.OperationStandardTextCode = _OperationStandardText.OperationStandardTextCode

  association [0..1] to I_InspResultRecordingView     as _InspResultRecordingView       on  $projection.InspResultRecordingView = _InspResultRecordingView.InspResultRecordingView

  association [1..1] to I_OperationStdWorkQtyGrpgCat  as _OperationStdWorkQtyGrpgCat    on  $projection.OperationStdWorkQtyGrpgCat = _OperationStdWorkQtyGrpgCat.OperationStdWorkQtyGrpgCat

  association [0..1] to I_CapacityCategory            as _CapacityCategory              on  $projection.CapacityCategoryCode = _CapacityCategory.CapacityCategoryCode

  association [0..1] to I_PurchasingInfoRecordApi01   as _PurchasingInfoRecord          on  $projection.PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
  association [0..1] to I_PurchasingOrganization      as _PurchasingOrganization        on  $projection.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization
  association [0..1] to I_PurchaseContract            as _PurchaseContract              on  $projection.PurchaseContract = _PurchaseContract.PurchaseContract
  association [0..1] to I_PurchaseContractItem        as _PurchaseContractItem          on  $projection.PurchaseContract     = _PurchaseContractItem.PurchaseContract
                                                                                        and $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem
  /*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ] } */
  association [0..1] to I_MaterialGroup               as _MaterialGroup                 on  $projection.MaterialGroup = _MaterialGroup.MaterialGroup
  association [0..1] to I_PurchasingGroup             as _PurchasingGroup               on  $projection.PurchasingGroup = _PurchasingGroup.PurchasingGroup
  association [0..1] to I_Supplier                    as _Supplier                      on  $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_Currency                    as _OpExternalProcessingCurrency  on  $projection.OpExternalProcessingCurrency = _OpExternalProcessingCurrency.Currency

  association [0..1] to I_InspectionLotType           as _InspectionLotType             on  $projection.InspectionLotType = _InspectionLotType.InspectionLotType

  association [1..1] to I_UnitOfMeasure               as _BillOfOperationsBreakDurnUnit on  $projection.BillOfOperationsBreakDurnUnit = _BillOfOperationsBreakDurnUnit.UnitOfMeasure

  association [1..1] to I_UnitOfMeasure               as _StandardWorkQuantityUnit1     on  $projection.StandardWorkQuantityUnit1 = _StandardWorkQuantityUnit1.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _StandardWorkQuantityUnit2     on  $projection.StandardWorkQuantityUnit2 = _StandardWorkQuantityUnit2.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _StandardWorkQuantityUnit3     on  $projection.StandardWorkQuantityUnit3 = _StandardWorkQuantityUnit3.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _StandardWorkQuantityUnit4     on  $projection.StandardWorkQuantityUnit4 = _StandardWorkQuantityUnit4.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _StandardWorkQuantityUnit5     on  $projection.StandardWorkQuantityUnit5 = _StandardWorkQuantityUnit5.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _StandardWorkQuantityUnit6     on  $projection.StandardWorkQuantityUnit6 = _StandardWorkQuantityUnit6.UnitOfMeasure

  association [1..1] to I_PerformanceEfficiencyRatio  as _PerformanceEfficiencyRatio1   on  $projection.PerfEfficiencyRatioCode1 = _PerformanceEfficiencyRatio1.PerformanceEfficiencyRatioCode
  association [1..1] to I_PerformanceEfficiencyRatio  as _PerformanceEfficiencyRatio2   on  $projection.PerfEfficiencyRatioCode2 = _PerformanceEfficiencyRatio2.PerformanceEfficiencyRatioCode
  association [1..1] to I_PerformanceEfficiencyRatio  as _PerformanceEfficiencyRatio3   on  $projection.PerfEfficiencyRatioCode3 = _PerformanceEfficiencyRatio3.PerformanceEfficiencyRatioCode
  association [1..1] to I_PerformanceEfficiencyRatio  as _PerformanceEfficiencyRatio4   on  $projection.PerfEfficiencyRatioCode4 = _PerformanceEfficiencyRatio4.PerformanceEfficiencyRatioCode
  association [1..1] to I_PerformanceEfficiencyRatio  as _PerformanceEfficiencyRatio5   on  $projection.PerfEfficiencyRatioCode5 = _PerformanceEfficiencyRatio5.PerformanceEfficiencyRatioCode
  association [1..1] to I_PerformanceEfficiencyRatio  as _PerformanceEfficiencyRatio6   on  $projection.PerfEfficiencyRatioCode6 = _PerformanceEfficiencyRatio6.PerformanceEfficiencyRatioCode

  association [1..1] to I_UnitOfMeasure               as _MaximumWaitDurationUnit       on  $projection.MaximumWaitDurationUnit = _MaximumWaitDurationUnit.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _MinimumWaitDurationUnit       on  $projection.MinimumWaitDurationUnit = _MinimumWaitDurationUnit.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _StandardMoveDurationUnit      on  $projection.StandardMoveDurationUnit = _StandardMoveDurationUnit.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _MinimumMoveDurationUnit       on  $projection.MinimumMoveDurationUnit = _MinimumMoveDurationUnit.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _StandardQueueDurationUnit     on  $projection.StandardQueueDurationUnit = _StandardQueueDurationUnit.UnitOfMeasure
  association [1..1] to I_UnitOfMeasure               as _MinimumQueueDurationUnit      on  $projection.MinimumQueueDurationUnit = _MinimumQueueDurationUnit.UnitOfMeasure

  association [1..1] to I_UnitOfMeasure               as _MinProcessingDurnPerSplitUnit on  $projection.MinProcessingDurnPerSplitUnit = _MinProcessingDurnPerSplitUnit.UnitOfMeasure

  association [1..1] to I_UnitOfMeasure               as _OverlapMinimumDurationUnit    on  $projection.OverlapMinimumDurationUnit = _OverlapMinimumDurationUnit.UnitOfMeasure

  association [1..1] to I_UnitOfMeasure               as _OverlapMinimumTransferQtyUnit on  $projection.OverlapMinimumTransferQtyUnit = _OverlapMinimumTransferQtyUnit.UnitOfMeasure

  -- Belongs to CAPP which is deprecated
  //  association [0..1] to I_StandardWorkQtyDetnType     as _StandardWorkQtyDetnType       on  $projection.standardworkqtydetntype = _StandardWorkQtyDetnType.StandardWorkQtyDetnType

  //                                                                                        and $projection.Plant                   = _StandardWorkQtyDetnType.Plant


  association [0..1] to I_LeadTimeReductionStrategy   as _LeadTimeReductionStrategy     on  $projection.LeadTimeReductionStrategy = _LeadTimeReductionStrategy.LeadTimeReductionStrategy
                                                                                        and $projection.Plant                     = _LeadTimeReductionStrategy.Plant

  association [0..1] to I_EmployeeWageGroup           as _EmployeeWageGroup             on  $projection.EmployeeWageGroup = _EmployeeWageGroup.EmployeeWageGroup
                                                                                        and $projection.Plant             = _EmployeeWageGroup.Plant
  association [0..1] to I_EmployeeSuitability         as _EmployeeSuitability           on  $projection.EmployeeSuitability = _EmployeeSuitability.EmployeeSuitability
                                                                                        and $projection.Plant               = _EmployeeSuitability.Plant
  association [0..1] to I_OperationSetupType          as _OperationSetupType            on  $projection.OperationSetupType = _OperationSetupType.OperationSetupType
                                                                                        and $projection.Plant              = _OperationSetupType.Plant
  association [0..1] to I_OperationSetupGroupCategory as _OperationSetupGroupCategory   on  $projection.OperationSetupGroupCategory = _OperationSetupGroupCategory.OperationSetupGroupCategory
                                                                                        and $projection.Plant                       = _OperationSetupGroupCategory.Plant
  association [0..1] to I_OperationSetupGroup         as _OperationSetupGroup           on  $projection.OperationSetupGroup         = _OperationSetupGroup.OperationSetupGroup
                                                                                        and $projection.OperationSetupGroupCategory = _OperationSetupGroup.OperationSetupGroupCategory
                                                                                        and $projection.Plant                       = _OperationSetupGroup.Plant
  association [0..1] to I_ControlRecipeDestination    as _ControlRecipeDestination      on  $projection.Plant                    = _ControlRecipeDestination.Plant
                                                                                        and $projection.ControlRecipeDestination = _ControlRecipeDestination.ControlRecipeDestination
  association [0..1] to I_Currency                    as _FreeDefinedAmount1Currency    on  $projection.FreeDefinedAmount1Currency = _FreeDefinedAmount1Currency.Currency
  association [0..1] to I_Currency                    as _FreeDefinedAmount2Currency    on  $projection.FreeDefinedAmount2Currency = _FreeDefinedAmount2Currency.Currency

  association [1..1] to I_FreeDfndTableFieldSemantic  as _FreeDfndTableFieldSemantic    on  $projection.FreeDefinedTableFieldSemantic = _FreeDfndTableFieldSemantic.FreeDefinedTableFieldSemantic

  association [1..1] to I_UnitOfMeasure               as _OperationStandardDurationUnit on  $projection.OperationStandardDurationUnit = _OperationStandardDurationUnit.UnitOfMeasure
  association [0..1] to I_MaintOperationSystCondition as _OperationSystemCondition      on  $projection.OperationSystemCondition = _OperationSystemCondition.OperationSystemCondition
  association [0..1] to I_Material                    as _Assembly                      on  $projection.Assembly = _Assembly.Material
  association [0..1] to I_OperationCalculationControl as _OperationCalculationControl   on  $projection.OperationCalculationControl = _OperationCalculationControl.OperationCalculationControl
  association [1..1] to I_UnitOfMeasure               as _PurchaseOrderQtyUnit          on  $projection.PurchaseOrderQuantityUnit = _PurchaseOrderQtyUnit.UnitOfMeasure
//  association [0..1] to I_FunctionalLocation          as _FunctionalLocation            on  $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation

  association [0..1] to I_Equipment                   as _Equipment                     on  $projection.Equipment = _Equipment.Equipment

  association [1..1] to I_UnitOfMeasure               as _MinimumDurationUnit           on  $projection.MinimumDurationUnit = _MinimumDurationUnit.UnitOfMeasure
  association [1..1] to I_CompanyCode                 as _CompanyCode                   on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1..1] to I_FactoryCalendar             as _FactoryCalendar               on  $projection.FactoryCalendar = _FactoryCalendar.FactoryCalendar
  association [0..1] to I_Language                    as _LongTextLanguage              on  $projection.LongTextLanguageCode = _LongTextLanguage.Language
  association [0..*] to I_RoutingCompAllocSrchMod     as _RtgCompAllocSrchMod           on  $projection.BillOfOperationsType = _RtgCompAllocSrchMod.BillOfOperationsType
                                                                                        and $projection.BillOfOperationsGroup = _RtgCompAllocSrchMod.BillOfOperationsGroup
  association [0..*] to I_RoutingPRTSearchModel       as _RoutingPrtSrchMod             on  $projection.BillOfOperationsType = _RoutingPrtSrchMod.BillOfOperationsType
                                                                                        and $projection.BillOfOperationsGroup = _RoutingPrtSrchMod.BillOfOperationsGroup
                                                                                        and _RoutingPrtSrchMod.ProductionResourceType = 'FH'
                                                                                        and $projection.IsDeleted = _RoutingPrtSrchMod.IsDeleted
{
      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key plnty                                                            as   BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key plnnr                                                            as   BillOfOperationsGroup,
      @ObjectModel.foreignKey.association: '_BOOOperationInternalID'
  key plnkn                                                            as   BOOOperationInternalID,
      @ObjectModel.text.element: [ 'OperationText']
  key zaehl                                                            as   BOOOpInternalVersionCounter,

      // NOT a key field in THIS view !

      versn                                                            as   BillOfOperationsVersion,

      // ***************** Technical fields not on the CEWB-UI *****************


      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_WorkCenterStdVH', element: 'WorkCenterInternalID' } } ]
      @ObjectModel.foreignKey.association: '_WorkCenter'
      arbid                                                            as   WorkCenterInternalID,
      @ObjectModel.foreignKey.association: '_WorkCenterType'
      case when objty = '  ' and arbid <> '00000000' then 'A '
      else objty end                                                   as   WorkCenterTypeCode,

      loekz                                                            as   IsDeleted,
      loekz_inherited                                                  as   IsImplicitlyDeleted,

      sumnr                                                            as   SuperiorOperationInternalID,

      // ************************** Operation Header ***************************


      oprid                                                            as   OperationExternalID,
      vornr                                                            as   Operation,

      // ************************** Operation General **************************


      -- Operation
      @Semantics.text: true
      ltxa1                                                            as   OperationText,

      @ObjectModel.foreignKey.association: '_LongTextLanguage'
      txtsp                                                            as   LongTextLanguageCode,

      @ObjectModel.foreignKey.association: '_Plant'
      werks                                                            as   Plant,

      @ObjectModel.foreignKey.association: '_OperationControlProfile'
      steus                                                            as   OperationControlProfile,

      @ObjectModel.foreignKey.association: '_OperationStandardText'
      ktsch                                                            as   OperationStandardTextCode,

      -- Origin
      vplty                                                            as   BillOfOperationsRefType,
      cast (vplnr as billofoperationsrefgroup preserving type)         as   BillOfOperationsRefGroup,
      cast (vplal as billofoperationsrefvariant preserving type)       as   BillOfOperationsRefVariant,

      -- Production Line
      cast (takt as linesegmenttakt preserving type)                   as   LineSegmentTakt,

      -- Transfer to Orders     (-> Suboperations)
      @ObjectModel.foreignKey.association: '_OperationStdWorkQtyGrpgCat'
      cast (verdart as operationstdworkqtygrpgcat preserving type)     as   OperationStdWorkQtyGrpgCat,
      uavo_aufl                                                        as   OrderHasNoSubOperations,

      // ************************** Processing Times ***************************


      -- Standard Values
      @Semantics.quantity.unitOfMeasure: 'OperationUnit'
      bmsch                                                            as   OperationReferenceQuantity,
      @ObjectModel.foreignKey.association: '_OperationUnit'
      meinh                                                            as   OperationUnit,

      umrez                                                            as   OpQtyToBaseQtyNmrtr,
      umren                                                            as   OpQtyToBaseQtyDnmntr,

      @Semantics.quantity.unitOfMeasure: 'FREEDEFINEDQUANTITY2UNIT' 
zmerh                                                            as   BillOfOperationsBreakDuration,
      @ObjectModel.foreignKey.association: '_BillOfOperationsBreakDurnUnit'
      zeier                                                            as   BillOfOperationsBreakDurnUnit,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1'
      vgw01                                                            as   StandardWorkQuantity1,
      @ObjectModel.foreignKey.association: '_StandardWorkQuantityUnit1'
      vge01                                                            as   StandardWorkQuantityUnit1,
      lar01                                                            as   CostCtrActivityType1,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio1'
      zgr01                                                            as   PerfEfficiencyRatioCode1,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2'
      vgw02                                                            as   StandardWorkQuantity2,
      @ObjectModel.foreignKey.association: '_StandardWorkQuantityUnit2'
      vge02                                                            as   StandardWorkQuantityUnit2,
      lar02                                                            as   CostCtrActivityType2,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio2'
      zgr02                                                            as   PerfEfficiencyRatioCode2,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3'
      vgw03                                                            as   StandardWorkQuantity3,
      @ObjectModel.foreignKey.association: '_StandardWorkQuantityUnit3'
      vge03                                                            as   StandardWorkQuantityUnit3,
      lar03                                                            as   CostCtrActivityType3,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio3'
      zgr03                                                            as   PerfEfficiencyRatioCode3,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4'
      vgw04                                                            as   StandardWorkQuantity4,
      @ObjectModel.foreignKey.association: '_StandardWorkQuantityUnit4'
      vge04                                                            as   StandardWorkQuantityUnit4,
      lar04                                                            as   CostCtrActivityType4,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio4'
      zgr04                                                            as   PerfEfficiencyRatioCode4,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5'
      vgw05                                                            as   StandardWorkQuantity5,
      @ObjectModel.foreignKey.association: '_StandardWorkQuantityUnit5'
      vge05                                                            as   StandardWorkQuantityUnit5,
      lar05                                                            as   CostCtrActivityType5,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio5'
      zgr05                                                            as   PerfEfficiencyRatioCode5,

      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6'
      vgw06                                                            as   StandardWorkQuantity6,
      @ObjectModel.foreignKey.association: '_StandardWorkQuantityUnit6'
      vge06                                                            as   StandardWorkQuantityUnit6,
      lar06                                                            as   CostCtrActivityType6,
      @ObjectModel.foreignKey.association: '_PerformanceEfficiencyRatio6'
      zgr06                                                            as   PerfEfficiencyRatioCode6,

      // The ControllingArea is not known at this point and thus a foreign key relation can't be provided (for performance reasons).

      // A higher level view needs to get the ControllingArea using P_BOOPlantControllingArea which then the consumption view

      // can use to establish a foreign key relation to I_BusinessProcess

      prz01                                                            as   BusinessProcess,

      -- (Start) Determination of Standard Values is used for CAPP which is deprecated
      //      @ObjectModel.foreignKey.association: '_StandardWorkQtyDetnType'

      //      cast (zerma as standardworkqtydetntype preserving type)          as   StandardWorkQtyDetnType,

      //      cast (zgdat as standardworkqtydetnyear preserving type)          as   StandardWorkQtyDetnYear,

      //      cast (zcode as standardworkqtyreferenceid preserving type)       as   StandardWorkQtyReferenceID,

      //      cast (zulnr as standardworkqtycalcbasisid preserving type)       as   StandardWorkQuantityCalcBasis,

      //      capoc                                                            as   CAPPCalculationType,

      //      flg_captxt                                                       as   HasCAPPText,

      -- (End) Determination of Standard Values

      // ************************ Interoperation Times *************************


      -- Interoperation Times
      @ObjectModel.foreignKey.association: '_LeadTimeReductionStrategy'
      rstra                                                            as   LeadTimeReductionStrategy,

      ablipkz                                                          as   TeardownAndWaitIsParallel,

      @Semantics.quantity.unitOfMeasure: 'MaximumWaitDurationUnit'
      zlmax                                                            as   MaximumWaitDuration,
      @ObjectModel.foreignKey.association: '_MaximumWaitDurationUnit'
      zeilm                                                            as   MaximumWaitDurationUnit,

      @Semantics.quantity.unitOfMeasure: 'MinimumWaitDurationUnit'
      zlpro                                                            as   MinimumWaitDuration,
      @ObjectModel.foreignKey.association: '_MinimumWaitDurationUnit'
      zeilp                                                            as   MinimumWaitDurationUnit,

      @Semantics.quantity.unitOfMeasure: 'StandardQueueDurationUnit'
      zwnor                                                            as   StandardQueueDuration,
      @ObjectModel.foreignKey.association: '_StandardQueueDurationUnit'
      zeiwn                                                            as   StandardQueueDurationUnit,

      @Semantics.quantity.unitOfMeasure: 'MinimumQueueDurationUnit'
      zwmin                                                            as   MinimumQueueDuration,
      @ObjectModel.foreignKey.association: '_MinimumQueueDurationUnit'
      zeiwm                                                            as   MinimumQueueDurationUnit,

      @Semantics.quantity.unitOfMeasure: 'StandardMoveDurationUnit'
      ztnor                                                            as   StandardMoveDuration,
      @ObjectModel.foreignKey.association: '_StandardMoveDurationUnit'
      zeitn                                                            as   StandardMoveDurationUnit,
      @Semantics.quantity.unitOfMeasure: 'MinimumMoveDurationUnit'
      ztmin                                                            as   MinimumMoveDuration,
      @ObjectModel.foreignKey.association: '_MinimumMoveDurationUnit'
      zeitm                                                            as   MinimumMoveDurationUnit,

      // **************************** Control Data *****************************


      --- Splitting
      spmus                                                            as   OperationSplitIsRequired,

      cast (splim as maximumnumberofsplits preserving type)            as   MaximumNumberOfSplits,

      @Semantics.quantity.unitOfMeasure: 'MinProcessingDurnPerSplitUnit'
      zminb                                                            as   MinProcessingDurationPerSplit,
      @ObjectModel.foreignKey.association: '_MinProcessingDurnPerSplitUnit'
      zeimb                                                            as   MinProcessingDurnPerSplitUnit,

      --- Overlapping
      cast (uemus as operationoverlappingisrequired preserving type)   as   OperationOverlappingIsRequired,
      cast (uekan as operationoverlappingispossible preserving type)   as   OperationOverlappingIsPossible,
      flies                                                            as   OperationsIsAlwaysOverlapping,

      @Semantics.quantity.unitOfMeasure: 'OverlapMinimumDurationUnit'
      zminu                                                            as   OverlapMinimumDuration,
      @ObjectModel.foreignKey.association: '_OverlapMinimumDurationUnit'
      zeimu                                                            as   OverlapMinimumDurationUnit,

      @Semantics.quantity.unitOfMeasure: 'OverlapMinimumTransferQtyUnit'
      minwe                                                            as   OverlapMinimumTransferQty,
      @ObjectModel.foreignKey.association: '_OverlapMinimumTransferQtyUnit'
      meinh                                                            as   OverlapMinimumTransferQtyUnit,

      // ********************* Additional Operation Data ***********************


      --- General Data
      aufak                                                            as   OperationScrapPercent,

      loanz                                                            as   NumberOfTimeTickets,
      rsanz                                                            as   NumberOfConfirmationSlips,

      @ObjectModel.foreignKey.association: '_EmployeeWageGroup'
      logrp                                                            as   EmployeeWageGroup,
      loart                                                            as   EmployeeWageType,

      @ObjectModel.foreignKey.association: '_EmployeeSuitability'
      qualf                                                            as   EmployeeSuitability,

      anzma                                                            as   NumberOfEmployees,

      @ObjectModel.foreignKey.association: '_OperationSetupType'
      rasch                                                            as   OperationSetupType,
      @ObjectModel.foreignKey.association: '_OperationSetupGroupCategory'
      rfgrp                                                            as   OperationSetupGroupCategory,
      @ObjectModel.foreignKey.association: '_OperationSetupGroup'
      rfsch                                                            as   OperationSetupGroup,

      cast (ckselkz as operationcostingrelevancytype preserving type)  as   OperationCostingRelevancyType,

      //visible only in CA02

      nvadd                                                            as   IsNonValueAddedOperation,

      // ************************ External Processing **************************


      -- External Processing
      frdlb                                                            as   OpIsExtlyProcdWithSubcontrg,

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchasingInfoRecordStdVH', element: 'PurchasingInfoRecord' } } ]
      @ObjectModel.foreignKey.association: '_PurchasingInfoRecord'
      infnr                                                            as   PurchasingInfoRecord,

      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      ekorg                                                            as   PurchasingOrganization,

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchaseContractStdVH', element: 'PurchaseContract' } } ]
      @ObjectModel.foreignKey.association: '_PurchaseContract'
      ebeln                                                            as   PurchaseContract,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PurchaseContractItemStdVH', element: 'PurchaseContractItem' } } ]
      @ObjectModel.foreignKey.association: '_PurchaseContractItem'
      ebelp                                                            as   PurchaseContractItem,

      sortl                                                            as   PurchasingInfoRecdAddlGrpgName,

      @ObjectModel.foreignKey.association: '_MaterialGroup'
      matkl                                                            as   MaterialGroup,

      @ObjectModel.foreignKey.association: '_PurchasingGroup'
      ekgrp                                                            as   PurchasingGroup,

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_Supplier_VH', element: 'Supplier' } } ]
      @ObjectModel.foreignKey.association: '_Supplier'
      lifnr                                                            as   Supplier,

      plifz                                                            as   PlannedDeliveryDuration,

      peinh                                                            as   NumberOfOperationPriceUnits,

      @Semantics.amount.currencyCode: 'OpExternalProcessingCurrency'
      preis                                                            as   OpExternalProcessingPrice,

      @ObjectModel.foreignKey.association: '_InspectionLotType'
      qpart                                                            as   InspectionLotType,
      // The ControllingArea is not known at this point and thus a foreign key relation can't be provided (for performance reasons).

      // A higher level view needs to get the ControllingArea using P_BOOPlantControllingArea which then the consumption view

      // can use to establish a foreign key relation to I_CostElement

      sakto                                                            as   CostElement,

      @ObjectModel.foreignKey.association: '_OpExternalProcessingCurrency'
      waers                                                            as   OpExternalProcessingCurrency,

      // ************************* Qualification Data **************************


      @ObjectModel.foreignKey.association: '_CapacityCategory'
      qlkapar                                                          as   CapacityCategoryCode,

      // ************************* Process Control Data **************************


      phflg                                                            as   BOOOperationIsPhase,
      pvzkn                                                            as   BOOPhaseSuperiorOpInternalID,
      @ObjectModel.foreignKey.association: '_ControlRecipeDestination'
      phseq                                                            as   ControlRecipeDestination,

      // ************************* Quality Management **************************


      -- Quality management: general
      @ObjectModel.foreignKey.association: '_InspResultRecordingView'
      erfsicht                                                         as   InspResultRecordingView,
      @Semantics.quantity.unitOfMeasure: 'MinimumDurationUnit'
      daumi                                                            as   MinimumDuration,
      @ObjectModel.foreignKey.association: '_MinimumDurationUnit'
      daume                                                            as   MinimumDurationUnit,
      prznt                                                            as   OperationWorkPercent,
      vertl                                                            as   CapRqmtsDistributionFunction,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      bukrs                                                            as   CompanyCode,
      @ObjectModel.foreignKey.association: '_FactoryCalendar'
      kalid                                                            as   FactoryCalendar,
      vertn                                                            as   CapacityRequirementDistrKey,

      -- Quality management: inspection points
      qppktabs                                                         as   InspSbstCompletionConfirmation,
      qkzprfrei                                                        as   InspSbstHasNoTimeOrQuantity,

      @Semantics.quantity.unitOfMeasure: 'OperationStandardDurationUnit'
      plpo.dauno                                                       as   OperationStandardDuration,
      @ObjectModel.foreignKey.association: '_OperationStandardDurationUnit'
      plpo.daune                                                       as   OperationStandardDurationUnit,
      plpo.anzzl                                                       as   NumberOfCapacities,
      @ObjectModel.foreignKey.association: '_OperationSystemCondition'
      plpo.anlzu                                                       as   OperationSystemCondition,
      plpo.larnt                                                       as   CostCtrActivityType,
      @ObjectModel.foreignKey.association: '_OperationCalculationControl'
      plpo.indet                                                       as   OperationCalculationControl,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_MaterialStdVH', element: 'Material' } } ]
      @ObjectModel.foreignKey.association: '_Assembly'
      plpo.istru                                                       as   Assembly,
      @Semantics.quantity.unitOfMeasure: 'PurchaseOrderQuantityUnit'
      plpo.bmvrg                                                       as   PurchaseOrderQty,
      @ObjectModel.foreignKey.association: '_PurchaseOrderQtyUnit'
      plpo.bmeih                                                       as   PurchaseOrderQuantityUnit,
      plpo.esokz                                                       as   PurchasingInfoRecordCategory,
//      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_FunctionalLocationStdVH', element: 'FunctionalLocation' } } ]

//      @ObjectModel.foreignKey.association: '_FunctionalLocation'

//      plpo.tplnr                                                       as   FunctionalLocation,

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_EquipmentStdVH', element: 'Equipment' } } ]
//      @ObjectModel.foreignKey.association: '_Equipment'

      plpo.equnr                                                       as   Equipment,

      // ***************************** User Fields *****************************

      @ObjectModel.foreignKey.association: '_FreeDfndTableFieldSemantic'
      slwid                                                            as   FreeDefinedTableFieldSemantic,
      usr00                                                            as   FreeDefinedAttribute01,
      usr01                                                            as   FreeDefinedAttribute02,
      usr02                                                            as   FreeDefinedAttribute03,
      usr03                                                            as   FreeDefinedAttribute04,
      @Semantics.quantity.unitOfMeasure: 'FreeDefinedQuantity1Unit'
      usr04                                                            as   FreeDefinedQuantity1,
      use04                                                            as   FreeDefinedQuantity1Unit,
      @Semantics.quantity.unitOfMeasure: 'FreeDefinedQuantity2Unit'
      usr05                                                            as   FreeDefinedQuantity2,
      use05                                                            as   FreeDefinedQuantity2Unit,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount1Currency'
      usr06                                                            as   FreeDefinedAmount1,
      @ObjectModel.foreignKey.association: '_FreeDefinedAmount1Currency'
      use06                                                            as   FreeDefinedAmount1Currency,
      @Semantics.amount.currencyCode: 'FreeDefinedAmount2Currency'
      usr07                                                            as   FreeDefinedAmount2,
      @ObjectModel.foreignKey.association: '_FreeDefinedAmount2Currency'
      use07                                                            as   FreeDefinedAmount2Currency,
      usr08                                                            as   FreeDefinedDate1,
      usr09                                                            as   FreeDefinedDate2,
      usr10                                                            as   FreeDefinedIndicator1,
      usr11                                                            as   FreeDefinedIndicator2,

      // *************************** Administration ****************************


      -- Administrative Data
      @Semantics.systemDate.createdAt: true
      andat                                                            as   CreationDate,
      @Semantics.user.createdBy: true
      cast (annam as vdm_createdbyuserid preserving type)              as   CreatedByUser,

      @Semantics.systemDate.lastChangedAt: true
      aedat                                                            as   LastChangeDate,
      @Semantics.user.lastChangedBy: true
      cast (aenam as vdm_lastchangedbyuserid preserving type)          as   LastChangedByUser,

      -- Validity
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_ChangeMasterStdVH', element: 'ChangeNumber' } } ]
      @ObjectModel.foreignKey.association: '_ChangeMaster'
      cast (aennr as changenumber preserving type)                     as   ChangeNumber,
      @Semantics.businessDate.from: true
      cast(datuv as pph_begda preserving type)                         as   ValidityStartDate,
      @Semantics.businessDate.to: true
      cast(valid_to as pph_endda preserving type)                      as   ValidityEndDate,

      // ******************* Fields of other task list types *******************


      @Semantics.quantity.unitOfMeasure: 'FREEDEFINEDQUANTITY2UNIT' 
arbei                                                            as   OpPlannedWorkQuantity,
      arbeh                                                            as   OpWorkQuantityUnit,

      // **************************** Associations *****************************


      _Assembly,
      _BOOOperationInternalID,
      _BillOfOperationsBreakDurnUnit,
      _BillOfOperationsGroup,
      _BillOfOperationsType,
      _CapacityCategory,
      _ChangeMaster,
      _CompanyCode,
      _ControlRecipeDestination,
      _EmployeeSuitability,
      _EmployeeWageGroup,
      _Equipment,
      _FactoryCalendar,
      _FreeDefinedAmount1Currency,
      _FreeDefinedAmount2Currency,
      _FreeDfndTableFieldSemantic,
//      _FunctionalLocation,

      _InspResultRecordingView,
      _InspectionLotType,
      _LeadTimeReductionStrategy,
      _LongTextLanguage,
      _MaterialGroup,
      _MaximumWaitDurationUnit,
      _MinimumDurationUnit,
      _MinimumMoveDurationUnit,
      _MinimumQueueDurationUnit,
      _MinimumWaitDurationUnit,
      _MinProcessingDurnPerSplitUnit,
      _OpExternalProcessingCurrency,
      _OperationCalculationControl,
      _OperationControlProfile,
      _OperationSetupGroup,
      _OperationSetupGroupCategory,
      _OperationSetupType,
      _OperationStandardDurationUnit,
      _OperationStandardText,
      _OperationStdWorkQtyGrpgCat,
      _OperationSystemCondition,
      _OperationUnit,
      _OverlapMinimumDurationUnit,
      _OverlapMinimumTransferQtyUnit,
      _PerformanceEfficiencyRatio1,
      _PerformanceEfficiencyRatio2,
      _PerformanceEfficiencyRatio3,
      _PerformanceEfficiencyRatio4,
      _PerformanceEfficiencyRatio5,
      _PerformanceEfficiencyRatio6,
      _Plant,
      _PurchaseContract,
      _PurchaseContractItem,
      _PurchaseOrderQtyUnit,
      _PurchasingGroup,
      _PurchasingInfoRecord,
      _PurchasingOrganization,
      _StandardMoveDurationUnit,
      _StandardQueueDurationUnit,
      _StandardWorkQuantityUnit1,
      _StandardWorkQuantityUnit2,
      _StandardWorkQuantityUnit3,
      _StandardWorkQuantityUnit4,
      _StandardWorkQuantityUnit5,
      _StandardWorkQuantityUnit6,
      _Supplier,
      _WorkCenter,
      _WorkCenterType,
      _RtgCompAllocSrchMod,
      _RoutingPrtSrchMod
}
where loekz is initial;