I_AllocationFileUploadTP

DDL: I_ALLOCATIONFILEUPLOADTP SQL: ALLOUPFILETP Type: view TRANSACTIONAL Package: MANAGE_ALLOCATION_EXCEL

File upload TP

I_AllocationFileUploadTP is a Transactional CDS View that provides data about "File upload TP" in SAP S/4HANA. It reads from 1 data source (I_AllocationFileUpload) and exposes 12 fields with key field UploadUUID. It has 7 associations to related views. Part of development package MANAGE_ALLOCATION_EXCEL.

Data Sources (1)

SourceAliasJoin Type
I_AllocationFileUpload I_AllocationFileUpload from

Associations (7)

CardinalityTargetAliasCondition
[0..*] I_AllocationCycleUploadTP _Cycle $projection.UploadUUID = _Cycle.UploadUUID
[0..*] I_AllocationSegmentUploadTP _Segment $projection.UploadUUID = _Segment.UploadUUID
[0..*] I_AllocationSenderUploadTP _Sender $projection.UploadUUID = _Sender.UploadUUID
[0..*] I_AllocationReceiverUploadTP _Receiver $projection.UploadUUID = _Receiver.UploadUUID
[0..*] I_AllocFieldDerivationUploadTP _FieldDerivation $projection.UploadUUID = _FieldDerivation.UploadUUID
[0..*] I_AllocationReceiverBsUpldTP _ReceiverBasis $projection.UploadUUID = _ReceiverBasis.UploadUUID
[0..*] I_AllocationSenderBasisUpldTP _SenderBasis $projection.UploadUUID = _SenderBasis.UploadUUID

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName ALLOUPFILETP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label File upload TP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeDraftPersistence ALLOUPFILETPD 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 #TRANSACTIONAL view

Fields (12)

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

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_AllocationFileUploadTP.
-- 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: ALLOUPFILETP

CREATE VIEW I_AllocationFileUploadTP AS
SELECT
  UploadUUID,
  AllocationUploadName,
  UploadFileContentBinary,
  UploadedByUser,
  UploadCreationDateTime
FROM I_AllocationFileUpload
LEFT OUTER JOIN I_AllocationCycleUploadTP AS _Cycle ON UploadUUID = _Cycle.UploadUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocationSegmentUploadTP AS _Segment ON UploadUUID = _Segment.UploadUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocationSenderUploadTP AS _Sender ON UploadUUID = _Sender.UploadUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocationReceiverUploadTP AS _Receiver ON UploadUUID = _Receiver.UploadUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocFieldDerivationUploadTP AS _FieldDerivation ON UploadUUID = _FieldDerivation.UploadUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocationReceiverBsUpldTP AS _ReceiverBasis ON UploadUUID = _ReceiverBasis.UploadUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocationSenderBasisUpldTP AS _SenderBasis ON UploadUUID = _SenderBasis.UploadUUID  -- association [0..*]
;