JOURNALITEM

15 Fields

JOURNALITEM is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY AccountingDocumentType CostAnalysisResourceName 1
KEY CompanyCode CompanyCode 3
KEY CostCenter CostAnalysisResourceName,CostCenter 2
KEY FiscalYear FiscalYear 3
KEY GLAccount GLAccount 1
KEY Ledger Ledger 3
KEY LedgerGLLineItem LedgerGLLineItem 2
_CompanyCode _CompanyCode 3
_FiscalYear _FiscalYear 3
_JournalEntry _JournalEntry 2
_Ledger _Ledger 2
CompanyCodeCurrency CompanyCodeCurrency 2
PostingDate PostingDate 2
TransactionCurrency TransactionCurrency 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE JOURNALITEM (
    ACCOUNTINGDOCUMENT,
    ACCOUNTINGDOCUMENTTYPE,
    COMPANYCODE,
    COSTCENTER,
    FISCALYEAR,
    GLACCOUNT,
    LEDGER,
    LEDGERGLLINEITEM,
    _COMPANYCODE,
    _FISCALYEAR,
    _JOURNALENTRY,
    _LEDGER,
    COMPANYCODECURRENCY,
    POSTINGDATE,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, ACCOUNTINGDOCUMENTTYPE, COMPANYCODE, COSTCENTER, FISCALYEAR, GLACCOUNT, LEDGER, LEDGERGLLINEITEM)
);

Learn More