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.

Info

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

Table of Contents

maxLevel	3

Workbook/Query General Description

Main Query for DIP Reporting query with all KPIsKpi's coming from DIP Dynasys tool.

General parameters

Global properties

Tab	Screenshot	Comment
General	Image RemovedImage Added
Planning	Image Modified
Extended	Image Modified

Variables

Definitions

Variable Name	Info-object	Selection Type	Required	Description/Explanation
CALMONT2 Calendar Month/Year (Interval, Mandatory)	0CALMONTH	Interval/Mandatory/ManualEntry	Yes
V_CCPFCTR1_PFCTR12_00010008 ERP BFC GBU (Authorization without inputSelect option, Optional)C	CPFCTR1_PFCTR12	SelectionOption/Optional/Authorization/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 Material 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_PLANTDYN_0010083 Plant (Select option, Optional)	C_DYN_PLANT083	SelectionOption/Optional/ManualEntry	No
V_CPFCTR1C_2DYN_0008062 S&OP Planner (Plant) BFC GBU (Select option, Optional)CPFCTR1_2	C_DYN_074__C_DYN_062	SelectionOption/Optional/Authorization/ManualEntry	No
V_C_DYN_FACUBU024_0003001 Site BFC Group of activities (Select option, Optional)CPFCTR2	C_DYN_2024	SelectionOption/Optional/ManualEntry	No
V_C_COMPCDEDYN_C_AUTHMA079_001 Auth Scope on Company Code (Auth without inputBFC Market (Site) (Select option, Optional)	C_DYN_COMPCDE084__C_DYN_AUTHMA079	SelectionOption/Optional/AuthorizationManualEntry	No
V_C_DYN_MATNR2084__C_MATDYN_GRP077_0001001 Zone S&OP (Site) Material Group (Select option, Optional)	C_DYN_MATNR2084__C_MATDYN_GRP077	SelectionOption/Optional/ManualEntry	No
V_C_AUTHMAPFCTR1_0001 ERP GBU (Authorization without input)	C_PFCTR1	SelectionOption/Optional/Authorization	No
V_C_COMPCDE_C_AUTHMA_001 Auth Scope (Authorization, No on Company Code (Auth without input)	C_PLANTCOMPCDE__C_AUTHMA	SelectionOption/Optional/Authorization	No
VBASEV_C_UOMAUTHMA_09 UoM for Qty conv. (Single value, Mandatory)	SingleValue/Mandatory	Yes	V_0CURRENCY_0006 Currency (Single value, Mandatory)	SingleValue/Mandatory	0001 Authorization Scope (Authorization, No input)	C_PLANT__C_AUTHMA	SelectionOption/Optional/Authorization	NoYes

Variable Sequence

Image RemovedImage Added

Filters

Object	Filter Value	Explanation

No filters used in the query.

Key figures

Image Added

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

Available Inventory

Displayed by default

BW_RKF_CPDYN13_0001 (Available

Inventory

inventory as validated)

QCT_

MATN17

MATNR5
Final Safety Stock	Available but not displayed by default	BW_RKF_CPDYN13_0002 (Final Safety Stock)	QCT_

MATN17

MATNR5
Cycle Stock	Available but not displayed by default	BW_RKF_CPDYN13_0003 (Cycle Stock)	QCT_

MATN17

MATNR5

Budget Planned Inventory (another name: "working stock"

Available inventory (Budget)

Available but not displayed by default

BW_RKF_CPDYN13_0004 (Available inventory (Budget

(Planned Inventory

))

QCT_

MATN17

MATNR5
Available inventory + Blocked	Available but not displayed by default	BW_RKF_CPDYN13_0005(Physical Inventory)	QCT_

MATN17

MATNR5
In transit inventory from SAP (ETA)	Available but not displayed by default	BW_RKF_CPDYN13_0006 (In

Transit Inventory

transit inventory from SAP (ETA))

QCT_

MATN17

MATNR5
Inventory value	Available but not displayed by default	BW_RKF_CPDYN13_0007 (Projected Inventory value)	CTK_CAR4_M

P&I Past & Future Demand

Safety stock v3

Available but not displayed by default

BW_RKF_CPDYN13_

0008 (Past & Future Demand

0026 (Safety stock v3)

QCT_

MATN17

MATNR5

Initial inventory

Final forecast from DP (ETD)

Available but not displayed by default

BW_RKF_CPDYN13_

0009 (Final forecast from DP (ETD)

0027 (Initial Stock)

QCT_

MATN17

MATNR5

Projected Transit inventory ETA

Final forecast from DP (ETA)

Available but not displayed by default

BW_RKF_CPDYN13_

0010 (Final forecast from DP (

0031 (Projected Transit inventory ETA)

)

QCT_

MATN17Final Demand after netting (ETD

MATNR5
Safety Stock (SAP)	Available but not displayed by default	BW_RKF_CPDYN13_

0011 (Final Demand after netting (ETD

0038 (Safety Stock (SAP))

QCT_

MATN17Backorders

MATNR5
Actuals & Projected Inventory	Available but not displayed by default	BW_RKF_CPDYN13_

0012 (Backorders

0041 (Actuals & Projected Inventory)

QCT_

MATN17

MATNR5

Shipping requirements

Production Plan as validated

Available but not displayed by default

BW_RKF_CPDYN13_

0013

0017 (

Shipping requirements

Production Plan as validated)

QCT_

MATN17

MATNR5

Production capacity

Shipping Plan as validated

Available but not displayed by default

BW_RKF_CPDYN13_

0014 (Shipping Plan as validated

0018 (Production capacity)

QCT_

MATN17

MATNR5

Constraint demand

Internal consumption

Available but not displayed by default

BW_RKF_CPDYN13_

0015

0034 (

Constraint demand

Internal consumption)

QCT_

MATN17

MATNR5

Purchase plan

Actual Production

Available but not displayed by default

BW_RKF_CPDYN13_

0016

0040 (

Purchase plan

Actual Production)

QCT_

MATN17

MATNR5

Production

Plan

plan by resource as validated

Available but not displayed by default

BW_RKF_CPDYN13_

0017

0019 (Production

Plan

plan by resource as validated)

QCT_

MATN17

MATNR5

Production

Available capacity in Hours

Available but not displayed by default

BW_RKF_CPDYN13_

0018

0020 (

Production Plan by resource

Available capacity in Hours)

QCT_MATN17

Production requirements

Available but not displayed by default

BW_RKF_CPDYN13_

0019 (Plan by resource

0021 (Production requirements)

QCT_

MATN17

MATNR5

Available capacity

Balance

Available but not displayed by default

BW_RKF_CPDYN13_

0020

0024 (

Available capacity

Balance)

QCT_

MATN17

MATNR5

Production requirements

Cumulative Balance

Available but not displayed by default

BW_RKF_CPDYN13_

0021

0025 (

Production requirements

Cumulative Balance)

QCT_

MATN17

MATNR5
Load %	Available but not displayed by default	BW_CKF_CPDYN13_0001 (Load %)

QCT_MATN17


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

QCT_MATN17

Balance

Available but not displayed by default

BW_RKF_CPDYN13_

0024 (Balance

0045 (Budget Shipping Plan ETD)

QCT

CTK_CAR4_

MATN17Cumulative Balance

M
Budget Final Demand ETD	Available but not displayed by default	BW_RKF_CPDYN13_

0025 (Cumulative Balance

0047 (Budget Final Demand ETD)

QCT_

MATN17

MATNR5

Safety

Budget Working stock

v3

Available but not displayed by default

BW_RKF_CPDYN13_

0026

0048 (

Safety stock v3

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_

MATN17Initial inventory

MATNR5
Budget Forecast from DP (ETD )	Available but not displayed by default	BW_RKF_CPDYN13_

0027 (Initial Stock

0050 (Budget Forecast from DP (ETD ) )

QCT_

MATN17

MATNR5

BFR Forecast from DP (ETA)

Firm Receipt ETA

Available but not displayed by default

BW_RKF_CPDYN13_

0028 (Firm Receipt ETA

0051 (BFR Forecast from DP (ETA))

QCT_

MATN17

MATNR5

BFR Forecast from DP (ETD)

Internal flows ETD

Available but not displayed by default

BW_RKF_CPDYN13_

0029 (Internal flows ETD

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_

MATN17

MATNR5

Planned shutdown

External flows detailed ETD

Available but not displayed by default

BW_RKF_CPDYN13_

0036 (External flows detailed ETD

0056 (Planned shutdown)

QCT_

MATN17

MATNR5

Projected Transit

Anticipated inventory

ETA

Available but not displayed by default

BW_RKF_CPDYN13_

0031

0057 (

Projected Transit

Anticipated inventory

ETA

)

QCT_

MATN17

MATNR5

Demand Review (ETA)

Shipping requirements ETD

Available but not displayed by default

BW_RKF_CPDYN13_

0032 (Shipping requirements ETD

0058 (Demand Review (ETA))

QCT_

MATN17

MATNR5

Receipt Plant

Shortages (ETA)

Available but not displayed by default

BW_RKF_CPDYN13_

0033

0059 (Shortages (

Receipt Plant ETA)

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

QCT_MATN17

Internal consumption

Available but not displayed by default

BW_RKF_CPDYN13_

0034 (Internal consumption

0064 (Order book requested ETD)

QCT_

MATN17

MATNR5

Order book confirmed or requested

Firm Shipments

ETD

Available but not displayed by default

BW_RKF_CPDYN13_

0035 (Firm Shipments

0065 (Order book confirmed or requested ETD)

QCT_

MATN17

MATNR5

Final demand as validated

External flows

ETD

Available but not displayed by default

BW_RKF_CPDYN13_

0030 (External flows ETD)

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

QCT_MATN17

Safety Stock (SAP)

Available but not displayed by default

BW_RKF_CPDYN13_

0038 (Safety Stock (SAP)

0071 (Final forecast from DP (ETD) M-1)

QCT_

MATN17

MATNR5

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

Page tree

Versions Compared

Old Version 2

New Version Current

Key

Workbook/Query General Description

General parameters

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Cells

Conditions

Exceptions

Page tree

Page History

Versions Compared

Old Version 2

New Version Current

Key

Workbook/Query General Description

General parameters

Global properties

Variables

Definitions

Variable Sequence

Filters

Key figures

Cells

Conditions

Exceptions