TRIALBALANCEITEM

16 Fields

TRIALBALANCEITEM is an SAP database table in S/4HANA. It contains 16 fields.

Fields (16)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 5
KEY CompanyCode CompanyCode 5
KEY GLAccount GLAccount 4
KEY Ledger Ledger 5
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
AlternativeGLAccount AlternativeGLAccount 2
AlternativeGLAccountIsUsed AlternativeGLAccountIsUsed 1
CreditAmountInReportingCrcy CreditAmountInReportingCrcy 2
DebitAmountInReportingCurrency DebitAmountInReportingCurrency 2
EndingBalanceAmtInRptgCrcy EndingBalanceAmtInRptgCrcy 2
FiscalPeriod FiscalPeriod 5
JrnlEntryItemMigrationSource JrnlEntryItemMigrationSource 1
ReportingCurrency ReportingCurrency 2
StartingBalanceAmtInRptgCrcy StartingBalanceAmtInRptgCrcy 2

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 TRIALBALANCEITEM (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    GLACCOUNT,
    LEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    ALTERNATIVEGLACCOUNT,
    ALTERNATIVEGLACCOUNTISUSED,
    CREDITAMOUNTINREPORTINGCRCY,
    DEBITAMOUNTINREPORTINGCURRENCY,
    ENDINGBALANCEAMTINRPTGCRCY,
    FISCALPERIOD,
    JRNLENTRYITEMMIGRATIONSOURCE,
    REPORTINGCURRENCY,
    STARTINGBALANCEAMTINRPTGCRCY,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, GLACCOUNT, LEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID)
);

Learn More