Show TOC

Market Segment Planning on Periods Locate this document in the navigation structure

Query Query: /ERP/SFIN_A51_IRQ0001

 

You can use this query to enter your planned costs in a fiscal year for one or more market segments (material group/customer group) at period level. The query is based on aggregation level /ERP/SFIN_A51, and is used in workbook Market Segment Planning on Periods (/ERP/SFIN_A51_WB01).

Example Example

You are a product manager and want to plan the packaging costs incurred in the coming fiscal year for your material group at period level. To do this, you start the query and specify in the selection screen for the following selection criteria the values for which you want to plan costs:

  • The coming fiscal year

  • The category

  • The company code

  • The currency

  • Your material group

Once you have confirmed the selection criteria, the system displays a table with columns for the material groups (your material group), the customer groups, the general ledger accounts (cost elements), the actual values of the previous fiscal year, the planned values of the coming fiscal year, and a difference column. There is a column in the query for periods 1 - 12 for the year selected for both actual and planned values. The fields in the plan columns are ready for input You can enter there your planned costs in the rows for the corresponding G/L account.

End of the example.

Structure

Filters

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Client

0MANDT

Characteristic Characteristic

Currency

0CURRENCY

Characteristic Characteristic

Posting Period

0FISCPER3

Characteristic Characteristic

Fiscal Year Variant

0FISCVARNT

Characteristic Characteristic

Customer Group

/ERP/CUST_GRP

Characteristic Characteristic

Fiscal Year

0FISCYEAR

Characteristic Characteristic

Material Group

/ERP/MATL_GRP

Characteristic Characteristic

Controlling Area

/ERP/CO_AREA

Characteristic Characteristic

Company Code

/ERP/COMPCODE

Characteristic Characteristic

Chart of Accounts

/ERP/CHRTACCT

Characteristic Characteristic

G/L Account

/ERP/GL_ACCT

Free Characteristics

Object Type

Name

Technical Name

Characteristic Characteristic

Currency

0CURRENCY

Characteristic Characteristic

Company Code

/ERP/COMPCODE

Characteristic Characteristic

Category

/ERP/CATEGORY

Variables

Object Type

Name

Technical Name

Variable Variable

Fiscal Year

/ERP/P_0FISCYEAR01

Variable Variable

Category

/ERP/P_CATEGORY

Variable Variable

Company Code

/ERP/P_COMPCODE01

Variable Variable

Material or Product Group

/ERP/M_MATL_GRP01

Variable Variable

Customer Group

/ERP/M_CUST_GRP01

Variable Variable

GL Account Hierarchy

/ERP/H_GL_ACCT01

Variable Variable

GL Account / GL Account Group

/ERP/N_GL_ACCT01

Variable Variable

Currency

/ERP/P_0CURRENCY01

Rows

Object Type

Name

Technical Name

Value Restriction / Calculation

Characteristic Characteristic

Material Group

/ERP/MATL_GRP

Characteristic Characteristic

Customer Group

/ERP/CUST_GRP

Characteristic Characteristic

G/L Account

/ERP/GL_ACCT

Columns

Object Type

Name

Technical Name

Value Restriction / Calculation

Key Figure Key Figure

Total Actual

&/ERP/T_FISCYEAR01&

Key Figure Key Figure

Period 1

Key Figure Key Figure

Period 2

Key Figure Key Figure

Period 3

Key Figure Key Figure

Period 4

Key Figure Key Figure

Period 5

Key Figure Key Figure

Period 6

Key Figure Key Figure

Period 7

Key Figure Key Figure

Period 8

Key Figure Key Figure

Period 9

Key Figure Key Figure

Period 10

Key Figure Key Figure

Period 11

Key Figure Key Figure

Period 12

Key Figure Key Figure

Total Plan

&/ERP/T_FISCYEAR01&

Key Figure Key Figure

Period 1

Key Figure Key Figure

Period 2

Key Figure Key Figure

Period 3

Key Figure Key Figure

Period 4

Key Figure Key Figure

Period 5

Key Figure Key Figure

Period 6

Key Figure Key Figure

Period 7

Key Figure Key Figure

Period 8

Key Figure Key Figure

Period 9

Key Figure Key Figure

Period 10

Key Figure Key Figure

Period 11

Key Figure Key Figure

Period 12

Formula Formula

Difference Plan Actual