I_ARunSupProtCnsmpn

DDL: I_ARUNSUPPROTCNSMPN Type: view BASIC Package: VDM_ARUN_ANALYTICS
18 Fields 2 Data Sources

Supply Protection Consumption Details

I_ARunSupProtCnsmpn is a Basic CDS View that provides data about "Supply Protection Consumption Details" in SAP S/4HANA. It reads from 2 data sources (I_SupDmndMaterialPlant, sup_object) and exposes 18 fields with key field SupProtPermConsumptionUUID. Part of development package VDM_ARUN_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
I_SupDmndMaterialPlant MaterialPlant inner
sup_object SupProt from

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.sqlViewName IARUNSUPPROTCNS 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 Consumption Details view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY SupProtPermConsumptionUUID SupProtCnsmpn SupProtPermConsumptionUUID
SupProtTimeBucketUUID SupProtTimeBucket SupProtTimeBucketUUID
SupplyProtectionName sup_object name Zone name
Material sup_object material Vehicle Model
Plant sup_object plant Valuation Area
RequirementType
clientNULLasvdm_v_start_dateasStartDate
clientNULLasvdm_v_end_dateasEndDate
BaseUnit SupProtCnsmpn SupProtConsumedQuantityUnit
SupProtConsumedQuantity SupProtCnsmpn SupProtConsumedQuantity Consumed Quantity
SupProtAssignedDocument SupProtAssignedDocument Requirement Document Number
SupProtAssignedDocumentItem SupProtAssignedDocumentItem Requirement Document Item
SupplyProtectionDocumentType SupplyProtectionDocumentType Requirement Type
MaterialGroup MaterialGroup Product Group
MaterialType MaterialType Material Type
CrossPlantConfigurableProduct CrossPlantConfigurableProduct Cross-plant CP
SupplyProtectionUUID sup_object uuid Waste Partner UUID
SupplyProtectionGroupUUID SupProtGroup uuid Waste Partner UUID

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_ARunSupProtCnsmpn.
-- 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_ARunSupProtCnsmpn AS
SELECT
  SupProtCnsmpn.SupProtPermConsumptionUUID AS SupProtPermConsumptionUUID,
  SupProtTimeBucket.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  SupProt.name AS SupplyProtectionName,
  SupProt.material AS Material,
  SupProt.plant AS Plant,
  'SP' AS RequirementType,
  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,
  SupProtCnsmpn.SupProtConsumedQuantityUnit AS BaseUnit,
  SupProtCnsmpn.SupProtConsumedQuantity AS SupProtConsumedQuantity,
  SupProtAssignedDocument,
  SupProtAssignedDocumentItem,
  SupplyProtectionDocumentType,
  MaterialGroup,
  MaterialType,
  CrossPlantConfigurableProduct,
  SupProt.uuid AS SupplyProtectionUUID,
  SupProtGroup.uuid AS SupplyProtectionGroupUUID
FROM sup_object AS SupProt
INNER JOIN I_SupDmndMaterialPlant AS MaterialPlant ON /* join condition not captured in parsed metadata */
;

Learn More