P_MfgOrderOpAdaptedDatesBasic

@AbapCatalog.sqlViewName: 'PORDOPERADPTDTS'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
// Unit Tests defined in class TCL_P_PROCGEXECOPERATIONACTIVI

define view P_MfgOrderOpAdaptedDatesBasic
  as select from I_OrderOperation
{
      //I_OrderOperation

  key OrderInternalID,
  key OrderOperationInternalID,
      Sequence,
      Operation,
      BillOfOperationsSequence,
      BillOfOperationsType,
      BillOfOperationsGroup,
      BillOfOperationsVariant,
      BOOOperationInternalID,
      BillOfOperationsVersion,
      BillOfMaterialCategory,
      BillOfMaterialInternalID,
      BillOfMaterialItemNodeNumber,
      BOMItemNodeCount,
      SuperiorOperationInternalID,
      OperationControlProfile,
      WorkCenterInternalID,
      WorkCenterTypeCode_2 as WorkCenterTypeCode,
      Plant,
      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,
--    OpExternalProcessingPriceUnit,
      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,
      OpErlstSchedldExecStrtDte,
      OpErlstSchedldExecStrtTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpErlstSchedldExecStrtTme = '240000' then DATS_ADD_DAYS(OpErlstSchedldExecStrtDte, 1, 'UNCHANGED')
        else OpErlstSchedldExecStrtDte
      end as pph_fsavd preserving type) as OpErlstSchedldExecStrtDte2,
      cast(case
        when OpErlstSchedldExecStrtTme = '240000' then '000000'
        else OpErlstSchedldExecStrtTme
      end as pph_fsavz preserving type) as OpErlstSchedldExecStrtTme2,
      OpErlstSchedldProcgStrtDte,
      OpErlstSchedldProcgStrtTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpErlstSchedldProcgStrtTme = '240000' then DATS_ADD_DAYS(OpErlstSchedldProcgStrtDte, 1, 'UNCHANGED')
        else OpErlstSchedldProcgStrtDte
      end as pph_fssbd preserving type) as OpErlstSchedldProcgStrtDte2,
      cast(case
        when OpErlstSchedldProcgStrtTme = '240000' then '000000'
        else OpErlstSchedldProcgStrtTme
      end as pph_fssbz preserving type) as OpErlstSchedldProcgStrtTme2,
      OpErlstSchedldTrdwnStrtDte,
      OpErlstSchedldTrdwnStrtTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpErlstSchedldTrdwnStrtTme = '240000' then DATS_ADD_DAYS(OpErlstSchedldTrdwnStrtDte, 1, 'UNCHANGED')
        else OpErlstSchedldTrdwnStrtDte
      end as pph_fssad preserving type) as OpErlstSchedldTrdwnStrtDte2,
      cast(case
        when OpErlstSchedldTrdwnStrtTme = '240000' then '000000'
        else OpErlstSchedldTrdwnStrtTme
      end as pph_fssaz preserving type) as OpErlstSchedldTrdwnStrtTme2,
      OpErlstSchedldExecEndDte,
      OpErlstSchedldExecEndTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpErlstSchedldExecEndTme = '240000' then DATS_ADD_DAYS(OpErlstSchedldExecEndDte, 1, 'UNCHANGED')
        else OpErlstSchedldExecEndDte
      end as pph_fsedd preserving type) as OpErlstSchedldExecEndDte2,
      cast(case
        when OpErlstSchedldExecEndTme = '240000' then '000000'
        else OpErlstSchedldExecEndTme
      end as pph_fsedz preserving type) as OpErlstSchedldExecEndTme2,
      OpLtstSchedldExecStrtDte,
      OpLtstSchedldExecStrtTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpLtstSchedldExecStrtTme = '240000' then DATS_ADD_DAYS(OpLtstSchedldExecStrtDte, 1, 'UNCHANGED')
        else OpLtstSchedldExecStrtDte
      end as pph_ssavd preserving type) as OpLtstSchedldExecStrtDte2,
      cast(case
        when OpLtstSchedldExecStrtTme = '240000' then '000000'
        else OpLtstSchedldExecStrtTme
      end as pph_ssavz preserving type) as OpLtstSchedldExecStrtTme2,
      OpLtstSchedldProcgStrtDte,
      OpLtstSchedldProcgStrtTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpLtstSchedldProcgStrtTme = '240000' then DATS_ADD_DAYS(OpLtstSchedldProcgStrtDte, 1, 'UNCHANGED')
        else OpLtstSchedldProcgStrtDte
      end as pph_sssbd preserving type) as OpLtstSchedldProcgStrtDte2,
      cast(case
        when OpLtstSchedldProcgStrtTme = '240000' then '000000'
        else OpLtstSchedldProcgStrtTme
      end as pph_sssbz preserving type) as OpLtstSchedldProcgStrtTme2,
      OpLtstSchedldTrdwnStrtDte,
      OpLtstSchedldTrdwnStrtTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpLtstSchedldTrdwnStrtTme = '240000' then DATS_ADD_DAYS(OpLtstSchedldTrdwnStrtDte, 1, 'UNCHANGED')
        else OpLtstSchedldTrdwnStrtDte
      end as pph_sssad preserving type) as OpLtstSchedldTrdwnStrtDte2,
      cast(case
        when OpLtstSchedldTrdwnStrtTme = '240000' then '000000'
        else OpLtstSchedldTrdwnStrtTme
      end as pph_sssaz preserving type) as OpLtstSchedldTrdwnStrtTme2,
      OpLtstSchedldExecEndDte,
      OpLtstSchedldExecEndTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpLtstSchedldExecEndTme = '240000' then DATS_ADD_DAYS(OpLtstSchedldExecEndDte, 1, 'UNCHANGED')
        else OpLtstSchedldExecEndDte
      end as pph_ssedd preserving type) as OpLtstSchedldExecEndDte2,
      cast(case
        when OpLtstSchedldExecEndTme = '240000' then '000000'
        else OpLtstSchedldExecEndTme
      end as pph_ssedz preserving type) as OpLtstSchedldExecEndTme2,
      OperationConfirmedStartDate,
      OperationConfirmedEndDate,
      OpActualExecutionStartDate,
      OpActualExecutionStartTime,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpActualExecutionStartTime = '240000' then DATS_ADD_DAYS(OpActualExecutionStartDate, 1, 'UNCHANGED')
        else OpActualExecutionStartDate
      end as isdd preserving type)      as OpActualExecutionStartDate2,
      cast(case
        when OpActualExecutionStartTime = '240000' then '000000'
        else OpActualExecutionStartTime
      end as isdz preserving type)      as OpActualExecutionStartTime2,
      OpActualSetupEndDate,
      OpActualSetupEndTime,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpActualSetupEndTime = '240000' then DATS_ADD_DAYS(OpActualSetupEndDate, 1, 'UNCHANGED')
        else OpActualSetupEndDate
      end as ierd preserving type)      as OpActualSetupEndDate2,
      cast(case
        when OpActualSetupEndTime = '240000' then '000000'
        else OpActualSetupEndTime
      end as ierz preserving type)      as OpActualSetupEndTime2,
      OpActualProcessingStartDate,
      OpActualProcessingStartTime,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpActualProcessingStartTime = '240000' then DATS_ADD_DAYS(OpActualProcessingStartDate, 1, 'UNCHANGED')
        else OpActualProcessingStartDate
      end as isbd preserving type)      as OpActualProcessingStartDate2,
      cast(case
        when OpActualProcessingStartTime = '240000' then '000000'
        else OpActualProcessingStartTime
      end as isbz preserving type)      as OpActualProcessingStartTime2,
      OpActualProcessingEndDate,
      OpActualProcessingEndTime,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpActualProcessingEndTime = '240000' then DATS_ADD_DAYS(OpActualProcessingEndDate, 1, 'UNCHANGED')
        else OpActualProcessingEndDate
      end as iebd preserving type)      as OpActualProcessingEndDate2,
      cast(case
        when OpActualProcessingEndTime = '240000' then '000000'
        else OpActualProcessingEndTime
      end as iebz preserving type)      as OpActualProcessingEndTime2,
      OpActualTeardownStartDate,
      OpActualTeardownStartTme,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpActualTeardownStartTme = '240000' then DATS_ADD_DAYS(OpActualTeardownStartDate, 1, 'UNCHANGED')
        else OpActualTeardownStartDate
      end as isad preserving type)      as OpActualTeardownStartDate2,
      cast(case
        when OpActualTeardownStartTme = '240000' then '000000'
        else OpActualTeardownStartTme
      end as isaz preserving type)      as OpActualTeardownStartTme2,
      OpActualExecutionEndDate,
      OpActualExecutionEndTime,
      @Semantics.calendarItem.dtStart: true
      cast(case
        when OpActualExecutionEndTime = '240000' then DATS_ADD_DAYS(OpActualExecutionEndDate, 1, 'UNCHANGED')
        else OpActualExecutionEndDate
      end as iedd preserving type)      as OpActualExecutionEndDate2,
      cast(case
        when OpActualExecutionEndTime = '240000' then '000000'
        else OpActualExecutionEndTime
      end as iedz preserving type)      as OpActualExecutionEndTime2,
      ActualForecastEndDate,
      ActualForecastEndTime,
      SchedldFcstdEarliestStartDate,
      SchedldFcstdEarliestStartTime,
      SchedldFcstdEarliestEndDate,
      SchedldFcstdEarliestEndTime,
      LatestSchedldFcstdStartDate,
      SchedldFcstdLatestStartTime,
      LatestSchedldFcstdEndDate,
      SchedldFcstdLatestEndTime,
      ConstraintDateForBscStartDate,
      ConstraintTimeForBscStartTime,
      ForecastedStartDate,
      ForecastedStartTime,
      ForecastedEndDate,
      ForecastedEndTime,
      ForecastProcessingDurationUnit,
      ForecastProcessingDuration,
      OpDispatchedExecStartDate,
      OpDispatchedExecStartTime,
      OpDispatchedExecEndDate,
      OpDispatchedExecEndTime,
--    BasicDatesFreeFloat,
--    TotalFloatForBasicDates,
--    TotalFloatForForecastedDates,
--    ForecastedDatesFreeFloat,
      StartDateOffsetReferenceCode,
      StartDateOffsetDurationUnit,
      StartDateOffsetDuration,
      EndDateOffsetReferenceCode,
      EndDateOffsetDuration,
      EndDateOffsetDurationUnit,
      FreeDefinedTableFieldSemantic,
      FreeDefinedAttribute01,
      FreeDefinedAttribute02,
      FreeDefinedAttribute03,
      FreeDefinedAttribute04,
      FreeDefinedQuantity1,
      FreeDefinedQuantity2,
      FreeDefinedAmount1,
      FreeDefinedAmount2,
      FreeDefinedDate1,
      FreeDefinedDate2,
      FreeDefinedIndicator1,
      FreeDefinedIndicator2,
      SetupOpActyNtwkInstance,
      ProduceOpActyNtwkInstance,
      TeardownOpActyNtwkInstance,
      /* Associations */
      //I_OrderOperation

      _OrderInternalID,
      _WorkCenter,
      _WorkCenterType
}