R_UnivAllocReceiverElementTP

DDL: R_UNIVALLOCRECEIVERELEMENTTP Type: view_entity TRANSACTIONAL Package: ODATA_MANAGE_ALLOCATION_V2_RAP
20 Fields 1 Data Sources 1 Associations

Receiver Element Draft

R_UnivAllocReceiverElementTP is a Transactional CDS View that provides data about "Receiver Element Draft" in SAP S/4HANA. It reads from 1 data source (I_UniversalAllocationElement) and exposes 20 fields with key fields AllocationType, AllocationCycle, AllocationCycleStartDate, AllocationCycleSegment, AllocElementSequenceNumber. It has 1 association to related views. Part of development package ODATA_MANAGE_ALLOCATION_V2_RAP.

Data Sources (1)

SourceAliasJoin Type
I_UniversalAllocationElement I_UniversalAllocationElement from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_UniversalAllocationCycleTP _Cycle $projection.AllocationType = _Cycle.AllocationType and $projection.AllocationCycle = _Cycle.AllocationCycle and $projection.AllocationCycleStartDate = _Cycle.AllocationCycleStartDate

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Receiver Element Draft view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY AllocationType AllocationType Table
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
KEY AllocationCycleSegment AllocationCycleSegment Segment Number
KEY AllocElementSequenceNumber AllocElementSequenceNumber Sequence Number
KEY AllocSenderReceiverVariant AllocSenderReceiverVariant Sender Receiver Variant
AllocationElement1 AllocationElement1 Field Value 1
AllocationElement2 AllocationElement2 Field Value 2
AllocationElement3 AllocationElement3 Field Value 3
AllocationElement4 AllocationElement4 Field Value 4
AllocationElement5 AllocationElement5 Field Value 5
AllocationElement6 AllocationElement6 Field Value 6
AllocationElement7 AllocationElement7 Field Value 7
AllocationElement8 AllocationElement8 Field Value 8
AllocationElement9 AllocationElement9 Field Value 9
AllocationElement10 AllocationElement10 Field Value 10
AllocationElementValue AllocationElementValue Value
AllocationCurrency _Segment AllocationCurrency Currency
_Cycle _Cycle
_Segment _Segment

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 R_UnivAllocReceiverElementTP.
-- 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 R_UnivAllocReceiverElementTP AS
SELECT
  AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocElementSequenceNumber,
  AllocSenderReceiverVariant,
  AllocationElement1,
  AllocationElement2,
  AllocationElement3,
  AllocationElement4,
  AllocationElement5,
  AllocationElement6,
  AllocationElement7,
  AllocationElement8,
  AllocationElement9,
  AllocationElement10,
  AllocationElementValue,
  _Segment.AllocationCurrency AS AllocationCurrency
FROM I_UniversalAllocationElement
LEFT OUTER JOIN R_UniversalAllocationCycleTP AS _Cycle ON AllocationType = _Cycle.AllocationType AND AllocationCycle = _Cycle.AllocationCycle AND AllocationCycleStartDate = _Cycle.AllocationCycleStartDate  -- association [1..1]
;

Learn More