I_PlannedOrderCapacity

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 I_PlannedOrderCapacity.
-- 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: IPLNDORDERCAP

CREATE VIEW I_PlannedOrderCapacity AS
SELECT
  kbed.CapacityRequirement AS CapacityRequirement,
  kbed.CapacityRequirementItem AS CapacityRequirementItem,
  kbed.PlannedOrder AS PlannedOrder,
  kbed.WorkCenterInternalID AS WorkCenterInternalID,
  kbed.WorkCenterTypeCode_2 AS WorkCenterType,
  kbed.CapacityInternalID AS CapacityInternalID,
  kbed._Capacity.CapacityCategoryCode AS CapacityCategory,
  kbed.CapacityRqmtConfirmation AS CapacityRqmtConfirmation,
  kbed.OrderObjectInternalID AS OrderObjectInternalID,
  kbed.BillOfOperationsSequence AS Sequence,
  kbed.Operation_2 AS Operation,
  case when BOOSubOp.SuperiorOperationInternalID > '00000000' then BOOSubOp.OperationText else kbed._BOOOperationInternalVersion.OperationText end as OperationText AS OperationTextendasOperationText,
  kbed.ActualNumberOfSplits AS ActualNumberOfSplits,
  kbed.CapacityRequirementSplit AS CapacityRequirementSplit,
  kbed.OperationLatestStartDate AS OperationLatestStartDate,
  kbed.OperationLatestStartTime AS OperationLatestStartTime,
  kbed.OperationLatestEndDate AS OperationLatestEndDate,
  kbed.OperationLatestEndTime AS OperationLatestEndTime,
  kbed.OperationEarliestStartDate AS OperationEarliestStartDate,
  kbed.OperationEarliestStartTime AS OperationEarliestStartTime,
  kbed.OperationEarliestEndDate AS OperationEarliestEndDate,
  kbed.OperationEarliestEndTime AS OperationEarliestEndTime,
  kbed.ErlstSchedldProcStrtDte AS OpErlstSchedldProcgStrtDte,
  kbed.ErlstSchedldProcStrtTime AS OpErlstSchedldProcgStrtTme,
  kbed.ErlstSchedldTrdwnStrtDte AS OpErlstSchedldTrdwnStrtDte,
  kbed.ErlstSchedldTrdwnStrtTime AS OpErlstSchedldTrdwnStrtTme,
  kbed.LtstSchedldProcStrtDte AS OpLtstSchedldProcgStrtDte,
  kbed.LtstSchedldProcStrtTime AS OpLtstSchedldProcgStrtTme,
  kbed.LtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  kbed.LtstSchedldTrdwnStrtTime AS OpLtstSchedldTrdwnStrtTme,
  kbed.CapacityRequirementUnit AS CapacityRequirementUnit,
  kbed.ScheduledCapReqOpSegSetupDurn AS ScheduledCapReqOpSegSetupDurn,
  kbed.RemainingCapReqOpSegSetupDurn AS RemainingCapReqOpSegSetupDurn,
  kbed.ScheduledCapReqOpSegProcgDurn AS ScheduledCapReqOpSegProcgDurn,
  kbed.RemainingCapReqOpSegProcgDurn AS RemainingCapReqOpSegProcgDurn,
  kbed.ScheduledCapReqOpSegTrdwnDurn AS ScheduledCapReqOpSegTrdwnDurn,
  kbed.RemainingCapReqOpSegTrdwnDurn AS RemainingCapReqOpSegTrdwnDurn,
  kbed._CapacityRequirementConf AS _CapacityRequirementConf,
  kbed._CapacityRequirement AS _CapacityRequirement,
  kbed._CapacityRequirementItem AS _CapacityRequirementItem,
  kbed._Capacity AS _Capacity,
  kbed._UnitOfMeasure AS _UnitOfMeasure
FROM I_CapacityRequirementItemCap AS kbed
LEFT OUTER JOIN I_CapacityCategory AS _CapacityCategory ON CapacityCategory = _CapacityCategory.CapacityCategoryCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterType = _WorkCenterType.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterType = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_StatusObject AS _OrderStatusObject ON OrderObjectInternalID = _OrderStatusObject.StatusObject  -- association [0..1]
LEFT OUTER JOIN I_PlannedOrder AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [1..1]
;