SAP S/4HANA Group Reporting provides a number of CDS views (Core Data Services) for financial consolidation reporting. These views allow users to create various consolidated financial reports such as balance sheets, income statements, cash flow statements, and others by leveraging data from the ACDOCU table and related consolidation data sources. Below is a detailed list of important standard CDS views available for Group Reporting, categorized by their usage in different aspects of consolidation:
1. General Reporting CDS Views
I_ConsolidatedGroupReportingItemCube
- Provides a consolidated cube for Group Reporting containing aggregated values for consolidated financial statements.
- It includes data for the consolidation unit, fiscal year, and key figures like total assets, liabilities, and profit.
I_ConsolidationGroupHierarchyNode
- Provides the hierarchical structure of consolidation groups, useful for reporting at different levels of the consolidation group hierarchy.
I_ConsolidationUnitHierarchyNode
- Provides hierarchical data for consolidation units, enabling reports at different levels of consolidation units within the hierarchy.
I_ConsolidatedFinancialStatements
- A CDS view that provides a high-level summary of consolidated financial statements (e.g., consolidated balance sheet, income statement) for each consolidation unit.
2. Consolidation Entries and Adjustments
I_ConsolidationDocument
- Provides data on the consolidation entries posted to ACDOCU, including data such as document number, posting date, consolidation unit, and the amount posted.
I_ConsolidationDocumentLineItem
- Displays line-item details for each consolidation document posted to ACDOCU, including consolidation group, unit, and financial statement item.
I_ConsolidationDataCube
- A cube that allows for reporting of eliminations, adjustments, and consolidation entries at the group level. This view provides visibility into eliminations (e.g., intercompany payables and receivables).
3. Profit and Loss CDS Views
I_ConsolidatedProfitLoss
- Provides consolidated profit and loss statement data for a group, including revenue, cost of sales, operating profit, and net income, broken down by the consolidation unit.
I_ConsolidationIncomeStatementCube
- A specific cube that focuses on income statement line items across the consolidation group, providing aggregated data for revenues, expenses, and profitability.
4. Balance Sheet CDS Views
I_ConsolidatedBalanceSheet
- Provides consolidated balance sheet data, including assets, liabilities, and equity positions, for each consolidation unit within the group.
I_ConsolidationBalanceSheetItemCube
- A detailed cube for balance sheet items (e.g., fixed assets, current assets, liabilities, and equity) with consolidated values for each group and unit.
5. Elimination and Intercompany Transactions
I_ConsolidationElimination
- Provides detailed data on eliminations performed during the consolidation process, such as eliminations of intercompany payables/receivables, sales, and COGS.
I_IntercompanyReconciliationData
- Enables reports on intercompany reconciliation, showing the elimination entries and differences identified between consolidation units for transactions like intercompany sales, purchases, or services.
6. Currency Translation CDS Views
I_ConsolidationCurrencyTranslation
- Displays data on currency translation adjustments for entities that report in different currencies, including translation differences posted to ACDOCU.
I_ConsolidationGroupCurrency
- Provides details on the group currency used for consolidation, including translation rates and adjustments.
7. Consolidation of Investments
- I_ConsolidationInvestmentElimination
- Provides detailed data for the elimination of investments in subsidiaries or affiliated entities, including elimination of the investment and adjustments made for goodwill.
8. Non-Controlling Interests (NCI)
- I_ConsolidationNonControllingInterest
- Provides data for adjustments related to non-controlling interests (NCI), such as profit and loss allocated to non-controlling interest and adjustments to equity positions.
9. Consolidated Cash Flow
- I_ConsolidatedCashFlow
- Provides detailed reporting for consolidated cash flow statements, including cash inflows and outflows, operating, investing, and financing activities for each consolidation unit.
10. Plan Data for Group Reporting
I_ConsolidationPlanData
- A CDS view to report planned financial data for consolidation purposes, enabling comparison between actual and plan data for consolidated financial statements.
I_ConsolidationPlanDocument
- Displays planned consolidation entries, similar to actuals but focusing on data from planning exercises.
11. Other Useful CDS Views
I_ConsolidationCategory
- Shows different categories of consolidation such as actual, budget, or plan, allowing segmentation in reports.
I_ConsolidationVersion
- Provides details on the version used in the consolidation process (e.g., different consolidation scenarios or timeframes).
I_ConsolidationRule
- Shows the consolidation rules used for eliminations, adjustments, and other activities during the consolidation process.
How to Use CDS Views in Group Reporting
Data Source for Reports: These CDS views can be used as the data source for SAP Fiori Apps, SAP Analytics Cloud (SAC) reports, or custom reporting tools.
Analysis and Customization: Users can analyze data directly from these views or customize them by creating extensions to meet specific reporting needs (e.g., adding custom fields for financial ratios).
Real-Time Insights: Since CDS views work in real-time with the underlying data in SAP S/4HANA, they allow for up-to-date reporting without needing additional data replication.
Integration with SAC: For enhanced visualization, these CDS views can be consumed in SAP Analytics Cloud, providing dashboarding and advanced reporting for financial consolidation.
These CDS views form the backbone for financial reporting in SAP Group Reporting, offering flexibility and scalability for different reporting needs.
No comments:
Post a Comment