- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_CnsldtnRpt30Q
Group Data Analysis
| view: CSRPT30Q
| Extraction:
Not supported
| Component: Embedded Analytics
Tables used:
ACDOCU, FINCS_REF_VERS_R, ACDOCU, FINCS_GRPSTR, TF200, HRRP_NODE, FINSC_FISC_DATE, FINSC_PERIOD
- 🔑 Keys
- 💰 Amounts (6)
- ∑ Quantities (2)
- 📅 Dates (2)
- ☰ Categorical (5)
- Other (67)
- 🔗 Relations
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 💲 Currency Key (TransactionCurrency): | ||
| AmountInTransactionCurrency | Amount in Transaction Currency | |
| CnsldtnSignAdjdAmtInTransCrcy | Sign-Adjusted Amount in Transaction Currency | |
| 💲 Currency key of the local currency (LocalCurrency): | ||
| AmountInLocalCurrency | Amount in Local Currency | |
| CnsldtnSignAdjdAmtInLocalCrcy | Sign-Adjusted Amount in Local Currency | |
| 💲 Group Currency (GroupCurrency): | ||
| AmountInGroupCurrency | Value in Group Currency | |
| CnsldtnSignAdjdAmtInGroupCrcy | Sign-Adjusted Amount in Group Currency | |
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (BaseUnit): | ||
| CnsldtnQuantityInBaseUnit | Quantity | |
| CnsldtnSignAdjdQtyInBaseUnit | Sign-Adjusted Quantity | |
| Column Name | Description | |
|---|---|---|
| PostingDate | Posting Date in the Document | |
| KeyDate | null |
| Column Name | Description | |
|---|---|---|
| PeriodMode | Period Mode | Show values |
| InvestmentActivityType | Consolidation of Investments Activity | Show values |
| PostingLevel | Posting Level | Show values |
| CurrencyConversionsDiffType | Currency Translation | Show values |
| GLRecordType | Record Type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| ConsolidationChartOfAccounts | Consolidation Chart of Accounts | FC_ITCLG | |
| ConsolidationVersion | Consolidation Version | FC_RVERS | |
| ConsolidationVersionElement | Consolidation Version Element | FC_RVERS | |
| FiscalYear | Fiscal Year | GJAHR | |
| FiscalPeriod | Fiscal Period | POPER | |
| FiscalYearPeriod | Fiscal Year Period | FIS_JAHRPER_CONV | |
| ConsolidationDimension | Dimension | FC_DIMEN | |
| ConsolidationGroup | Consolidation Group | FINCS_CONGR | |
| ConsolidationUnitForElim | Consolidation Unit for Elimination | FINCS_ELIMINATION_MEMBER | |
| ConsolidationUnit | Consolidation Unit | FC_BUNIT | |
| FinancialStatementItem | Financial Statement Item | FC_ITEM | |
| SubItemCategory | Subitem Category | FC_SITYP | |
| SubItem | Subitem | FC_SITEM | |
| PartnerConsolidationUnit | Partner Unit | FC_BUNIT | |
| ConsolidationDocumentType | Document Type | FC_DOCTY | |
| InvesteeConsolidationUnit | Investee Unit | FC_BUNIT | |
| InvestmentActivity | Consolidation of Investments Activity Number | BELNR | |
| InvestorConsolidationUnit | Investor Unit | FC_BUNIT | |
| ChartOfAccounts | Chart of Accounts | KTOPL | |
| GLAccount | Account Number | SAKNR | |
| AssignmentReference | Assignment number | ZUONR | |
| CostCenter | Cost Center | KOSTL | |
| ProfitCenter | Profit Center | PRCTR | |
| ConsolidationPrftCtrForElim | Profit Center for Elimination | FINCS_ELIMINATION_MEMBER | |
| FunctionalArea | Functional Area | FKBER | |
| BusinessArea | Business Area | GSBER | |
| ControllingArea | Controlling Area | CACCD | |
| Segment | Segment for Segmental Reporting | FB_SEGMENT | |
| ConsolidationSegmentForElim | Segment for Elimination | FINCS_ELIMINATION_MEMBER | |
| PartnerCostCenter | Sender cost center | KOSTL | |
| PartnerProfitCenter | Partner Profit Center | PRCTR | |
| PartnerFunctionalArea | Partner Functional Area | FKBER | |
| PartnerBusinessArea | Trading partner's business area | GSBER | |
| PartnerCompany | Company ID of Trading Partner | RCOMP | |
| PartnerSegment | Partner Segment for Segmental Reporting | FB_SEGMENT | |
| OrderID | Order Number | AUFNR | |
| Customer | Customer Number | KUNNR | |
| Supplier | Account Number of Supplier | LIFNR | |
| Material | Material Number | MATNR | |
| Plant | Plant | WERKS | |
| FinancialTransactionType | Transaction type | RMVCT | |
| WBSElementExternalID | Work Breakdown Structure Element (WBS Element) | PS_POSID | |
| Project | Project definition | PS_PSPID | |
| BillingDocumentType | Billing Type | FKART | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| OrganizationDivision | Division | SPART | |
| MaterialGroup | Material Group | MATKL | |
| SoldProduct | Product Sold | MATNR | |
| SoldProductGroup | Product Sold Group | MATKL | |
| CustomerGroup | Customer Group | KDGRP | |
| CustomerSupplierCountry | Country/Region Key | LAND1 | |
| CustomerSupplierIndustry | Industry key | BRSCH | |
| SalesDistrict | Sales District | BZIRK | |
| BillToParty | Bill-to Party | KUNNR | |
| ShipToParty | Ship-to Party | KUNNR | |
| CnsldtnAdhocItem | Ad Hoc Item | FINCS_ADHOCITEM | |
| CnsldtnAdhocSet | Ad Hoc Set | FINCS_ADHOCSET | |
| CnsldtnAdhocSetItem | Ad Hoc Set Item | FINCS_ADHOCSETITEM | |
| MatchingReasonCode | Reason Code | ICA_RCODE | |
| OriginType | Origin Type | FINCS_ORIG_TYPE | |
| OriginReference | Origin Reference | FINCS_ORIG_REF | |
| ConsolidationDocumentNumber | Group Journal Entry | BELNR | |
| CnsldtnGroupJrnlEntryBundle | Document Bundle Number | FINCS_BUNNR | |
| ConsolidationUnitHierarchy | null | ||
| ConsolidationSegmentHierarchy | null | ||
| ConsolidationPrftCtrHierarchy | null |