Demand Planning - Uploading Key Figures

Last Updated On:

Introduction :
You can upload the key figures Final Actuals, and Final Forecast using this template.
Note that the upload will erase the actual values of the demand plan.
Adding Data :
This template allows you to enter a fixed maximum of 1200 rows of entries.
For instance, in a montly plan this corresponds to a set of 100 products in one planning area and in one demand plan for an history horizon
If you want to upload more entries, please perform multiple uploads each including up to 1200 entries.
Data quality:
Entries that do not match the data quality requirements will be rejected for upload. Please familiarize yourself with these requirements in th
Note that:
-The combination of ID fields for demand plan, product, and planning area must exactly match to a scope entry of an existing demand plan
-The Period field must be maintained either in the YYYY-MM or in the YYYY-WW format and within the horizons defined for uploading key
- The key figure type attribute defines which of The following key figures will be uploaded: Final Actuals, Final Forecast, Distribution Factor
-The Unit of Measure field must match the demand plan UoM or the product's planning UoM depending on whether the particular demand

Demand Plan ID * Demand Plan Description Product ID * Product Description

TEST_002 DEMAND PLAN 2 TEST_997 Finished Goods for Demand Planning 1

TEST_002 DEMAND PLAN 2 TEST_998 Finished Goods for Demand Planning 2
TEST_002 DEMAND PLAN 2 TEST_999 Finished Goods for Demand Planning 3
d in one demand plan for an history horizon of 12 months.

arize yourself with these requirements in the ReadMe section.

o a scope entry of an existing demand plan.

thin the horizons defined for uploading key figures depending on the particular demand plan.
Actuals, Final Forecast, Distribution Factor.
pending on whether the particular demand plan is enabled for multilevel planning or not.

Planning Area Planning Area Period [YYYY-MM] or Key Figure Type * Key Figure Value
ID * Description [YYYY-WW] * *
P1100 2020-10 Final Forecast 100.00
P1100 2020-10 Final Forecast 100.00
P1100 2020-10 Final Forecast 100.00
Unit of Measure *

EA
EA
EA
Header fields marked with * are mandatory. Each line must contain a full set of mandatory field values.
If one of the mandatory field values does not meet the value range requirements the associated data will not be u
You will be asked ... the value ranges of which must fulfill the following conditions
to fill the following
fields....
Demand Plan ID* Must exactly correspond to a Demand Plan ID that was created in your system

Demand Plan No restrictions. Descriptions are just for your information and will not be uploaded.
Description
Product ID* Must exactly correspond to a Product ID that is in scope of the respective Demand
Plan ID

Product No restrictions. Descriptions are just for your information and will not be uploaded.
Description
Planning Area Must exactly correspond to a Planning Area ID that is in scope for the respective
ID* Demand Plan ID.Moreover combinations of Product ID and Planning Area ID that are
not in scope for the respective Demand Plan ID will not be uploaded.
Planning Area No restrictions. Descriptions are just for your information and will not be uploaded.
Description
Period* Note that monthly plans only accept values between YYYY-01 and YYYY-12 and
weekly plans only accept values between YYYY-01 and YYYY-53.

Key Figure Type* The value of the Key Figure Type must be selected from one of the
proposed values: Final Actuals, Final Forecast, Distribution Factor.

Key Figure Must be a numerical value greater or equal to zero with no more than three digits
Value: (e. g. behind the comma.Multilevel Plans – The number of decimal places of the value that
Final Actuals)* you enter must not exceed the number of decimal places of the unit of measure.
Otherwise the value will be rounded.Single Level Plans – The number of decimal
places of the value that you enter must not exceed the number of decimal places of
the product’s unit of measure.Otherwise the value will be rounded.Dimensionless key
figures (such as Key Figure Distribution Factors available in Multi Level Plans) have a
maximum of three digits after the comma regardless of the unit of measure.If you
leave this field blank the value zero will be uploaded.

Unit of Measure* If multilevel planning is enabled this must be the unit of measure code for the
respective Demand Plan ID.If multilevel planning is not enabled this must be the
planning unit of measure code for the respective Product ID.
datory field values.
e associated data will not be uploaded.
Good Example Bad Example
Potential issues

DP_BOILERS_01 DP BOILERS 01
Only part of the ID was
maintained.
Mr. Robinsons
Demand Plan
PRDBOI_1223444 1223444
Only part of the ID was
maintained.

