What is I_ARunSupplyProtection in SAP S/4HANA?

I_ARunSupplyProtection is a basic CDS view in SAP S/4HANA. Supply Protection relevant for Supply Assignment It contains 49 fields.

Which tables does I_ARunSupplyProtection read from?

I_ARunSupplyProtection reads data from: I_SupDmndMaterialPlant, sup_object.

What VDM layer is I_ARunSupplyProtection?

I_ARunSupplyProtection is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ARunSupplyProtection

DDL: I_ARUNSUPPLYPROTECTION Type: view BASIC Package: VDM_ARUN_ANALYTICS

49 Fields 2 Data Sources 11 Associations

Supply Protection relevant for Supply Assignment

I_ARunSupplyProtection is a Basic CDS View that provides data about "Supply Protection relevant for Supply Assignment" in SAP S/4HANA. It reads from 2 data sources (I_SupDmndMaterialPlant, sup_object) and exposes 49 fields with key field SupProtTimeBucketUUID. It has 11 associations to related views. Part of development package VDM_ARUN_ANALYTICS.

Data Sources (2)

Source	Alias	Join Type
I_SupDmndMaterialPlant	MaterialPlant	inner
sup_object	SupProt	from

Associations (11)

Cardinality	Target	Alias	Condition
[0..1]	I_SupProtTimeBucketSum	_SupProtTimeBucketSum	`$projection.SupProtTimeBucketUUID = _SupProtTimeBucketSum.SupProtTimeBucketUUID`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc01	`$projection.SupProtCharc01CtlgPathUUID = _SupProtCharc01.ProdAllocCharcCtlgPathUUID and _SupProtCharc01.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc01.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc02	`$projection.SupProtCharc02CtlgPathUUID = _SupProtCharc02.ProdAllocCharcCtlgPathUUID and _SupProtCharc02.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc02.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc03	`$projection.SupProtCharc03CtlgPathUUID = _SupProtCharc03.ProdAllocCharcCtlgPathUUID and _SupProtCharc03.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc03.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc04	`$projection.SupProtCharc04CtlgPathUUID = _SupProtCharc04.ProdAllocCharcCtlgPathUUID and _SupProtCharc04.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc04.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc05	`$projection.SupProtCharc05CtlgPathUUID = _SupProtCharc05.ProdAllocCharcCtlgPathUUID and _SupProtCharc05.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc05.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc06	`$projection.SupProtCharc06CtlgPathUUID = _SupProtCharc06.ProdAllocCharcCtlgPathUUID and _SupProtCharc06.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc06.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc07	`$projection.SupProtCharc07CtlgPathUUID = _SupProtCharc07.ProdAllocCharcCtlgPathUUID and _SupProtCharc07.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc07.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc08	`$projection.SupProtCharc08CtlgPathUUID = _SupProtCharc08.ProdAllocCharcCtlgPathUUID and _SupProtCharc08.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc08.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc09	`$projection.SupProtCharc09CtlgPathUUID = _SupProtCharc09.ProdAllocCharcCtlgPathUUID and _SupProtCharc09.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc09.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`
[1..1]	I_ProdAllocCharcCatalogPath	_SupProtCharc10	`$projection.SupProtCharc10CtlgPathUUID = _SupProtCharc10.ProdAllocCharcCtlgPathUUID and _SupProtCharc10.ABAPDataElement = 'SGT_RCAT' and _SupProtCharc10.ProdAllocCharcCatalogUseType = '05' and MaterialPlant.SegmentationStrategy is not initial`

Annotations (11)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
AbapCatalog.sqlViewName	IARUNSUPPROT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
EndUserText.label	Supply Protection relevant for Supply Assignment	view

Fields (49)

