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 | Stock margin elimination report (Core Query) |
|---|---|
| Technical Name | BW_QRY_CPCOMS01_0001 |
Application | RTR - MS |
Info-provider | CPCOMS01 |
Usage type | Workbook BW_WB_MS_0099 |
Expected users |
|
Workbook/Query General Description
This query will calculate the stock margin elimination and will be used in workbook BW_WB_MS_0099.
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display |
| |
| Rows/Columns |
| |
| Value Display | Insert screenshot | |
| Planning |
| |
| Extended |
|
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
0I_CMNTH | 0CALMONTH | Manual Input - Interval | Yes | |
| V_C_COMPCDE_C_AUTHMA_002 | C_COMPCDE_C_AUTHMA | Authorization - Selection Option | No | |
| V_COMPPRS_0006 | C_COMPPRS | Authorization - Selection Option | No | |
| V_C_COMPCDE__C_MNGAREA_0006 | C_COMPCDE__C_MNGAREA | Authorization - Selection Option | No | |
| V_C_COMPCDE_0001 | C_COMPCDE | Manual Input - Selection Option | No | |
| C_PLANT02 | C_PLANT | Manual Input - S election Option | No | |
| SOO_C_MATNR2_0001 | C_MATNR2 | Manual Input - S election Option | No | |
| V_LOGSYS_0006 | 0LOGSYS | Manual Input - S election Option | No | |
| V_CPFCTR1_2_0007 | CPFCTR1_2 | Authorization - Seletion option | No | |
| V_0RTYPE | Manual Input - S election Option | Yes | Exchange rate type linkd to conversion type CTK_VARPLT |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Material Type | <> ZHIB <> ZRES <> ZERS | Ex : Exclude intercompanies |
| InfoProvider | = APCOMS04 | Take data from propagation ADSO because conversions + calculations are done in query |
Key figures
List here
Currency Conversion
Exchange Rate Type : V_0RTYPE
Currency : Defined with CTK_VARPLT → use currency of plant
Time Reference : End of the month of 0CALMONTH
Unit Conversion
Unit : use conversion type UOM_MATNR2, unit based on material.
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Row | 0CALMONTH | Calmonth | |
| Row | 0LOGSYS | Source system | |
| Row | C_COMPCDE | Company code | |
| Row | C_PLANT | Plant | |
| Row | C_MATNR2 | Material | |
| Row | C_PRODPLA | Manufacturing Plant |
Free characteristics:
Cells
If you have 2 structures and special cells calculations, explain here.
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 | |