Skip to end of metadata
Go to start of metadata

The In-Store Food Production Integration ES bundle, developed for the retail grocery industry, connects an external In-Store Food Production (ISFP) software solution to SAP ERP Retail for management of all processes involving a store's fresh items, with provision for the seamless integration of end-to-end business process support.

Note: The Term "In-Store Food Production" is equal to "Fresh Item Management".

This ES bundle will shorten the implementation time required to integrate ISFP data into SAP ERP Retail. An In-Store Food Production solution manages the full lifecycle of all perishable items in a store across all applicable departments (Meat, Seafood, Deli, Bakery, Produce, Food Service, Grocery and Floral) from the time of receipt of ingredients and primals through recipe, to construction or cutting plan to deconstruction. Comprehensive fresh item data management is a valuable tool to improve productivity, which reduces shrink of slow-moving and date-sensitive products that otherwise have to be thrown away. It can increase profitability for stores, which is important because of the thin margins in the grocery business. The In-Store Food Production Integration ES bundle leverages SOA by enabling stores to integrate their fresh item management solutions with SAP ERP using enterprise services.

Audience

This ES bundle will be of value to retail grocery enterprises using fresh item management systems to maintain and manage a store's perishable products.

For details on Service Operations, Business Objects and Process Components, please check the ES Workplace.


In-Store Food Production Architecture (click to enlarge)

In-Store Food Production Process
(click to enlarge)


How To Use This ES Bundle

Perishables, as their name suggests, require special care and handling. At a minimum, retailers need to know how much product to stock and to incorporate in in-store prepared foods, to avoid losses from spoilage. Because grocery margins are already thin, any reduction in perishables waste means more bottom-line profit.

  • A master data exchange process is necessary to create a consolidated base for both involved systems (SAP ERP Retail and external ISFP) for all "fresh" items (ingredients, primals and sellable products). The master data created and maintained within SAP ERP Retail must be replicated to the external ISFP system.
  • An inventory exchange process enables synchronization of inventory data between SAP ERP Retail and the external ISFP system. Besides inventory synchronization, physical inventory adjustments in form of complete counts of "fresh" items are sending back to the SAP ERP system.
  • A price/cost exchange process between both systems will obtain the final sales price at SAP ERP Retail out of the calculated unit cost of a "finished" product sent from the external ISFP system.

The basic processes / data exchanges are:

  • Transfer of master data from SAP ERP system to ISFP system
    • Transfer of supplier data
    • Transfer of merchandise category data (incl. Hierarchy)
    • Transfer of store data
    • Transfer of store group data
    • Transfer of product data inclusive purchase and sales price data
  • Transfer of master data from ISFP system to SAP ERP system
    • Transfer of cost data
  • Exchange of goods movement data
    • Transfer of goods movement data (from SAP ERP system to ISFP system)
    • Transfer of goods movement data (from ISFP system to SAP ERP system)
  • Transfer of inventory data
    • Request to execute physical inventory count (from SAP ERP system to ISFP system)
    • Transfer of inventory data as creation (from ISFP system to SAP ERP system)
    • Transfer of inventory data as confirmation (from ISFP system to SAP ERP system)

The following series of use cases for the In-Store Food Production Integration ES bundle shows how different outcomes can be achieved by using the enterprise services in different combinations. While these examples illustrate a few of the ways that this ES bundle could be used, the intention is to show the flexibility and reusability of these business objects and enterprise service operations so that you will have a clearer understanding of how to best deploy them in your own environment. This wiki is also a space for you to share knowledge and collaborate with others who are implementing the In-Store Food Production Integration ES bundle.

Use Case 1: Replication of Master Data from SAP ERP Retail to the external ISFP System

Master data within a retail organization need to be transferred from SAP ERP Retail to the external ISFP system. Master data are: Product data (including prices), merchandise category data (including hierarchies), store data, store group data and supplier data. Please refer to the Connectivity Kit to see details about all 5 Master data replication services.
An example for this use case is the replication of Stores: Stores can be grouped and flagged based on desired parameters, such as whether or not individual stores offer in-store food production. Once the desired stores are selected, store data can be replicated from SAP ERP to the external ISFP system.

Master Data replication enterprise services used within this case are:

StoreERPReplicationBulkRequest_Out

StoreGroupERPReplicationBulkRequest_Out

SupplierERPReplicationBulkRequest_Out

ProductCategoryHierarchyERPReplicationRequest_OUT

MerchandiseERPReplicationBulkRequest_Out


Use Case 2: Execution of Physical Inventory

Request to exceute Physical Inventory count from the SAP ERP system to the ISFP system

REQUEST: This process step sends a request to execute a physical inventory count from the SAP ERP system to to the ISFP system. The message contains all items that have to be counted. This service is only relevant in connection with the (CONFIRMATION) Service that sends the results of the inventory count back to SAP ERP.The reponsible enterprise Services is: PhysicalInventoryCountERPRequest_Out

