I_ALLOCATIONKEYFIELD

CDS View

Allocation Key Field

I_ALLOCATIONKEYFIELD is a CDS View in S/4HANA. Allocation Key Field. It contains 13 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
I_AllocationCycleKeyFieldTP view from TRANSACTIONAL Allocation Cycle Key Field TP
I_AllocationKeyFieldTP view from TRANSACTIONAL Allocation Key Field TP
I_AllocationSenderKeyFieldTP view from TRANSACTIONAL Allocation Sender Key Field TP
I_AllocRcvrTracingKeyFieldTP view from TRANSACTIONAL Allocation Receiver Tracing Key Field TP
I_AllocReceiverKeyFieldTP view from TRANSACTIONAL Allocation Receiver Key Field TP
I_AllocSenderValueKeyFieldTP view from TRANSACTIONAL Allocation Sender Value Key Field TP
I_FuncnlAreaCostAllocSgmt view from COMPOSITE Cost Allocation Segment for Funcnl Area
I_FuncnlAreaCostAllocSgmt view union COMPOSITE Cost Allocation Segment for Funcnl Area
I_FundCostAllocSgmt view union COMPOSITE Cost Allocation Segment for Fund
I_FundCostAllocSgmt view from COMPOSITE Cost Allocation Segment for Fund
I_GrantCostAllocSgmt view from COMPOSITE Cost Allocation Segment for Grant
I_GrantCostAllocSgmt view union COMPOSITE Cost Allocation Segment for Grant
P_AllocationCostCenterVH view from COMPOSITE
P_AllocationKeyField view from BASIC
P_AllocRcvrTracingRefCount view from CONSUMPTION
P_TDDVirtualField view from COMPOSITE
P_WhereUsdIntOrdAlloc view_entity inner COMPOSITE
P_WhereUsdIntOrdAlloc view_entity union_all COMPOSITE
P_WhereUsdIntOrdAllocPlnCat view_entity from COMPOSITE WUIO Allocations - Relation to the Plan Category

Fields (13)

KeyField CDS FieldsUsed in Views
KEY AllocationCycle AllocationCycle 3
KEY AllocationCycleSegment AllocationCycleSegment 3
KEY AllocationCycleStartDate AllocationCycleStartDate 3
KEY AllocationSetType AllocationSetType 2
KEY AllocationType AllocationType 7
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber 3
_Cycle _Cycle 2
_Segment _Segment 2
AllocationFieldMaximumValue AllocationFieldMaximumValue 1
AllocationFieldMinimumValue AllocationFieldMinimumValue 1
AllocationFieldName AllocationFieldName 1
AllocationSetId AllocationSetId 1
AllocationSetName AllocationSetName 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 Key Field
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ALLOCATIONKEYFIELD (
    ALLOCATIONCYCLE,
    ALLOCATIONCYCLESEGMENT,
    ALLOCATIONCYCLESTARTDATE,
    ALLOCATIONSETTYPE,
    ALLOCATIONTYPE,
    ALLOCDOCUMENTSEQUENCENUMBER,
    _CYCLE,
    _SEGMENT,
    ALLOCATIONFIELDMAXIMUMVALUE,
    ALLOCATIONFIELDMINIMUMVALUE,
    ALLOCATIONFIELDNAME,
    ALLOCATIONSETID,
    ALLOCATIONSETNAME,
    PRIMARY KEY (ALLOCATIONCYCLE, ALLOCATIONCYCLESEGMENT, ALLOCATIONCYCLESTARTDATE, ALLOCATIONSETTYPE, ALLOCATIONTYPE, ALLOCDOCUMENTSEQUENCENUMBER)
);