I_GLACCTBALANCECUBE

CDS View
12 Fields 5 CDS Views

G/L Account Balance - Cube

I_GLACCTBALANCECUBE is a CDS View in S/4HANA. G/L Account Balance - Cube. It contains 12 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
C_BR_FinStmntAcctBalCube view inner CONSUMPTION Financial Statement Account Balance Cube
C_TrialBalance view from CONSUMPTION Trial Balance
C_Trialbalanceq0001 view from CONSUMPTION Trial Balance
FAC_DART_Z3_ARAPBALANCE view from AR/AP Balance
FAC_DART_Z3_GLACCTBALANCE view from G/L Account Balance

Fields (12)

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
_CompanyCode _CompanyCode 1
PartnerProjectExternalID PartnerProjectExternalID 2
PartnerProjectInternalID PartnerProjectInternalID 2
ProjectExternalID ProjectExternalID 2
ProjectInternalID ProjectInternalID 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.

-- G/L Account Balance - Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_GLACCTBALANCECUBE (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALPERIODDATE,
    FISCALYEAR,
    GLACCOUNTFLOWTYPE,
    LEDGERGLLINEITEM,
    SOURCELEDGER,
    _COMPANYCODE,
    PARTNERPROJECTEXTERNALID,
    PARTNERPROJECTINTERNALID,
    PROJECTEXTERNALID,
    PROJECTINTERNALID,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALPERIODDATE, FISCALYEAR, GLACCOUNTFLOWTYPE, LEDGERGLLINEITEM, SOURCELEDGER)
);

Learn More