I_UNIVALLOCATIONCYCLEVERSION

CDS View
61 Fields 2 CDS Views

Universal Allocation Cycle Version

I_UNIVALLOCATIONCYCLEVERSION is a CDS View in S/4HANA. Universal Allocation Cycle Version. It contains 61 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_AllocCycleMaxCreatedVersion view_entity from CONSUMPTION Universal Allocation Cycle Version
P_UnivAllocCycleActiveVersion view_entity from CONSUMPTION Universal Allocation Cycle Version

Fields (61)

KeyField CDS FieldsUsed in Views
KEY AllocationCycle AllocationCycle 1
KEY AllocationCycleStartDate AllocationCycleStartDate 1
KEY AllocationCycleVersionValue AllocationCycleVersionValue 1
KEY AllocationType AllocationType 1
AllocationActualPlanVariant AllocationActualPlanVariant 1
AllocationCreateDate AllocationCreateDate 1
AllocationCycleEndDate AllocationCycleEndDate 1
AllocationCycleIsIterative AllocationCycleIsIterative 1
AllocationCycleName AllocationCycleName 1
AllocationCycleRunGroup AllocationCycleRunGroup 1
AllocationCycleSet AllocationCycleSet 1
AllocationCycleTagVersionValue AllocationCycleTagVersionValue 1
AllocationFrequency AllocationFrequency 1
AllocationIsBalanceSheetActive AllocationIsBalanceSheetActive 1
AllocationIsCumulative AllocationIsCumulative 1
AllocationIsPeriodShiftActive AllocationIsPeriodShiftActive 1
AllocationIsProcessed AllocationIsProcessed 1
AllocationIsVariableQuantity AllocationIsVariableQuantity 1
AllocationJob AllocationJob 1
AllocationLastExecutedByUser AllocationLastExecutedByUser 1
AllocationLastExecutedDate AllocationLastExecutedDate 1
AllocationLastExecutionTime AllocationLastExecutionTime 1
AllocationLedgerGroup AllocationLedgerGroup 1
AllocationPeriodDeltaSize AllocationPeriodDeltaSize 1
AllocationPostingType AllocationPostingType 1
AllocationStatus AllocationStatus 1
AllocationSubstitutionName AllocationSubstitutionName 1
AllocationValuationType AllocationValuationType 1
AllocCycDrvtnRuleVersionValue AllocCycDrvtnRuleVersionValue 1
AllocCycFieldGroupVersionValue AllocCycFieldGroupVersionValue 1
AllocCycFldMappingVersionValue AllocCycFldMappingVersionValue 1
AllocCycleElementVersionValue AllocCycleElementVersionValue 1
AllocCycleKeyFieldVersionValue AllocCycleKeyFieldVersionValue 1
AllocCycleNoteVersionValue AllocCycleNoteVersionValue 1
AllocCycleSegmentVersionValue AllocCycleSegmentVersionValue 1
AllocCycleTemplateVersionValue AllocCycleTemplateVersionValue 1
AllocCycleTextVersionValue AllocCycleTextVersionValue 1
AllocCycleVersionCreatedByUser AllocCycleVersionCreatedByUser 1
AllocFundMgmtIsActive AllocFundMgmtIsActive 1
AllocHasAggregatedProcess AllocHasAggregatedProcess 1
AllocHasDerivdFundFrmRcpnt AllocHasDerivdFundFrmRcpnt 1
AllocIsCumulativeOptimized AllocIsCumulativeOptimized 1
AllocIsDerivdBudgedPerdRcpnt AllocIsDerivdBudgedPerdRcpnt 1
AllocIsDerivdFuncAreaFrmRcpnt AllocIsDerivdFuncAreaFrmRcpnt 1
AllocIsDerivdGrantFrmRcpnt AllocIsDerivdGrantFrmRcpnt 1
AllocIsProdnMnthDerivd AllocIsProdnMnthDerivd 1
AllocSegmentNoteVersionValue AllocSegmentNoteVersionValue 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
CreatedByUser CreatedByUser 1
CycleIsAttributedLineItmEnbld CycleIsAttributedLineItmEnbld 1
CycleIsDeltaProcessEnabled CycleIsDeltaProcessEnabled 1
CycleIsParallelLedgerEnabled CycleIsParallelLedgerEnabled 1
DeletedByUser DeletedByUser 1
DeletionDateTime DeletionDateTime 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
Ledger Ledger 1
OperatingConcern OperatingConcern 1
PlanningCategory PlanningCategory 1
ScaleNegativeTracingFactor ScaleNegativeTracingFactor 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Universal Allocation Cycle Version
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_UNIVALLOCATIONCYCLEVERSION (
    ALLOCATIONCYCLE,
    ALLOCATIONCYCLESTARTDATE,
    ALLOCATIONCYCLEVERSIONVALUE,
    ALLOCATIONTYPE,
    ALLOCATIONACTUALPLANVARIANT,
    ALLOCATIONCREATEDATE,
    ALLOCATIONCYCLEENDDATE,
    ALLOCATIONCYCLEISITERATIVE,
    ALLOCATIONCYCLENAME,
    ALLOCATIONCYCLERUNGROUP,
    ALLOCATIONCYCLESET,
    ALLOCATIONCYCLETAGVERSIONVALUE,
    ALLOCATIONFREQUENCY,
    ALLOCATIONISBALANCESHEETACTIVE,
    ALLOCATIONISCUMULATIVE,
    ALLOCATIONISPERIODSHIFTACTIVE,
    ALLOCATIONISPROCESSED,
    ALLOCATIONISVARIABLEQUANTITY,
    ALLOCATIONJOB,
    ALLOCATIONLASTEXECUTEDBYUSER,
    ALLOCATIONLASTEXECUTEDDATE,
    ALLOCATIONLASTEXECUTIONTIME,
    ALLOCATIONLEDGERGROUP,
    ALLOCATIONPERIODDELTASIZE,
    ALLOCATIONPOSTINGTYPE,
    ALLOCATIONSTATUS,
    ALLOCATIONSUBSTITUTIONNAME,
    ALLOCATIONVALUATIONTYPE,
    ALLOCCYCDRVTNRULEVERSIONVALUE,
    ALLOCCYCFIELDGROUPVERSIONVALUE,
    ALLOCCYCFLDMAPPINGVERSIONVALUE,
    ALLOCCYCLEELEMENTVERSIONVALUE,
    ALLOCCYCLEKEYFIELDVERSIONVALUE,
    ALLOCCYCLENOTEVERSIONVALUE,
    ALLOCCYCLESEGMENTVERSIONVALUE,
    ALLOCCYCLETEMPLATEVERSIONVALUE,
    ALLOCCYCLETEXTVERSIONVALUE,
    ALLOCCYCLEVERSIONCREATEDBYUSER,
    ALLOCFUNDMGMTISACTIVE,
    ALLOCHASAGGREGATEDPROCESS,
    ALLOCHASDERIVDFUNDFRMRCPNT,
    ALLOCISCUMULATIVEOPTIMIZED,
    ALLOCISDERIVDBUDGEDPERDRCPNT,
    ALLOCISDERIVDFUNCAREAFRMRCPNT,
    ALLOCISDERIVDGRANTFRMRCPNT,
    ALLOCISPRODNMNTHDERIVD,
    ALLOCSEGMENTNOTEVERSIONVALUE,
    COMPANYCODE,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CYCLEISATTRIBUTEDLINEITMENBLD,
    CYCLEISDELTAPROCESSENABLED,
    CYCLEISPARALLELLEDGERENABLED,
    DELETEDBYUSER,
    DELETIONDATETIME,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LEDGER,
    OPERATINGCONCERN,
    PLANNINGCATEGORY,
    SCALENEGATIVETRACINGFACTOR,
    PRIMARY KEY (ALLOCATIONCYCLE, ALLOCATIONCYCLESTARTDATE, ALLOCATIONCYCLEVERSIONVALUE, ALLOCATIONTYPE)
);

Learn More