_JOURNALENTRYITEM

57 Fields

_JOURNALENTRYITEM is an SAP database table in S/4HANA. It contains 57 fields.

Fields (57)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY LedgerGLLineItem LedgerGLLineItem 2
_AccountingDocumentType _AccountingDocumentType 2
_ControllingArea _ControllingArea 2
_CostCenter _CostCenter 2
_GLAccountInCompanyCode _GLAccountInCompanyCode 2
_GlobalCurrency _GlobalCurrency 2
_Order _Order 2
_ProfitCenter _ProfitCenter 2
_TransactionCurrency _TransactionCurrency 2
AccountingDocumentType AccountingDocumentType 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 2
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 2
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 2
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 2
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 2
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 2
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 2
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 2
AmountInGlobalCurrency AmountInGlobalCurrency 2
AmountInTransactionCurrency AmountInTransactionCurrency 2
AssignmentReference AssignmentReference 2
BusinessArea BusinessArea 2
CompanyCodeCurrency CompanyCodeCurrency 2
ControllingArea ControllingArea 2
ControllingObject REAccountingObject 1
CostCenter CostCenter 2
CreationDate CreationDate 2
DocumentDate DocumentDate 2
DocumentItemText DocumentItemText 4
FreeDefinedCurrency1 FreeDefinedCurrency1 2
FreeDefinedCurrency2 FreeDefinedCurrency2 2
FreeDefinedCurrency3 FreeDefinedCurrency3 2
FreeDefinedCurrency4 FreeDefinedCurrency4 2
FreeDefinedCurrency5 FreeDefinedCurrency5 2
FreeDefinedCurrency6 FreeDefinedCurrency6 2
FreeDefinedCurrency7 FreeDefinedCurrency7 2
FreeDefinedCurrency8 FreeDefinedCurrency8 2
FunctionalArea FunctionalArea 2
GLAccount GLAccount 2
GlobalCurrency GlobalCurrency 2
IsReversal IsReversal 1
IsReversed IsReversed 1
OrderID OrderID 2
PostingDate PostingDate 2
ProfitCenter ProfitCenter 2
ReferenceDocument ReferenceDocument 4
ReferenceDocumentContext ReferenceDocumentContext 2
ReferenceDocumentType ReferenceDocumentType,ReferenceDocumentType2 3
Segment Segment 2
SourceLedger Ledger 1
Supplier Supplier 1
TransactionCurrency TransactionCurrency 2
WBSElementInternalID WBSElementInternalID 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 _JOURNALENTRYITEM (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    _ACCOUNTINGDOCUMENTTYPE,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _GLACCOUNTINCOMPANYCODE,
    _GLOBALCURRENCY,
    _ORDER,
    _PROFITCENTER,
    _TRANSACTIONCURRENCY,
    ACCOUNTINGDOCUMENTTYPE,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINFREEDEFINEDCURRENCY1,
    AMOUNTINFREEDEFINEDCURRENCY2,
    AMOUNTINFREEDEFINEDCURRENCY3,
    AMOUNTINFREEDEFINEDCURRENCY4,
    AMOUNTINFREEDEFINEDCURRENCY5,
    AMOUNTINFREEDEFINEDCURRENCY6,
    AMOUNTINFREEDEFINEDCURRENCY7,
    AMOUNTINFREEDEFINEDCURRENCY8,
    AMOUNTINGLOBALCURRENCY,
    AMOUNTINTRANSACTIONCURRENCY,
    ASSIGNMENTREFERENCE,
    BUSINESSAREA,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    COSTCENTER,
    CREATIONDATE,
    DOCUMENTDATE,
    DOCUMENTITEMTEXT,
    FREEDEFINEDCURRENCY1,
    FREEDEFINEDCURRENCY2,
    FREEDEFINEDCURRENCY3,
    FREEDEFINEDCURRENCY4,
    FREEDEFINEDCURRENCY5,
    FREEDEFINEDCURRENCY6,
    FREEDEFINEDCURRENCY7,
    FREEDEFINEDCURRENCY8,
    FUNCTIONALAREA,
    GLACCOUNT,
    GLOBALCURRENCY,
    ISREVERSAL,
    ISREVERSED,
    ORDERID,
    POSTINGDATE,
    PROFITCENTER,
    REFERENCEDOCUMENT,
    REFERENCEDOCUMENTCONTEXT,
    REFERENCEDOCUMENTTYPE,
    SEGMENT,
    SOURCELEDGER,
    SUPPLIER,
    TRANSACTIONCURRENCY,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGERGLLINEITEM)
);

Learn More