I_SupplyProtectionTP

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_SupplyProtectionTP.
-- 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_SupplyProtectionTP AS
SELECT
  SupplyProtectionUUID,
  SupplyProtectionName,
  Material,
  _Material.MaterialBaseUnit AS UnitOfMeasure,
  Plant,
  SupProtIsPlanningContextSlsOrd,
  SupProtIsPlanningContextSTO,
  SupProtCharcCatalogType,
  SupProtPlanningPeriodType,
  SupProtPlanningPeriodStartDate,
  SupProtPlanningPeriodEndDate,
  SupProtAutomActivationIsActive,
  SupProtAutomActivationDate,
  SupProtCoreCharc01CtlgPathUUID,
  CoreCharc01CtlgPathIntID,
  cast( '' as charccatalogcharacteristicname ) AS SupProtCoreCharc01Name,
  cast( _ProdAllocCharcText01.ProdAllocCharcCtlgPathDesc as sup_charc_text preserving type ) AS SupProtCoreCharc01Text,
  SupProtCoreCharc01ValueID,
  SupProtCoreCharc02CtlgPathUUID,
  CoreCharc02CtlgPathIntID,
  cast( '' as charccatalogcharacteristicname ) AS SupProtCoreCharc02Name,
  cast( _ProdAllocCharcText02.ProdAllocCharcCtlgPathDesc as sup_charc_text preserving type ) AS SupProtCoreCharc02Text,
  SupProtCoreCharc02ValueID,
  SupProtLifecycleStatus,
  SupProtProtectedQuantity,
  SupProtConsumedQuantity,
  SupProtRemainingProtectedQty,
  CreatedByUser,
  CreationDateTime,
  cast(tstmp_to_dats( cast( CreationDateTime as abap.dec(15,0) ), 'UTC', $session.client, 'NULL' ) as sup_creation_date preserving type ) AS CreationDate,
  LastChangedByUser,
  LastChangeDateTime,
  cast(tstmp_to_dats( cast( LastChangeDateTime as abap.dec(15,0) ), 'UTC', $session.client, 'NULL' ) as sup_last_change_date preserving type ) AS LastChangeDate,
  CharcValAuthznGroup,
  SupplyProtectionIsBlocked,
  DraftLastChangedDateTime,
  SupProtActivationDate,
  SupProtCnsmpnDateTimeType,
  SupProtSelfRestrictionType,
  cast(' ' as sup_plngcontext_consistent preserving type ) AS SupProtPlngContextIsConsistent,
  cast(0 as sup_plngcontext_criticality preserving type ) AS SupProtPlngContextCriticality,
  StorageLocation,
  PoolSegment,
  SupProtPlanningLevel
FROM I_SupplyProtection
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [1..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON UnitOfMeasure = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_SupProtLifecycleStatus AS _SupProtLifecycleStatus ON SupProtLifecycleStatus = _SupProtLifecycleStatus.SupProtLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_SupProtLifecycleStatusText AS _SupProtLifecycleStatusText ON SupProtLifecycleStatus = _SupProtLifecycleStatusText.SupProtLifecycleStatus  -- association [0..*]
LEFT OUTER JOIN I_SupProtPlanningPeriodType AS _SupProtPlanningPeriodType ON SupProtPlanningPeriodType = _SupProtPlanningPeriodType.SupProtPlanningPeriodType  -- association [0..1]
LEFT OUTER JOIN I_SupProtPlanningPeriodTypeT AS _SupProtPlanningPeriodTypeT ON SupProtPlanningPeriodType = _SupProtPlanningPeriodTypeT.SupProtPlanningPeriodType  -- association [0..*]
LEFT OUTER JOIN I_SupProtCnsmpnDateTimeType AS _SupProtCnsmpnDateTimeType ON SupProtCnsmpnDateTimeType = _SupProtCnsmpnDateTimeType.SupProtCnsmpnDateTimeType  -- association [0..1]
LEFT OUTER JOIN I_SupProtCnsmpnDateTimeTypeT AS _SupProtCnsmpnDateTimeTypeT ON SupProtCnsmpnDateTimeType = _SupProtCnsmpnDateTimeTypeT.SupProtCnsmpnDateTimeType  -- association [0..*]
LEFT OUTER JOIN I_SupProtSelfRestrictionType AS _SupProtSelfRestrictionType ON SupProtSelfRestrictionType = _SupProtSelfRestrictionType.SupProtSelfRestrictionType  -- association [0..1]
LEFT OUTER JOIN I_SupProtSelfRestrictionTypeT AS _SupProtSelfRestrictionTypeT ON SupProtSelfRestrictionType = _SupProtSelfRestrictionTypeT.SupProtSelfRestrictionType  -- association [0..*]
LEFT OUTER JOIN I_SupProtRelatedSupProtTP AS _SupProtRelatedSupProtTP ON Material = _SupProtRelatedSupProtTP.Material AND Plant = _SupProtRelatedSupProtTP.Plant AND SupProtPlanningLevel = _SupProtRelatedSupProtTP.SupProtPlanningLevel AND StorageLocation = _SupProtRelatedSupProtTP.StorageLocation AND PoolSegment = _SupProtRelatedSupProtTP.PoolSegment AND SupplyProtectionUUID <> _SupProtRelatedSupProtTP.SupplyProtectionUUID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocCharcText AS _ProdAllocCharcText01 ON _ProdAllocCharcText01.ProdAllocCharcCtlgPathIntID = CoreCharc01CtlgPathIntID AND _ProdAllocCharcText01.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcText AS _ProdAllocCharcText02 ON _ProdAllocCharcText02.ProdAllocCharcCtlgPathIntID = CoreCharc02CtlgPathIntID AND _ProdAllocCharcText02.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_SupProtPlanningLevel AS _SupProtPlanningLevel ON SupProtPlanningLevel = _SupProtPlanningLevel.SupProtPlanningLevel  -- association [0..1]
LEFT OUTER JOIN I_SupProtPlanningLevelText AS _SupProtPlanningLevelText ON SupProtPlanningLevel = _SupProtPlanningLevelText.SupProtPlanningLevel  -- association [0..*]
LEFT OUTER JOIN E_SupAvailabilityProtPlan AS _Extension ON SupplyProtectionUUID = _Extension.SupplyProtectionUUID  -- association [0..1]
LEFT OUTER JOIN I_SupProtCharacteristicTP AS _SupProtCharacteristicTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SupplyProtectionGroupTP AS _SupplyProtectionGroupTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SupProtFlexibleTimeBucketTP AS _SupProtFlexibleTimeBucketTP ON /* condition not available in parsed metadata */  -- association [0..*]
;