The new wiki link for this data flow is here:
BW - DiP - Distribution Planning - Inventory data
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 - DIP - Distribution Planning - Inventory data |
|---|---|
| Technical Name | BW_QRY_CPDYN13_0002 |
Application | DiP - Distribution Planning |
Info-provider | Composite CPDYN13 |
Usage type | Direct execution via Analysis |
Expected users | Ex: GBU zone and WW controllers |
Workbook/Query General Description
DiP reporting query with all Inventory Kpis
General parameters
Global properties
| Tab | Screenshot | Comment |
|---|---|---|
| General |
| |
| Planning |
| |
| Extended |
|
Variables
Definitions
Variable Name | Info-object | Selection Type | Required | Description/Explanation |
|---|---|---|---|---|
CALMONT2 Calendar Month/Year (Interval, Mandatory) | 0CALMONTH | Interval/Mandatory/ManualEntry | Yes | |
V_C_PFCTR1_0001 ERP GBU (Authorization without input) | C_PFCTR1 | SelectionOption/Optional/Authorization/ManualEntry | No | |
V_C_MATNR2_0001 Material (Select option, Optional) | C_MATNR2 | SelectionOption/Optional/ManualEntry | No | |
VPROD_HIER Material (Select option, Optional) | C_MATNR2__0PROD_HIER | SelectionOption/Optional/ManualEntry | No | |
V_C_PLANT_0010 Plant (Select option, Optional) | C_PLANT | SelectionOption/Optional/ManualEntry | No | |
V_CPFCTR1_2_0008 BFC GBU (Select option, Optional) | CPFCTR1_2 | SelectionOption/Optional/Authorization/ManualEntry | No | |
V_C_FACUBU_0003 BFC Group of activities (Select option, Optional) | CPFCTR2_2 | SelectionOption/Optional/ManualEntry | No | |
V_C_COMPCDE_C_AUTHMA_001 Auth Scope on Company Code (Auth without input) | C_COMPCDE__C_AUTHMA | SelectionOption/Optional/Authorization | No | |
C_MATNR2__C_MAT_GRP_0001 Material Group (Select option, Optional) | C_MATNR2__C_MAT_GRP | SelectionOption/Optional/ManualEntry | No | |
V_C_AUTHMA_0001 Authorization Scope (Authorization, No input) | C_PLANT__C_AUTHMA | SelectionOption/Optional/Authorization | No | |
VBASE_UOM_09 UoM for Qty conv. (Single value, Mandatory) | SingleValue/Mandatory | Yes | ||
V_0CURRENCY_0006 Currency (Single value, Mandatory) | SingleValue/Mandatory | Yes |
Variable Sequence
Filters
Object | Filter Value | Explanation |
|---|---|---|
No filters used in the query.
Key figures
Description | Display | Type | Conversion Type |
Available Inventory | Displayed by default | BW_RKF_CPDYN13_0001 (Available Inventory) | QCT_MATN17 |
Final Safety Stock | Available but not displayed by default | BW_RKF_CPDYN13_0002 (Final Safety Stock) | QCT_MATN17 |
Cycle Stock | Available but not displayed by default | BW_RKF_CPDYN13_0003 (Cycle Stock) | QCT_MATN17 |
Budget Planned Inventory (another name: "working stock") | Available but not displayed by default | BW_RKF_CPDYN13_0004 (Budget (Planned Inventory)) | QCT_MATN17 |
Available inventory + Blocked | Available but not displayed by default | BW_RKF_CPDYN13_0005(Physical Inventory) | QCT_MATN17 |
In transit inventory | Available but not displayed by default | BW_RKF_CPDYN13_0006 (In Transit Inventory) | QCT_MATN17 |
Inventory value | Available but not displayed by default | BW_RKF_CPDYN13_0007 (Projected Inventory value) | CTK_CAR4_M |
Safety stock v3 | Available but not displayed by default | BW_RKF_CPDYN13_0026 (Safety stock v3) | QCT_MATN17 |
Initial inventory | Available but not displayed by default | BW_RKF_CPDYN13_0027 (Initial Stock) | QCT_MATN17 |
Projected Transit Inventory ETA | Available but not displayed by default | BW_RKF_CPDYN13_0031 (Projected Transit Inventory ETA) | QCT_MATN17 |
More details in the specification document here.
Characteristics
List of characterisctics available here.
Cells
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 | |||||
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
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/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 | |