Market Segments - Plan/Actual

Query Query: /ERP/SFIN_M01_Q2501

 

You can use this query to compare the plan and actual costs for your market segment in a specific period.

This query is based on the Financials (Planning and Actuals) (/ERP/SFIN_M01) MultiProvider.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Customer Group

/ERP/CUST_GRP

Characteristic Characteristic

Material Group

/ERP/MATL_GRP

Characteristic Characteristic

Segment

/ERP/SEGMENT

Characteristic Characteristic

Posting Period

0FISCPER3

Characteristic Characteristic

Functional Area

/ERP/FUNCAREA

Characteristic Characteristic

Fiscal Year

0FISCYEAR

Characteristic Characteristic

Chart of Accounts

/ERP/CHRTACCT

Characteristic Characteristic

Profit Center

/ERP/PROFTCTR

Characteristic Characteristic

Fiscal Year Variant

0FISCVARNT

Characteristic Characteristic

Controlling Area

/ERP/CO_AREA

Characteristic Characteristic

Currency

0CURRENCY

Characteristic Characteristic

G/L Account

/ERP/GL_ACCT

Characteristic Characteristic

Client

0MANDT

Characteristic Characteristic

Company Code

/ERP/COMPCODE

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Posting Period

0FISCPER3

Characteristic Characteristic

Functional Area

/ERP/FUNCAREA

Characteristic Characteristic

Segment

/ERP/SEGMENT

Characteristic Characteristic

Profit Center

/ERP/PROFTCTR

Characteristic Characteristic

Company Code

/ERP/COMPCODE

Characteristic Characteristic

Business Area

/ERP/BUSAREA

Characteristic Characteristic

Partn. Activity Type

/ERP/PACTTYPE

Characteristic Characteristic

Partner Order Number

/ERP/PCOORDER

Characteristic Characteristic

Partner Project Def.

/ERP/PPROJECT

Characteristic Characteristic

Partner Cost Center

/ERP/PCOSTCTR

Characteristic Characteristic

Partner Funct. Area

/ERP/PFUNAREA

Characteristic Characteristic

Partn. Profit Center

/ERP/PPROFCTR

Characteristic Characteristic

Partner WBS Element

/ERP/PWBSELMT

Characteristic Characteristic

Deb/Cred Ind CO

/ERP/DCINDCO

Characteristic Characteristic

Activity Type

/ERP/ACTTYPE

Characteristic Characteristic

Unit of Measure

0UNIT

Variables

Object Type

Name

Technical Name

Variable Variable

Fiscal Year

/ERP/P_0FISCYEAR01

Variable Variable

Posting Period

/ERP/S_0FISCPER301

Variable Variable

Category

/ERP/P_CATEGORY

Variable Variable

Company Code

/ERP/S_COMPCODE01

Variable Variable

Functional Area

/ERP/S_FUNCAREA01

Variable Variable

Segment

/ERP/S_SEGMENT01

Variable Variable

Profit Center

/ERP/S_PROFTCTR01

Variable Variable

Customer Group

/ERP/S_CUST_GRP01

Variable Variable

Material or Product Group

/ERP/S_MATL_GRP01

Variable Variable

GL Account Hierarchy

/ERP/H_GL_ACCT01

Variable Variable

GL Account / GL Account Group

/ERP/N_GL_ACCT01

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Customer Group

/ERP/CUST_GRP

Characteristic Characteristic

Material Group

/ERP/MATL_GRP

Characteristic Characteristic

G/L Account

/ERP/GL_ACCT

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Actual Amount

Key Figure Key Figure

Plan Amount

Formula Formula

Difference

Formula Formula

%-Difference

Key Figure Key Figure

Actual Quantity

Key Figure Key Figure

Plan Quantity

Formula Formula

Difference

Formula Formula

%-Difference