The objective of this documentation is not to allow to recreate from scratch the object but to explain everything that is not obvious by looking directly at the query/workbook or emphases on things that are important for the report to work.

Remove the sections that are not relevant.

Description	BW P&L - Monthly Integrated Margin CM/GM Query
Technical Name	BW_QRY_CPCOPA03_0002
Application	P&L
Info-provider	CPCOPA03
Usage type	Analyser
Expected users

Workbook/Query General Description

BW P&L Query - Monthly

General parameters

Global properties

Tab	Screenshot	Comment
Display	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-32-8.png$
Rows/Columns	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-32-26.png$
Value Display	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-32-53.png$
Planning	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-33-9.png$
Extended	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-34-10.png$

Variables

Definitions

Variable Name	Info-object	Selection Type	Required	Description/Explanation
V_CCDE_AUTHMA_0001 Auth Scope on Company Code (Auth with input)	4CPCOPA03-CCDE_AUTHMA	Selection Option	Optional	Authorization variable
V_CONSOV_0001 Conso. view? (1=Yes/0=No)	1FORMULA	Single Value	Mandatory with initial
0P_CALYE Calendar year (Single Val, Mandatory)	0CALYEAR	Single Value	Mandatory without initial
V_FISCYEAR_0003 Currency Conversion Year	0FISCYEAR	Single Value	Optional
V_CPFCTR1_2_0007 BFC GBU (Selection Option, Optional)	CPFCTR1_2	Selection Option	Optional
V_TECM_PFCT2_2_0001 BFC Group of Activities (Select Options, Optional)	4CPCOPA03-TECM_PFCT2_2	Selection Option	Optional
V_CCDE_MNGAREA_0001 BFC Gestion Area	4CPCOPA03-CCDE_MNGAREA	Selection Option	Optional
V_COMPPRS_0006 PRS Company code (Selection option, Optional)	C_COMPPRS	Authorization	Optional
V_C_COMPCDE_0001 Company code (Selection option)	C_COMPCDE	Selection Option	Optional
V_C_PLANT_0010 Plant (Selection Option, Optional)	C_PLANT	Selection Option	Optional
V_0RTYPE Echange rate type	0RTYPE	Single value	Mandatory with initial
V_0CURRENCY_0003 Target Currency	0CURRENCY	Single Value	Optional
V_0UNIT_0001 Qty conv. unit (Single value)	0UNIT	Single Value	Optional

Variable Sequence

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-34-42.png$

Filters

Object

Filter Value

Explanation

Version

C_VERSN2

= 000

= 0

Add screenshot if relevant

Key figures

Structure STR_CPCOP03_0001 & STR_CPCOPA03_0002 documentation:

Currency Conversion

Conversion type: CTK_V_YTD1, CTK_V_YTD2, CTK_V_YTD3, CTK_V_YTD4, CTK_V_YTD5, CTK_V_YTD6, CTK_V_YTD7, CTK_V_YTD8, CTK_V_YTD9, CTK_V_YTD10, CTK_V_YTD11, CTK_V_YTD12.

Exchange Rate Type : Variable (V_0RTYPE)

Currency : Variable (V_0CURRENCY_0003)

Time References : V_0CALDAY_YTD01, V_0CALDAY_YTD02, V_0CALDAY_YTD03, V_0CALDAY_YTD04, V_0CALDAY_YTD05, V_0CALDAY_YTD06, V_0CALDAY_YTD07, V_0CALDAY_YTD08, V_0CALDAY_YTD09, V_0CALDAY_YTD10, V_0CALDAY_YTD11, V_0CALDAY_YTD12.

→ customers exit: Use V_FISCYEAR_0003 to have the year and take the end of each month (January, February....).

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-53-24.png$ $TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-53-41.png$ $TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-54-1.png$

Unit Conversion

Unit : Variable V_0UNIT_0001

Quantity conversion type: QCT_MATNR3

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_16-54-15.png$ $TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_16-54-33.png$

Characteristics

Rows:

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-41-27.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-42-13.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-42-37.png$

Columns:

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-58-37.png$

Free Characteristics:

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-21_10-59-12.png$

Conditions

If you have conditions, explain here.

Condition Name

Active

By default

Key Figure

(Structure)

Operator

Value

Characteristic Assignement

Ex : Excl if <=10

Yes/No

Sales Value

Greater Than

10

Ex : All Independently

Exceptions

If you have conditions, explain here.

Exception Name

Active

By default

Alert Level

Operator

Value

Other parameters

(if different from default)

Ex : Red if <=10

Yes/No

Bad 3

Lesser Than

10