C_UnivAllocationCycleUploadTP

DDL: C_UNIVALLOCATIONCYCLEUPLOADTP Type: view_entity CONSUMPTION Package: ODATA_MANAGE_ALLOCATION_V2_XLS

Cycle data from Alloc Excel upload TP

C_UnivAllocationCycleUploadTP is a Consumption CDS View that provides data about "Cycle data from Alloc Excel upload TP" in SAP S/4HANA. It reads from 1 data source (R_UnivAllocationCycleUploadTP) and exposes 30 fields with key fields AllocationUploadRowUUID, UploadUUID. 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_UnivAllocationCycleUploadTP R_UnivAllocationCycleUploadTP projection

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cycle data from Alloc Excel upload TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M 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 (30)

KeyFieldSource TableSource FieldDescription
KEY AllocationUploadRowUUID AllocationUploadRowUUID Row GUID
KEY UploadUUID UploadUUID Upload GUID
AllocationCycle AllocationCycle Cycle
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationType AllocationType Table
Ledger Ledger Ledger
AllocationCycleStartDate AllocationCycleStartDate Valid From
RowIndex RowIndex Row index
AllocationCycleEndDate AllocationCycleEndDate Valid To
AllocationCycleDescription AllocationCycleDescription Cycle Description
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
AllocationPostingType AllocationPostingType Posting Type
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationCycleCategory AllocationCycleCategory Plan Category
AllocationIsVariableQuantity AllocationIsVariableQuantity Quantities
AllocationIsInTransactionCrcy AllocationIsInTransactionCrcy Trans. Currency
AllocationCycleIsIterative AllocationCycleIsIterative Iteration
CycleIsParallelLedgerEnabled CycleIsParallelLedgerEnabled Flex. Ledger
AllocationIsCumulative AllocationIsCumulative Cumulative
UploadedByUser UploadedByUser Uploaded By
UploadCreationDateTime UploadCreationDateTime Time Stamp
AllocationCycleRunGroup AllocationCycleRunGroup Cycle Run Group
AllocationContextTypeTextlocalized
LedgerNamelocalized
AllocationPostingTypeTextlocalized
AllocActualPlanVariantTextlocalized
AllocationCycleRunGroupTextlocalized
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ControllingAreaName _ControllingArea ControllingAreaName Long Text

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_UnivAllocationCycleUploadTP.
-- 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_UnivAllocationCycleUploadTP AS
SELECT
  AllocationUploadRowUUID,
  UploadUUID,
  AllocationCycle,
  AllocationCycleName,
  AllocationType,
  Ledger,
  AllocationCycleStartDate,
  RowIndex,
  AllocationCycleEndDate,
  AllocationCycleDescription,
  CompanyCode,
  ControllingArea,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationCycleCategory,
  AllocationIsVariableQuantity,
  AllocationIsInTransactionCrcy,
  AllocationCycleIsIterative,
  CycleIsParallelLedgerEnabled,
  AllocationIsCumulative,
  UploadedByUser,
  UploadCreationDateTime,
  AllocationCycleRunGroup,
  _Context._Text.AllocationContextTypeText : localized AS AllocationContextTypeTextlocalized,
  _LedgerText.LedgerName : localized AS LedgerNamelocalized,
  _AllocationPostingTypeText.AllocationPostingTypeText : localized AS AllocationPostingTypeTextlocalized,
  _ActualPlanVariant._Text.AllocActualPlanVariantText : localized AS AllocActualPlanVariantTextlocalized,
  _CycleRunGroup._Text.AllocationCycleRunGroupText : localized AS AllocationCycleRunGroupTextlocalized,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _ControllingArea.ControllingAreaName AS ControllingAreaName
FROM R_UnivAllocationCycleUploadTP
;