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 - WISE - Collection Global Overview (Core Query) |
|---|---|
| Technical Name | BW_QRY_MVWISE01_0011 |
Application | Financial Supply Chain Management |
Info-provider | MVWISE01 |
Usage type | Direct Execution |
Expected users |
Workbook/Query General Description
This query is build on top of MVWISE01 multiprovider.
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_C_COMPCDE__C_AUTHMA_0001 | C_COMPCDE__C_AUTHMA | Selection Option | Yes | |
| V_C_ZONEFI_0004 | C_CUSTID__C_ZONEFI | Selection Option | Yes | |
| C_COMPCDE_01 | C_COMPCDE | Selection Option | Yes | |
| 0P_KEYDT | 0NETDUEDATE | Single | Yes | |
| 0S_GLACC | 0GL_ACCOUNT | Selection Option | Yes | |
| V_C_MERGDAT_0003 | C_COMPCDE__C_MERGDAT | Single | Yes | |
| V_C_COMPPRS_0005 | C_COMPCDE__C_COMPPRS | Selection Option | Yes | |
| V_C_ZONE_0002 | C_COMPCDE__C_ZONE | Selection Option | Yes | |
| V_C_FLGINT_0003 | C_COMPCDE__C_FLGINT | Single | Yes | |
| V_CUSTPRS_0001 | C_CUSTID__C_CUSTPR | Selection Option | Yes | |
| V_C_CUSTID__C_FLGINT_0001 | C_CUSTID__C_FLGINT | Single | Yes | |
| V_PFCTR1_2_0001 | 0G_CWWE01__CPFCTR1_2 | Selection Option | Yes |
Variable Sequence
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| C_ERRFLG | = # | |
| C_COMPCDE__C_FGPTOB | <> 1 | |
| 0GL_ACCOUNT__C_GL_STYP | <> PRODUCT DOUBTFUL <> SERVICES DOUBTFUL <> DOUBTFUL <> WRITE DOWN | |
| 0FI_DOCSTAT | = O | |
| C_COMPCDE__C_MERGDAT | = # |
Add screenshot if relevant
Key figures
Key Figure 1
Description
Text/name of the variable and explanation
Calculation rule detail
Quantity x Price
Text Replacement Variable
If relevant, add the text replacement rule used for the key figure
Currency Conversion
Exchange Rate Type : Ex ZRH0
Currency : Variable, or fixed currency used
Time Reference : Current date / Based on infoobject X / Variable
Unit Conversion
Unit : Variable or fixed unit
Characteristics
| Location | Info-object Name | Info-object Text | Explanation (if needed) |
|---|---|---|---|
| Free | C_CUSTSAL__C_ZIPART | CSR (Sold-to) | |
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 | |