P_ALLOCRUNJOURNALENTRYITEM

CDS View
13 Fields 1 CDS Views

P_ALLOCRUNJOURNALENTRYITEM is a CDS View in S/4HANA. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_AllocRunJournalEntryItem1 view from CONSUMPTION

Fields (13)

KeyField CDS FieldsUsed in Views
KEY AllocationCycle AllocationCycle 1
KEY AllocationCycleStartDate AllocationCycleStartDate 1
KEY AllocDocumentSequenceNumber AllocDocumentSequenceNumber 1
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY UniversalAllocationRun UniversalAllocationRun 1
AllocationActualPlanVariant AllocationActualPlanVariant 1
AllocationCycleName AllocationCycleName 1
AllocationPostingType AllocationPostingType 1
AllocationRunStartDateTime AllocationRunStartDateTime 1
AllocationType AllocationType 1
ReferenceDocumentNumber ReferenceDocumentNumber 1
ReversalReferenceDocument ReversalReferenceDocument 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_ALLOCRUNJOURNALENTRYITEM (
    ALLOCATIONCYCLE,
    ALLOCATIONCYCLESTARTDATE,
    ALLOCDOCUMENTSEQUENCENUMBER,
    FISCALPERIOD,
    FISCALYEAR,
    UNIVERSALALLOCATIONRUN,
    ALLOCATIONACTUALPLANVARIANT,
    ALLOCATIONCYCLENAME,
    ALLOCATIONPOSTINGTYPE,
    ALLOCATIONRUNSTARTDATETIME,
    ALLOCATIONTYPE,
    REFERENCEDOCUMENTNUMBER,
    REVERSALREFERENCEDOCUMENT,
    PRIMARY KEY (ALLOCATIONCYCLE, ALLOCATIONCYCLESTARTDATE, ALLOCDOCUMENTSEQUENCENUMBER, FISCALPERIOD, FISCALYEAR, UNIVERSALALLOCATIONRUN)
);

Learn More