GLACCOUNTBALANCE

22 Fields

GLACCOUNTBALANCE is an SAP database table in S/4HANA. It contains 22 fields.

Fields (22)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY ChartOfAccounts ChartOfAccounts 6
KEY CompanyCode CompanyCode 6
KEY FiscalYear FiscalYear 4
KEY GLAccount GLAccount 4
KEY Ledger Ledger 8
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
AccountingDocumentItem AccountingDocumentItem 2
CompanyCodeCurrency CompanyCodeCurrency 7
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 3
CreditAmountInReportingCrcy CreditAmountInReportingCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 3
DebitAmountInReportingCurrency DebitAmountInReportingCurrency 1
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 3
EndingBalanceAmtInRptgCrcy EndingBalanceAmtInRptgCrcy 1
FiscalPeriod FiscalPeriod 4
PostingDate PostingDate 4
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy 3
StartingBalanceAmtInRptgCrcy StartingBalanceAmtInRptgCrcy 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 GLACCOUNTBALANCE (
    ACCOUNTINGDOCUMENT,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    FISCALYEAR,
    GLACCOUNT,
    LEDGER,
    LEDGERGLLINEITEM,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    ACCOUNTINGDOCUMENTITEM,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINREPORTINGCRCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINREPORTINGCURRENCY,
    ENDINGBALANCEAMTINCOCODECRCY,
    ENDINGBALANCEAMTINRPTGCRCY,
    FISCALPERIOD,
    POSTINGDATE,
    STARTINGBALANCEAMTINCOCODECRCY,
    STARTINGBALANCEAMTINRPTGCRCY,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CHARTOFACCOUNTS, COMPANYCODE, FISCALYEAR, GLACCOUNT, LEDGER, LEDGERGLLINEITEM, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More