I_ORDEROPERATIONDATETIME

@AbapCatalog.sqlViewName: 'IORDOPTSTMPS'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Order Operation Date and Time as Timestamp'
define view I_OrderOperationDateTime
  as select from P_MfgOrderOpAdaptedDatesBasic
  association [1..1] to I_Plant as _Plant on $projection.Plant = _Plant.Plant
{
      //P_MfgOrderOpAdaptedDatesBasic

  key OrderInternalID,
  key OrderOperationInternalID,
      Sequence,
      Operation,
      BillOfOperationsSequence,
      BillOfOperationsType,
      BillOfOperationsGroup,
      BillOfOperationsVariant,
      BOOOperationInternalID,
      BillOfOperationsVersion,
      BillOfMaterialCategory,
      BillOfMaterialInternalID,
      BillOfMaterialItemNodeNumber,
      BOMItemNodeCount,
      SuperiorOperationInternalID,
      OperationControlProfile,
      WorkCenterInternalID,
      WorkCenterTypeCode,
      Plant,
      _Plant.PlantName,
      FactoryCalendar,
      CapacityRequirement,
      CapacityRequirementItem,
      ActualNumberOfSplits,
      NumberOfCapacities,
      OperationIsToBeDeleted,
      NetworkActivityPriority,
      OperationImportance,
      OperationWorkPercent,
      UsageCode,
      Assembly,
      ProjectInternalID,
      ObjectInternalID,
      OperationConfirmation,
      NumberOfOperationConfirmations,
      NumberOfOperationExecutions,
      OperationSystemCondition,
      ChangeNumber,
      StandardTextInternalID,
      OperationText,
      Language,
      NumberOfTimeTickets,
      EmployeeWageType,
      EmployeeWageGroup,
      NumberOfConfirmationSlips,
      EmployeeSuitability,
      Personnel,
      NumberOfEmployees,
      OperationSetupGroupCategory,
      OperationSetupGroup,
      OperationSetupType,
      OperationScrapPercent,
      OperationOverlappingIsRequired,
      OperationOverlappingIsPossible,
      OperationsIsAlwaysOverlapping,
      OperationSplitIsRequired,
      MaximumNumberOfSplits,
      LeadTimeReductionStrategy,
      OverheadCode,
      OperationPurgInfoRecdSearchTxt,
      ExtProcgOperationHasSubcontrg,
      Supplier,
      OpExternalProcessingPrice,
      Currency,
      PurgInfoRecdDataIsFixed,
      PurchasingInfoRecord,
      PurchasingInfoRecordCategory,
      PurchasingOrganization,
      PurchasingGroup,
      PurchaseRequisition,
      PurchaseRequisitionItem,
      PurchasingDocument,
      PurchasingDocumentItem,
      MaterialGroup,
      GoodsRecipientName,
      UnloadingPointName,
      CompanyCode,
      BusinessArea,
      ProfitCenter,
      CostElement,
      CostingVariant,
      CostEstimate,
      CostingSheet,
      RequestingCostCenter,
      OperationCalculationControl,
      OperationCostingRelevancyType,
      NetworkActivityCost,
      NtwkAccountAssignmentCode,
      ActyIsTakenAcctForProjSmmry,
      ControllingObjectCurrency,
      ControllingObjectClass,
      TaxJurisdiction,
      FunctionalArea,
      BusinessProcess,
      BusinessProcessConfirmedQty,
      BusinessProcessEntryUnit,
      NoFurtherBusinessProcQtyIsExpd,
      BusinessProcessRemainingQty,
      BusinessProcRemainingQtyUnit,
      CostCtrActivityType1,
      CostCtrActivityType2,
      CostCtrActivityType3,
      CostCtrActivityType4,
      CostCtrActivityType5,
      CostCtrActivityType6,
      CostCtrActivityType,
      NoFurtherOpWorkQuantity1IsExpd,
      NoFurtherOpWorkQuantity2IsExpd,
      NoFurtherOpWorkQuantity3IsExpd,
      NoFurtherOpWorkQuantity4IsExpd,
      NoFurtherOpWorkQuantity5IsExpd,
      NoFurtherOpWorkQuantity6IsExpd,
      NoFurtherWorkQuantityIsExpd,
      WorkCenterStandardWorkQty1,
      WorkCenterStandardWorkQty2,
      WorkCenterStandardWorkQty3,
      WorkCenterStandardWorkQty4,
      WorkCenterStandardWorkQty5,
      WorkCenterStandardWorkQty6,
      OpPlannedWorkQuantity,
      WorkCenterStandardWorkQtyUnit1,
      WorkCenterStandardWorkQtyUnit2,
      WorkCenterStandardWorkQtyUnit3,
      WorkCenterStandardWorkQtyUnit4,
      WorkCenterStandardWorkQtyUnit5,
      WorkCenterStandardWorkQtyUnit6,
      OpWorkQuantityUnit1,
      OpWorkQuantityUnit2,
      OpWorkQuantityUnit3,
      OpWorkQuantityUnit4,
      OpWorkQuantityUnit5,
      OpWorkQuantityUnit6,
      OpWorkQuantityUnit,
      OpConfirmedWorkQuantity1,
      OpConfirmedWorkQuantity2,
      OpConfirmedWorkQuantity3,
      OpConfirmedWorkQuantity4,
      OpConfirmedWorkQuantity5,
      OpConfirmedWorkQuantity6,
      ActualWorkQuantity,
      ForecastWorkQuantity1,
      ForecastWorkQuantity2,
      ForecastWorkQuantity3,
      ForecastWorkQuantity4,
      ForecastWorkQuantity5,
      ForecastWorkQuantity6,
      ForecastWorkQuantity,
      OrderIntBillOfOpItemOfPhase,
      MfgOrderOperationIsPhase,
      ControlRecipeDestination,
      DependencyObjectNumber,
      LineHierarchyInternalID,
      OpSchedldReductionLevel,
      InspectionSubSystem,
      ServicePackage,
      MaterialPlanningRelevance,
      ProductConfiguration,
      ProgressAnlysAggregationWeight,
      OperationRequisitionerName,
      OperationTrackingNumber,
      InspectionLotType,
      ExchangeRate,
      BillingPlan,
      ReferencePoint,
      OperationUnit,
      OperationReferenceQuantity,
      OpQtyToBaseQtyDnmntr,
      OpQtyToBaseQtyNmrtr,
      OpPlannedTotalQuantity,
      OpPlannedScrapQuantity,
      OpTotalConfirmedYieldQty,
      OpTotalConfirmedScrapQty,
      OperationConfirmedReworkQty,
      OpTotConfdYieldQtyInOrdQtyUnit,
      BreakDurationUnit,
      PlannedBreakDuration,
      ConfirmedBreakDuration,
      OverlapMinimumDurationUnit,
      OverlapMinimumDuration,
      MaximumWaitDurationUnit,
      MaximumWaitDuration,
      MinimumWaitDurationUnit,
      MinimumWaitDuration,
      StandardMoveDurationUnit,
      StandardMoveDuration,
      StandardQueueDurationUnit,
      StandardQueueDuration,
      MinimumQueueDurationUnit,
      MinimumQueueDuration,
      MinimumMoveDurationUnit,
      MinimumMoveDuration,
      OperationStandardDuration,
      OperationStandardDurationUnit,
      MinimumDuration,
      MinimumDurationUnit,
      ScheduledMoveDuration,
      ScheduledMoveDurationUnit,
      ScheduledQueueDuration,
      ScheduledQueueDurationUnit,
      ScheduledWaitDuration,
      ScheduledWaitDurationUnit,
      PlannedDeliveryDuration,
      OpPlannedSetupDurn,
      OpPlannedSetupDurnUnit,
      OpPlannedProcessingDurn,
      OpPlannedProcessingDurnUnit,
      OpPlannedTeardownDurn,
      OpPlannedTeardownDurnUnit,
      ActyBscStartDateConstraintType,
      ActyBscEndDateConstraintType,
      ActyFcstEndDateConstraintType,
      ActyFcstStartDteConstraintType,
      ActualForecastDuration,
      ActualForecastDurationUnit,
      ForecastedStandardDuration,
      FcstdStandardDurationUnit,
      ForecastedMinimumDuration,
      ForecastedMinimumDurationUnit,
      @Semantics.timeZone: true
      _Plant._Address.AddressTimeZone                                                                                                                                          as PlantTimeZone,
      OpErlstSchedldExecStrtDte,
      OpErlstSchedldExecStrtTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpErlstSchedldExecStrtDte2, OpErlstSchedldExecStrtTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as fsavdz preserving type)    as OpErlstSchedldExecStrtDteTme,
      OpErlstSchedldProcgStrtDte,
      OpErlstSchedldProcgStrtTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpErlstSchedldProcgStrtDte2, OpErlstSchedldProcgStrtTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as fssbdz preserving type)  as OpErlstSchedldProcgStrtDteTme,
      OpErlstSchedldTrdwnStrtDte,
      OpErlstSchedldTrdwnStrtTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpErlstSchedldTrdwnStrtDte2, OpErlstSchedldTrdwnStrtTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as fssadz preserving type)  as OpErlstSchedldTrdwnStrtDteTme,
      OpErlstSchedldExecEndDte,
      OpErlstSchedldExecEndTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpErlstSchedldExecEndDte2, OpErlstSchedldExecEndTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as fseddz preserving type)      as OpErlstSchedldExecEndDteTme,
      OpLtstSchedldExecStrtDte,
      OpLtstSchedldExecStrtTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpLtstSchedldExecStrtDte2, OpLtstSchedldExecStrtTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as ssavdz preserving type)      as OpLtstSchedldExecStrtDteTme,
      OpLtstSchedldProcgStrtDte,
      OpLtstSchedldProcgStrtTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpLtstSchedldProcgStrtDte2, OpLtstSchedldProcgStrtTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as sssbdz preserving type)    as OpLtstSchedldProcgStrtDteTme,
      OpLtstSchedldTrdwnStrtDte,
      OpLtstSchedldTrdwnStrtTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpLtstSchedldTrdwnStrtDte2, OpLtstSchedldTrdwnStrtTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as sssadz preserving type)    as OpLtstSchedldTrdwnStrtDteTme,
      OpLtstSchedldExecEndDte,
      OpLtstSchedldExecEndTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpLtstSchedldExecEndDte2, OpLtstSchedldExecEndTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as sseddz preserving type)        as OpLtstSchedldExecEndDteTme,
      OperationConfirmedStartDate,
      OperationConfirmedEndDate,
      OpActualExecutionStartDate,
      OpActualExecutionStartTime,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpActualExecutionStartDate2, OpActualExecutionStartTime2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as isddz preserving type)   as OpActualExecutionStartDateTime,
      OpActualSetupEndDate,
      OpActualSetupEndTime,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpActualSetupEndDate2, OpActualSetupEndTime2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as ierdz preserving type)               as OpActualSetupEndDateTime,
      OpActualProcessingStartDate,
      OpActualProcessingStartTime,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpActualProcessingStartDate2, OpActualProcessingStartTime2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as isbdz preserving type) as OpActualProcessingStartDteTme,
      OpActualProcessingEndDate,
      OpActualProcessingEndTime,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpActualProcessingEndDate2, OpActualProcessingEndTime2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as iebdz preserving type)     as OpActualProcessingEndDateTime,
      OpActualTeardownStartDate,
      OpActualTeardownStartTme,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpActualTeardownStartDate2, OpActualTeardownStartTme2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as isadz preserving type)      as OpActualTeardownStartDateTime,
      OpActualExecutionEndDate,
      OpActualExecutionEndTime,
      @Semantics.timeZoneReference: 'PlantTimeZone'
      cast( dats_tims_to_tstmp(OpActualExecutionEndDate2, OpActualExecutionEndTime2, _Plant._Address.AddressTimeZone, $session.client, 'NULL') as ieddz preserving type)       as OpActualExecutionEndDateTime,
      ActualForecastEndDate,
      ActualForecastEndTime,
      SchedldFcstdEarliestStartDate,
      SchedldFcstdEarliestStartTime,
      SchedldFcstdEarliestEndDate,
      SchedldFcstdEarliestEndTime,
      LatestSchedldFcstdStartDate,
      SchedldFcstdLatestStartTime,
      LatestSchedldFcstdEndDate,
      SchedldFcstdLatestEndTime,
      ConstraintDateForBscStartDate,
      ConstraintTimeForBscStartTime,
      ForecastedStartDate,
      ForecastedStartTime,
      ForecastedEndDate,
      ForecastedEndTime,
      ForecastProcessingDurationUnit,
      ForecastProcessingDuration,
      OpDispatchedExecStartDate,
      OpDispatchedExecStartTime,
      OpDispatchedExecEndDate,
      OpDispatchedExecEndTime,
      StartDateOffsetReferenceCode,
      StartDateOffsetDurationUnit,
      StartDateOffsetDuration,
      EndDateOffsetReferenceCode,
      EndDateOffsetDuration,
      EndDateOffsetDurationUnit,
      FreeDefinedTableFieldSemantic,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      FreeDefinedQuantity1,
      FreeDefinedQuantity2,
      FreeDefinedAmount1,
      FreeDefinedAmount2,
      FreeDefinedDate1,
      FreeDefinedDate2,
      FreeDefinedIndicator1,
      FreeDefinedIndicator2,
      SetupOpActyNtwkInstance,
      ProduceOpActyNtwkInstance,
      TeardownOpActyNtwkInstance,
      /* Associations */
      //P_MfgOrderOpAdaptedDatesBasic

      _OrderInternalID,
      _WorkCenter,
      _WorkCenterType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_PLANT",
"P_MFGORDEROPADAPTEDDATESBASIC"
],
"ASSOCIATED":
[
"I_ORDERINTERNALID",
"I_PLANT",
"I_WORKCENTER",
"I_WORKCENTERTYPE"
],
"BASE":
[
"P_MFGORDEROPADAPTEDDATESBASIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/