P_MntrWrkCtrOrderOperations

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_MntrWrkCtrOrderOperations.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PMWCORDOP

CREATE VIEW P_MntrWrkCtrOrderOperations AS
SELECT
  OrderID,
  CapacityRequirementItem,
  CapacityRqmtItemCapacity,
  OrderCategory,
  CapacityRequirement,
  Operation,
  Material,
  Plant,
  MRPArea,
  MRPController,
  LastChangeDateTime,
  WorkCenterInternalID,
  WorkCenter,
  WorkCenterCategoryCode,
  WorkCenterText,
  WorkCenterTypeCode,
  CapacityInternalID,
  CapacityCategoryCode,
  WorkCenterResponsible,
  CapacityResponsiblePlanner,
  OrderInternalID,
  ManufacturingOrder,
  PlannedOrder,
  ProductionVersion,
  ProductionLine,
  OperationPlanningStatusCode,
  ScheduledBasicStartDate,
  ScheduledBasicStartTime,
  ScheduledBasicEndDate,
  ScheduledBasicEndTime,
  OperationLatestStartDate,
  OperationLatestStartTime,
  LtstSchedldExecStrtDteTme,
  OperationLatestEndDate,
  OperationLatestEndTime,
  LtstSchedldExecEndDteTme,
  OpLtstSchedldProcgStrtDte,
  OpLtstSchedldProcgStrtTme,
  OpLtstSchedldTrdwnStrtDte,
  OpLtstSchedldTrdwnStrtTme,
  RequirementDate,
  OrderPlannedTotalQty,
  BaseUnit,
  CapacityRequirementUnit,
  RemCapReqOpSegSetupDurnInHours,
  RemCapReqOpSegProcgDurnInHours,
  RemCapReqOpSegTrdwnDurnInHours,
  BOOExplosionDate,
  BOMExplosionDate,
  PlndOrderPlannedStartDate,
  PlndOrderPlannedEndDate,
  OrderObjectInternalID,
  OperationSetupGroup,
  OperationSetupGroupCategory,
  OperationSetupType,
  HorizonStartDate,
  HorizonStartDatetime,
  case when PlantTimeZone is null then tstmp_to_dats( tstmp_current_utctimestamp(),abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL' ) when PlantTimeZone is not null then tstmp_to_dats( tstmp_current_utctimestamp(), PlantTimeZone, $session.client, 'NULL' ) end as PlantCurrentDate AS clientNULLendasPlantCurrentDate,
  case when PlantTimeZone is null then tstmp_to_tims( tstmp_current_utctimestamp(), abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL' ) when PlantTimeZone is not null then tstmp_to_tims( tstmp_current_utctimestamp(), PlantTimeZone, $session.client,'NULL' ) end as PlantCurrentTime AS clientNULLendasPlantCurrentTime,
  OrderHasConfiguration,
  OperationLatestStartDateTime,
  OperationLatestEndDateTime,
  PlantTimeZone,
  OrderType,
  OperationLatestStartDateTime AS OpLtstSchedldSetupStrtDteTme,
  OperationLatestEndDateTime AS OpLtstSchedldTrdwnEndDteTme,
  tstmp_seconds_between(cast(LtstSchedldExecStrtDteTme as abap.dec(15,0)), cast(LtstSchedldExecEndDteTme as abap.dec(15,0)), 'FAIL' ) AS TotalDuration,
  tstmp_seconds_between(cast(LtstSchedldExecStrtDteTme as abap.dec(15,0)) , cast(LtstSchdlProcStrtDteTime as abap.dec(15,0)), 'FAIL') AS SetupDuration,
  tstmp_seconds_between(cast( LtstSchdlProcStrtDteTime as abap.dec(15,0)), cast(LtstSchdlTrdwnStrtDteTime as abap.dec(15,0)), 'FAIL') AS ProcessDuration,
  tstmp_seconds_between(cast(LtstSchdlTrdwnStrtDteTime as abap.dec(15,0)), cast(LtstSchedldExecEndDteTme as abap.dec(15,0)), 'FAIL') AS TearDownDuration
FROM P_MntrWrkCtrOrderOps AS PMntrWrkCtrOrd
;