I_SupplyProtection

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_SupplyProtection.
-- 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_SupplyProtection AS
SELECT
  uuid AS SupplyProtectionUUID,
  Material,
  Plant,
  name AS SupplyProtectionName,
  status AS SupProtLifecycleStatus,
  planningperiodtype AS SupProtPlanningPeriodType,
  planningperiodstart AS SupProtPlanningPeriodStartDate,
  planningperiodend AS SupProtPlanningPeriodEndDate,
  corecharc01catalogpathuuid AS SupProtCoreCharc01CtlgPathUUID,
  corecharc01catalogpathid AS CoreCharc01CtlgPathIntID,
  corecharc01value AS SupProtCoreCharc01ValueID,
  corecharc02catalogpathuuid AS SupProtCoreCharc02CtlgPathUUID,
  corecharc02catalogpathid AS CoreCharc02CtlgPathIntID,
  corecharc02value AS SupProtCoreCharc02ValueID,
  planningcontextso AS SupProtIsPlanningContextSlsOrd,
  planningcontextsto AS SupProtIsPlanningContextSTO,
  catalogtype AS SupProtCharcCatalogType,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  CharcValAuthznGroup,
  last_changed_at AS DraftLastChangedDateTime,
  blocked AS SupplyProtectionIsBlocked,
  autoactivation AS SupProtAutomActivationIsActive,
  autoactivationdate AS SupProtAutomActivationDate,
  activationdate AS SupProtActivationDate,
  cast('' as abap.unit(3) ) AS UnitOfMeasure,
  cast(0 as sup_protected_quantity ) AS SupProtProtectedQuantity,
  cast(0 as sup_consumed_quantity ) AS SupProtConsumedQuantity,
  cast(0 as sup_remaining_quantity ) AS SupProtRemainingProtectedQty,
  StorageLocation,
  PoolSegment,
  Batch,
  case planningperiodtimezone when '' then 'Etc/UTC' else cast( supprotplanningperiodiana as abap.char(64) ) end as SupProtPlngPeriodTmznIANACode AS char64endasSupProtPlngPeriodTmznIANACode
FROM sup_object
LEFT OUTER JOIN I_SupProtCharacteristic AS _SupProtCharacteristic ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SupplyProtectionGroup AS _SupplyProtectionGroup ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_SupProtFlexibleTimeBucket AS _SupProtFlexibleTimeBucket ON /* condition not available in parsed metadata */  -- association [0..*]
;