P_AllocRunReferenceResult

DDL: P_ALLOCRUNREFERENCERESULT SQL: PALLOCNREFRES Type: view CONSUMPTION Package: ODATA_RUN_ALLOCATION
9 Fields 1 Data Sources 2 Associations

Allocation Run Reference Result

P_AllocRunReferenceResult is a Consumption CDS View that provides data about "Allocation Run Reference Result" in SAP S/4HANA. It reads from 1 data source (I_AllocRunReferenceMapping) and exposes 9 fields with key fields UniversalAllocationRun, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocationRunReceiverItem. It has 2 associations to related views. Part of development package ODATA_RUN_ALLOCATION.

Data Sources (1)

SourceAliasJoin Type
I_AllocRunReferenceMapping I_AllocRunReferenceMapping from

Associations (2)

CardinalityTargetAliasCondition
[1] C_AllocationRunResult _SourceResult _SourceResult.UniversalAllocationRun = $projection.UniversalAllocationRun and _SourceResult.AllocationCycle = $projection.AllocationCycle and _SourceResult.AllocationCycleStartDate = $projection.AllocationCycleStartDate and _SourceResult.AllocationCycleSegment = $projection.AllocationCycleSegment and _SourceResult.AllocationRunDataCategory = 'R' and _SourceResult.AllocationRunResultItem = $projection.AllocationRunReceiverItem
[1] C_AllocationRunResult _TargetResult _TargetResult.UniversalAllocationRun = $projection.UniversalAllocationRun and _TargetResult.AllocationCycle = $projection.AllocationCycle and _TargetResult.AllocationCycleStartDate = $projection.AllocationCycleStartDate and _TargetResult.AllocationCycleSegment = $projection.AllocationCycleSegment and _TargetResult.AllocationRunDataCategory = 'F' and _TargetResult.AllocationRunResultItem = $projection.AllocationRunReferenceItem

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PALLOCNREFRES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation Run Reference Result view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UniversalAllocationRun UniversalAllocationRun UUID
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY AllocationCycleSegment AllocationCycleSegment Segment Number
KEY AllocationRunReceiverItem AllocationRunReceiverItem Result Pos.
KEY AllocationRunReferenceItem AllocationRunReferenceItem Result Pos.
AllocationRunDataCategory _TargetResult AllocationRunDataCategory
_TargetResult _TargetResult
_SourceResult _SourceResult

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 P_AllocRunReferenceResult.
-- 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.
-- SQL view name: PALLOCNREFRES

CREATE VIEW P_AllocRunReferenceResult AS
SELECT
  UniversalAllocationRun,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationRunReceiverItem,
  AllocationRunReferenceItem,
  _TargetResult.AllocationRunDataCategory AS AllocationRunDataCategory
FROM I_AllocRunReferenceMapping
LEFT OUTER JOIN C_AllocationRunResult AS _SourceResult ON _SourceResult.UniversalAllocationRun = UniversalAllocationRun AND _SourceResult.AllocationCycle = AllocationCycle AND _SourceResult.AllocationCycleStartDate = AllocationCycleStartDate AND _SourceResult.AllocationCycleSegment = AllocationCycleSegment AND _SourceResult.AllocationRunDataCategory = 'R' AND _SourceResult.AllocationRunResultItem = AllocationRunReceiverItem  -- association [1]
LEFT OUTER JOIN C_AllocationRunResult AS _TargetResult ON _TargetResult.UniversalAllocationRun = UniversalAllocationRun AND _TargetResult.AllocationCycle = AllocationCycle AND _TargetResult.AllocationCycleStartDate = AllocationCycleStartDate AND _TargetResult.AllocationCycleSegment = AllocationCycleSegment AND _TargetResult.AllocationRunDataCategory = 'F' AND _TargetResult.AllocationRunResultItem = AllocationRunReferenceItem  -- association [1]
;

Learn More