I_Capacity

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_Capacity.
-- 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: IPPCAPACITY

CREATE VIEW I_Capacity AS
SELECT
  kako.kapid AS CapacityInternalID,
  kako.werks AS Plant,
  kako.name AS Capacity,
  cast(kako.kapar as pph_kapart preserving type) AS CapacityCategoryCode,
  kako.versa AS CapacityActiveVersion,
  kako.kapter AS CapacityIsFinite,
  kako.poolk AS CapacityIsPooled,
  kako.mehr AS CapacityHasIndivCapacities,
  kako.kaplpl AS CapacityIsExcldFrmLongTermPlng,
  kako.aznor AS CapacityNumberOfCapacities,
  kako.planr AS CapacityResponsiblePlanner,
  kako.ngrad AS CapacityPlanUtilizationPercent,
  kako.pause AS CapacityBreakDuration,
  cast(kako.kapavo as pph_kzavo preserving type) AS CapIsUsedInMultiOperations,
  cast(kako.refid as pph_refid preserving type) AS ReferencedCapacityInternalID,
  kako.ueberlast AS CapOverloadThresholdInPercent,
  kako.kalid AS FactoryCalendar,
  kako.mosid AS ShiftGroup,
  kako.begzt AS CapacityStartTime,
  kako.endzt AS CapacityEndTime,
  cast(kako.begzt as vdm_begzt preserving type) AS CapacityStartTimeID,
  cast(kako.endzt as vdm_endzt preserving type) AS CapacityEndTimeID,
  kako.kapeh AS CapacityQuantityUnit,
  kako.meins AS CapacityBaseQtyUnit,
  kako.type AS ResourceType,
  kako.restype AS ResourceCategory,
  kako.lc_days_minus AS RsceValidityStartOffsetInDays,
  kako.lc_days_plus AS RsceValidityEndOffsetInDays,
  kako.sort AS ResourceSortText,
  kako.finity_level AS ResourceFinitenessLevel,
  kako.is_bottleneck AS ResourceIsBottleNeck,
  kako.sync_start AS RsceOverlappingActiesSync,
  kako.buffertime AS ResourceTimeBufferQuantity,
  kako.buffertime_unit AS ResourceTimeBufferUnit,
  kako.min_overlap AS ResourceMaxOverlapDuration,
  kako.min_overlap_unit AS ResourceMaxOverlapDurationUnit,
  kako.campaign_ppds AS ResourceIsCampaignRelevant,
  kako.tstream_external AS RsceShiftsAndBreaksAreDerived,
  kako.pp_def_buckets AS PPDSPeriodSourceType,
  kako.pp_bucket_schema AS PPDSPeriodDurationSchema,
  kako.pp_bucket_fact AS PPDSPeriodTimeRatioInPercent,
  kako.mix_plan_type AS PPDSCapacitySupplyTimeCategory,
  kako.storage_capable AS RsceHasStorCharcs,
  kako.dim_storage AS RsceStorageQuantityDimension,
  kako.storage_unit AS RsceStorageQuantityUnit,
  kako.min_storage AS RsceStorageMinProductionQty,
  kako.max_storage AS RsceStorageMaxQuantity,
  kako.storage_to_zero AS RsceStorIsZeroOnNoFillPurity,
  kako.campaign_ppo AS CapacityPlanningPeriodLotSize,
  kako.multiple_product AS RsceStorHasMltplProds,
  kako.zero_threshold AS RsceStorZeroFillPurityThldQty
FROM kako
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_CapacityText AS _Text ON CapacityInternalID = _Text.CapacityInternalID  -- association [0..*]
LEFT OUTER JOIN I_CapacityText AS _ReferencedCapacityText ON ReferencedCapacityInternalID = _ReferencedCapacityText.CapacityInternalID  -- association [0..*]
LEFT OUTER JOIN I_CapacityCategory AS _CapacityCategory ON CapacityCategoryCode = _CapacityCategory.CapacityCategoryCode  -- association [1..1]
LEFT OUTER JOIN I_CapacityRespPlanner AS _CapacityResponsiblePlanner ON CapacityResponsiblePlanner = _CapacityResponsiblePlanner.CapacityResponsiblePlanner  -- association [0..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON FactoryCalendar = _FactoryCalendar.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_ShiftGrouping AS _ShiftGrouping ON ShiftGroup = _ShiftGrouping.ShiftGrouping  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CapacityQuantityUnit ON CapacityQuantityUnit = _CapacityQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CapacityBaseQtyUnit ON CapacityBaseQtyUnit = _CapacityBaseQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Capacity AS _Capacity ON ReferencedCapacityInternalID = _Capacity.CapacityInternalID  -- association [0..1]
LEFT OUTER JOIN I_CapacityBySemanticKey AS _CapacityBySemanticKey ON Plant = _CapacityBySemanticKey.Plant AND Capacity = _CapacityBySemanticKey.Capacity  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ResourceTimeBufferUnit ON ResourceTimeBufferUnit = _ResourceTimeBufferUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RsceMaxOverlapDurationUnit ON ResourceMaxOverlapDurationUnit = _RsceMaxOverlapDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RsceStorageQuantityUnit ON RsceStorageQuantityUnit = _RsceStorageQuantityUnit.UnitOfMeasure  -- association [0..1]
;