C_UnivAllocFldDrvtnUploadTP

DDL: C_UNIVALLOCFLDDRVTNUPLOADTP Type: view_entity CONSUMPTION Package: ODATA_MANAGE_ALLOCATION_V2_XLS

Allocation Fld Derivation for Excel TP

C_UnivAllocFldDrvtnUploadTP is a Consumption CDS View that provides data about "Allocation Fld Derivation for Excel TP" in SAP S/4HANA. It reads from 1 data source (R_UnivAllocFldDrvtnUploadTP) and exposes 16 fields with key fields UploadUUID, AllocationUploadRowUUID. It is exposed through 2 OData services (ASQL_F3338A, UI_FCO_MANAGE_ALLOCATION). Part of development package ODATA_MANAGE_ALLOCATION_V2_XLS.

Data Sources (1)

SourceAliasJoin Type
R_UnivAllocFldDrvtnUploadTP R_UnivAllocFldDrvtnUploadTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Allocation Fld Derivation for Excel TP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3338A ASQL_F3338A C2 NOT_RELEASED
UI_FCO_MANAGE_ALLOCATION UI_FCOUA_MANAGE_ALLOCATION V2 C1 NOT_RELEASED

Fields (16)

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
AllocationFieldName AllocationFieldName Field
AllocationFieldLabel AllocationFieldLabel Long Text
AllocationFieldIsDerived AllocationFieldIsDerived Derive Value
UploadedByUser UploadedByUser Uploaded By
UploadCreationDateTime UploadCreationDateTime Time Stamp
AllocationContextTypeTextlocalized
LedgerNamelocalized
_AllocationCycle _AllocationCycle

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_UnivAllocFldDrvtnUploadTP.
-- 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 C_UnivAllocFldDrvtnUploadTP AS
SELECT
  UploadUUID,
  AllocationUploadRowUUID,
  RowIndex,
  AllocationCycle,
  AllocationCycleName,
  AllocationType,
  Ledger,
  AllocationCycleStartDate,
  AllocationFieldName,
  AllocationFieldLabel,
  AllocationFieldIsDerived,
  UploadedByUser,
  UploadCreationDateTime,
  _Context._Text.AllocationContextTypeText : localized AS AllocationContextTypeTextlocalized,
  _LedgerText.LedgerName : localized AS LedgerNamelocalized
FROM R_UnivAllocFldDrvtnUploadTP
;