Admin Guide Fresh Product Forecasting AddOn 1.2 FBS
Admin Guide Fresh Product Forecasting AddOn 1.2 FBS
Admin Guide Fresh Product Forecasting AddOn 1.2 FBS
Typographic Conventions
Example Words or characters quoted from the screen. These include field names, screen titles,
pushbuttons labels, menu names, menu paths, and menu options.
Textual cross-references to other documents.
EXAMPLE Technical names of system objects. These include report names, program names,
transaction codes, table names, and key concepts of a programming language when they are
surrounded by body text, for example, SELECT and INCLUDE.
Example Output on the screen. This includes file and directory names and their paths, messages,
names of variables and parameters, source text, and names of installation, upgrade and
database tools.
Example Exact user entry. These are words or characters that you enter in the system exactly as they
appear in the documentation.
<Example> Variable user entry. Angle brackets indicate that you replace these words and characters with
appropriate entries to make entries in the system.
SAP Forecasting and Replenishment for Retail, add-on for fresh products, fresh product
forecasting add-on January 24, 2017
Configuration Guide – Version: 1.0 – Final © 2014 SAP SE or an SAP affiliate company. All rights reserved. 2
Administration Guide PUBLIC
Document History
, SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Final © 2014 SAP SE or an SAP affiliate company. All rights reserved. 3
Administration Guide PUBLIC
Table of Contents
2 Solution Overview............................................................................................. 10
2.1 System Landscape.................................................................................................................... 10
, SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Final © 2014 SAP SE or an SAP affiliate company. All rights reserved. 4
Administration Guide PUBLIC
4 Security ............................................................................................................ 39
5 Operations ........................................................................................................ 40
5.1 Monitoring................................................................................................................................. 40
5.1.1 Alert Monitoring.......................................................................................................... 40
5.1.2 Error Logs.................................................................................................................. 40
5.1.3 Background Job Monitoring ........................................................................................ 41
5.2 Administration and Management ............................................................................................... 41
5.2.1 Starting and Stopping................................................................................................. 41
5.2.2 Technical Configuration.............................................................................................. 41
5.2.3 Load Balancing and Scalability ................................................................................... 42
, SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Final © 2014 SAP SE or an SAP affiliate company. All rights reserved. 5
Administration Guide PUBLIC
Table of Figures
SAP Forecasting and Replenishment for Retail, add-on for fresh products, fresh product
forecasting add-on January 24, 2017
Configuration Guide – Version: 1.0 – Final © 2014 SAP SE or an SAP affiliate company. All rights reserved. 6
Administration Guide PUBLIC
The administrators guide provides a central starting point for the technical implementation and configuration of SAP
Forecasting and Replenishment for Retail, add-on for fresh products. It describes everything you have to do to
implement and configure SAP Forecasting and Replenishment for Retail, add-on for fresh products. In addition, this
configuration guide provides security and operations information.
SAP Forecasting and Replenishment for Retail, add-on for fresh products supports the following processes:
· Identification and configuration of fresh products
· Forecasting and automated replenishment for fresh products
· Automated stock corrections for fresh products at relevant expiration date (calculation of projected waste and
shrinkage)
· Multiple order, delivery, and availability times per day
1.3 Glossary
Demand influencing factor DIF An external factor that describes everything which
influences the demand. It can be assigned on a
product or a location level.
ERP Core Component ECC Also known as ERP Central Component, the core of
SAP ERP.
Expiration date of an item n/a Date by which the product has to be sold. The date
itself is the last day the item can be sold. At the end
of this day, remaining items have to be written off.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 7
Administration Guide PUBLIC
First in first out FIFO The item that was delivered first will be sold first.
That means the consumer always picks the piece
that has the shortest remaining time until expiration
date.
Last in first out LIFO The principle that the item that is delivered last will
be sold first. This means that the consumer always
picks the piece that has the longest remaining time
until expiration date.
Planned goods receipt PGR List of open order quantities for the target location
on the delivery date. Planned goods receipts in the
past (back orders) only are considered if they are
still within the past horizon for back orders.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 8
Administration Guide PUBLIC
Make sure that you have installed the required software before you start the implementation process. You can find
the required installation information in the SAP Notes listed in the table below.
Recommendation
Make sure that you have read the SAP Notes before you start implementing the software. These SAP Notes
contain the latest information about installation as well as corrections to the installation information.
Also make sure that you have the up-to-date version of each SAP Note, which is available on SAP Service
Marketplace https://support.sap.com/notes.
2368802 FRP_BAdI_003: Interface- This note must be implemented before you install SAP
Enhancements Forecasting and Replenishment for Retail, add-on for fresh
products. This note provides BAdI enhancements
2316913 Change documents are not You must implement this to ensure enhanced functionality
created for location products
2398914 Delete Sales Items Append This note must be implemented to avoid FRP abort error
Structure message.
2401175 Standard FRP run aborts after This note must be implemented to avoid implementation
fresh products add-on error.
installation
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 9
Administration Guide PUBLIC
2 Solution Overview
Fresh products such as vegetables, fruits, meat, fish, and convenience foods are essential for grocery retailers
because they contribute significantly to margin and revenue. Typically, fresh products are items that are delivered at
least 4 times a week with delivery times less than or equal to 2 working days. In addition, they have short
replenishment cycles, strong trends, and sell quickly during the week. The SAP Forecasting and Replenishment for
Retail, add-on for fresh products is integrated into SAP F&R as an add-on. This solution helps customers reduce
spoilage and increase availability of this kind of product category.
The SAP Forecasting and Replenishment for Retail, add-on for fresh products is implemented as an enhancement of
SAP F&R. Enhanced core modules for fresh product specific improvements are realized in Java. The following
system components are required as minimum:
o SAP SCM 7.02 and higher
o SAP F&R 5.2
o SAP JVM 7
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 10
Administration Guide PUBLIC
Note
The functionality that enables the system to identify and configure fresh products is only available if product
master data has been received from SAP ECC.
Recommendation
SAP recommends that you use a minimal system landscape for test and demo purposes only. For reasons of
performance, scalability, high availability, and security do not use a minimal system landscape as your
productive landscape. For more information about creating productive system landscapes, see SAP Service
Marketplace at https://service.sap.com.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 11
Administration Guide PUBLIC
This chapter describes the mandatory settings in SAP F&R standard Customizing as well as the necessary entries in
the system table for time series. These settings are a prerequisite for using the functions provided by SAP
Forecasting and Replenishment for Retail, add-on for fresh products. Settings to switch on or off the fresh product-
specific calculations and to fine tune single functions and features can be made in the new Customizing for SAP
Forecasting and Replenishment for Retail, add-on for fresh products SAP Forecasting and Replenishment for Retail,
add-on for fresh products.
Note
The Customizing settings and system table entries are also available in the add-on installation. The figures
displayed in 2.2 are used for illustration purposes and refer to default Customizing settings.
Recommendation
SAP recommends that, after installation, you manually create transport requests with default settings and
import these client-specific default Customizing settings into each add-on client. If you do not do this, the
settings must be made manually in each individual add-on-relevant client.
SAP Forecasting and Replenishment for Retail, add-on for fresh products introduces four time series. The key figure
parameters for the time series are:
· /FFIS/CONS_DATA – Fresh product additional consumption data
In this time series the consumption data is saved for at least two years with a daily granularity.
· /FFIS/FCST – Calculated fresh product forecast
This time series contains the forecast results calculated with the enhanced forecast module.
· /FFIS/PROJWASTE – Calculated projected waste
· /FFIS/SHRINKAGE – Calculated shrinkage
The result of the projected waste and the shrinkage calculation is saved in these two time series.
You create the following key figure parameter for the time series in table /FRE/TSKPRM (transaction SM30 –Time
Series Parameters) with the technical settings displayed in Figure 1 and Figure 2:
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 12
Administration Guide PUBLIC
Recommendation
SAP recommends using exactly the same key figure parameter names as mentioned in Figure 1 and Figure
2 to prevent conflicts during the import of support packages and notes.
After creating the key figure parameters for the time series of SAP Forecasting and Replenishment for Retail, add-on
for fresh products, the time key figure parameters must be assigned to physical database tables. For each key figure
parameter an assignment to a database table for a daily granularity as well as for a weekly granularity is mandatory.
Therefore, you have to make the following entries in system table /FRE/CDM_DEF (transaction SE16 – Define CDM
Time Series Types):
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 13
Administration Guide PUBLIC
Note
The database tables for the time series are part of the add-on installation.
To use SAP Forecasting and Replenishment for Retail, add-on for fresh products, you have to make some additional
settings in the SAP Customizing Implementation Guide for SAP Forecasting and Replenishment for Retail.
You define a message type that is used when transferring time-based scheduling data. You also specify the packet
size for each message. This customizing is only relevant if using the intraday functions.
In the In the SAP - Implementation Guide, choose Forecasting and Replenishment -> Interfaces -> Define Message
Types and create a new entry with the following values:
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 14
Administration Guide PUBLIC
Caution
Based on your system performance, you can enter any value for the maximum number of objects. However,
the other data must be entered as specified to ensure the data is transferred correctly.
Consumption data for fresh products is saved in time series (see Add-On Time Series Settings). To ensure that the
system updates consumption data for fresh products in separate time series in parallel, you have to create a new
qualifier. This qualifier is only used internally and is not meant to receive data from the external system. You define
the qualifier by performing the following Customizing activity:
In the SAP - Implementation Guide, choose Forecasting and Replenishment -> Interfaces -> Define Movement Type
Qualifiers.
Example
In the deployed default Customizing, the new qualifier 3099 POS DAILY SALES is created.
You can set the Goods Receipt Processing Time manually in Maintain Location Products (transaction
/FRE/MASS_MATLOC) or as part of a mass maintenance in Mass Maintenance in Background (transaction
/FRE/MASS_BACKGROUND).
To do this, you need first to define the field and make it editable.
/SCMB/MDL_LOCPROD /FFIS/GRPTH
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 15
Administration Guide PUBLIC
The qualifier that you create as described in 3.2.1 must be connected to the time series for consumption data for
fresh products. You assign the qualifier to time series in the following Customizing activity:
In the SAP - Implementation Guide choose Forecasting and Replenishment -> Interfaces -> Maintain Time Series
Interface
For the four time series introduced with the add-on, you define the parameters in the following SAP F&R standard
Customizing activity:
In the SAP - Implementation Guide, choose Forecasting and Replenishment -> Time Series -> Maintain Time Series
Profiles.
Key figure parameters (time series):
· /FFIS/CONS_DATA Fresh product additional consumption data
· /FFIS/FCST Calculated fresh product forecast
· /FFIS/PROJWASTE Calculated projected waste
· /FFIS/SHRINKAGE Calculated shrinkage
o They must be assigned to the time series profile. For example, you define the time series parameters as
shown in
Figure 7.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 16
Administration Guide PUBLIC
Recommendation
SAP recommends that you make sales data for fresh products available daily for at least two years (~ 740
days).
Please leave the Second Granularity empty as indicated above.
The SAP Forecasting and Replenishment for Retail, add-on for fresh products provides high-level exceptions. You
find these exceptions in Figure 8. To use these add-on specific exceptions in the exception workbench for each
message, you must create an entry in the following Customizing activity:
In the SAP – Implementation Guide, choose Forecasting and Replenishment -> Exception Management -> Maintain
Configuration Data for High Level Exceptions.
Recommendation
SAP recommends that you assign the add-on specific high-level exceptions to business area 7 (Forecast).
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 17
Administration Guide PUBLIC
Note
Only adapt the dispatcher profile if the dispatcher is activated and used as F&R Processor.
The extended dispatcher profile can be used for fresh products as well as non-fresh products.
To use the add-on-specific functionality for fresh products, you must add new tasks that provide data for enhanced
forecast, projected waste, and shrinkage calculations to the dispatcher profile. In addition, you have to insert the
modules, which allow the calculation to be performed and imported as time series data, into the dispatcher profile.
You have to replace task SAFRUN_CRIT in the SAP F&R standard dispatcher profile with the new function to be
executed.
You can edit the dispatcher profile, dispatcher sequences, and dispatcher tasks in the following Customizing activity:
In the SAP – Implementation Guide, choose Forecasting and Replenishment -> F&R Processor -> Maintain
Dispatcher Profiles.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 18
Administration Guide PUBLIC
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 19
Administration Guide PUBLIC
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 20
Administration Guide PUBLIC
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 21
Administration Guide PUBLIC
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 22
Administration Guide PUBLIC
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 23
Administration Guide PUBLIC
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 24
Administration Guide PUBLIC
This section contains the information necessary to configure the SAP system to meet customer requirements. The
configuration is done in the Customizing (transaction SPRO).
The SAP Forecasting and Replenishment for Retail, add-on for fresh products provides additional Customizing
activities located in the following Customizing path:
SAP - Implementation Guide -> SAP Forecasting and Replenishment for Retail, add-on for fresh products
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 25
Administration Guide PUBLIC
The following chapters describe the settings to be made in Customizing for SAP Forecasting and Replenishment for
Retail, add-on for fresh products. Additional information is available as system documentation in Customizing.
Recommendation
The installation of this add-on contains default Customizing settings. SAP recommends that you create a
copy of these Customizing entries instead of changing the default values.
SAP – Implementation Guide -> SAP Forecasting and Replenishment for Retail, add-on for fresh products -> Master
Data
This Customizing node contains general activities to define weekday groups, weekday group profiles, and resolution
groups. This data constitutes the allowed values in other Customizing activities.
SAP – Implementation Guide -> SAP Forecasting and Replenishment for Retail, add-on for fresh products -> Master
Data -> Fresh Product Identification
This Customizing node contains activities needed to identify whether new location products entered on the interface
are fresh products.
Note
Automatic identification of new products as fresh products is optional. You do not need to make any settings
if you do not want to use this functionality.
SAP – Implementation Guide -> SAP Forecasting and Replenishment for Retail, add-on for fresh products ->
Demand Influencing Factors
This Customizing node contains activities to define the relevance of the DIF identifier for fresh products and edit the
DIF identifier.
3.3.4 Interfaces
SAP – Implementation Guide -> SAP Forecasting and Replenishment for Retail, add-on for fresh products ->
Interfaces
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 26
Administration Guide PUBLIC
This Customizing node contains settings related to interfaces. These are general settings considered during
outbound processing within an FRP run but also settings relevant for inbound processing of consumption data. For
fresh products, you can make different settings from SAP F&R standard to retrieve historical consumption data during
the initial transfer from BI.
SAP – Implementation Guide -> SAP Forecasting and Replenishment for Retail, add-on for fresh products -> F&R
Processor
This Customizing node contains settings that control the FRP run. You can set the parameters for the enhanced
forecast, projected waste, and shrinkage calculations. In addition to generally activating the fresh products forecast
and waste calculations for SAP F&R standard forecasting profiles, you can activate and deactivate the individual
enhanced forecast features. You can also define the parameters used for the calculation.
Caution
These Customizing activities determine whether the add-on's main functions are activated. When activating
the fresh product forecast and/or projected waste calculation at forecasting profile level, the functions are
activated for all location products where the forecasting profile is (already) assigned. Then the assignment of
a suitable parameter profile is mandatory.
Finally, you can select how the system deals with back orders when calculating the projected waste. You can, for
example, choose to determine valid back orders based on the shelf life of the product. If the back order is so late that
the products shelf life has been exceeded, the system will stop considering the products as planned goods receipts.
SAP – Implementation Guide -> SAP Forecasting and Replenishment for Retail, add-on for fresh products ->Intraday
Functions
The settings required to enable intraday functions are collected here. These functions enable you to provide
scheduling data for multiple order and delivery times and import intraday selling profiles for different locations to help
calculate demand for products with shorter shelf lives.
When you have implemented these rely on data imported from an external system and override the dates generated
by procurements cycles.
This section provides information about the database tables provided with the intraday functionality and provides
detailed information about each of the Customizing activities that you have to perform.
SAP provides the following database tables which you have to fill with data from your master data system:
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 27
Administration Guide PUBLIC
Location opening hours table /FFIS/LOC_OPENHR This tables contains the opening
hours for all of your stores. Once the
data is imported into the BIF tables,
you have to execute Process Fresh
Produce BIF Data (transaction
/FFIS/BIF_PROC) to copy the data
to the database tables
Selling profiles table /FFIS/SELLPROF This table contains all your selling
profiles. Profiles are imported by
implementing and calling BAdI
/FFIS/BD_SELLING_PROF
The scheduling data table has the following structure that you can provide data for:
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 28
Administration Guide PUBLIC
New domain:
Field Value
Name /FFIS/SCHED_GROUP
Format CHAR(000040)
Output 000040
Value Range
The system uses scheduling groups to classify location products that are ordered and delivered together. The groups
are a technical key used to store scheduling data at an aggregated data level. You define a scheduling group by
specifying a combination of master data attributes from your product, location product, and lane data. The system
concatenates these fields to form the technical key and aggregate products.
In this Customizing activity, you select which master data attributes are used to define the scheduling groups in the
table /FFIS/SCHEDULES and the order that the system concatenates the attributes in. You specify one combination
of attributes for internal replenishment and a different one for external replenishment.
To define a scheduling group, you can use any combination of attributes from the following structures:
· /FRE/MATKEY
· /FRE/MATLOC
· /FRE/SOS_STY
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 29
Administration Guide PUBLIC
Caution
You must perform this Customizing activity before you use the groups productively for the first time because
the content of scheduling groups is part of the key definition of the database table /FFIS/SCHEDULES.
After you have used a scheduling group productively, you must not edit this Customizing activity. If you need
to change the scheduling group definition, you must first reorganize the database content and you may have
to migrate it.
In this Customizing activity you select a distribution method and availability moment calculation method. This section
contains information about each of the options that are available and lists the requirements for each of them.
Distribution Methods
The distribution method specifies how the system distributes forecast values throughout the day. By default, Equal
Distribution is selected.
Equal distribution
If you select this option, system assumes that the forecast values are equally distributed throughout the whole day.
To change the period of time over which the forecast values are distributed for specific locations, you import your
location opening times into database table /FFIS/LOC_OPENHR. When transferring location data from the master
data system to the SAP Forecasting and Replenishment for Retail system, the add-on automatically stores the
location opening hours in a BIF table. Execute Process Fresh Produce BIF Data (transaction /FFIS/BIF_PROC) to
copy the data to the database tables.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 30
Administration Guide PUBLIC
Example
If a location's opening times are defined in the table as being 08:00 to 20:00 daily, the system calculates the
daily forecast values as being equally distributed over the 12 hours. If you have not imported store opening
times, the system calculates the forecast values as being equally distributed over 24 hours.
Imported Intraday Selling Profiles
If you select this option, the system can distribute forecast values based on selling profiles that are imported from an
external system. The intraday selling profiles will then define how your forecast values are distributed throughout the
day. The data provided in intraday profiles overrides any date that you have imported for location opening hours.
To use this option you must implement and call BAdI /FFIS/BD_SELLING_PROF to import intraday selling profiles.
SAP provides an example implementation /FFIS/BD_SELLING_PROF_IMPL for the BAdI. For more information,
see BAdI /FFIS/BD_SELLING_PROF. If you do not provide intraday selling profiles, for example, for a specific
merchandise category or product, the system uses equal distribution as a fallback.
This option can be used in combination with the Define Time Clusters and Merchandise Categories activity in the
Customizing (transaction SPRO) under SAP Forecasting and Replenishment for Retail, add-on for fresh products ->
Intraday Functions. For more information about how these two activities interact, see Define Time Clusters and
Merchandise Categories.
Example
You have a selling profile for a particular merchandise category or product, which defines the following
forecast value distribution:
After importing this data into the system and selecting the Import Intraday Selling Profiles option in the
Customizing, the SAP Forecasting and Replenishment for Retail system will use these values for calculating
the forecast value distribution for this merchandise category or product. The system calculates the forecast
value distribution for other merchandise categories and products by using equal distribution.
In this Customizing activity you activate the available intraday functions. This section contains information about the
functions themselves and the requirements for each of them.
The following functions are available:
Function Description
Time-based If this function is active, the system uses the order, delivery, and availability dates and times
scheduling that are stored in table /FFIS/SCHEDULES instead of determining them from procurement
cycles as in the standard solution.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 31
Administration Guide PUBLIC
Function Description
Time-based By using availability times and store opening times within SAP Forecasting and
replenishment Replenishment, the system can consider intraday movements. Demand calculation is done
based on availability times instead of availability days only. The daily forecast values are
distributed based on predefined intraday movement rates.
If this function is active, in addition to using the order, delivery, and availability dates stored
in the table, the system also uses the time that is assigned to the order, delivery, and
availability moments in the table.
Order proposal This feature allows you to see a time component to the order proposal process allowing you
split to specify order moments rather than just order dates. Order moments are a specific time on
a specific date.
If this function is active, the system will generate more than one order proposal if there are
multiple order, delivery, or availability times for the same date. The end user can see the
times for order and delivery moments in the Replenishment Workbench and not just the
dates. This means you can have multiple order proposals per planning day for the same
product.
Daily demand forecast is split based the distribution method and the availability moment is
calculated based on the calculation method, both of which you select in Perform Basic
Settings.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 32
Administration Guide PUBLIC
In this Customizing activity you can set time clusters for specific merchandise categories at different locations. The
system uses this to determine how the forecast is distributed across a location's opening hours.
Note
These settings are used in combination with the Imported Intraday Selling Profiles distribution method that
you can select in the Customizing (transaction SPRO) under SAP Forecasting and Replenishment for Retail,
add-on for fresh products -> Intraday Functions -> Perform Basic Settings. If your imported selling profiles do
not already specify time clusters, you can use the values you have specified here to apply them to the data
that you import from your external system. The settings you make here are passed to BAdI
/FFIS/BD_SELLING_PROF allowing you to use them in your implementation.
For SAP Forecasting and Replenishment for Retail, add-on for fresh products, BAdI implementations are used. In this
section the implemented BAdIs are listed as well as some technical information and a short description of the process
related to the BAdI implementation.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 33
Administration Guide PUBLIC
The BAdI implementation of the method IF_CON_BADI_009_ENR_MATLOC is executed if location product data is
received from the sending system. In this implementation the verification whether a location product should be
handled as fresh product based on defined conditions and rules maintained in Customizing (see 3.3.2) is executed
for new products. For identified fresh products, the default forecasting profile for fresh products is set for the location
product.
Attribute Value
Method IF_CON_BADI_009_ENR_MATLOC
This BAdI is called if time series data is received and right before they are written into the buffer table. In SAP
Forecasting and Replenishment for Retail, add-on for fresh products, an implementation is contained to duplicate
received entries with the new qualifier before updating the buffer. The Customizing settings control which dataset with
which qualifier are duplicated with the new qualifier (see 3.3.4).
Attribute Value
Implementation Short Text Import consumption data into time series buffer
Method IF_CON_BADI_003_TSD
If the initial transfer of consumption data from BI, which is an SAP Forecasting and Replenishment for Retail standard
process, is used, you maintain the data source to be accessed for retrieving historical consumption data in the SAP
Forecasting and Replenishment for Retail Customizing (Alternative Transfer of Consumption from BI - Profile). To
enable the maintenance of the divergent data source for fresh products, add-on specific Customizing is introduced
(see 3.3.4). The methods RETRIEVE_CONSUMPTION and CHANGE_TS is used to overwrite the SAP F&R standard
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 34
Administration Guide PUBLIC
setting for the provision of BI data with fresh product specific settings. In addition, it is used to duplicate the received
data with the new qualifier (similar to BAdI /FRE/IF_CON_BADI_003).
Attribute Value
Implementation Short Text Import consumption data into time series appl. table
The method CHANGE_PARAMETERS of this BAdI is implemented to eliminate DIF identifiers from the equation
parameters in the SAP F&R standard configuration file, that is, the CONFIG.INI if the DIF identifier is set as only
relevant for fresh products in Customizing (see chapter 3.3.3).
Attribute Value
Implementation Short Text Filter out DIFs for CONFIG.INI only relevant for fresh products
Method CHANGE_PARAMETERS
The two methods of this BAdI definition are used to filter DIF occurrences on location level as well as on location
product level. With this implementation it is ensured that DIF occurrences that are only relevant for fresh products are
not written into the SAP Forecasting and Replenishment for Retail standard files. Fresh product specific occurrences
are provided in add-on specific outbound files.
Attribute Value
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 35
Administration Guide PUBLIC
Attribute Value
Caution
BAdI definition /FRE/FU_FRP_BADI016 is only available after importing or installing SAP Note 2080084
(Add-on for Fresh Product Forecast: BAdIs to Filter DIFs)
Due to the fact that SAP Forecasting and Replenishment for Retail, add-on for fresh products allows you to calculate
planned goods issues (projected waste and shrinkage), the display of the time series of stock projection must be
adjusted. This adjustment is performed using method GET_STOCK_PROJECTION of BAdI /FRE/FU_TS_BADI_007.
Attribute Value
Implementation Short Text Customer stock projection (providing end of day stock)
Method GET_STOCK_PROJECTION
This BAdI is implemented in case there is a requirement to show additional fields within the Order Item subscreen of
the Replenishment Workbench.
This BAdI is implemented to display the following columns on the Order Item subscreen
· Availability Time
· Release Time
· Order Time
· Delivery Time
Attribute Value
Implementation Short Text BAdI Implementation for Intraday Solution for RWB
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 36
Administration Guide PUBLIC
Attribute Value
Method GET_ADDITIONAL_DATA
This BAdI is implemented to enhance the configuration of the Replenishment Workbench. In this BAdI, you can only
add the new fields to be displayed.
This BAdI is implemented to add the following columns to the order Item subscreen:
· Availability Time
· Release Time
· Order Time
· Delivery Time
Attribute Value
Method GET_OPTIONAL_ORDERITEMS_FIELDS
Importing location opening hours handled by standard location interface. The default BAdI implementation selects
WRF1 location opening hours from the system that is assigned to the Order message type in database table
/FRE/BIF_MSGTP. To import any other location opening hours, you have to implement his own BAdI
implementation.
Attribute Value
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 37
Administration Guide PUBLIC
Attribute Value
Method IF_CON_BADI_007_ENR_LOCATION
To import intraday selling profiles from an external system, you have to be able to configure the interface between the
F&R system and the external system. You use this BAdI to pull selling profiles from the external source system. This
BAdI is called by the report /FFIS/INTRADAY_IMP.
Attribute Value
Method IMPORT_SELL_PROFILE
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 38
Administration Guide PUBLIC
4 Security
SAP Forecasting and Replenishment for Retail, add-on for fresh products is based on SAP F&R. Therefore, the
related guides also apply to this software.
For more information about specific security related topics, see the following resources on SAP Service Marketplace
and the SAP Community Network at http://scn.sap.com.
Security http://service.sap.com/security
http://sdn.sap.com/irj/sdn/security
Platforms http://service.sap.com/platforms
Infrastructure http://service.sap.com/securityguide
→ Infrastructure Security
For a complete list of available SAP Security Guides, see SAP Service Marketplace at
http://service.sap.com/securityguide.
Note
No new authorizations and/or roles are used by SAP Forecasting and Replenishment for Retail, add-on for
fresh products.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 39
Administration Guide PUBLIC
5 Operations
Designing, implementing, and running your SAP applications at peak performance 24 hours a day is vital to ensure
business success. This chapter contains important information about how to operate SAP Forecasting and
Replenishment for Retail, add-on for fresh products.
The add-on is based on SAP F&R. Therefore, the general operations information in related operations guides also
applies to SAP Forecasting and Replenishment for Retail, add-on for fresh products.
For a complete list of available SAP operations guides, see the SAP Service Marketplace at
http://service.sap.com/instguides.
The operations information specific to SAP Forecasting and Replenishment for Retail, add-on for fresh products is
described in the following chapters. The following areas are covered:
· Monitoring
· Administration and Management
5.1 Monitoring
Messages raised in add-on-specific steps when running FRP are provided to be displayed in the SAP F&R standard
exception workbench. To be able to display messages in the exception workbench, you make the necessary
Customizing settings as describe in 3.2.6.
Log files with errors and information about what occurred when executing the modules as part of FRP are written to
folder./frp/<client>/<site-GUID>/log/ffi.
The log level can be configured with the following files:
· logback-cleanup.xml
· logback-enhancedforecast.xml
· logback-projectedwaste.xml
· All add-on relevant log files are located next to the standard FRPs in
/sapmnt/<SID>/global/frp/bin/FFI/lib.
The valid log levels are:
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 40
Administration Guide PUBLIC
LEVEL Description
No add-on specific background job monitoring exists. You can also use the SAP F&R standard transaction Check of
Location Status (/FRE/FRP_LOC_STATUS) to monitor the status of the FRP run.
With SAP Forecasting and Replenishment for Retail, add-on for fresh products, the FRP run is executed with
additional fresh product specific steps. If you are using the dispatcher for the F&R processor, the relevant dispatcher
profiles needs to be enhanced in Customizing (see 3.2.7) with additional tasks. If the FRP dispatcher is deactivated
and the SAP F&R standard report /FRE/FRP_MID_BASIC is used for the FRP run instead, you must use the add-on
report /FFIS/FRP_MID_BASIC. This report also executes the fresh product specific steps during the FRP run.
Report /FFID/INIT_NEW_FRESH_PRODUCTS allows you to initialize existing location products when someone has
manually assigned a fresh-product-relevant forecasting profile. Therefore, you have to activate change documents for
location products. You can do this in the Customizing (transaction SPRO) under Advanced Planning and
Optimization -> Master Data -> Product -> Activate Change Documents.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 41
Administration Guide PUBLIC
All other details about the technical configuration are described in the installation notes mentioned in 1.5.
The SAP Forecasting and Replenishment for Retail, add-on for fresh products does not replace any steps of the FRP
run. Instead, with the add-on, additional data needs to be stored and processed by the calculation modules. For
example, you should store daily consumption data for about two years. In addition, the calculation of the fresh
product specific forecast as well as the calculation of projected waste and shrinkage is added to the standard FRP
run. As a result, load balancing and scalability must be considered and verified with the installation of this add-on.
Using this add-on may require an increase in system resources.
Note
Sizing information related to this add-on is available in the sizing guide for SAP Forecasting &
Replenishment for Retail.
SAP Forecasting and Replenishment for Retail, add-on for fresh products January 24, 2017
Configuration Guide – Version: 1.2 – Released to Customer © 2014 SAP SE or an SAP affiliate company. All rights reserved. 42
www.sap.com/contactsap