I_CNSLDTNFNDNCUBE

CDS View
8 Fields 27 CDS Views

Consolidation Foundation Cube

I_CNSLDTNFNDNCUBE is a CDS View in S/4HANA. Consolidation Foundation Cube. It contains 8 fields. 27 CDS views read from this table.

CDS Views using this table (27)

ViewTypeJoinVDMDescription
C_CnsldtdTotals01Q view from CONSUMPTION Data Analysis – Reporting Logic
C_CnsldtdTotals11Q view from CONSUMPTION Consolidated Balance Sheet
C_CnsldtdTotals12Q view from CONSUMPTION Consolidated Balance Sheet - Year Comparison
C_CnsldtdTotals13Q view from CONSUMPTION Consolidated Balance Sheet -By Subgroups
C_CnsldtdTotals15Q view from CONSUMPTION Consolidated Balance Sheet - By Movements
C_CnsldtdTotals21Q view from CONSUMPTION Consolidated P&L by Nature
C_CnsldtdTotals22Q view from CONSUMPTION Consolidated P&L by Nature - Year Comparison
C_CnsldtdTotals23Q view from CONSUMPTION Consolidated P&L by Nature - By Subgroups
C_CnsldtdTotals24Q view from CONSUMPTION Consolidated P&L by Nature - By Functional Areas
C_CnsldtdTotals61Q view from CONSUMPTION Currency Translation - Reserve Analysis
C_CnsldtdTotals62Q view from CONSUMPTION Currency Translation - Difference Analysis
C_CnsldtnTotals01Q view from CONSUMPTION Data Analysis
C_CnsldtnTotals11Q view from CONSUMPTION Balance Sheet - By Consolidation Units
C_CnsldtnTotals12Q view from CONSUMPTION Balance Sheet - Year Comparison
C_CnsldtnTotals15Q view from CONSUMPTION Balance Sheet - By Movements
C_CnsldtnTotals21Q view from CONSUMPTION P&L by Nature of Expense - By Consolidation Units
C_CnsldtnTotals22Q view from CONSUMPTION P&L by Nature of Expense - Year Comparison
C_CnsldtnTotals24Q view from CONSUMPTION P&L by Nature of Expense - By Functional Areas
P_CnsldtnFndnWithRptRule view from COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE2 view from COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE2 view union_all COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE3 view from COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE3 view union_all COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE5 view from COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE5 view union_all COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE8 view from COMPOSITE
P_CNSLDTNFNDNWITHRPTRULE8 view union_all COMPOSITE

Fields (8)

KeyField CDS FieldsUsed in Views
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 5
ConsolidationDocumentType ConsolidationDocumentType 4
ConsolidationUnit ConsolidationUnit 4
ConsolidationVersion ConsolidationVersion 4
FinancialStatementItem FinancialStatementItem 5
GroupCurrency GroupCurrency 4
SubItem SubItem 5
SubItemCategory SubItemCategory 5

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.

-- Consolidation Foundation Cube
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNFNDNCUBE (
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONDOCUMENTTYPE,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONVERSION,
    FINANCIALSTATEMENTITEM,
    GROUPCURRENCY,
    SUBITEM,
    SUBITEMCATEGORY
);

Learn More