Key	Field	Source Table	Source Field	Description
KEY	SupProtTimeBucketUUID	SupProtTimeBucket	SupProtTimeBucketUUID
	SupplyProtectionName	sup_object	name	Zone name
	Material	sup_object	material	Vehicle Model
	Plant	sup_object	plant	Valuation Area
	SupProtLifecycleStatus	sup_object	status	Workflow Status
	clientNULLasvdm_v_start_dateasStartDate
	clientNULLasvdm_v_end_dateasEndDate
	SupProtProtectedQuantity	SupProtTimeBucket	SupProtProtectedQuantity	Protected Quantity
	SupProtConsumedQuantity	_SupProtTimeBucketSum	SupProtConsumedQuantity	Consumed Quantity
	BaseUnit	SupProtTimeBucket	UnitOfMeasure	Unit Protected Qty
	RequirementType
	MaterialGroup	I_SupDmndMaterialPlant	MaterialGroup	Product Group
	MaterialType	I_SupDmndMaterialPlant	MaterialType	Material Type
	CrossPlantConfigurableProduct	I_SupDmndMaterialPlant	CrossPlantConfigurableProduct	Cross-plant CP
	SegmentationStrategy	I_SupDmndMaterialPlant	SegmentationStrategy	Segment. Strategy
	SegmentationStrategyScope	I_SupDmndMaterialPlant	SegmentationStrategyScope	Seg. Scope
	SupplyProtectionUUID	sup_object	uuid	Waste Partner UUID
	SupplyProtectionGroupUUID	SupProtGroup	uuid	Waste Partner UUID
	SupProtGroupPriorityValue	SupProtGroup	cvcpriority	Priority
	SupProtCharc01CtlgPathUUID		charc01catalogpathuuid	Catalog Path UUID
	SupProtCharc01CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc01ValueID		characteristic01	Characteristic Value
	SupProtCharc02CtlgPathUUID		charc02catalogpathuuid	Catalog Path UUID
	SupProtCharc02CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc02ValueID		characteristic02	Characteristic Value
	SupProtCharc03CtlgPathUUID		charc03catalogpathuuid	Catalog Path UUID
	SupProtCharc03CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc03ValueID		characteristic03	Characteristic Value
	SupProtCharc04CtlgPathUUID		charc04catalogpathuuid	Catalog Path UUID
	SupProtCharc04CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc04ValueID		characteristic04	Characteristic Value
	SupProtCharc05CtlgPathUUID		charc05catalogpathuuid	Catalog Path UUID
	SupProtCharc05CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc05ValueID		characteristic05	Characteristic Value
	SupProtCharc06CtlgPathUUID		charc06catalogpathuuid	Catalog Path UUID
	SupProtCharc06CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc06ValueID		characteristic06	Characteristic Value
	SupProtCharc07CtlgPathUUID		charc07catalogpathuuid	Catalog Path UUID
	SupProtCharc07CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc07ValueID		characteristic07	Characteristic Value
	SupProtCharc08CtlgPathUUID		charc08catalogpathuuid	Catalog Path UUID
	SupProtCharc08CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc08ValueID		characteristic08	Characteristic Value
	SupProtCharc09CtlgPathUUID		charc09catalogpathuuid	Catalog Path UUID
	SupProtCharc09CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc09ValueID		characteristic09	Characteristic Value
	SupProtCharc10CtlgPathUUID		charc10catalogpathuuid	Catalog Path UUID
	SupProtCharc10CtlgPathIntID	SupProtGroup	charc01catalogpathid	Catalog Path Int. ID
	SupProtCharc10ValueID		characteristic10	Characteristic Value

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_ARunSupplyProtection.
-- 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_ARunSupplyProtection AS
SELECT
  SupProtTimeBucket.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  SupProt.name AS SupplyProtectionName,
  SupProt.material AS Material,
  SupProt.plant AS Plant,
  SupProt.status AS SupProtLifecycleStatus,
  cast(tstmp_to_dats( SupProtTimeBucket.SupProtPeriodStartUTCDateTime, 'UTC', $session.client, 'NULL' ) as vdm_v_start_date) as StartDate AS clientNULLasvdm_v_start_dateasStartDate,
  cast(tstmp_to_dats( SupProtTimeBucket.SupProtPeriodEndUTCDateTime,'UTC', $session.client, 'NULL' ) as vdm_v_end_date) as EndDate AS clientNULLasvdm_v_end_dateasEndDate,
  SupProtTimeBucket.SupProtProtectedQuantity AS SupProtProtectedQuantity,
  _SupProtTimeBucketSum.SupProtConsumedQuantity AS SupProtConsumedQuantity,
  SupProtTimeBucket.UnitOfMeasure AS BaseUnit,
  'SP' AS RequirementType,
  MaterialPlant.MaterialGroup AS MaterialGroup,
  MaterialPlant.MaterialType AS MaterialType,
  MaterialPlant.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  MaterialPlant.SegmentationStrategy AS SegmentationStrategy,
  MaterialPlant.SegmentationStrategyScope AS SegmentationStrategyScope,
  SupProt.uuid AS SupplyProtectionUUID,
  SupProtGroup.uuid AS SupplyProtectionGroupUUID,
  SupProtGroup.cvcpriority AS SupProtGroupPriorityValue,
  charc01catalogpathuuid AS SupProtCharc01CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc01CtlgPathIntID,
  characteristic01 AS SupProtCharc01ValueID,
  charc02catalogpathuuid AS SupProtCharc02CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc02CtlgPathIntID,
  characteristic02 AS SupProtCharc02ValueID,
  charc03catalogpathuuid AS SupProtCharc03CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc03CtlgPathIntID,
  characteristic03 AS SupProtCharc03ValueID,
  charc04catalogpathuuid AS SupProtCharc04CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc04CtlgPathIntID,
  characteristic04 AS SupProtCharc04ValueID,
  charc05catalogpathuuid AS SupProtCharc05CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc05CtlgPathIntID,
  characteristic05 AS SupProtCharc05ValueID,
  charc06catalogpathuuid AS SupProtCharc06CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc06CtlgPathIntID,
  characteristic06 AS SupProtCharc06ValueID,
  charc07catalogpathuuid AS SupProtCharc07CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc07CtlgPathIntID,
  characteristic07 AS SupProtCharc07ValueID,
  charc08catalogpathuuid AS SupProtCharc08CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc08CtlgPathIntID,
  characteristic08 AS SupProtCharc08ValueID,
  charc09catalogpathuuid AS SupProtCharc09CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc09CtlgPathIntID,
  characteristic09 AS SupProtCharc09ValueID,
  charc10catalogpathuuid AS SupProtCharc10CtlgPathUUID,
  SupProtGroup.charc01catalogpathid AS SupProtCharc10CtlgPathIntID,
  characteristic10 AS SupProtCharc10ValueID
