You can use this query to compare annual 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 Years (/ERP/SFIN_A00_IRQ0001
), Internal Order Planning on Years (/ERP/SFIN_A10_IRQ0001
), Project Planning on Years (/ERP/SFIN_A20_IRQ0001
), Market Segment Planning on Years (/ERP/SFIN_A50_IRQ0001
), Profit Center Planning on Years (/ERP/SFIN_A70_IRQ0001
), Functional Area Planning on Years (/ERP/SFIN_A80_IRQ0001
) and P&L Planning on Years (/ERP/SFIN_A90_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 | Posting Period | 0FISCPER3 |
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 |