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 |
| |
| Rows/Columns |
| |
| Value Display |
| |
| Planning |
| |
| Extended |
|
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
Filters
| Object | Filter Value | Explanation |
|---|---|---|
Version C_VERSN2 | = 000 = 0 |
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....).
Unit Conversion
Unit : Variable V_0UNIT_0001
Quantity conversion type: QCT_MATNR3
Characteristics
Rows:
Columns:
Free Characteristics:
Conditions
| Condition Name | Active By default | Key Figure (Structure) | Operator | Value | Characteristic Assignement |
|---|---|---|---|---|---|
Exceptions
| Exception Name | Active By default | Alert Level | Operator | Value | Other parameters (if different from default) |
|---|---|---|---|---|---|
| Yes/No | |||||