I_SupplyProtectionGroupTP

DDL: I_SUPPLYPROTECTIONGROUPTP Type: view_entity TRANSACTIONAL
53 Fields 1 Data Sources 3 Associations

Supply Protection Group

I_SupplyProtectionGroupTP is a Transactional CDS View that provides data about "Supply Protection Group" in SAP S/4HANA. It reads from 1 data source (I_SupplyProtectionGroup) and exposes 53 fields with key field SupplyProtectionGroupUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SupplyProtectionGroup I_SupplyProtectionGroup from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_SupProtTimeBucketCnsmpnTP _SupProtTimeBucketCnsmpnTP $projection.SupplyProtectionGroupUUID = _SupProtTimeBucketCnsmpnTP.SupplyProtectionGroupUUID
[0..*] I_SupProtTimeBucketChart _SupProtTimeBucketChart $projection.SupplyProtectionGroupUUID = _SupProtTimeBucketChart.SupplyProtectionGroupUUID
[0..*] I_SupplyProtectionTimeBucketTP _SupplyProtectionTimeBucketTP

Annotations (7)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Supply Protection Group view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY SupplyProtectionGroupUUID SupplyProtectionGroupUUID CVC UUID
SupplyProtectionUUID SupplyProtectionUUID UUID
SupProtCharc01CtlgPathUUID SupProtCharc01CtlgPathUUID Catalog Path UUID
SupProtCharc01CtlgPathIntID SupProtCharc01CtlgPathIntID Catalog Path Int. ID
SupProtCoreCharc01Text
SupProtCharc01ValueID SupProtCharc01ValueID Characteristic Value
SupProtCharc02CtlgPathUUID SupProtCharc02CtlgPathUUID Catalog Path UUID
SupProtCharc02CtlgPathIntID SupProtCharc02CtlgPathIntID Catalog Path Int. ID
SupProtCoreCharc02Text
SupProtCharc02ValueID SupProtCharc02ValueID Characteristic Value
SupProtCharc03CtlgPathUUID SupProtCharc03CtlgPathUUID Catalog Path UUID
SupProtCharc03CtlgPathIntID SupProtCharc03CtlgPathIntID Catalog Path Int. ID
SupProtCharc03ValueID SupProtCharc03ValueID Characteristic Value
SupProtCharc04CtlgPathUUID SupProtCharc04CtlgPathUUID Catalog Path UUID
SupProtCharc04CtlgPathIntID SupProtCharc04CtlgPathIntID Catalog Path Int. ID
SupProtCharc04ValueID SupProtCharc04ValueID Characteristic Value
SupProtCharc05CtlgPathUUID SupProtCharc05CtlgPathUUID Catalog Path UUID
SupProtCharc05CtlgPathIntID SupProtCharc05CtlgPathIntID Catalog Path Int. ID
SupProtCharc05ValueID SupProtCharc05ValueID Characteristic Value
SupProtCharc06CtlgPathUUID SupProtCharc06CtlgPathUUID Catalog Path UUID
SupProtCharc06CtlgPathIntID SupProtCharc06CtlgPathIntID Catalog Path Int. ID
SupProtCharc06ValueID SupProtCharc06ValueID Characteristic Value
SupProtCharc07CtlgPathUUID SupProtCharc07CtlgPathUUID Catalog Path UUID
SupProtCharc07CtlgPathIntID SupProtCharc07CtlgPathIntID Catalog Path Int. ID
SupProtCharc07ValueID SupProtCharc07ValueID Characteristic Value
SupProtCharc08CtlgPathUUID SupProtCharc08CtlgPathUUID Catalog Path UUID
SupProtCharc08CtlgPathIntID SupProtCharc08CtlgPathIntID Catalog Path Int. ID
SupProtCharc08ValueID SupProtCharc08ValueID Characteristic Value
SupProtCharc09CtlgPathUUID SupProtCharc09CtlgPathUUID Catalog Path UUID
SupProtCharc09CtlgPathIntID SupProtCharc09CtlgPathIntID Catalog Path Int. ID
SupProtCharc09ValueID SupProtCharc09ValueID Characteristic Value
SupProtCharc10CtlgPathUUID SupProtCharc10CtlgPathUUID Catalog Path UUID
SupProtCharc10CtlgPathIntID SupProtCharc10CtlgPathIntID Catalog Path Int. ID
SupProtCharc10ValueID SupProtCharc10ValueID Characteristic Value
SupProtGroupPriorityValue SupProtGroupPriorityValue Priority
UnitOfMeasure _SupplyProtectionTP UnitOfMeasure Unit Protected Qty
UnitOfMeasureISOCode _SupplyProtectionTP UnitOfMeasureISOCode
SupProtProtectedQuantity SupProtProtectedQuantity Protected Quantity
SupProtConsumedQuantity SupProtConsumedQuantity Consumed Quantity
SupProtRemainingProtectedQty SupProtRemainingProtectedQty Remaining Protection
CharcValAuthznGroup CharcValAuthznGroup Authorization Group
CharcValAuthznGroupIsAllowed
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
SupplyProtectionGroupIsBlocked SupplyProtectionGroupIsBlocked Complaint Locked
Plant _SupplyProtectionTP Plant Valuation Area
_SupplyProtectionTimeBucketTP _SupplyProtectionTimeBucketTP
_SupplyProtectionTP _SupplyProtectionTP
_SupProtTimeBucketCnsmpnTP _SupProtTimeBucketCnsmpnTP
_SupProtTimeBucketChart _SupProtTimeBucketChart
_BaseUnit _SupplyProtectionTP _BaseUnit

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_SupplyProtectionGroupTP.
-- 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_SupplyProtectionGroupTP AS
SELECT
  SupplyProtectionGroupUUID,
  SupplyProtectionUUID,
  SupProtCharc01CtlgPathUUID,
  SupProtCharc01CtlgPathIntID,
  cast( '' as sup_charc_text ) AS SupProtCoreCharc01Text,
  SupProtCharc01ValueID,
  SupProtCharc02CtlgPathUUID,
  SupProtCharc02CtlgPathIntID,
  cast( '' as sup_charc_text ) AS SupProtCoreCharc02Text,
  SupProtCharc02ValueID,
  SupProtCharc03CtlgPathUUID,
  SupProtCharc03CtlgPathIntID,
  SupProtCharc03ValueID,
  SupProtCharc04CtlgPathUUID,
  SupProtCharc04CtlgPathIntID,
  SupProtCharc04ValueID,
  SupProtCharc05CtlgPathUUID,
  SupProtCharc05CtlgPathIntID,
  SupProtCharc05ValueID,
  SupProtCharc06CtlgPathUUID,
  SupProtCharc06CtlgPathIntID,
  SupProtCharc06ValueID,
  SupProtCharc07CtlgPathUUID,
  SupProtCharc07CtlgPathIntID,
  SupProtCharc07ValueID,
  SupProtCharc08CtlgPathUUID,
  SupProtCharc08CtlgPathIntID,
  SupProtCharc08ValueID,
  SupProtCharc09CtlgPathUUID,
  SupProtCharc09CtlgPathIntID,
  SupProtCharc09ValueID,
  SupProtCharc10CtlgPathUUID,
  SupProtCharc10CtlgPathIntID,
  SupProtCharc10ValueID,
  SupProtGroupPriorityValue,
  _SupplyProtectionTP.UnitOfMeasure AS UnitOfMeasure,
  _SupplyProtectionTP.UnitOfMeasureISOCode AS UnitOfMeasureISOCode,
  SupProtProtectedQuantity,
  SupProtConsumedQuantity,
  SupProtRemainingProtectedQty,
  CharcValAuthznGroup,
  'X' AS CharcValAuthznGroupIsAllowed,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  SupplyProtectionGroupIsBlocked,
  _SupplyProtectionTP.Plant AS Plant,
  _SupplyProtectionTP._BaseUnit AS _BaseUnit
FROM I_SupplyProtectionGroup
LEFT OUTER JOIN I_SupProtTimeBucketCnsmpnTP AS _SupProtTimeBucketCnsmpnTP ON SupplyProtectionGroupUUID = _SupProtTimeBucketCnsmpnTP.SupplyProtectionGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_SupProtTimeBucketChart AS _SupProtTimeBucketChart ON SupplyProtectionGroupUUID = _SupProtTimeBucketChart.SupplyProtectionGroupUUID  -- association [0..*]
LEFT OUTER JOIN I_SupplyProtectionTimeBucketTP AS _SupplyProtectionTimeBucketTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More