I_GLACCTBALANCE

CDS View
19 Fields 7 CDS Views

G/L Account Balance

I_GLACCTBALANCE is a CDS View in S/4HANA. G/L Account Balance. It contains 19 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_GLAccountBalanceCube view from COMPOSITE G/L Account Balance Cube
I_GLAcctBalanceCube view_entity from COMPOSITE G/L Account Balance - Cube
P_GlAcctBalanceComprn1 view_entity from COMPOSITE GL Account Balance Comparison
P_GlAcctBalanceComprn1 view_entity union_all COMPOSITE GL Account Balance Comparison
P_NO_SAFTGLBALANCE0 view from COMPOSITE Root Norway GL Balance for Customers and Vendors
P_NO_SAFTGLBALANCE0 view union COMPOSITE Root Norway GL Balance for Customers and Vendors
P_SAFTGenLedgerBalance5 view from COMPOSITE SAF-T General Ledger Balance

Fields (19)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY Ledger Ledger 1
KEY LedgerGLLineItem LedgerGLLineItem 1
KEY SourceLedger SourceLedger 1
AlternativeGLAccount AlternativeGLAccount 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
BaseUnit BaseUnit 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency 1
CountryChartOfAccounts CountryChartOfAccounts 1
GLAccount GLAccount 1
Material Material 1
PartnerProjectExternalID PartnerProjectExternalID 1
PartnerProjectInternalID PartnerProjectInternalID 1
ProjectExternalID ProjectExternalID 1
ProjectInternalID ProjectInternalID 1
ValuationArea ValuationArea 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.

-- G/L Account Balance
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCTBALANCE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    ALTERNATIVEGLACCOUNT,
    AMOUNTINCOMPANYCODECURRENCY,
    BASEUNIT,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    COUNTRYCHARTOFACCOUNTS,
    GLACCOUNT,
    MATERIAL,
    PARTNERPROJECTEXTERNALID,
    PARTNERPROJECTINTERNALID,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    VALUATIONAREA,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER, LEDGERGLLINEITEM, SOURCELEDGER)
);

Learn More