Boiler Maxi Size for

European Union
MC64000 MC64001
Planning area ID is not part of
the respective demand plan.
Akron Production

2009-10 1959-54
Period is beyond the plans
History Horizon for Uploading
Final Actuals. Period is beyond
the maximum calendar week
value of 53.

123.123 -123,1222
Negative value and too many
digits behind the comma.

EA KGM
KGM might not be the Demand
Plan unit of measure
Where to get the data from?
Demand Plan ID*

Demand Plan
Description
Product ID* The valid combinations of demand plan, product and planning area ID as well as the
respective descriptions can be looked up and copied from:

Product Common Task: Analyse Demand Plan Scope

Description
Planning Area
ID*

Planning Area
Description
Period* Before you perform an upload please lookup the values of Forecast Start Date,
History Horizon for Uploading Final Actuals, and Forecast Horizon for Uploading Final
Actuals in the Demand Plans work center view for the respective demand plan.For
Forecast Start Date go to Edit and choose the General tab.For the Horizons for
Uploading Final Actuals go to Edit and choose the Process Settings tab.

Key Figure You can look up the existing values in the Demand Plans work center view by
Value: (e. g. opening the planning board for the appropriate demand plan.Click Plan to open the
Final Actuals)* planning board.Configure the planning board so the particular key figure (e. g. Final
Actuals) is displayed.

Unit of Measure* Work Center View Demand Plans:For multilevel enabled plans go to Edit and choose
the General tab.For multilevel disabled plans go to Plan and configure the planning
board so the characteristic Planning Unit of Measure is also displayed.
Simulate the value range for the Period field
Fill in the white fields according to the demand plan data to simulate the value range for the periods that can b
Specify the PERIODICITY Enter the plans Enter the plans Enter the plans First day in history
of the plan. "Forecast Start Date" "History Horizon "Forecast horizon allowed for
Enter Month or Week. For Updating Horizon For upload
Final Actuals" Updating Final
Actuals"

Month 10/1/2009 12 1 10/1/2008

For monthly plans specify periods in the format YYYY-MM.

YYYY-MM must not be before First Date in History Horizon Allowed for Upload.
YYYY-MM must not be after Last Day in Forecast Horizon Allowed for Upload.
e value range for the periods that can be uploaded.
Last day in
forecast horizon
allowed for upload

10/31/2009
SAP BYD Code List Configuration

Element XPath Validation Type

/ns1:ManageDemandPlanIn/DemandPlan/unitCode 1 - Static Code List
/ns1:ManageDemandPlanIn/DemandPlan/KeyFigureTypeCode 1 - Static Code List

SAP BYD Code List for UnitCode

Delimiter -
Display type 2 - Name only

DisplayAs Code
5B 5B
ACT ACT
ANN ANN
AU AU
DAY DAY
DZN DZN
E49 E49
EA EA
FOT FOT
FTQ FTQ
GLL GLL
GRM GRM
HUR HUR
INH INH
KGM KGM
KMT KMT
LBR LBR
LTR LTR
MIN MIN
MMT MMT
MON MON
MTQ MTQ
MTR MTR
ONZ ONZ
SEC SEC
SMI SMI
STN STN
TNE TNE
WEE WEE
XBG XBG
XBX XBX
XCR XCR
XCS XCS
XCT XCT
XPK XPK
XPX XPX
XSX XSX
YRD YRD
XDR XDR
SAP BYD Code List for KeyFigureTypeCode

Delimiter -
Display type 2 - Name only

DisplayAs Code
Final Actuals 2
Final Forecast 4
Distribution Factor 5
Code List XML Map SearchCode
SAP_BYD_CodeList_UnitCode
SAP_BYD_CodeList_KeyFigureTypeCode

Name Description
batch
activity
year
activity unit
day(s)
dozen
working day(s)
each
foot
cubic foot
gallon (US)
gram
hour(s)
inch
kilogram
kilometre
pound
litre
minute [time]
millimetre
month
cubic metre
metre
ounce
second [time]
mile (statute mile)
ton (US) or short ton (UK/US)
tonne (metric ton)
week
Bag
Box
Crate
Case
Carton
Package
Pallet
Set
drum
drum
2

Name Description
Final Actuals
Final Forecast
Distribution Factor