GLACCTBALANCE

17 Fields

GLACCTBALANCE is an SAP database table in S/4HANA. It contains 17 fields.

Fields (17)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalPeriodDate FiscalPeriodDate 1
KEY FiscalYear FiscalYear 1
KEY GLAccountFlowType GLAccountFlowType 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SourceLedger SourceLedger 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
Customer Customer 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 1
FinancialAccountType FinancialAccountType 1
GLAccount GLAccount 1
SpecialGLCode SpecialGLCode 1
Supplier Supplier 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 GLACCTBALANCE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALPERIODDATE,
    FISCALYEAR,
    GLACCOUNTFLOWTYPE,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    CUSTOMER,
    DEBITAMOUNTINCOCODECRCY,
    ENDINGBALANCEAMTINCOCODECRCY,
    FINANCIALACCOUNTTYPE,
    GLACCOUNT,
    SPECIALGLCODE,
    SUPPLIER,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALPERIODDATE, FISCALYEAR, GLACCOUNTFLOWTYPE, LEDGERGLLINEITEM, SOURCELEDGER)
);

Learn More