FROM sup_object AS SupProt
INNER JOIN I_SupDmndMaterialPlant AS MaterialPlant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupProtTimeBucketSum AS _SupProtTimeBucketSum ON SupProtTimeBucketUUID = _SupProtTimeBucketSum.SupProtTimeBucketUUID  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc01 ON SupProtCharc01CtlgPathUUID = _SupProtCharc01.ProdAllocCharcCtlgPathUUID AND _SupProtCharc01.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc01.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc02 ON SupProtCharc02CtlgPathUUID = _SupProtCharc02.ProdAllocCharcCtlgPathUUID AND _SupProtCharc02.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc02.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc03 ON SupProtCharc03CtlgPathUUID = _SupProtCharc03.ProdAllocCharcCtlgPathUUID AND _SupProtCharc03.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc03.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc04 ON SupProtCharc04CtlgPathUUID = _SupProtCharc04.ProdAllocCharcCtlgPathUUID AND _SupProtCharc04.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc04.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc05 ON SupProtCharc05CtlgPathUUID = _SupProtCharc05.ProdAllocCharcCtlgPathUUID AND _SupProtCharc05.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc05.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc06 ON SupProtCharc06CtlgPathUUID = _SupProtCharc06.ProdAllocCharcCtlgPathUUID AND _SupProtCharc06.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc06.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc07 ON SupProtCharc07CtlgPathUUID = _SupProtCharc07.ProdAllocCharcCtlgPathUUID AND _SupProtCharc07.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc07.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc08 ON SupProtCharc08CtlgPathUUID = _SupProtCharc08.ProdAllocCharcCtlgPathUUID AND _SupProtCharc08.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc08.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc09 ON SupProtCharc09CtlgPathUUID = _SupProtCharc09.ProdAllocCharcCtlgPathUUID AND _SupProtCharc09.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc09.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _SupProtCharc10 ON SupProtCharc10CtlgPathUUID = _SupProtCharc10.ProdAllocCharcCtlgPathUUID AND _SupProtCharc10.ABAPDataElement = 'SGT_RCAT' AND _SupProtCharc10.ProdAllocCharcCatalogUseType = '05' AND MaterialPlant.SegmentationStrategy is not initial  -- association [1..1]
;

Depth:

I_ARunSupplyProtection view

sup_object
I_SupDmndMaterialPlant view