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 Integrated Margin CM/GM Query
Technical Name	BW_QRY_CPCOPA03_0001
Application	P&L
Info-provider	CPCOPA03
Usage type	Direct usage in Analyser
Expected users

Workbook/Query General Description

Enter some description to explain what is the purpose of this query/workbook and who/how it will be used.

General parameters

Global properties

Tab	Screenshot	Comment
Display	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_15-34-48.png$
Rows/Columns	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_15-35-11.png$
Value Display	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_15-35-22.png$
Planning	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_15-35-47.png$
Extended	$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_15-36-2.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
0I_CMNTH Calendar year/month	0CALMONTH	Interval	Mandatory with initial
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_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_15-36-44.png$

Filters

Object

Filter Value

Explanation

Version

C_VERSN2

= 000

= 0

Ex : Exclude intercompanies

Add screenshot if relevant

Key figures

Structure STR_CPCOP03_0001 documentation:

Currency Conversion

Exchange Rate Type : Variable (V_0RTYPE)

Currency : Variable (V_0CURRENCY_0003)

Time Reference : End of the month of 0CALMONTH (Variable V_0DATE_0002)

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_16-57-26.png$ $TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_16-57-40.png$ $TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_16-57-54.png$

Unit Conversion

Unit : Variable V_0UNIT_0001

Quantity conversion type: QCT_MATNR3

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

Characteristics

Columns

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_16-59-21.png$

Row

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_16-59-53.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-0-18.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-1-53.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-7-21.png$

Free characteristicss:

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-11-19.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-11-54.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-12-20.png$

If you have 2 structures and special cells calculations, explain here.Cells

Conditions

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-17-46.png$

$TECHNO - BI TEAM > BW_QRY_CPCOPA03_0001 - BW P&L Integrated Margin CM/GM Query /!\ obsolete /!\ > image2022-3-14_17-18-7.png$

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