I_SupplyProtectionGroup

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_SupplyProtectionGroup.
-- 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_SupplyProtectionGroup AS
SELECT
  uuid AS SupplyProtectionGroupUUID,
  supobjectuuid AS SupplyProtectionUUID,
  charc01catalogpathuuid AS SupProtCharc01CtlgPathUUID,
  charc01catalogpathid AS SupProtCharc01CtlgPathIntID,
  characteristic01 AS SupProtCharc01ValueID,
  charc02catalogpathuuid AS SupProtCharc02CtlgPathUUID,
  charc02catalogpathid AS SupProtCharc02CtlgPathIntID,
  characteristic02 AS SupProtCharc02ValueID,
  charc03catalogpathuuid AS SupProtCharc03CtlgPathUUID,
  charc03catalogpathid AS SupProtCharc03CtlgPathIntID,
  characteristic03 AS SupProtCharc03ValueID,
  charc04catalogpathuuid AS SupProtCharc04CtlgPathUUID,
  charc04catalogpathid AS SupProtCharc04CtlgPathIntID,
  characteristic04 AS SupProtCharc04ValueID,
  charc05catalogpathuuid AS SupProtCharc05CtlgPathUUID,
  charc05catalogpathid AS SupProtCharc05CtlgPathIntID,
  characteristic05 AS SupProtCharc05ValueID,
  charc06catalogpathuuid AS SupProtCharc06CtlgPathUUID,
  charc06catalogpathid AS SupProtCharc06CtlgPathIntID,
  characteristic06 AS SupProtCharc06ValueID,
  charc07catalogpathuuid AS SupProtCharc07CtlgPathUUID,
  charc07catalogpathid AS SupProtCharc07CtlgPathIntID,
  characteristic07 AS SupProtCharc07ValueID,
  charc08catalogpathuuid AS SupProtCharc08CtlgPathUUID,
  charc08catalogpathid AS SupProtCharc08CtlgPathIntID,
  characteristic08 AS SupProtCharc08ValueID,
  charc09catalogpathuuid AS SupProtCharc09CtlgPathUUID,
  charc09catalogpathid AS SupProtCharc09CtlgPathIntID,
  characteristic09 AS SupProtCharc09ValueID,
  charc10catalogpathuuid AS SupProtCharc10CtlgPathUUID,
  charc10catalogpathid AS SupProtCharc10CtlgPathIntID,
  characteristic10 AS SupProtCharc10ValueID,
  cvcpriority AS SupProtGroupPriorityValue,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  CharcValAuthznGroup,
  blocked AS SupplyProtectionGroupIsBlocked,
  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,
  _SupplyProtectionTP.Plant AS Plant
FROM sup_cvc
LEFT OUTER JOIN I_SupplyProtectionTimeBucket AS _SupplyProtectionTimeBucketTP ON /* condition not available in parsed metadata */  -- association [0..*]
;