Skip to Content
author's profile photo Former Member
Former Member

ERP: consuption data & transfer to SAP F&R

Hello Everyone!

this is related to data transfer from SAP Retail to SAP F&R.

i know that SAP F&R requires historical consumption data. Variants for such a consumtion data could be: BI, Sap Retail or other OLTP system.

Unfortunately we do not have SAP BI, and thus, standard upload method does not work.

1) can anyone recommend the way of data upload from excel/Oracle BI in terms of target location in F&R? (i.e. where the data finally should be posted, what the design of data should be - so that we could make the analogue upload)

2) in SAP retail there's a standard initial \delta upload (not indicated as "BI" related) : fre03/fre01 - with consumption data. does it mean the system takes all consumption from SAP Retail (only, w\o BI or other system involvement) and transfers to F&R? i.e. to transfer consumption via fre03 we do not need anything but SAP Retail data, is that correct understanding?

many thanks in advance,



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 08, 2012 at 05:57 PM

    Hi Alexander,

    ad 1

    the load of consumption data should be done into the interface tables for time series /FRE/BIF_TSD. Qualifier 3000 is used for consumption data (4000 for stock data).

    In case article/site combinations become newly F&R relevant but were already operated before, then historical consumption data is probably available within a BI (or another) system. Historical data has to be transferred once.

    From that point in time on the consumptions of this location product needs to be transferred daily in case there is a consumption.

    The system can identify per location if there was an update made today. This is done in table /FRE/FRPMID_SCHE with FRP sequence ID 91 ('Consumption Update'). For the relevant location the record in the table is updated when booking interface records (using the booking program /FRE/BIF_INB01). This requires that the accomplish flag (field /FRE/BIF-ACCOMPLISH) was set for one record of the relevant location (Excursus: for each product that has a consumption on a certain day, one record of qualifier 3000 needs to be created in /FRE/BIF_TSD. Ideally for the last record the accomplish flag is set. This flag does not only update table /FRE/FRPMID_SCHE it is also the trigger for the daily start of the dispatcher (FRP run) for this location (if time series interface customizing is maintained appropriately).

    For the technial requirements of the interfaces in F&R see published documentation on SAP Service Marketplace

    SAP Service Marketplace

    --> SAP Support Portal

    --> tab Help & Support

    --> on the right side: search for: type in 'F&R API'

    --> document SAP F&R 5.2 RFC API-Documentation is suggested for opening / downloading; this document is available for releases F&R 5.0 and F&R 5.1 as well

    Ad 2

    The initial load of consumption data from SAP BI or SAP ERP Retail are just 2 alternatives that F&R offers for flexibility reasons. Concerning the initial load of consumption data it doesn't make sense to combine both.

    For daily consumption data, the consumptions can be transferred from SAP ERP Retail or SAP POS DM (which is an application of SAP BI)

    Kind regards,


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 09, 2012 at 09:25 AM


    1) Use program /FRE/FU_TOOLS_TS_FILE_LOAD in SAP F&R to upload directly with specific key figures and target locations. The design of data and how you can upload can be read from program documentation.It was well written and anybody can able to do successfully.

    2) If you want to transfer consumption from SAP RETAIL , you will have to do certain configurations with in SAP RETAIL to work with FRE03 & pick for SAP F&R. The article location needs to have the forecast replenishment type (replensihment procedure should be 'G')- And with this articles FRE03 will fetch from MVER table in SAP RETAIL with corresponding periodic indicators configured in article master maintenace like Daily,Weekly& monthly.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.