GLBALANCE

27 Fields

GLBALANCE is an SAP database table in S/4HANA. It contains 27 fields.

Fields (27)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 6
KEY CompanyCode CompanyCode 6
KEY FiscalYear FiscalYear 6
KEY GLAccount GLAccount 3
KEY HouseBank HouseBank 1
KEY HouseBankAccount HouseBankAccount 1
KEY Ledger Ledger 4
KEY LedgerGLLineItem LedgerGLLineItem 6
AdjustedBkAcctBalanceAmt AdjustedBkAcctBalanceAmt 1
AdjustedGLAcctBalanceAmt AdjustedGLAcctBalanceAmt 1
AlternativeGLAccount AlternativeGLAccount 1
BankAccount BankAccount 1
BankAccountReferenceText BankAccountReferenceText 1
BankName BankName 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreationUserName CreationUserName 1
Currency Currency 5
FunctionalArea FunctionalArea 1
GLAccountExternal GLAccountExternal 1
GLAcctBalanceAmt GLAcctBalanceAmt 1
HouseBankCurrency HouseBankCurrency 1
LastBankReconciliationDate LastBankReconciliationDate 1
PostingDate PostingDate 1
UnmatchedIncgBkStmntPayt UnmatchedIncgBkStmntPayt 1
UnmatchedIncgJrnlEntrPayt UnmatchedIncgJrnlEntrPayt 1
UnmatchedOutgBkStmntPayt UnmatchedOutgBkStmntPayt 1
UnmatchedOutgJrnlEntrPayt UnmatchedOutgJrnlEntrPayt 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 GLBALANCE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    GLACCOUNT,
    HOUSEBANK,
    HOUSEBANKACCOUNT,
    LEDGER,
    LEDGERGLLINEITEM,
    ADJUSTEDBKACCTBALANCEAMT,
    ADJUSTEDGLACCTBALANCEAMT,
    ALTERNATIVEGLACCOUNT,
    BANKACCOUNT,
    BANKACCOUNTREFERENCETEXT,
    BANKNAME,
    COMPANYCODECURRENCY,
    CREATIONUSERNAME,
    CURRENCY,
    FUNCTIONALAREA,
    GLACCOUNTEXTERNAL,
    GLACCTBALANCEAMT,
    HOUSEBANKCURRENCY,
    LASTBANKRECONCILIATIONDATE,
    POSTINGDATE,
    UNMATCHEDINCGBKSTMNTPAYT,
    UNMATCHEDINCGJRNLENTRPAYT,
    UNMATCHEDOUTGBKSTMNTPAYT,
    UNMATCHEDOUTGJRNLENTRPAYT,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, GLACCOUNT, HOUSEBANK, HOUSEBANKACCOUNT, LEDGER, LEDGERGLLINEITEM)
);

Learn More