C_AllocFieldDerivationUpload

DDL: C_ALLOCFIELDDERIVATIONUPLOAD SQL: CALLOCFLDDUPLD Type: view CONSUMPTION Package: MANAGE_ALLOCATION_EXCEL
19 Fields 1 Data Sources 1 Associations

Allocation field derivation for excel

C_AllocFieldDerivationUpload is a Consumption CDS View that provides data about "Allocation field derivation for excel" in SAP S/4HANA. It reads from 1 data source (I_AllocFieldDerivationUploadTP) and exposes 19 fields with key field AllocationUploadRowUUID. It has 1 association to related views. Part of development package MANAGE_ALLOCATION_EXCEL.

Data Sources (1)

SourceAliasJoin Type
I_AllocFieldDerivationUploadTP I_AllocFieldDerivationUploadTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_AllocationFileUpload _File $projection.UploadUUID = _File.UploadUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CALLOCFLDDUPLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Allocation field derivation for excel view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.representativeKey AllocationUploadRowUUID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
VDM.viewType #CONSUMPTION view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY AllocationUploadRowUUID I_AllocFieldDerivationUploadTP AllocationUploadRowUUID Row GUID
UploadUUID I_AllocFieldDerivationUploadTP UploadUUID Upload GUID
RowIndex I_AllocFieldDerivationUploadTP RowIndex Row index
AllocationCycle I_AllocFieldDerivationUploadTP AllocationCycle Cycle
AllocationType I_AllocFieldDerivationUploadTP AllocationType Table
Ledger I_AllocFieldDerivationUploadTP Ledger Ledger
AllocationCycleStartDate I_AllocFieldDerivationUploadTP AllocationCycleStartDate Valid From
AllocationFieldName I_AllocFieldDerivationUploadTP AllocationFieldName Field
AllocationFieldLabel I_AllocFieldDerivationUploadTP AllocationFieldLabel Long Text
AllocationFieldIsDerived I_AllocFieldDerivationUploadTP AllocationFieldIsDerived Derive Value
UploadedByUser UploadedByUser Uploaded By
UploadCreationDateTime UploadCreationDateTime Time Stamp
AllocationSearchHelpEntityName AllocationSearchHelpEntityName
AllocationSearchHelpOutput AllocationSearchHelpOutput
GroupValueHelpEntityName GroupValueHelpEntityName
GroupValueHelpOutput GroupValueHelpOutput
GroupValueHelpOutputText GroupValueHelpOutputText
NumberOfErrors _ErrorCount NumberOfErrors Error Number
_File _File

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_AllocFieldDerivationUpload.
-- 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: CALLOCFLDDUPLD

CREATE VIEW C_AllocFieldDerivationUpload AS
SELECT
  I_AllocFieldDerivationUploadTP.AllocationUploadRowUUID AS AllocationUploadRowUUID,
  I_AllocFieldDerivationUploadTP.UploadUUID AS UploadUUID,
  I_AllocFieldDerivationUploadTP.RowIndex AS RowIndex,
  I_AllocFieldDerivationUploadTP.AllocationCycle AS AllocationCycle,
  I_AllocFieldDerivationUploadTP.AllocationType AS AllocationType,
  I_AllocFieldDerivationUploadTP.Ledger AS Ledger,
  I_AllocFieldDerivationUploadTP.AllocationCycleStartDate AS AllocationCycleStartDate,
  I_AllocFieldDerivationUploadTP.AllocationFieldName AS AllocationFieldName,
  I_AllocFieldDerivationUploadTP.AllocationFieldLabel AS AllocationFieldLabel,
  I_AllocFieldDerivationUploadTP.AllocationFieldIsDerived AS AllocationFieldIsDerived,
  UploadedByUser,
  UploadCreationDateTime,
  AllocationSearchHelpEntityName,
  AllocationSearchHelpOutput,
  GroupValueHelpEntityName,
  GroupValueHelpOutput,
  GroupValueHelpOutputText,
  _ErrorCount.NumberOfErrors AS NumberOfErrors
FROM I_AllocFieldDerivationUploadTP
LEFT OUTER JOIN C_AllocationFileUpload AS _File ON UploadUUID = _File.UploadUUID  -- association [1..1]
;

Learn More