The new wiki link for this data flow is here:
BW_QRY_CPCOPA03_0002 - BW P&L - Monthly Integrated Margin CM/GM Query
Please update the doc there and no longer here.
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 |
| Table of Contents | ||
|---|---|---|
|
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:
Embedded Google Drive File docid 1Aqb0GGjyxZe2eVBlbJTVqbXAaZgG5LD9
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 | |||||