I_CNSLDTNJRNLENTRYHEADER

CDS View
31 Fields 3 CDS Views

Group Journal Entry Header

I_CNSLDTNJRNLENTRYHEADER is a CDS View in S/4HANA. Group Journal Entry Header. It contains 31 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CnsldtnJrnlEntryTP view from TRANSACTIONAL Journal Entry Management
P_IMPORTJOURNALENTRIES view inner BASIC Import Journal Entries
R_CnsldtnGrpJrnlEntrTP view_entity from TRANSACTIONAL Cons Group Journal Entry trans TP

Fields (31)

KeyField CDS FieldsUsed in Views
KEY ConsolidationDocumentNumber ConsolidationDocumentNumber,ConsolidationDocumentNumber1 2
KEY ConsolidationLedger ConsolidationLedger,ConsolidationLedger1,ConsolidationLedgerForEdit 2
KEY FiscalYear FiscalYear,FiscalYearForEdit 2
CnsldtnDocumentNumberForEdit CnsldtnDocumentNumberForEdit 1
CnsldtnGroupJrnlEntryBundle CnsldtnGroupJrnlEntryBundle 2
CnsldtnManualReversedDocument CnsldtnManualReversedDocument 1
CnsldtnManualReverseDocument CnsldtnManualReverseDocument 1
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 2
ConsolidationDimension ConsolidationDimension 2
ConsolidationDocReversalYear ConsolidationDocReversalYear 1
ConsolidationDocumentType ConsolidationDocumentType 2
ConsolidationGroup ConsolidationGroup 2
ConsolidationUnit ConsolidationUnit 2
ConsolidationUnit1 ConsolidationUnit1 2
ConsolidationUnit2 ConsolidationUnit2 2
ConsolidationVersion ConsolidationVersion 2
CreationDate CreationDate 2
CreationTime CreationTime 2
DocumentItemText DocumentItemText 1
FiscalPeriod FiscalPeriod 2
fiscalyearforedit fiscalyearforedit 1
InvesteeConsolidationUnit InvesteeConsolidationUnit 2
InvestmentActivity InvestmentActivity 2
InvestmentActivityType InvestmentActivityType 2
IsReversalDocument IsReversalDocument 1
PostingDate PostingDate 2
PostingLevel PostingLevel 2
RefConsolidationDocumentNumber RefConsolidationDocumentNumber 2
ReversedDocument ReversedDocument 1
ReverseDocument ReverseDocument 1
UserID UserID 2

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.

-- Group Journal Entry Header
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNJRNLENTRYHEADER (
    CONSOLIDATIONDOCUMENTNUMBER,
    CONSOLIDATIONLEDGER,
    FISCALYEAR,
    CNSLDTNDOCUMENTNUMBERFOREDIT,
    CNSLDTNGROUPJRNLENTRYBUNDLE,
    CNSLDTNMANUALREVERSEDDOCUMENT,
    CNSLDTNMANUALREVERSEDOCUMENT,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONDOCREVERSALYEAR,
    CONSOLIDATIONDOCUMENTTYPE,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONUNIT1,
    CONSOLIDATIONUNIT2,
    CONSOLIDATIONVERSION,
    CREATIONDATE,
    CREATIONTIME,
    DOCUMENTITEMTEXT,
    FISCALPERIOD,
    FISCALYEARFOREDIT,
    INVESTEECONSOLIDATIONUNIT,
    INVESTMENTACTIVITY,
    INVESTMENTACTIVITYTYPE,
    ISREVERSALDOCUMENT,
    POSTINGDATE,
    POSTINGLEVEL,
    REFCONSOLIDATIONDOCUMENTNUMBER,
    REVERSEDDOCUMENT,
    REVERSEDOCUMENT,
    USERID,
    PRIMARY KEY (CONSOLIDATIONDOCUMENTNUMBER, CONSOLIDATIONLEDGER, FISCALYEAR)
);

Learn More