P_MFGORDEROPERATIONDELAY

@AbapCatalog.sqlViewName: 'PMFGORERDOPDELAY'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@VDM.private: true

define view P_MfgOrderOperationDelay
  as select from I_MfgOrderOperation as afvg

{
      // Technical Key

  key afvg.OrderInternalBillOfOperations,
  key afvg.OrderIntBillOfOperationsItem,

      // Semantical key

      afvg.ManufacturingOrder,
      afvg.ManufacturingOrderSequence,
      afvg.ManufacturingOrderOperation,
      afvg.ManufacturingOrderSubOperation,
      afvg.MfgOrderOperationOrSubOp,

      // Order header data

      afvg.ManufacturingOrderCategory,
      afvg.ManufacturingOrderType,
      afvg.ProductionSupervisor,
      afvg.MRPController,
      afvg.ResponsiblePlannerGroup,
      afvg.ProductConfiguration,
      afvg.ManufacturingOrderImportance,
      afvg.InspectionLot,

      // Text

      afvg.MfgOrderOperationText,
      afvg.Language,
      afvg.OperationStandardTextCode,
      afvg.OperationHasLongText,

      // Attributes

      afvg.OperationIsToBeDeleted,
      afvg.MfgOrderOperationIsPhase,
      afvg.MfgOrderPhaseSuperiorOperation,
      afvg.NumberOfCapacities,
      afvg.NumberOfConfirmationSlips,
      afvg.OperationImportance,

      // Assignments

      afvg.SuperiorOperationInternalID,
      afvg.ProductionPlant,
      afvg.WorkCenterInternalID,

      afvg.WorkCenterTypeCode,   // CHAR1

      afvg.WorkCenterTypeCode_2, // CHAR2

      afvg.OperationControlProfile,
      afvg.ControlRecipeDestination,
      afvg.OperationConfirmation,
      afvg.NumberOfOperationConfirmations,
      afvg.FactoryCalendar,
      afvg.CapacityRequirement,
      afvg.CapacityRequirementItem,
      afvg.ChangeNumber,
      afvg.ManufacturingObject,

      // Assignments BOO and BOM

      afvg.BillOfOperationsType,
      afvg.BillOfOperationsGroup,
      afvg.BillOfOperationsVariant,
      afvg.BillOfOperationsSequence,
      afvg.BOOOperationInternalID,
      afvg.BillOfOperationsVersion,
      afvg.BillOfMaterialCategory,
      afvg.BillOfMaterialInternalID,
      afvg.BillOfMaterialItemNodeNumber,
      afvg.BOMItemNodeCount,

      // Assignments Purchasing

      afvg.ExtProcgOperationHasSubcontrg,
      afvg.PurchasingOrganization,
      afvg.PurchasingGroup,
      afvg.PurchaseRequisition,
      afvg.PurchaseRequisitionItem,
      afvg.PurchaseOrder,
      afvg.PurchaseOrderItem,
      afvg.PurchasingInfoRecord,
      afvg.PurgInfoRecdDataIsFixed,
      afvg.PurchasingInfoRecordCategory,
      afvg.OpExternalProcessingPriceUnit,
      afvg.Supplier,
      afvg.GoodsRecipientName,
      afvg.UnloadingPointName,

      // Amount and Currency

      afvg.OpExternalProcessingCurrency,
      afvg.OpExternalProcessingPrice,
      afvg.NumberOfOperationPriceUnits,

      // Assignments FI/CO

      afvg.CompanyCode,
      afvg.BusinessArea,
      afvg.ControllingArea,
      afvg.ProfitCenter,
      afvg.RequestingCostCenter,
      afvg.CostElement,
      afvg.CostingVariant,
      afvg.CostingSheet,
      afvg.CostEstimate,
      afvg.ControllingObjectCurrency,
      afvg.ControllingObjectClass,
      afvg.FunctionalArea,
      afvg.TaxJurisdiction,

      // Assignments HR

      afvg.EmployeeWageType,
      afvg.EmployeeWageGroup,
      afvg.EmployeeSuitability,
      afvg.NumberOfTimeTickets,
      afvg.Personnel,
      afvg.NumberOfEmployees,

      // Setup and Overlapping

      afvg.OperationSetupGroupCategory,
      afvg.OperationSetupGroup,
      afvg.OperationSetupType,
      afvg.OperationOverlappingIsRequired,
      afvg.OperationOverlappingIsPossible,
      afvg.OperationsIsAlwaysOverlapping,
      afvg.OperationSplitIsRequired,
      afvg.MaximumNumberOfSplits,
      afvg.LeadTimeReductionStrategy,
      afvg.OpSchedldReductionLevel,

      // Dates and Times

      afvg.OpErlstSchedldExecStrtDte,
      afvg.OpErlstSchedldExecStrtTme,
      afvg.OpErlstSchedldProcgStrtDte,
      afvg.OpErlstSchedldProcgStrtTme,
      afvg.OpErlstSchedldTrdwnStrtDte,
      afvg.OpErlstSchedldTrdwnStrtTme,
      afvg.OpErlstSchedldExecEndDte, 
      afvg.OpErlstSchedldExecEndTme, 
      afvg.OpLtstSchedldExecStrtDte,  
      afvg.OpLtstSchedldExecStrtTme,
      afvg.OpLtstSchedldProcgStrtDte,  
      afvg.OpLtstSchedldProcgStrtTme,  
      afvg.OpLtstSchedldTrdwnStrtDte,
      afvg.OpLtstSchedldTrdwnStrtTme,
      afvg.OpLtstSchedldExecEndDte,
      afvg.OpLtstSchedldExecEndTme,
      afvg.OperationConfirmedStartDate,
      afvg.OperationConfirmedEndDate,
      afvg.OpActualExecutionStartDate,
      afvg.OpActualExecutionStartTime,
      afvg.OpActualSetupEndDate,
      afvg.OpActualSetupEndTime,
      afvg.OpActualProcessingStartDate,
      afvg.OpActualProcessingStartTime,
      afvg.OpActualProcessingEndDate,
      afvg.OpActualProcessingEndTime,
      afvg.OpActualTeardownStartDate,
      afvg.OpActualTeardownStartTme,
      afvg.OpActualExecutionEndDate,
      afvg.OpActualExecutionEndTime,
      // Forecast Dates and Times

      afvg.ActualForecastEndDate,
      afvg.ActualForecastEndTime,
      afvg.SchedldFcstdEarliestStartDate,
      afvg.SchedldFcstdEarliestStartTime,
      afvg.SchedldFcstdEarliestEndDate,
      afvg.SchedldFcstdEarliestEndTime,
      afvg.LatestSchedldFcstdStartDate,
      afvg.SchedldFcstdLatestStartTime,
      afvg.LatestSchedldFcstdEndDate,
      afvg.SchedldFcstdLatestEndTime,
      // Wait Date and Times

      afvg.EarliestScheduledWaitStartDate,
      afvg.EarliestScheduledWaitStartTime,
      afvg.EarliestScheduledWaitEndDate,
      afvg.EarliestScheduledWaitEndTime,
      afvg.LatestScheduledWaitStartDate,
      afvg.LatestScheduledWaitStartTime,
      afvg.LatestScheduledWaitEndDate,
      afvg.LatestScheduledWaitEndTime,
 
      // Durations

      afvg.BreakDurationUnit,
      afvg.PlannedBreakDuration,
      afvg.ConfirmedBreakDuration,
      cast(afvg.OverlapMinimumDurationUnit as pph_dzeimu preserving type) as OverlapMinimumDurationUnit,
      afvg.OverlapMinimumDuration,
      afvg.MaximumWaitDurationUnit,
      afvg.MaximumWaitDuration,
      afvg.MinimumWaitDurationUnit,
      afvg.MinimumWaitDuration,
      afvg.StandardMoveDurationUnit,
      afvg.StandardMoveDuration,
      afvg.StandardQueueDurationUnit,
      afvg.StandardQueueDuration,
      afvg.MinimumQueueDurationUnit,
      afvg.MinimumQueueDuration,
      afvg.MinimumMoveDurationUnit,
      afvg.MinimumMoveDuration,
      afvg.OperationStandardDuration,
      afvg.OperationStandardDurationUnit,
      afvg.MinimumDuration,
      afvg.MinimumDurationUnit,
      afvg.MinimumProcessingDuration,
      afvg.MinimumProcessingDurationUnit,
      afvg.ScheduledMoveDuration,
      afvg.ScheduledMoveDurationUnit,
      afvg.ScheduledQueueDuration,
      afvg.ScheduledQueueDurationUnit,
      afvg.ScheduledWaitDuration,
      afvg.ScheduledWaitDurationUnit,
      cast(afvg.PlannedDeliveryDuration     as pph_plifz preserving type) as PlannedDeliveryDuration,
      afvg.OpPlannedSetupDurn,
      afvg.OpPlannedSetupDurnUnit,
      afvg.OpPlannedProcessingDurn,
      cast(afvg.OpPlannedProcessingDurnUnit as pph_beaze preserving type) as OpPlannedProcessingDurnUnit,
      afvg.OpPlannedTeardownDurn,
      afvg.OpPlannedTeardownDurnUnit,
      afvg.ActualForecastDuration,
      afvg.ActualForecastDurationUnit,
      afvg.ForecastProcessingDuration,
      afvg.ForecastProcessingDurationUnit,

     // Calculated Durations

      case afvg.OpLtstSchedldExecStrtTme
        when '240000' then  // function dats_tims_to_tstmp does not work with time 24:00

          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpLtstSchedldExecStrtDte, cast('235959' as tims), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  ,
          tstmp_current_utctimestamp(),'INITIAL') + 1
        else
          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpLtstSchedldExecStrtDte, afvg.OpLtstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  ,
          tstmp_current_utctimestamp(),'INITIAL')
      end as PlannedCurrentStrtDateDvtnDurn,

      case afvg.OpErlstSchedldExecEndTme
        when '240000' then  // function dats_tims_to_tstmp does not work with time 24:00

          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpErlstSchedldExecEndDte, cast('235959' as tims), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  , 
          tstmp_current_utctimestamp(),'INITIAL') + 1
        else
          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpErlstSchedldExecEndDte, afvg.OpErlstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  , 
          tstmp_current_utctimestamp(),'INITIAL')
      end as PlannedCurrentEndDateDvtnDurn,

      case afvg.OpLtstSchedldExecStrtTme
        when '240000' then  // function dats_tims_to_tstmp does not work with time 24:00

          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpLtstSchedldExecStrtDte, cast('235959' as tims), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  ,
          dats_tims_to_tstmp( afvg.OpActualExecutionStartDate, afvg.OpActualExecutionStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'INITIAL') + 1
        else
          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpLtstSchedldExecStrtDte, afvg.OpLtstSchedldExecStrtTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  ,
          dats_tims_to_tstmp( afvg.OpActualExecutionStartDate, afvg.OpActualExecutionStartTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'INITIAL')
      end as PlannedActualStartDateDvtnDurn,

      case afvg.OpErlstSchedldExecEndTme
        when '240000' then  // function dats_tims_to_tstmp does not work with time 24:00

          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpErlstSchedldExecEndDte, cast('235959' as tims), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  ,
          dats_tims_to_tstmp( afvg.OpActualExecutionEndDate, afvg.OpActualExecutionEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'INITIAL') + 1
        else
          tstmp_seconds_between(dats_tims_to_tstmp( afvg.OpErlstSchedldExecEndDte, afvg.OpErlstSchedldExecEndTme, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL')  ,
          dats_tims_to_tstmp( afvg.OpActualExecutionEndDate, afvg.OpActualExecutionEndTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL'), 'INITIAL')
      end as PlannedActualEndDateDvtnDurn,
 
      // Offset

      afvg.StartDateOffsetReferenceCode,
      afvg.StartDateOffsetDurationUnit,
      afvg.StartDateOffsetDuration,
      afvg.EndDateOffsetReferenceCode,
      afvg.EndDateOffsetDurationUnit,
      afvg.EndDateOffsetDuration,

      // Quantities and UoM

      @Semantics.unitOfMeasure: true
      cast(afvg.OperationUnit as operationunit preserving type) as OperationUnit,
      afvg.OpQtyToBaseQtyDnmntr,
      afvg.OpQtyToBaseQtyNmrtr,
      afvg.OperationScrapPercent,
      afvg.OperationReferenceQuantity,
      afvg.OpPlannedTotalQuantity,
      afvg.OpPlannedScrapQuantity,
      afvg.OpPlannedYieldQuantity,
      afvg.OpTotalConfirmedYieldQty,
      afvg.OpTotalConfirmedScrapQty,
      afvg.OperationConfirmedReworkQty,
      afvg.ProductionUnit,
      afvg.OpTotConfdYieldQtyInOrdQtyUnit,

      // Confirmed Work Quantities and UoM

      afvg.OpWorkQuantityUnit1,
      afvg.OpConfirmedWorkQuantity1,
      afvg.NoFurtherOpWorkQuantity1IsExpd,
      afvg.OpWorkQuantityUnit2,
      afvg.OpConfirmedWorkQuantity2,
      afvg.NoFurtherOpWorkQuantity2IsExpd,
      afvg.OpWorkQuantityUnit3,
      afvg.OpConfirmedWorkQuantity3,
      afvg.NoFurtherOpWorkQuantity3IsExpd,
      afvg.OpWorkQuantityUnit4,
      afvg.OpConfirmedWorkQuantity4,
      afvg.NoFurtherOpWorkQuantity4IsExpd,
      afvg.OpWorkQuantityUnit5,
      afvg.OpConfirmedWorkQuantity5,
      afvg.NoFurtherOpWorkQuantity5IsExpd,
      afvg.OpWorkQuantityUnit6,
      afvg.OpConfirmedWorkQuantity6,
      afvg.NoFurtherOpWorkQuantity6IsExpd,

      // Work Quantities and UoM

      afvg.WorkCenterStandardWorkQtyUnit1,
      afvg.WorkCenterStandardWorkQty1,
      afvg.CostCtrActivityType1,
      afvg.WorkCenterStandardWorkQtyUnit2,
      afvg.WorkCenterStandardWorkQty2,
      afvg.CostCtrActivityType2,
      afvg.WorkCenterStandardWorkQtyUnit3,
      afvg.WorkCenterStandardWorkQty3,
      afvg.CostCtrActivityType3,
      afvg.WorkCenterStandardWorkQtyUnit4,
      afvg.WorkCenterStandardWorkQty4,
      afvg.CostCtrActivityType4,
      afvg.WorkCenterStandardWorkQtyUnit5,
      afvg.WorkCenterStandardWorkQty5,
      afvg.CostCtrActivityType5,
      afvg.WorkCenterStandardWorkQtyUnit6,
      afvg.WorkCenterStandardWorkQty6,
      afvg.CostCtrActivityType6,
 
      // Forecast Work Quantities

      afvg.ForecastWorkQuantity1,
      afvg.ForecastWorkQuantity2,
      afvg.ForecastWorkQuantity3,
      afvg.ForecastWorkQuantity4,
      afvg.ForecastWorkQuantity5,
      afvg.ForecastWorkQuantity6,

      // Business Process

      afvg.BusinessProcess,
      afvg.BusinessProcessEntryUnit,
      afvg.BusinessProcessConfirmedQty,
      afvg.NoFurtherBusinessProcQtyIsExpd,
      afvg.BusinessProcRemainingQtyUnit,
      afvg.BusinessProcessRemainingQty,

      // OAN data

      afvg.SetupOpActyNtwkInstance,
      afvg.ProduceOpActyNtwkInstance,
      afvg.TeardownOpActyNtwkInstance,

      // Free-defined fields

      afvg.FreeDefinedTableFieldSemantic,
      afvg.FreeDefinedAttribute01,
      afvg.FreeDefinedAttribute02,
      afvg.FreeDefinedAttribute03,
      afvg.FreeDefinedAttribute04,
      afvg.FreeDefinedQuantity1,
      afvg.FreeDefinedQuantity2,
      afvg.FreeDefinedAmount1,
      afvg.FreeDefinedAmount2,
      afvg.FreeDefinedDate1,
      afvg.FreeDefinedDate2,
      afvg.FreeDefinedIndicator1,
      afvg.FreeDefinedIndicator2,

      // Associations

      _OrdInternalBillOfOperations,
      _MfgOrder,
      _MfgOrderSequence,
      _MfgOrderCategory,
      _MfgOrderType,
      _SuperiorOperation,
      _OperationStandardTextCode,
      _ProductionPlant,
      _ProductionSupervisor,
      _ProductionUnit,
      _OperationUnit,
      _WorkCenter,
      _WorkCenterType,
      _WorkCenter_2,
      _WorkCenterType_2,
      _OperationControlProfile,
      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _BillOfOperationsVariant,
      _BillOfOperationsSequence,
      _BOOOperationInternalID,
      _MRPController,
      _ResponsiblePlannerGroup,
      _ControlRecipeDestination,
      _OperationConfirmation,
      _FactoryCalendar,
      _CapacityRequirement,
      _CapacityRequirementItem,
      _ChangeNumber,
      _PurchasingOrganization,
      _PurchasingGroup,
      _PurchaseOrder,
      _PurchaseOrderItem,
      _PurchaseRequisition,
      _PurchaseRequisitionItem,
      _PurchasingInfoRecord,
      _OpExternalProcessingCurrency,
      _EmployeeWageGroup,
      _EmployeeSuitability,
      _Employee,
      _CompanyCode,
      _ProfitCenter,
      _RequestingCostCenter,
      _ControllingArea,
      _ControllingObjectClass,
      _FunctionalArea,
      _BusinessArea,
      _BusinessProcess,
      _BusinessProcessEntryUnit,
      _OperationSetupGroupCategory,
      _OperationSetupGroup,
      _OperationSetupType,
      _LeadTimeReductionStrategy,
      _StartDateOffsetReferenceCode,
      _EndDateOffsetReferenceCode,
      _Language,
      _SetupOpActyNtwkInstance,
      _ProduceOpActyNtwkInstance,
      _TeardownOpActyNtwkInstance,
      _LongText
};