R_UnivAllocationReceiverUpload

DDL: R_UNIVALLOCATIONRECEIVERUPLOAD Type: view_entity COMPOSITE
18 Fields 1 Data Sources 3 Associations

Receiver data from Alloc Excel Upload

R_UnivAllocationReceiverUpload is a Composite CDS View that provides data about "Receiver data from Alloc Excel Upload" in SAP S/4HANA. It reads from 1 data source (I_UnivAllocationReceiverUpload) and exposes 18 fields with key fields UploadUUID, AllocationUploadRowUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_UnivAllocationReceiverUpload I_UnivAllocationReceiverUpload from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UnivAllocationFileUpload _Upload $projection.UploadUUID = _Upload.UploadUUID
[0..1] I_AllocationContextType _Context $projection.AllocationType = _Context.AllocationType
[0..*] I_LedgerText _LedgerText $projection.Ledger = _LedgerText.Ledger

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Receiver data from Alloc Excel Upload view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY UploadUUID UploadUUID Upload GUID
KEY AllocationUploadRowUUID AllocationUploadRowUUID Row GUID
RowIndex RowIndex Row index
AllocationCycle AllocationCycle Cycle
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationType AllocationType Table
Ledger Ledger Ledger
AllocationCycleStartDate AllocationCycleStartDate Valid From
AllocationCycleSegment AllocationCycleSegment Segment Number
AllocationFieldName AllocationFieldName Field
AllocationFieldText AllocationFieldText Long Text
AllocationFieldMinimumValue AllocationFieldMinimumValue From Value
AllocationFieldMaximumValue AllocationFieldMaximumValue To Value
AllocationSetId AllocationSetId Group ID
UploadedByUser _Upload UploadedByUser Uploaded By
UploadCreationDateTime _Upload UploadCreationDateTime Time Stamp
_Context _Context
_LedgerText _LedgerText

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_UnivAllocationReceiverUpload.
-- 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_UnivAllocationReceiverUpload AS
SELECT
  UploadUUID,
  AllocationUploadRowUUID,
  RowIndex,
  AllocationCycle,
  AllocationCycleName,
  AllocationType,
  Ledger,
  AllocationCycleStartDate,
  AllocationCycleSegment,
  AllocationFieldName,
  AllocationFieldText,
  AllocationFieldMinimumValue,
  AllocationFieldMaximumValue,
  AllocationSetId,
  _Upload.UploadedByUser AS UploadedByUser,
  _Upload.UploadCreationDateTime AS UploadCreationDateTime
FROM I_UnivAllocationReceiverUpload
LEFT OUTER JOIN I_UnivAllocationFileUpload AS _Upload ON UploadUUID = _Upload.UploadUUID  -- association [0..1]
LEFT OUTER JOIN I_AllocationContextType AS _Context ON AllocationType = _Context.AllocationType  -- association [0..1]
LEFT OUTER JOIN I_LedgerText AS _LedgerText ON Ledger = _LedgerText.Ledger  -- association [0..*]
;

Learn More