A_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 A_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: APLNDORDCAP

CREATE VIEW A_PlannedOrderCapacity AS
SELECT
  CapacityRequirement,
  CapacityRequirementItem,
  CapacityRqmtItemCapacity,
  PlannedOrder,
  _PlannedOrder.PlannedOrderType AS PlannedOrderType,
  BillOfOperationsSequence AS Sequence,
  kbed.Operation AS Operation,
  kbed._WorkCenter.WorkCenter AS WorkCenter,
  _Capacity.CapacityCategoryCode AS CapacityCategoryCode,
  _Capacity.Capacity AS Capacity,
  _PlannedOrder.MRPController AS MRPController,
  _PlannedOrder.MRPPlant AS MRPPlant,
  OperationLatestStartDate,
  OperationLatestStartTime,
  OperationLatestEndDate,
  OperationLatestEndTime,
  OperationEarliestStartDate,
  OperationEarliestStartTime,
  OperationEarliestEndDate,
  OperationEarliestEndTime,
  LtstSchedldProcStrtDte AS OpLtstSchedldProcgStrtDte,
  LtstSchedldProcStrtTime AS OpLtstSchedldProcgStrtTme,
  LtstSchedldTrdwnStrtDte AS OpLtstSchedldTrdwnStrtDte,
  LtstSchedldTrdwnStrtTime AS OpLtstSchedldTrdwnStrtTme,
  _CapacityRequirement.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  _CapacityRequirement.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  CapacityRequirementUnit,
  _UnitOfMeasure.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  ScheduledCapReqOpSegSetupDurn,
  RemainingCapReqOpSegSetupDurn,
  ScheduledCapReqOpSegProcgDurn,
  RemainingCapReqOpSegProcgDurn,
  ScheduledCapReqOpSegTrdwnDurn,
  RemainingCapReqOpSegTrdwnDurn,
  case when SubOperation.SuperiorOperationInternalID > '00000000' then SubOperation.OperationText else _BOOOperationInternalVersion.OperationText end as OperationText AS OperationTextendasOperationText,
  _PlannedOrder.LastChangeDateTime AS LastChangeDateTime
FROM I_CapacityRequirementItemCap AS kbed
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS SubOperation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_PlannedOrder AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [0..1]
;