You can use this query to compare period values (costs and revenues) of all categories (planned and actual) with each other. All of the account assignment-relevant characteristics are available for the row drilldown, so that you can use this query to analyze the planned data, and to check its dimensions that are derived when you enter the plan figures with planning queries, such as functional area or profit center.
This query is based on the MultiProvider Financials (Planning and Actuals) (/ERP/SFIN_M01
) and is used in queries Cost Center Planning on Periods (/ERP/SFIN_A01_IRQ0001
), Internal Order Planning on Periods (/ERP/SFIN_A11_IRQ0001
), Project Planning on Periods (/ERP/SFIN_A21_IRQ0001
), Market Segment Planning on Periods (/ERP/SFIN_A51_IRQ0001
), Profit Center Planning on Periods (/ERP/SFIN_A71_IRQ0001
), Functional Area Planning on Periods (/ERP/SFIN_A81_IRQ0001
) and P&L Planning on Periods (/ERP/SFIN_A91_IRQ0001
) as the jump target using report/report interface.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Client | 0MANDT | |
Characteristic | Controlling Area | /ERP/CO_AREA |
Object Type | Name | Technical Name |
---|---|---|
Characteristic | Chart of Accounts | /ERP/CHRTACCT |
Characteristic | Currency | 0CURRENCY |
Characteristic | InfoProvider | 0INFOPROV |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Controlling Area | /ERP/CO_AREA | |
Characteristic | Company Code | /ERP/COMPCODE | |
Characteristic | Plant | /ERP/PLANT | |
Characteristic | Profit Center | /ERP/PROFTCTR | |
Characteristic | Cost Center | /ERP/COSTCNTR | |
Characteristic | Order | /ERP/COORDER | |
Characteristic | Project Definition | /ERP/PROJECT | |
Characteristic | WBS Element | /ERP/WBSELMT | |
Characteristic | Functional Area | /ERP/FUNCAREA | |
Characteristic | Segment | /ERP/SEGMENT | |
Characteristic | Customer Group | /ERP/CUST_GRP | |
Characteristic | Material Group | /ERP/MATL_GRP | |
Characteristic | Material | /ERP/MATERIAL | |
Characteristic | Business Area | /ERP/BUSAREA | |
Characteristic | Division | /ERP/DIVISION | |
Characteristic | Industry | /ERP/INDUSTRY | |
Characteristic | Sales District | /ERP/SALESDST | |
Characteristic | Sales Office | /ERP/SALESOFF | |
Characteristic | Sales Group | /ERP/SALESGRP | |
Characteristic | Sales Organization | /ERP/SALESORG | |
Characteristic | Distribution Channel | /ERP/DISTRCHN | |
Characteristic | G/L Account | /ERP/GL_ACCT |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Amount | ||
Key Figure | Category | /ERP/CATEGORY | |
Key Figure | Fiscal Year | 0FISCYEAR | |
Key Figure | Posting Period | 0FISCPER3 |