The new wiki link for this data flow is here:
BW - DP - Mid Term Planning MTP (Core Query)
Please update the new 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 - DP - MTP (Core Query) |
|---|---|
| Technical Name | BW_QRY_CPDYN14_0001 |
Application | DP - Demand Planning |
Info-provider | Composite Provider CPDYN14 |
Usage type | Direct execution via Analysis |
Expected users | GBU Special Chem (to start) |
Workbook/Query General Description
Specification
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| Display | Insert screenshot | |
| Rows/Columns | Insert screenshot | |
| Value Display | Insert screenshot | |
| Planning | Insert screenshot | |
| Extended | Insert screenshot |
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
Ex : Calendar Day | 0CALDAY | Single/Multiple/SelectOption/SAPexit/ClientExit | Yes/No | Explanation for the use of this variable |
Variable Sequence
Add screenshot
Filters
| Object | Filter Value | Explanation |
|---|---|---|
| Ex : Status of the trading partner | Ex : <> 1 | Ex : Exclude intercompanies |
Add screenshot if relevant
Key figures
1) Invoiced History Net Sales - K_GHEUR
Mapped from CRDYN13 - K_GHEUR.
This is to be in sync with BW - DP - Budget Review (Core query).
Changes are part of WO0000000344223.
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/Row/Column | 0COUNTRY | Country | Country of the customer |
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 | |