The new wiki link for this data flow is here:
BW - DiP - Distribution Planning - 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 - DIP - Distribution Planning - Core Query |
|---|---|
| Technical Name | BW_QRY_CPDYN13_0001 |
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
Main query with all Kpi's coming from DIP Dynasys tool.
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 | Explanation for the use of this variable |
V_CPFCTR1_2_0008 BFC GBU (Select option, Optional) | CPFCTR1_2 | SelectionOption/Optional/ManualEntry | No | |
V_0CURRENCY_0006 Currency (Single value, Mandatory) | SingleValue/Mandatory | Yes | ||
VBASE_UOM_05 UoM for Qty conv. (Single value, Mandatory) | SingleValue/Mandatory | Yes | ||
V_C_MATNR2_0001 Material (Select option, Optional) | C_MATNR2 | SelectionOption/Optional/ManualEntry | No | |
VPROD_HIER Product Hierarchy (Select option, Optional) | C_MATNR2__0PROD_HIER | SelectionOption/Optional/ManualEntry | No | |
C_MATNR2__C_MAT_GRP_0001 Material group (Select option, Optional) | C_MATNR2__C_MAT_GRP | SelectionOption/Optional/ManualEntry | No | |
V_C_DYN_083 Plant (Select option, Optional) | C_DYN_083 | SelectionOption/Optional/ManualEntry | No | |
V_C_DYN_062 S&OP Planner (Plant) (Select option, Optional) | C_DYN_074__C_DYN_062 | SelectionOption/Optional/ManualEntry | No | |
V_C_DYN_024_001 Site (Select option, Optional) | C_DYN_024 | SelectionOption/Optional/ManualEntry | No | |
V_C_DYN_079_001 BFC Market (Site) (Select option, Optional) | C_DYN_084__C_DYN_079 | SelectionOption/Optional/ManualEntry | No | |
V_C_DYN_084__C_DYN_077_001 Zone S&OP (Site) (Select option, Optional) | C_DYN_084__C_DYN_077 | SelectionOption/Optional/ManualEntry | No | |
V_C_PFCTR1_0001 ERP GBU (Authorization without input) | C_PFCTR1 | SelectionOption/Optional/Authorization | No | |
V_C_COMPCDE_C_AUTHMA_001 Auth Scope on Company Code (Auth without input) | C_COMPCDE__C_AUTHMA | SelectionOption/Optional/Authorization | No | |
V_C_AUTHMA_0001 Authorization Scope (Authorization, No input) | C_PLANT__C_AUTHMA | SelectionOption/Optional/Authorization | No |
Variable Sequence
Filters
Object | Filter Value | Explanation |
|---|---|---|
Ex : Status of the trading partner | Ex : <> 1 | Ex : Exclude intercompanies |
No filters used in the query.
Key figures
Description | Display | Type | Conversion Type |
| Past & Future Demand | Available but not displayed by default | BW_RKF_CPDYN13_0008 (Past & Future Demand) | QCT_MATNR5 |
| Final forecast from DP (ETD) | Available but not displayed by default | BW_RKF_CPDYN13_0009 (Final forecast from DP (ETD)) | QCT_MATNR5 |
| Final forecast from DP (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0010 (Final forecast from DP (ETA)) | QCT_MATNR5 |
| Actual Shipped and final demand (ETD) | Available but not displayed by default | BW_RKF_CPDYN13_0011 (Actual Shipped and final demand (ETD)) | |
| Backorders in ETD | Available but not displayed by default | BW_RKF_CPDYN13_0012 (Backorders in ETD) | QCT_MATNR5 |
| Shipping requirements as validated (ETD) | Available but not displayed by default | BW_RKF_CPDYN13_0013 (Shipping requirements as validated (ETD)) | QCT_MATNR5 |
| Shipping plan as validated (ETD) | Available but not displayed by default | BW_RKF_CPDYN13_0014 (Shipping plan as validated (ETD)) | QCT_MATNR5 |
| Constraint demand (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0015 (Constraint demand (ETA)) | QCT_MATNR5 |
| Purchase plan (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0016 (Purchase plan (ETA)) | QCT_MATNR5 |
| Firm Receipt ETA | Available but not displayed by default | BW_RKF_CPDYN13_0028 (Firm Receipt ETA) | QCT_MATNR5 |
| Internal flows ETD | Available but not displayed by default | BW_RKF_CPDYN13_0029 (Internal flows ETD) | QCT_MATNR5 |
| External flows ETD | Available but not displayed by default | BW_RKF_CPDYN13_0030 (External flows ETD) | QCT_MATNR5 |
| External flows detailed ETD | Available but not displayed by default | BW_RKF_CPDYN13_0036 (External flows detailed ETD) | QCT_MATNR5 |
| Shipping requirements ETD | Available but not displayed by default | BW_RKF_CPDYN13_0032 (Shipping requirements ETD) | QCT_MATNR5 |
| Receipt Plan ETA | Available but not displayed by default | BW_RKF_CPDYN13_0033 (Receipt Plant ETA) | QCT_MATNR5 |
| Firm Shipments ETD | Available but not displayed by default | BW_RKF_CPDYN13_0035 (Firm Shipments ETD) | QCT_MATNR5 |
| Shipping plan | Available but not displayed by default | BW_RKF_CPDYN13_0037 (Shipping plan) | QCT_MATNR5 |
| Firm shipping requirements (ETD) | Available but not displayed by default | BW_RKF_CPDYN13_0046 (Firm shipping requirements (ETD)) | QCT_MATNR5 |
| Actuals shipped ETD | Available but not displayed by default | BW_RKF_CPDYN13_0039 (Actuals shipped ETD) | QCT_MATNR5 |
Available inventory as validated | Displayed by default | BW_RKF_CPDYN13_0001 (Available inventory as validated) | QCT_MATNR5 |
Final Safety Stock | Available but not displayed by default | BW_RKF_CPDYN13_0002 (Final Safety Stock) | QCT_MATNR5 |
Cycle Stock | Available but not displayed by default | BW_RKF_CPDYN13_0003 (Cycle Stock) | QCT_MATNR5 |
Available inventory (Budget) | Available but not displayed by default | BW_RKF_CPDYN13_0004 (Available inventory (Budget)) | QCT_MATNR5 |
Available inventory + Blocked | Available but not displayed by default | BW_RKF_CPDYN13_0005(Physical Inventory) | QCT_MATNR5 |
In transit inventory from SAP (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0006 (In transit inventory from SAP (ETA)) | QCT_MATNR5 |
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_MATNR5 |
Initial inventory | Available but not displayed by default | BW_RKF_CPDYN13_0027 (Initial Stock) | QCT_MATNR5 |
Projected Transit inventory ETA | Available but not displayed by default | BW_RKF_CPDYN13_0031 (Projected Transit inventory ETA) | QCT_MATNR5 |
Safety Stock (SAP) | Available but not displayed by default | BW_RKF_CPDYN13_0038 (Safety Stock (SAP)) | QCT_MATNR5 |
Actuals & Projected Inventory | Available but not displayed by default | BW_RKF_CPDYN13_0041 (Actuals & Projected Inventory) | QCT_MATNR5 |
Production Plan as validated | Available but not displayed by default | BW_RKF_CPDYN13_0017 (Production Plan as validated) | QCT_MATNR5 |
Production capacity | Available but not displayed by default | BW_RKF_CPDYN13_0018 (Production capacity) | QCT_MATNR5 |
Internal consumption | Available but not displayed by default | BW_RKF_CPDYN13_0034 (Internal consumption) | QCT_MATNR5 |
Actual Production | Available but not displayed by default | BW_RKF_CPDYN13_0040 (Actual Production) | QCT_MATNR5 |
Production plan by resource as validated | Available but not displayed by default | BW_RKF_CPDYN13_0019 (Production plan by resource as validated) | QCT_MATNR5 |
Available capacity in Hours | Available but not displayed by default | BW_RKF_CPDYN13_0020 (Available capacity in Hours) | |
Production requirements | Available but not displayed by default | BW_RKF_CPDYN13_0021 (Production requirements) | QCT_MATNR5 |
Balance | Available but not displayed by default | BW_RKF_CPDYN13_0024 (Balance) | QCT_MATNR5 |
Cumulative Balance | Available but not displayed by default | BW_RKF_CPDYN13_0025 (Cumulative Balance) | QCT_MATNR5 |
Load % | Available but not displayed by default | BW_CKF_CPDYN13_0001 (Load %) | |
Scheduled % | Available but not displayed by default | BW_CKF_CPDYN13_0002 (Scheduled %) | |
Unit Purchase cost in € | Available but not displayed by default | BW_RKF_CPDYN13_0042 (Unit Purchase cost in €) | CTK_CAR4_M |
Budget production Plan | Available but not displayed by default | BW_RKF_CPDYN13_0043 (Budget production Plan) | QCT_MATNR5 |
Budget Shipping requirement ETD | Available but not displayed by default | BW_RKF_CPDYN13_0044 (Budget Shipping requirement ETD) | CTK_CAR4_M |
Budget Shipping Plan ETD | Available but not displayed by default | BW_RKF_CPDYN13_0045 (Budget Shipping Plan ETD) | CTK_CAR4_M |
| Budget Final Demand ETD | Available but not displayed by default | BW_RKF_CPDYN13_0047 (Budget Final Demand ETD) | QCT_MATNR5 |
| Budget Working stock | Available but not displayed by default | BW_RKF_CPDYN13_0048 (Budget Working stock) | QCT_MATNR5 |
| Budget Forecast from DP (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0049 (Budget Forecast from DP (ETA)) | QCT_MATNR5 |
| Budget Forecast from DP (ETD ) | Available but not displayed by default | BW_RKF_CPDYN13_0050 (Budget Forecast from DP (ETD ) ) | QCT_MATNR5 |
| BFR Forecast from DP (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0051 (BFR Forecast from DP (ETA)) | QCT_MATNR5 |
| BFR Forecast from DP (ETD) | Available but not displayed by default | BW_RKF_CPDYN13_0052 (BFR Forecast from DP (ETD)) | QCT_MATNR5 |
| Blocked Stock | Available but not displayed by default | BW_RKF_CPDYN13_0053 (Blocked Stock) | QCT_MATNR5 |
| QM Batch | Available but not displayed by default | BW_RKF_CPDYN13_0054 (QM Batch) | QCT_MATNR5 |
| Restricted stock | Available but not displayed by default | BW_RKF_CPDYN13_0055 (Restricted stock) | QCT_MATNR5 |
| Planned shutdown | Available but not displayed by default | BW_RKF_CPDYN13_0056 (Planned shutdown) | QCT_MATNR5 |
| Anticipated inventory | Available but not displayed by default | BW_RKF_CPDYN13_0057 (Anticipated inventory) | QCT_MATNR5 |
| Demand Review (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0058 (Demand Review (ETA)) | QCT_MATNR5 |
| Shortages (ETA) | Available but not displayed by default | BW_RKF_CPDYN13_0059 (Shortages (ETA)) | QCT_MATNR5 |
| Overall Equipment Effectiveness (OEE) | Available but not displayed by default | BW_RKF_CPDYN13_0060 (Overall Equipment Effectiveness (OEE)) | QCT_MATNR5 |
| Maximum Daily Capacity (MDC) | Available but not displayed by default | BW_RKF_CPDYN13_0061 (Maximum Daily Capacity (MDC)) | QCT_MATNR5 |
| Working Stock | Available but not displayed by default | BW_RKF_CPDYN13_0062 (Working Stock) | QCT_MATNR5 |
| Working stock as validated | Available but not displayed by default | BW_RKF_CPDYN13_0063 (Working stock as validated) | QCT_MATNR5 |
| Orderbook (ETD) | Available but not displayed by default | BW_CKF_CPDYN13_0003 (Orderbook (ETD) ) | QCT_MATNR5 |
| Forecast consumption ETD % | Available but not displayed by default | BW_CKF_CPDYN13_0004 (Forecast consumption ETD %) | |
| Order book requested ETD | Available but not displayed by default | BW_RKF_CPDYN13_0064 (Order book requested ETD) | QCT_MATNR5 |
| Order book confirmed or requested ETD | Available but not displayed by default | BW_RKF_CPDYN13_0065 (Order book confirmed or requested ETD) | QCT_MATNR5 |
| Final demand as validated ETD | Available but not displayed by default | BW_RKF_CPDYN13_0066 (Final demand as validated ETD) | QCT_MATNR5 |
| Gross requirements | Available but not displayed by default | BW_RKF_CPDYN13_0067 (Gross requirements ) | QCT_MATNR5 |
| Production planned (H) | Available but not displayed by default | BW_RKF_CPDYN13_0068 (Production planned (H)) | |
| Production Capacity (H) | Available but not displayed by default | BW_RKF_CPDYN13_0069 (Production Capacity (H)) | |
| Final forecast from DP (ETA) M-1 | Available but not displayed by default | BW_RKF_CPDYN13_0070 (Final forecast from DP (ETA) M-1) | QCT_MATNR5 |
| Final forecast from DP (ETD) M-1 | Available but not displayed by default | BW_RKF_CPDYN13_0071 (Final forecast from DP (ETD) M-1) | QCT_MATNR5 |
More details in the specification document here.
Characteristics
List of characterisctics available here.
Cells
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 | |