I_CapacityRequirement

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_CapacityRequirement.
-- 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: IPPCAPRQMT

CREATE VIEW I_CapacityRequirement AS
SELECT
  kbko.bedid AS CapacityRequirement,
  cast(kbko.typkz as capacityrequirementorigin preserving type) AS CapacityRequirementOrigin,
  kbko.plnum AS PlannedOrder,
  afko.aufnr AS OrderID,
  cast(kbko.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  kbko.safnr AS SalesOperationsPlanningOrder,
  kbko.plnty AS BillOfOperationsType,
  kbko.plnnr AS BillOfOperationsGroup,
  kbko.plnal AS BillOfOperations,
  cast(kbko.terkz as pph_termkz preserving type) AS SchedulingType,
  kbko.gstrs AS ScheduledBasicStartDate,
  kbko.gsuzs AS ScheduledBasicStartTime,
  kbko.gltrs AS ScheduledBasicEndDate,
  kbko.gluzs AS ScheduledBasicEndTime,
  kbko.trmdt AS LastScheduledDate,
  kbko.plauf AS BOOExplosionDate
FROM kbko
LEFT OUTER JOIN I_CapacityRequirementOrigin AS _CapacityRequirementOrigin ON CapacityRequirementOrigin = _CapacityRequirementOrigin.CapacityRequirementOrigin  -- association [1..1]
LEFT OUTER JOIN I_PlannedOrder AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [0..1]
LEFT OUTER JOIN I_SalesOperationsPlanningOrder AS _SalesOperationsPlanningOrder ON SalesOperationsPlanningOrder= _SalesOperationsPlanningOrder.SalesOperationsPlanningOrder  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperations = _BillOfOperations.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_SchedulingType AS _SchedulingType ON SchedulingType = _SchedulingType.SchedulingType  -- association [0..1]
LEFT OUTER JOIN I_CapacityRequirementItem AS _CapacityRequirementItem ON CapacityRequirement = _CapacityRequirementItem.CapacityRequirement  -- association [1..*]
;