I_CapacityRequirementItemCap

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_CapacityRequirementItemCap.
-- 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: IPPCAPRQMTITMCAP

CREATE VIEW I_CapacityRequirementItemCap AS
SELECT
  kbed.bedid AS CapacityRequirement,
  cast(kbed.bedzl as pph_bedzl preserving type) AS CapacityRequirementItem,
  kbed.bstkz AS CapacityRqmtConfirmation,
  kbed.arbid AS WorkCenterInternalID,
  cast('A' as pph_arbty preserving type) AS WorkCenterTypeCode,
  cast('A ' as vdm_arbty preserving type) AS WorkCenterTypeCode_2,
  kbed.kapid AS CapacityInternalID,
  kbed.plnum AS PlannedOrder,
  cast(kbed.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  afko.aufnr AS OrderID,
  cast(kbed.aplzl as operationinternalid preserving type) AS OrderOperationInternalID,
  kbed.vornr AS Operation,
  cast(kbed.vornr as vdm_vornr preserving type) AS Operation_2,
  kbed.safnr AS SalesOperationsPlanningOrder,
  kbed.pernr AS PersonnelNumber,
  kbed.kpver AS CapacityRequirementDistrKey,
  kbed.phase_kz AS OperationIsPhase,
  cast(kbed.bedzlf as pph_sumnr preserving type) AS SuperiorOperationInternalID,
  cast(kbed.plnty as billofoperationstype preserving type) AS BillOfOperationsType,
  cast(kbed.plnnr as billofoperations preserving type) AS BillOfOperationsGroup,
  cast(kbed.plnal as billofoperationsvariant preserving type) AS BillOfOperations,
  cast(kbed.zaehl as billofoperationschgstate preserving type) AS BillOfOperationsChangeStateID,
  kbed.plnfl AS BillOfOperationsSequence,
  kbed.plnkn AS BOOOperationInternalID,
  kbed.zaehp AS BOOOpInternalVersionCounter,
  kbed.splkn AS BOOSubOperationInternalID,
  kbed.szaehl AS BOOSubOperationInternalVersion,
  kbed.keinh AS CapacityRequirementUnit,
  kbed.kruesoll AS ScheduledCapReqOpSegSetupDurn,
  kbed.kruerest AS RemainingCapReqOpSegSetupDurn,
  kbed.kbeasoll AS ScheduledCapReqOpSegProcgDurn,
  kbed.kbearest AS RemainingCapReqOpSegProcgDurn,
  kbed.kabrsoll AS ScheduledCapReqOpSegTrdwnDurn,
  kbed.kabrrest AS RemainingCapReqOpSegTrdwnDurn,
  kbez.daune AS OperationStandardDurationUnit,
  kbez.dauno AS OperationStandardDuration,
  kbed.fstad AS OperationEarliestStartDate,
  kbed.fstau AS OperationEarliestStartTime,
  kbed.fendd AS OperationEarliestEndDate,
  kbed.fendu AS OperationEarliestEndTime,
  kbed.sstad AS OperationLatestStartDate,
  kbed.sstau AS OperationLatestStartTime,
  kbed.sendd AS OperationLatestEndDate,
  kbed.sendu AS OperationLatestEndTime,
  kbed.istad AS ActualStartDate,
  kbed.istau AS ActualStartTime,
  kbed.iendd AS ActualEndDate,
  kbed.iendu AS ActualEndTime,
  cast(kbed.fssbd as pph_fssbd preserving type) AS ErlstSchedldProcStrtDte,
  cast(kbed.fssbz as pph_fssbz preserving type) AS ErlstSchedldProcStrtTime,
  cast(kbed.fssad as pph_fssad preserving type) AS ErlstSchedldTrdwnStrtDte,
  cast(kbed.fssaz as pph_fssaz preserving type) AS ErlstSchedldTrdwnStrtTime,
  cast(kbed.sssbd as pph_sssbd preserving type) AS LtstSchedldProcStrtDte,
  cast(kbed.sssbz as pph_sssbz preserving type) AS LtstSchedldProcStrtTime,
  cast(kbed.sssad as pph_sssad preserving type) AS LtstSchedldTrdwnStrtDte,
  cast(kbed.sssaz as pph_sssaz preserving type) AS LtstSchedldTrdwnStrtTime,
  kbed.ispli AS ActualNumberOfSplits,
  cast(kbed.split as pph_split preserving type) AS CapacityRequirementSplit,
  kbed.kbsta AS ObjectInternalID,
  cast(kbed.obsta as pph_obsta preserving type) AS OrderObjectInternalID,
  cast(kbez.vge01 as pph_vge01 preserving type) AS StandardWorkQuantityUnit1,
  cast(kbez.vgw01 as vdm_vgw01 preserving type) AS StandardWorkQuantity1,
  cast(kbez.vge02 as pph_vge02 preserving type) AS StandardWorkQuantityUnit2,
  cast(kbez.vgw02 as vdm_vgw02 preserving type) AS StandardWorkQuantity2,
  cast(kbez.vge03 as pph_vge03 preserving type) AS StandardWorkQuantityUnit3,
  cast(kbez.vgw03 as vdm_vgw03 preserving type) AS StandardWorkQuantity3,
  cast(kbez.vge04 as pph_vge04 preserving type) AS StandardWorkQuantityUnit4,
  cast(kbez.vgw04 as vdm_vgw04 preserving type) AS StandardWorkQuantity4,
  cast(kbez.vge05 as pph_vge05 preserving type) AS StandardWorkQuantityUnit5,
  cast(kbez.vgw05 as vdm_vgw05 preserving type) AS StandardWorkQuantity5,
  cast(kbez.vge06 as pph_vge06 preserving type) AS StandardWorkQuantityUnit6,
  cast(kbez.vgw06 as vdm_vgw06 preserving type) AS StandardWorkQuantity6,
  kbez.arbeh AS StandardWorkQuantityUnit,
  kbez.arbei AS PlannedWorkQuantity,
  kbez.ismnw AS ActualWorkQuantity
FROM kbed
LEFT OUTER JOIN I_CapacityRequirement AS _CapacityRequirement ON CapacityRequirement = _CapacityRequirement.CapacityRequirement  -- association [1..1]
LEFT OUTER JOIN I_CapacityRequirementItem AS _CapacityRequirementItem ON CapacityRequirement = _CapacityRequirementItem.CapacityRequirement AND CapacityRequirementItem = _CapacityRequirementItem.CapacityRequirementItem  -- association [1..1]
LEFT OUTER JOIN I_CapacityRequirementConf AS _CapacityRequirementConf ON CapacityRqmtConfirmation= _CapacityRequirementConf.CapacityRqmtConfirmation  -- association [1..1]
LEFT OUTER JOIN I_Capacity AS _Capacity ON CapacityInternalID = _Capacity.CapacityInternalID  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType ON WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter_2 ON WorkCenterTypeCode_2 = _WorkCenter_2.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter_2.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterType AS _WorkCenterType_2 ON WorkCenterTypeCode_2 = _WorkCenterType_2.WorkCenterTypeCode  -- association [1..1]
LEFT OUTER JOIN I_PlannedOrder AS _PlannedOrder ON PlannedOrder = _PlannedOrder.PlannedOrder  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalID  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_OrderItem AS _OrderItem ON OrderID = _OrderItem.OrderID AND _OrderItem.OrderItem = '0001'  -- association [0..1]
LEFT OUTER JOIN I_OrderOperation AS _OrderOperation ON OrderInternalID = _OrderOperation.OrderInternalID AND OrderOperationInternalID = _OrderOperation.OrderOperationInternalID  -- 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_BillOfOperationsChangeState AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperations = _BillOfOperationsChangeState.BillOfOperationsVariant AND BillOfOperationsChangeStateID = _BillOfOperationsChangeState.BOOInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperationsSequence AS _BillOfOperationsSequence ON BillOfOperationsType = _BillOfOperationsSequence.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence.BillOfOperationsGroup AND BillOfOperations = _BillOfOperationsSequence.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsSequence AS _BillOfOperationsSequence2 ON BillOfOperationsType = _BillOfOperationsSequence2.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsSequence2.BillOfOperationsGroup AND BillOfOperations = _BillOfOperationsSequence2.BillOfOperationsVariant AND BillOfOperationsSequence = _BillOfOperationsSequence2.BillOfOperationsSequence  -- association [0..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOOperationInternalID ON BillOfOperationsType = _BOOOperationInternalID.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationInternalID.BillOfOperationsGroup AND BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS _BOOOperationInternalVersion ON BillOfOperationsType = _BOOOperationInternalVersion.BillOfOperationsType AND BillOfOperationsGroup = _BOOOperationInternalVersion.BillOfOperationsGroup AND BOOOperationInternalID = _BOOOperationInternalVersion.BOOOperationInternalID AND BOOOpInternalVersionCounter = _BOOOperationInternalVersion.BOOOpInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_BOOOperationInternalID AS _BOOSubOperationInternalID ON BillOfOperationsType = _BOOSubOperationInternalID.BillOfOperationsType AND BillOfOperationsGroup = _BOOSubOperationInternalID.BillOfOperationsGroup AND BOOSubOperationInternalID = _BOOSubOperationInternalID.BOOOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_BillOfOperationsOpBasic AS _BOOSubOperationInternalVers ON BillOfOperationsType = _BOOSubOperationInternalVers.BillOfOperationsType AND BillOfOperationsGroup = _BOOSubOperationInternalVers.BillOfOperationsGroup AND BOOSubOperationInternalID = _BOOSubOperationInternalVers.BOOOperationInternalID AND BOOSubOperationInternalVersion = _BOOSubOperationInternalVers.BOOOpInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_Employee AS _Employee ON PersonnelNumber = _Employee.Employee  -- association [0..1]
LEFT OUTER JOIN I_Employment AS _Employment ON PersonnelNumber = _Employment.EmploymentInternalID  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _StatusObjectStatus ON ObjectInternalID = _StatusObjectStatus.StatusObject AND _StatusObjectStatus.StatusCode = 'I0117'  -- association [0..1]
LEFT OUTER JOIN I_StatusObjectStatus AS _OrderStatusObjectStatus ON OrderObjectInternalID = _OrderStatusObjectStatus.StatusObject AND _OrderStatusObjectStatus.StatusCode = 'I0117'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit1 ON StandardWorkQuantityUnit1 = _WorkQuantityUnit1.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit2 ON StandardWorkQuantityUnit2 = _WorkQuantityUnit2.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit3 ON StandardWorkQuantityUnit3 = _WorkQuantityUnit3.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit4 ON StandardWorkQuantityUnit4 = _WorkQuantityUnit4.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit5 ON StandardWorkQuantityUnit5 = _WorkQuantityUnit5.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WorkQuantityUnit6 ON StandardWorkQuantityUnit6 = _WorkQuantityUnit6.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _StandardDurationUnit ON OperationStandardDurationUnit = _StandardDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ForecastDurationUnit ON ActualForecastDurationUnit = _ForecastDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CapacityRequirementUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
;