_GLITEMS

18 Fields

_GLITEMS is an SAP database table in S/4HANA. It contains 18 fields.

Fields (18)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY ControllingArea ControllingArea 1
KEY CostCenter CostCenter 1
KEY CostElement CostElement 1
KEY FiscalPeriod FiscalPeriod 1
KEY FiscalYear FiscalYear 1
KEY FiscalYearVariant FiscalYearVariant 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY PurchasingDocument PurchasingDocument 1
KEY SourceLedger SourceLedger 1
KEY ValidityEndDate ValidityEndDate 1
KEY ValidityStartDate ValidityStartDate 1
EndDate EndDate 1
IsCommitment IsCommitment 1
PostingDate PostingDate 1
StartDate StartDate 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 _GLITEMS (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTELEMENT,
    FISCALPERIOD,
    FISCALYEAR,
    FISCALYEARVARIANT,
    LEDGER,
    LEDGERGLLINEITEM,
    PURCHASINGDOCUMENT,
    SOURCELEDGER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    ENDDATE,
    ISCOMMITMENT,
    POSTINGDATE,
    STARTDATE,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, CONTROLLINGAREA, COSTCENTER, COSTELEMENT, FISCALPERIOD, FISCALYEAR, FISCALYEARVARIANT, LEDGER, LEDGERGLLINEITEM, PURCHASINGDOCUMENT, SOURCELEDGER, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More