JOURNALLINEITEM

25 Fields

JOURNALLINEITEM is an SAP database table in S/4HANA. It contains 25 fields.

Fields (25)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
_CompanyCode _CompanyCode 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_Customer _Customer 1
_FiscalYear _FiscalYear 1
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
_SourceLedger _SourceLedger 1
_Supplier _Supplier 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
Customer Customer 1
DocumentItemText DocumentItemText 1
PostingDate PostingDate 1
ReferenceDocument ReferenceDocument 1
SourceLedger SourceLedger 1
Supplier Supplier 1
TaxCode TaxCode 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 JOURNALLINEITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _CUSTOMER,
    _FISCALYEAR,
    _JOURNALENTRY,
    _LEDGER,
    _SOURCELEDGER,
    _SUPPLIER,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    COSTCENTER,
    CUSTOMER,
    DOCUMENTITEMTEXT,
    POSTINGDATE,
    REFERENCEDOCUMENT,
    SOURCELEDGER,
    SUPPLIER,
    TAXCODE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM)
);

Learn More