Transfer of physical inventory count data from the ISFP system to the SAP ERP system

This process consists of sending physical inventory count data from the ISFP system to the SAP ERP system. There are two options to send the physical inventory count data:

  • CREATE: The physical inventory count data are sent without a reference to an existing physical inventory document (CREATE). In this scenario the ISFP decides which products are counted.

The responsible enterprise Service is: PhysicalInventoryCountERPCreateRequest_In

  • CONFIRMATION: The physical inventory count data are sent as a confirmation to an existing physical inventory document. The confirmation is only relevant in connection with the above mentioned service which sends the (REQUEST) for counting. In this scenario the SAP ERP system decides which products has to be be counted.

The reponsible enterprise Service is: PhysicalInventoryCountERPConfirmation_In

Use Case 3: Transfer of Cost Data

Transfer of Cost Data from the ISFP System to the SAP ERP System

This process step consists of sending cost data from the ISFP system to the SAP ERP system. In the SAP ERP system the received data is used to create purchasing conditions.

For details about the element structure of the messages mentioned, see: ProcurementPriceSpecificationERPCreateRequest_In

Use Case 4: Transfer of Goods Movement Data between the ISFP System and the SAP ERP System.

Transfer of Goods Movement Data from the ISFP System to the SAP ERP System.

This process step consists of sending goods movement data from the ISFP system using a bulk message (for example, the message can include data for several goods movements procedures) to the SAP ERP system. In the SAP ERP system the received data is used to create corresponding goods movement documents.
For details about the element structure of the messages mentioned, see: GoodsMovementERPCreateRequest_In

Transfer of Goods Movement Data from the SAP ERP System to the ISFP System.

This process step contains of reading a single goods movement document (just at the booking time) within the SAP ERP system and sending this data using a message (for example, the message includes one header and several items) to the ISFP system.
For details about the element structure of the messages mentioned, see: GoodsMovementERPNotification_Out

Connectivity Kit

Connectivity Kit Available!

A Connectivity Kit is available to help administrators with the details of implementing this ES bundle. See the Connectivity Kits wiki for more information.


Best Practices

If you want to implement the integration scenario, please refer to the connectivity kit for the integration scenario also available in SDN.

Certified Partner Applications implementing this ES Bundle

Certified Partner Applications for In-Store Food Production Integration


 

Partner Company

ADC, Inc.

Name and Version of the Certified Product

InterStore 6.2

Validity of the certification

June 18, 2012

Brief Description of the Certified Product

ADC's InterStore.Net Grocery Fresh Item Management suite intergates three grocery-specific functional areas to the SAP Business Solution: InterScale - Data hosting and management of barcode labeling scales and printers. Data hosted to food labeling scales includes Item/PLU, price, ingredients statements, safe handling instructions, allergen warnings, nutritional facts, country of origin and traceability information, label graphics and formats, operator logins, merchanidsing messages, graphics and video. InterScale also retrieves labeling transaction logs from scales.

P-Cubed - Perishables shrink management and perishables inventory management. Allows the fresh foods retailer to identify and reduce shrink, to keep an automated perpetual inventory of saleable labelled fresh foods to optimize their retail sell through with minimum wastage on these short shelf life products. Includes perishable production planning based on the SAP forecast demand to define to in-store operators what to make, when to make it and how much of each fresh food item to make to optimally meet forecast demand while minimizing wastage and shrink.

Implemented Use case(s)

Use Case 1: Replication of Master Data from SAP ERP Retail to the external ISFP System
Use Case 2: Execution of Physical Inventory
Use Case 3: Transfer of Cost Data
Use Case 4: Transfer of Goods Movement Data between the ISFP System and the SAP ERP System.



Future Directions

Additional services, for Example Enterprise Services that move the price data, are planned for development for this ES bundle.

System Requirements

  • Installed your SAP ERP system with release version ERP 6.0 and Retail Add-On EA-Retail. The software component versions SAP APPL 604, ESA ECC-SE 604 and EA-RETAIL 604 must be installed.
    Note: The ES that are necessary to implement this integration scenario are contained in the following software component versions: SAP APPL 604, ESA ECC-SE 604, and EA-RETAIL 604.
  • Configured your SAP ERP for SAP Retail. This includes activating the corresponding SAP Retail business function set (for example, settings made using transaction SFW5). For more information, see Configuration as SAP Retail.
  • It is necessary to install SAP XI/PI if this is not yet available in the retailer's landscape. The minimum version is XI/PI based on SAP NetWeaver 7.0. You can download XI/PI from SAP Service Marketplace. For more information, see SAP Exchange Infrastructure or SAP NetWeaver 7.0.
    Note: During the initial XI/PI installation you should import SAP products and SAP software components to the System Landscape Directory (SLD). For further information, see #1.3. Configuring Integration Scenario and Maintaining Master Data.

SOA Homepage on SDN

Fresh Item Management solution provider for SAP:
ADC Inc.