GLACCOUNTLINEITEM

10 Fields

GLACCOUNTLINEITEM is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY BusinessTransactionType BusinessTransactionType 1
KEY FiscalYear FiscalYear 1
KEY PostingDate PostingDate,ReportingDate 1
AccountingDocumentCategory AccountingDocumentCategory 1
AccountingDocumentType AccountingDocumentType 1
DocumentDate DocumentDate 1
IsReversal IsReversal 1
IsReversed IsReversed 1
ReferenceDocumentType ReferenceDocumentType 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 GLACCOUNTLINEITEM (
    ACCOUNTINGDOCUMENT,
    BUSINESSTRANSACTIONTYPE,
    FISCALYEAR,
    POSTINGDATE,
    ACCOUNTINGDOCUMENTCATEGORY,
    ACCOUNTINGDOCUMENTTYPE,
    DOCUMENTDATE,
    ISREVERSAL,
    ISREVERSED,
    REFERENCEDOCUMENTTYPE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, BUSINESSTRANSACTIONTYPE, FISCALYEAR, POSTINGDATE)
);

Learn More