I_SchedCapacityRqmtItemCap

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_SchedCapacityRqmtItemCap.
-- 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: ISCHEDCAPITMCAP

CREATE VIEW I_SchedCapacityRqmtItemCap AS
SELECT
  kbed.bedid AS CapacityRequirement,
  cast(kbed.bedzl as pph_bedzl preserving type) AS CapacityRequirementItem,
  cast(kbed.canum as pph_canum preserving type) AS CapacityRqmtItemCapacity,
  kbed.bstkz AS CapacityRqmtConfirmation,
  kbed.arbid AS WorkCenterInternalID,
  cast('A' as cr_objty ) AS WorkCenterTypeCode,
  kbed.kapid AS CapacityInternalID,
  kbed.plnum AS PlannedOrder,
  cast(kbed.aufpl as pph_aufpl preserving type) AS OrderInternalID,
  cast(kbed.aplzl as operationinternalid preserving type) AS OrderOperationInternalID,
  kbed.vornr AS Operation,
  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.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,
  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,
  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
;