TRIALBALANCE

33 Fields

TRIALBALANCE is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY ChartOfAccounts ChartOfAccounts 1
KEY CompanyCode CompanyCode 1
KEY FinancialStatementVariant FinancialStatementVariant 1
KEY FiscalYear FiscalYear 1
KEY GLAccount GLAccount 1
KEY HierarchyNodeUniqueID HierarchyNodeUniqueID 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY StatryRptCategory StatryRptCategory 1
KEY StatryRptgEntity StatryRptgEntity 1
KEY StatryRptRunID StatryRptRunID 1
KEY ValidityEndDate ValidityEndDate 1
AccountingDocumentItem AccountingDocumentItem 1
BusinessPlace BusinessPlace 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInReportingCrcy CreditAmountInReportingCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInReportingCurrency DebitAmountInReportingCurrency 1
EndingBalanceAmtInCoCodeCrcy EndingBalanceAmtInCoCodeCrcy 1
FinancialStatementItem FinancialStatementItem 1
FiscalPeriod FiscalPeriod 1
GLAccountGroup GLAccountGroup 1
GLAccountInfo GLAccountInfo 1
GLAccountType GLAccountType 1
MX_SATGLAccountGrouping MX_SATGLAccountGrouping 1
PostingDate PostingDate 1
ReportingCurrency ReportingCurrency 1
StartingBalanceAmtInCoCodeCrcy StartingBalanceAmtInCoCodeCrcy 1
StartingBalanceAmtInRptgCrcy StartingBalanceAmtInRptgCrcy 1
ValidityStartDate ValidityStartDate 1
VATRegistration VATRegistration 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 TRIALBALANCE (
    ACCOUNTINGDOCUMENT,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    FINANCIALSTATEMENTVARIANT,
    FISCALYEAR,
    GLACCOUNT,
    HIERARCHYNODEUNIQUEID,
    LEDGER,
    LEDGERGLLINEITEM,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    VALIDITYENDDATE,
    ACCOUNTINGDOCUMENTITEM,
    BUSINESSPLACE,
    COMPANYCODECURRENCY,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINREPORTINGCRCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINREPORTINGCURRENCY,
    ENDINGBALANCEAMTINCOCODECRCY,
    FINANCIALSTATEMENTITEM,
    FISCALPERIOD,
    GLACCOUNTGROUP,
    GLACCOUNTINFO,
    GLACCOUNTTYPE,
    MX_SATGLACCOUNTGROUPING,
    POSTINGDATE,
    REPORTINGCURRENCY,
    STARTINGBALANCEAMTINCOCODECRCY,
    STARTINGBALANCEAMTINRPTGCRCY,
    VALIDITYSTARTDATE,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CHARTOFACCOUNTS, COMPANYCODE, FINANCIALSTATEMENTVARIANT, FISCALYEAR, GLACCOUNT, HIERARCHYNODEUNIQUEID, LEDGER, LEDGERGLLINEITEM, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, VALIDITYENDDATE)
);

Learn More