C_AllocationFileUpload

DDL: C_ALLOCATIONFILEUPLOAD SQL: CALLOCFILEUPLOAD Type: view CONSUMPTION

File content from Alloc. Excel upload

C_AllocationFileUpload is a Consumption CDS View that provides data about "File content from Alloc. Excel upload" in SAP S/4HANA. It reads from 1 data source (I_AllocationFileUploadTP) and exposes 12 fields with key field UploadUUID. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AllocationFileUploadTP I_AllocationFileUploadTP from

Associations (7)

CardinalityTargetAliasCondition
[0..*] C_AllocationCycleUpload _Cycle $projection.UploadUUID = _Cycle.UploadUUID
[0..*] C_AllocationSegmentUpload _Segment $projection.UploadUUID = _Segment.UploadUUID
[0..*] C_AllocationSenderUpload _Sender $projection.UploadUUID = _Sender.UploadUUID
[0..*] C_AllocationSenderBasisUpload _SenderBasis $projection.UploadUUID = _SenderBasis.UploadUUID
[0..*] C_AllocationReceiverUpload _Receiver $projection.UploadUUID = _Receiver.UploadUUID
[0..*] C_AllocationReceiverBasisUpld _ReceiverBasis $projection.UploadUUID = _ReceiverBasis.UploadUUID
[0..*] C_AllocFieldDerivationUpload _FieldDerivation $projection.UploadUUID = _FieldDerivation.UploadUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CALLOCFILEUPLOAD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label File content from Alloc. Excel upload view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey UploadUUID view
ObjectModel.semanticKey AllocationUploadName view
ObjectModel.draftEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.viewType #CONSUMPTION view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY UploadUUID UploadUUID Upload GUID
AllocationUploadName AllocationUploadName
UploadFileContentBinary UploadFileContentBinary Source File of Memo Records
UploadedByUser UploadedByUser Uploaded By
UploadCreationDateTime UploadCreationDateTime Time Stamp
_Cycle _Cycle
_Segment _Segment
_Sender _Sender
_SenderBasis _SenderBasis
_Receiver _Receiver
_ReceiverBasis _ReceiverBasis
_FieldDerivation _FieldDerivation

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 C_AllocationFileUpload.
-- 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: CALLOCFILEUPLOAD

CREATE VIEW C_AllocationFileUpload AS
SELECT
  UploadUUID,
  AllocationUploadName,
  UploadFileContentBinary,
  UploadedByUser,
  UploadCreationDateTime
FROM I_AllocationFileUploadTP
LEFT OUTER JOIN C_AllocationCycleUpload AS _Cycle ON UploadUUID = _Cycle.UploadUUID  -- association [0..*]
LEFT OUTER JOIN C_AllocationSegmentUpload AS _Segment ON UploadUUID = _Segment.UploadUUID  -- association [0..*]
LEFT OUTER JOIN C_AllocationSenderUpload AS _Sender ON UploadUUID = _Sender.UploadUUID  -- association [0..*]
LEFT OUTER JOIN C_AllocationSenderBasisUpload AS _SenderBasis ON UploadUUID = _SenderBasis.UploadUUID  -- association [0..*]
LEFT OUTER JOIN C_AllocationReceiverUpload AS _Receiver ON UploadUUID = _Receiver.UploadUUID  -- association [0..*]
LEFT OUTER JOIN C_AllocationReceiverBasisUpld AS _ReceiverBasis ON UploadUUID = _ReceiverBasis.UploadUUID  -- association [0..*]
LEFT OUTER JOIN C_AllocFieldDerivationUpload AS _FieldDerivation ON UploadUUID = _FieldDerivation.UploadUUID  -- association [0..*]
;