Show TOC

Planned/Actual Comparison (Periods) Locate this document in the navigation structure

Query Query: /ERP/SFIN_M01_Q0002

 

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.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Client

0MANDT

Characteristic Characteristic

Controlling Area

/ERP/CO_AREA

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Chart of Accounts

/ERP/CHRTACCT

Characteristic Characteristic

Currency

0CURRENCY

Characteristic Characteristic

InfoProvider

0INFOPROV

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Controlling Area

/ERP/CO_AREA

Characteristic Characteristic

Company Code

/ERP/COMPCODE

Characteristic Characteristic

Plant

/ERP/PLANT

Characteristic Characteristic

Profit Center

/ERP/PROFTCTR

Characteristic Characteristic

Cost Center

/ERP/COSTCNTR

Characteristic Characteristic

Order

/ERP/COORDER

Characteristic Characteristic

Project Definition

/ERP/PROJECT

Characteristic Characteristic

WBS Element

/ERP/WBSELMT

Characteristic Characteristic

Functional Area

/ERP/FUNCAREA

Characteristic Characteristic

Segment

/ERP/SEGMENT

Characteristic Characteristic

Customer Group

/ERP/CUST_GRP

Characteristic Characteristic

Material Group

/ERP/MATL_GRP

Characteristic Characteristic

Material

/ERP/MATERIAL

Characteristic Characteristic

Business Area

/ERP/BUSAREA

Characteristic Characteristic

Division

/ERP/DIVISION

Characteristic Characteristic

Industry

/ERP/INDUSTRY

Characteristic Characteristic

Sales District

/ERP/SALESDST

Characteristic Characteristic

Sales Office

/ERP/SALESOFF

Characteristic Characteristic

Sales Group

/ERP/SALESGRP

Characteristic Characteristic

Sales Organization

/ERP/SALESORG

Characteristic Characteristic

Distribution Channel

/ERP/DISTRCHN

Characteristic Characteristic

G/L Account

/ERP/GL_ACCT

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Amount

Key Figure Key Figure

Category

/ERP/CATEGORY

Key Figure Key Figure

Fiscal Year

0FISCYEAR

Key Figure Key Figure

Posting Period

0FISCPER3