I_SupProtRelatedSupProtTP

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_SupProtRelatedSupProtTP.
-- 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.

CREATE VIEW I_SupProtRelatedSupProtTP AS
SELECT
  SupplyProtectionUUID,
  SupplyProtectionName,
  Material,
  Plant,
  SupProtLifecycleStatus,
  _SupProtLifecycleStatusText.SupProtLifecycleStatusText AS SupProtLifecycleStatusText,
  SupProtPlanningPeriodType,
  _SupProtPlanningPeriodTypeText.SupProtPlanningPeriodTypeText AS SupProtPlanningPeriodTypeText,
  SupProtPlanningPeriodStartDate,
  SupProtPlanningPeriodEndDate,
  SupProtCoreCharc01CtlgPathUUID,
  cast( _SupProtCoreCharc01VH.Characteristic as sup_charc_text preserving type ) AS SupProtCoreCharc01Text,
  SupProtCoreCharc01ValueID,
  SupProtCoreCharc02CtlgPathUUID,
  cast( _SupProtCoreCharc02VH.Characteristic as sup_charc_text preserving type ) AS SupProtCoreCharc02Text,
  SupProtCoreCharc02ValueID,
  SupProtIsPlanningContextSlsOrd,
  SupProtIsPlanningContextSTO,
  _Material.MaterialBaseUnit AS UnitOfMeasure,
  SupProtProtectedQuantity,
  SupProtConsumedQuantity,
  SupProtRemainingProtectedQty,
  SupplyProtectionIsBlocked,
  SupProtCnsmpnDateTimeType,
  CharcValAuthznGroup,
  StorageLocation,
  PoolSegment,
  SupProtPlanningLevel
FROM I_SupplyProtection
LEFT OUTER JOIN I_SupProtCharacteristicVH AS _SupProtCoreCharc01VH ON SupProtCoreCharc01CtlgPathUUID = _SupProtCoreCharc01VH.ProdAllocCharcCtlgPathUUID  -- association [1..1]
LEFT OUTER JOIN I_SupProtCharacteristicVH AS _SupProtCoreCharc02VH ON SupProtCoreCharc02CtlgPathUUID = _SupProtCoreCharc02VH.ProdAllocCharcCtlgPathUUID  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON UnitOfMeasure = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SupProtLifecycleStatusText AS _SupProtLifecycleStatusText ON SupProtLifecycleStatus = _SupProtLifecycleStatusText.SupProtLifecycleStatus AND _SupProtLifecycleStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupProtPlanningPeriodTypeT AS _SupProtPlanningPeriodTypeText ON SupProtPlanningPeriodType = _SupProtPlanningPeriodTypeText.SupProtPlanningPeriodType AND _SupProtPlanningPeriodTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupProtCnsmpnDateTimeTypeT AS _SupProtCnsmpnDateTimeTypeT ON SupProtCnsmpnDateTimeType = _SupProtCnsmpnDateTimeTypeT.SupProtCnsmpnDateTimeType  -- association [0..*]
LEFT OUTER JOIN I_SupplyProtectionTP AS _SupplyProtectionTP ON SupplyProtectionUUID = _SupplyProtectionTP.SupplyProtectionUUID  -- association [1..1]
;