I_ALLOCATIONCYCLE

CDS View

Allocation Cycle

I_ALLOCATIONCYCLE is a CDS View in S/4HANA. Allocation Cycle. It contains 14 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
C_AllocationCycle view from CONSUMPTION Allocation Cycle
C_AllocCycleRunStatusFilter view from CONSUMPTION Allocation Cycle Run Status
I_AllocationCycleTP view from TRANSACTIONAL Allocation Cycle TP
P_AllocationStatus view from CONSUMPTION Allocation Status
P_AllocationTagCycleHierarchy view from CONSUMPTION
P_AllocCycleForScheduling view from CONSUMPTION
P_AllocImportCycleHierarchy view_entity from CONSUMPTION Allocation Import Cycle Hierarchy
P_CycleSegmentHierSourceParam view inner CONSUMPTION
P_CycleSegmentHierSourceParam view union CONSUMPTION
P_UniAllocTagCycleAssignment view from COMPOSITE
P_UniAllocTagObjectAssignment view from COMPOSITE
R_AllocationCycleTP view_entity from TRANSACTIONAL Allocation Cycle

Fields (14)

KeyField CDS FieldsUsed in Views
KEY AllocationCycle AllocationCycle 4
KEY AllocationCycleStartDate AllocationCycleStartDate 4
KEY AllocationType AllocationType 5
AllocationActualPlanVariant AllocationActualPlanVariant 1
AllocationCreateDate AllocationCreateDate 3
AllocationCycleEndDate AllocationCycleEndDate 1
AllocationCycleName AllocationCycleName 1
AllocationFrequency AllocationFrequency 1
AllocationPostingType AllocationPostingType 1
AllocationStatus AllocationStatus 1
CreatedByUser CreatedByUser 1
LastChangeDate LastChangeDate 3
LastChangedByUser LastChangedByUser 1
Ledger Ledger 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.

-- Allocation Cycle
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ALLOCATIONCYCLE (
    ALLOCATIONCYCLE,
    ALLOCATIONCYCLESTARTDATE,
    ALLOCATIONTYPE,
    ALLOCATIONACTUALPLANVARIANT,
    ALLOCATIONCREATEDATE,
    ALLOCATIONCYCLEENDDATE,
    ALLOCATIONCYCLENAME,
    ALLOCATIONFREQUENCY,
    ALLOCATIONPOSTINGTYPE,
    ALLOCATIONSTATUS,
    CREATEDBYUSER,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LEDGER,
    PRIMARY KEY (ALLOCATIONCYCLE, ALLOCATIONCYCLESTARTDATE, ALLOCATIONTYPE)
);