The new wiki link for this data flow is here:
QVSBS_BW_QRY_CPCOPA03_0001 - QV - BW P&L & Integrated Margin Query (CAR3)
Please update the doc there and no longer here.
Description | QV - BW P&L & Integrated Margin Query (CAR3) |
|---|---|
| Technical Name | QVSBS_BW_QRY_CPCOPA03_0001 |
Application | P&L |
Info-provider | CPCOPA03 |
Usage type | Qlikview source |
Expected users |
Workbook/Query General Description
Qlikview query for P&L by sales order.
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_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_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 | |
Plant C_PLANT | <> 8335 |
Key figures
Currency Conversion
Exchange Rate Type : Variable (V_0RTYPE)
Currency type: CTK_CAR3_E
Time Reference : V_0DATE_0002 (End of the month of 0CALMONTH)
Currency type: CTK_CAR3_U
Time Reference : V_0DATE_0002 (End of the month of 0CALMONTH)
Unit Conversion
Conversion type: QCT_MATNR3
Unit : Variable V_0UNIT_0001
Characteristics
Free:
Rows:
Columns:
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 | |||||