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
  cast( CapRqmtItmCap.OrderID as pph_cfs_ordernumber ) AS OrderID,
  cast(CapRqmtItmCap._Order.OrderCategory as pph_cfs_sch_ordercategory) AS OrderCategory,
  cast( CapRqmtItmCap.Operation as vornr) AS Operation,
  cast( CapRqmtItmCap._Order.Material as productnumber) AS Material,
  CapRqmtItmCap._WorkCenter.Plant AS Plant,
  cast( _Order._OrderMainItem.MRPArea as berid) AS MRPArea,
  cast( CapRqmtItmCap._Order.MRPController as dispo) AS MRPController,
  case CapRqmtItmCap._Order.LastChangeDate when '00000000' then cast(cast( concat( CapRqmtItmCap._Order.CreationDate, CapRqmtItmCap._Order.CreationTime)as abap.numc(15)) as timestamp) else cast(cast( concat( CapRqmtItmCap._Order.LastChangeDate, CapRqmtItmCap._Order.LastChangeTime)as abap.numc(15)) as timestamp) end as LastChangeDateTime AS numc15astimestampendasLastChangeDateTime,
  CapRqmtItmCap._WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  CapRqmtItmCap._WorkCenter.WorkCenter AS WorkCenter,
  CapRqmtItmCap._WorkCenter.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  CapRqmtItmCap._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  cast(CapRqmtItmCap.WorkCenterTypeCode as cr_objty) AS WorkCenterTypeCode,
  CapRqmtItmCap._Capacity.CapacityCategoryCode AS CapacityCategoryCode,
  CapRqmtItmCap._WorkCenter.WorkCenterResponsible AS WorkCenterResponsible,
  CapRqmtItmCap._Capacity.CapacityResponsiblePlanner AS CapacityResponsiblePlanner,
  cast(CapRqmtItmCap.OrderID as aufnr) AS ManufacturingOrder,
  cast(CapRqmtItmCap.PlannedOrder as plnum) AS PlannedOrder,
  cast( _Order._OrderMainItem.ProductionVersion as verid) AS ProductionVersion,
  _Order._OrderMainItem._ProductionVersion.ProductionLine AS ProductionLine,
  CapRqmtItmCap._Order.PlannedEndDate AS RequirementDate,
  cast ( CapRqmtItmCap._Order.OrderPlannedTotalQty as mgvrg ) AS OrderPlannedTotalQty,
  cast (CapRqmtItmCap._Order.BaseUnit as meins preserving type) AS BaseUnit,
  CapRqmtItmCap._Order.BOOExplosionDate AS BOOExplosionDate,
  CapRqmtItmCap._Order.BOOExplosionDate AS BOMExplosionDate,
  CapRqmtItmCap._PlannedOrder.PlndOrderPlannedStartDate AS PlndOrderPlannedStartDate,
  CapRqmtItmCap._PlannedOrder.PlndOrderPlannedEndDate AS PlndOrderPlannedEndDate,
  CapRqmtItmCap._OrderOperation.OperationSetupGroup AS OperationSetupGroup,
  CapRqmtItmCap._OrderOperation.OperationSetupGroupCategory AS OperationSetupGroupCategory,
  CapRqmtItmCap._OrderOperation.OperationSetupType AS OperationSetupType,
  cast(cast(concat(dats_add_days(cast($session.system_date as sydatum),-90,'NULL'),'000000')as abap.numc(15) ) as timestamp) AS HorizonStartDatetime,
  cast (dats_add_days(cast ($session.system_date as sydatum),-90,'FAIL') as sydatum) AS HorizonStartDate,
  case when CapRqmtItmCap._WorkCenter._Plant._Address.AddressTimeZone is null then tstmp_to_dats( tstmp_current_utctimestamp(), abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL' ) when CapRqmtItmCap._WorkCenter._Plant._Address.AddressTimeZone is not null then tstmp_to_dats( tstmp_current_utctimestamp(), CapRqmtItmCap._WorkCenter._Plant._Address.AddressTimeZone, $session.client, 'NULL' ) end as PlantCurrentDate AS clientNULLendasPlantCurrentDate,
  case when CapRqmtItmCap._WorkCenter._Plant._Address.AddressTimeZone is null then tstmp_to_tims( tstmp_current_utctimestamp(), abap_system_timezone($session.client, 'NULL'), $session.client, 'NULL' ) when CapRqmtItmCap._WorkCenter._Plant._Address.AddressTimeZone is not null then tstmp_to_tims( tstmp_current_utctimestamp(), CapRqmtItmCap._WorkCenter._Plant._Address.AddressTimeZone, $session.client, 'NULL' ) end as PlantCurrentTime AS clientNULLendasPlantCurrentTime,
  CapRqmtItmCap._WorkCenter._Plant._Address.AddressTimeZone AS PlantTimeZone,
  cast( CapRqmtItmCap._PlannedOrder.LastChangeDateTime as timestamp) AS LastChangeDateTime,
  cast('' as boole_d preserving type ) AS OrderHasConfiguration,
  CapRqmtItmCap._PlannedOrder.PlannedOrderType AS OrderType,
  CapRqmtItmCap.CapacityRequirementItem AS CapacityRequirementItem,
  CapRqmtItmCap.CapacityRqmtItemCapacity AS CapacityRqmtItemCapacity,
  CapRqmtItmCap.CapacityRequirement AS CapacityRequirement,
  CapRqmtItmCap.CapacityInternalID AS CapacityInternalID,
  CapRqmtItmCap.OrderInternalID AS OrderInternalID,
  CapRqmtItmCap.OperationLatestStartDate AS OperationLatestStartDate,
  CapRqmtItmCap.OperationLatestStartTime AS OperationLatestStartTime,
  CapRqmtItmCap.OperationLatestEndDate AS OperationLatestEndDate,
  CapRqmtItmCap.OperationLatestEndTime AS OperationLatestEndTime,
  CapRqmtItmCap.LtstSchedldProcStrtDte AS OpLtstSchedldProcgStrtDte,
  CapRqmtItmCap.LtstSchedldProcStrtTime AS OpLtstSchedldProcgStrtTme,
  CapRqmtItmCap.LtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  CapRqmtItmCap.LtstSchedldTrdwnStrtTime AS OpLtstSchedldTrdwnStrtTme,
  CapRqmtItmCap.OrderObjectInternalID AS OrderObjectInternalID,
  _CapacityRequirement.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _CapacityRequirement.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _CapacityRequirement.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _CapacityRequirement.ScheduledBasicEndTime AS ScheduledBasicEndTime
FROM I_CapacityRequirementItemCap AS CapRqmtItmCap
LEFT OUTER JOIN P_ProcCapReqOpDurn AS ProcOpDurn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusConfirmed ON CapRqmtItmCap.OrderObjectInternalID = _StatusConfirmed.StatusObject AND _StatusConfirmed.StatusCode = 'I0009' AND _StatusConfirmed.StatusIsActive = 'X'  -- association [1..1]
-- UNION ALL with additional select branch(es): I_CapacityRequirementItemCap
;