I_UnivAllocationCycleVersion

DDL: I_UNIVALLOCATIONCYCLEVERSION Type: view_entity COMPOSITE
61 Fields 1 Data Sources

Universal Allocation Cycle Version

I_UnivAllocationCycleVersion is a Composite CDS View that provides data about "Universal Allocation Cycle Version" in SAP S/4HANA. It reads from 1 data source (I_AllocationCycleVersion) and exposes 61 fields with key fields AllocationCycleVersionValue, AllocationType, AllocationCycle, AllocationCycleStartDate.

Data Sources (1)

SourceAliasJoin Type
I_AllocationCycleVersion I_AllocationCycleVersion from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Universal Allocation Cycle Version view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY AllocationCycleVersionValue AllocationCycleVersionValue WorklistID
KEY AllocationType AllocationType Table
KEY AllocationCycle AllocationCycle Cycle
KEY AllocationCycleStartDate AllocationCycleStartDate Valid From
AllocationCycleEndDate AllocationCycleEndDate Valid To
AllocCycleVersionCreatedByUser AllocCycleVersionCreatedByUser User Name
DeletedByUser DeletedByUser User Name
DeletionDateTime DeletionDateTime
AllocationCycleName AllocationCycleName Allocation Cycle
AllocationStatus AllocationStatus Status
AllocationFrequency AllocationFrequency Frequency ID
AllocationCreateDate AllocationCreateDate Entered On
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
AllocationLastExecutedDate AllocationLastExecutedDate Executed on
AllocationLastExecutedByUser AllocationLastExecutedByUser Executed By
AllocationLastExecutionTime AllocationLastExecutionTime Time
AllocationIsProcessed AllocationIsProcessed Processing
AllocationCycleSet AllocationCycleSet Set ID
ScaleNegativeTracingFactor ScaleNegativeTracingFactor Scale Neg. Factors
AllocationPostingType AllocationPostingType Posting Type
AllocationActualPlanVariant AllocationActualPlanVariant Actual/Plan
AllocationJob AllocationJob Undefined range (can be used for patch levels)
AllocationIsCumulative AllocationIsCumulative Cumulative
AllocIsCumulativeOptimized AllocIsCumulativeOptimized Cumulative Opt.
AllocHasAggregatedProcess AllocHasAggregatedProcess Agg.Trac.Factor
AllocationCycleRunGroup AllocationCycleRunGroup Cycle Run Group
AllocationSubstitutionName AllocationSubstitutionName Substitution
AllocFundMgmtIsActive AllocFundMgmtIsActive Der.Fund/FuncAr
AllocationIsBalanceSheetActive AllocationIsBalanceSheetActive Balance Sheet Accts
AllocHasDerivdFundFrmRcpnt AllocHasDerivdFundFrmRcpnt Derive Funds
AllocIsDerivdFuncAreaFrmRcpnt AllocIsDerivdFuncAreaFrmRcpnt Derive Func.Ar
AllocIsDerivdGrantFrmRcpnt AllocIsDerivdGrantFrmRcpnt Derive Grant
AllocIsDerivdBudgedPerdRcpnt AllocIsDerivdBudgedPerdRcpnt Derive Budg.Per
AllocationLedgerGroup AllocationLedgerGroup Ledger Group
AllocationIsPeriodShiftActive AllocationIsPeriodShiftActive Read Preperiod
AllocationPeriodDeltaSize AllocationPeriodDeltaSize Per. Delta
AllocIsProdnMnthDerivd AllocIsProdnMnthDerivd Production Month
AllocationIsVariableQuantity AllocationIsVariableQuantity Quantities
AllocationValuationType AllocationValuationType Valuation
Ledger Ledger Ledger
CompanyCode CompanyCode Receiver Company Code
ControllingArea ControllingArea Controlling Area
PlanningCategory PlanningCategory Plan Category
OperatingConcern OperatingConcern Operating concern
CycleIsDeltaProcessEnabled CycleIsDeltaProcessEnabled Delta Processing
AllocationCycleIsIterative AllocationCycleIsIterative Iteration
CycleIsParallelLedgerEnabled CycleIsParallelLedgerEnabled Flex. Ledger
CycleIsAttributedLineItmEnbld CycleIsAttributedLineItmEnbld Attributed Line item
AllocCycleSegmentVersionValue AllocCycleSegmentVersionValue ID
AllocCycleKeyFieldVersionValue AllocCycleKeyFieldVersionValue ID
AllocCycleElementVersionValue AllocCycleElementVersionValue ID
AllocCycFieldGroupVersionValue AllocCycFieldGroupVersionValue ID
AllocCycleTextVersionValue AllocCycleTextVersionValue ID
AllocCycFldMappingVersionValue AllocCycFldMappingVersionValue ID
AllocationCycleTagVersionValue AllocationCycleTagVersionValue ID
AllocCycleNoteVersionValue AllocCycleNoteVersionValue ID
AllocSegmentNoteVersionValue AllocSegmentNoteVersionValue ID
AllocCycDrvtnRuleVersionValue AllocCycDrvtnRuleVersionValue ID
AllocCycleTemplateVersionValue AllocCycleTemplateVersionValue ID

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_UnivAllocationCycleVersion.
-- 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 I_UnivAllocationCycleVersion AS
SELECT
  AllocationCycleVersionValue,
  AllocationType,
  AllocationCycle,
  AllocationCycleStartDate,
  AllocationCycleEndDate,
  AllocCycleVersionCreatedByUser,
  DeletedByUser,
  DeletionDateTime,
  AllocationCycleName,
  AllocationStatus,
  AllocationFrequency,
  AllocationCreateDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser,
  AllocationLastExecutedDate,
  AllocationLastExecutedByUser,
  AllocationLastExecutionTime,
  AllocationIsProcessed,
  AllocationCycleSet,
  ScaleNegativeTracingFactor,
  AllocationPostingType,
  AllocationActualPlanVariant,
  AllocationJob,
  AllocationIsCumulative,
  AllocIsCumulativeOptimized,
  AllocHasAggregatedProcess,
  AllocationCycleRunGroup,
  AllocationSubstitutionName,
  AllocFundMgmtIsActive,
  AllocationIsBalanceSheetActive,
  AllocHasDerivdFundFrmRcpnt,
  AllocIsDerivdFuncAreaFrmRcpnt,
  AllocIsDerivdGrantFrmRcpnt,
  AllocIsDerivdBudgedPerdRcpnt,
  AllocationLedgerGroup,
  AllocationIsPeriodShiftActive,
  AllocationPeriodDeltaSize,
  AllocIsProdnMnthDerivd,
  AllocationIsVariableQuantity,
  AllocationValuationType,
  Ledger,
  CompanyCode,
  ControllingArea,
  PlanningCategory,
  OperatingConcern,
  CycleIsDeltaProcessEnabled,
  AllocationCycleIsIterative,
  CycleIsParallelLedgerEnabled,
  CycleIsAttributedLineItmEnbld,
  AllocCycleSegmentVersionValue,
  AllocCycleKeyFieldVersionValue,
  AllocCycleElementVersionValue,
  AllocCycFieldGroupVersionValue,
  AllocCycleTextVersionValue,
  AllocCycFldMappingVersionValue,
  AllocationCycleTagVersionValue,
  AllocCycleNoteVersionValue,
  AllocSegmentNoteVersionValue,
  AllocCycDrvtnRuleVersionValue,
  AllocCycleTemplateVersionValue
FROM I_AllocationCycleVersion
;

Learn More