I_ALLOCATIONDOCUMENT

CDS View
12 Fields 2 CDS Views

Allocation Document

I_ALLOCATIONDOCUMENT is a CDS View in S/4HANA. Allocation Document. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_AllocationDocument view from CONSUMPTION Allocation Document
P_AllocationRunReversalCount view from CONSUMPTION Allocation Run Reversal Count

Fields (12)

KeyField CDS FieldsUsed in Views
KEY AllocationCycle AllocationCycle 1
KEY AllocationCycleIsReversed AllocationCycleIsReversed 2
KEY AllocationCycleStartDate AllocationCycleStartDate 1
KEY AllocationType AllocationType 1
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber 1
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
AllocationCycleName AllocationCycleName 1
AllocationCycleVersionValue AllocationCycleVersionValue 1
Ledger Ledger 1
PostingDate PostingDate 1
ReferenceDocumentNumber ReferenceDocumentNumber 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 Document
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ALLOCATIONDOCUMENT (
    ALLOCATIONCYCLE,
    ALLOCATIONCYCLEISREVERSED,
    ALLOCATIONCYCLESTARTDATE,
    ALLOCATIONTYPE,
    ALLOCDOCUMENTSEQUENCENUMBER,
    FISCALPERIOD,
    FISCALYEAR,
    ALLOCATIONCYCLENAME,
    ALLOCATIONCYCLEVERSIONVALUE,
    LEDGER,
    POSTINGDATE,
    REFERENCEDOCUMENTNUMBER,
    PRIMARY KEY (ALLOCATIONCYCLE, ALLOCATIONCYCLEISREVERSED, ALLOCATIONCYCLESTARTDATE, ALLOCATIONTYPE, ALLOCDOCUMENTSEQUENCENUMBER, FISCALPERIOD, FISCALYEAR)
);

Learn More