Store Connectivity SAP Best Practices for Retail

Purpose, Benefits, and Key Process Steps Purpose This scope item describes the connection of POS systems to SAP Retail. For the POS Outbound, the data transfer to the POS system, the download of articles, assortment lists, conditions, promotions, etc. is covered. In addition to the initial supply of data, another important aspect is the continuous preparation of change data, such as price changes. For the POS inbound not only the uploading of sales data, cash balancing, store orders, goods movements, etc. is explained, but also processes are covered that use this data, e. g. store replenishment, physical inventory. Benefits Several interface technologies to support different store technologies Flexible distribution models to supply POS Systems with only the needed master data for the store Centralized monitoring for inbound and outbond data transfer Key Process Steps General POS interface settings outbound/inbound Settings for Store Order/Store Order Return, Store Physical Inventory, Store Replenishment, Error Messages in Inbound, Goods Movements © 2014 SAP SE or an SAP affiliate company. All rights reserved. 2

Required SAP Applications and Company Roles Required SAP Applications SAP Enhancement Package 7 for SAP ERP 6. 0 Company Roles Retail Masterdata Manager Retail Store Manager Retail Pricing Manager Accounts Payable Assistant General Ledger Retail Replenishment Planner Retail Sales Person © 2014 SAP SE or an SAP affiliate company. All rights reserved. 3

Process Flow Diagram Store Connectivity POS Interface (Outbound) / Download Master Data to Cash Desk Download of Informtion on Merchandise Categories Retail Store Manager Download of Article Data EAN References Download of Follow-On Items Idoc Types for HPR and Standard Assortment List Differences between Standard Assortment List and HPR Assortment List Manual Selection for POS Outbound Initialization in POS Outbound Download of Setting Assignments © 2014 SAP SE or an SAP affiliate company. All rights reserved. Download Bonus Buy Data Download of Personal Data Download Promotion Discounts Assortment List Initialization and Full Version Creating Change Message Displaying created Idocs in POS Monitor POS Outbound in Detail Integration Functional Scope Displaying created Idocs in POS Monitor Manual Request Displaying IDoc 4

Process Flow Diagram Retail Store Manager Process Store Connectivity POS Inbound Sales as per Receipts to Anonymous Customer: Cash Payment with different currencies Sales as per Receipts to Anonymous Customer: Return Sales as per Receipts to Anonymous Customer: Payment with credit card and customer cards as well as Granting Item Discounts Customer: Payment with credit card and customer cards as well as Granting Header Discounts Clearing of Credit Cards Financial Transaction Cash Removal Means of Payment Displaying Clearing Account Executing Settlement Displaying Settlement Accounting Document © 2014 SAP SE or an SAP affiliate company. All rights reserved. Aggregated Sales Posting Incoming Payments Sales as per Receipts: Sales of Voucher Sales as per Receipts: Payment with Voucher Displaying Incoming Payments Accounting Document 5

Process Flow Diagram Store Connectivity Prerequisite s Creating store order and stock transport order Displaying order confirmation Change Store order and stock transport order Store Order Return Goods Receipt in Store Post Goods Issue for DC Create / Confirm transfer order Create delivery for stock transport order Create Store Order with Return Item Displaying Order Confirmatio n Goods Receipt (Real Goods Issue) in Store Creating Delivery for Purchase Order in DC Post Goods Issue for Delivery (Real Goods Receipt in DC for Returned Goods) Displaying Stock in DC Posting Goods Issue to “Unrestricte d Use“ Redisplaying Stock in DC Returning Goods to Vendor Displaying Stock in DC Store Procureme nt directly from Vendor Retail Store Manager Store Order External Purchase Order; Inbound via POS Goods Receipt Displaying Purchase Order Invoice Verification © 2014 SAP SE or an SAP affiliate company. All rights reserved. 6

Process Flow Diagram Store Connectivity Store Replenishmen t Prerequisites for Replenishmen t Multistep Replenishmen t Store Physical Inventory and Freeze Book Inventory Retail Store Manager Setting Posting Block Store Goods Receipt for Delivery Checking Store Preparing Physical Inventory Checking Stock Physical Inventory with Posting Block Stock Transport Order Store Sales Process differences Sending Physical Inventory Document to Store © 2014 SAP SE or an SAP affiliate company. All rights reserved. Checking Stock before Store Goods Receipt Checking Status in Physical Inventory Document Physical Inventory Overview Changing Delivery Checking Status in Physical Inventory Document Goods Movement before count Posting Process Delivery Sending Physical Inventory Document to Store Freezing Book Inventory Sending back count results Physical Inventory Controlling Replenishment Planning Processing Counting Physical Inventory Sending back count results Goods Movement before count posting Process differences Evaluate Physical Inventory 7

Process Flow Diagram Retail Store Manager Store Connectivity Goods Movement Special Store Goods Movements Goods Receipt in Store Bonus Buy and Coupons Outbound error message Messages from cash Register POS Messages Inbound error message Messages to cash Register Retail Pricing Manager Download of Bonus Buy POS Sales including coupon (Bonus Buy) discount Analysis Reports WPER 2 POS Outbound Tools Object Analysis (RWDDOWNLO AD) Reorganizatio n check (RWDREORGC HECK) IDoc Analysis (RWDIDOCPO S) Dummy Initialization (RWDSLDUM ) Reprocess (RWDREPRO CESS) IDoc Analysis (RWDIDOCS L) Reorganizati on check (RWDREORG CHECK 2) Assortment List Tools Dummy Initialization (RWDPOSDU) Reprocess (RWDREPROC ESS 2) General Download Tools Pointer Deletion (RBDCPCLR) © 2014 SAP SE or an SAP affiliate company. All rights reserved. Reorganizat ion (RWDPOSR S) Sales Analysis in Business Intelligence (BI) Overview SAP BI POS in BI Retail Content 8

POS & Payment Cards © 2014 SAP SE or an SAP affiliate company. All

POS - Cash Register : Overview POS & Payment Cards Regular Procurement of Stores with current Master Data (e. g. Article Master Data and Conditions) Transmission of Sales and Returns to the central SAP Retail System transacted in Stores by known and unknown Customers Settlement of Payment Cards Handling of Cash Balancing Processing of Voucher Handling © 2014 SAP SE or an SAP affiliate company. All rights reserved. 10

POS - Cash Register : Interfaces SAP Retail POS-Interface Input Unit Output Unit Sales Orders Store Goods Receipts POSMonitor Article Maste Data Conditions Delivery Note ALE/EDI POS-Converter IDoc Conversion Communication IDoc Stores/Point-Of-Sale © 2014 SAP SE or an SAP affiliate company. All rights reserved. 11

POS Cash Register: Outbound Merchandise Categories WPDWGR 01 Article Master Data incl. Conditions WP_PLU 03 Set. Assignments WPDSET 01 EANAssignments WP_EAN 01 Exchange Rates WPDCUR 01 POSOutbound Tax Rates WPDTAX 01 Customer Data WP_PER 01 Follow on Item WPDNAC 01 Bonus Buy WPDBBY 01 © 2014 SAP SE or an SAP affiliate company. All rights reserved. 12

Handling in POS-Outbound R/3 -System Application POS ALE Data Preparation Master. IDoc Transfer into the communication files EDI Comm. IDoc Data Status Communication Store System © 2014 SAP SE or an SAP affiliate company. All rights reserved. Comm. datei Converter 13

POS Cash Register: Inbound Payment Information WPUTAB 01 Sales as per receipts : WPUBON 01 aggregated: WPUUMS 01 Financial Transactions WPUFIB 01 Goods Movements WPUWBW 01 © 2014 SAP SE or an SAP affiliate company. All rights reserved. Store Orders WGSREQ 02 Cashier Satistics WPUKSR 01 POSInbound Store Inventory WVINVE 03 Master Data Article, EANAssignments WP_PLU 03 WP_EAN 01 14

Handling in POS - Inbound R/3 -System Application ALE Idoc File Workflow Application Data Application Function Comm. IDoc Data Status Communication Store System © 2014 SAP SE or an SAP affiliate company. All rights reserved. Comm. datei Converter 15

POS : Handling of Payment Cards Debits amount from the cardholder and transfers it to the bank of the retailer Customers Bank Retailers Bank - Authorization via POS- systems - settles payments Clearing house Uses payment card to buy Customer / Cardholder Delivers goods and accepts payment cards © 2014 SAP SE or an SAP affiliate company. All rights reserved. Retailer 16

Store Order / Store Return © 2014 SAP SE or an SAP affiliate company.

Scope Item Distribution Center Purchase Orders Store / Franchisee Ordered Merchandise © 2014 SAP

Communication R/3 Central R/3 System Store System Stock Transport Order DC IDoc maintained: VZ 01 Confirmation Store maintained: M 002 © 2014 SAP SE or an SAP affiliate company. All rights reserved. 19

Store Physical Inventory © 2014 SAP SE or an SAP affiliate company. All rights

Store Physical Inventory Periodic physical inventory Create and post physical inventory document Send physical inventory document to store Print count list at store or convert to MDE Block storage location Count, weigh, measure, estimate Send back counted results Post physical inventory differences Unblock storage location © 2014 SAP SE or an SAP affiliate company. All rights reserved. Physical inventory analysis Difference 21

Creating and Sending the Inventory Documents Document date Inventory Document Planned count date Store IDoc Storage Location Article Head Office © 2014 SAP SE or an SAP affiliate company. All rights reserved. Store 22

Posting Block Physical Counting Mo Transfer of count results causes delay of time Analysis of physical inventory Di Inventurums atz Inventurdiffer enz Inventory postings are blocked for the duration of the physical inventory © 2014 SAP SE or an SAP affiliate company. All rights reserved. 23

Phys. inv. Results Sent back to Central System Counting results POS-Simulation © 2014 SAP

Clearing of Phys. inv. Differences Counting Results Inventory Management Book Stock Actual 100 Counted 99 Difference 1 1 I-Differenz 100 Initialize recount or posting differences © 2014 SAP SE or an SAP affiliate company. All rights reserved. 25

Store Replenishment © 2014 SAP SE or an SAP affiliate company. All rights reserved.

Store Replenishment Process in SAP Retail handles the Procurement of Stores with Goods For the Use of Replenishment the Inventory Management is obligatory Inventory Update of reported Store Sales Procurement (Store Stock has to be replenished) © 2014 SAP SE or an SAP affiliate company. All rights reserved. 27

Store Replenishment Information Store DC Merchandise © 2014 SAP SE or an SAP affiliate

Store Sales Central SAP R/3 Retail System IDoc Sales in Store © 2014 SAP SE or an SAP affiliate company. All rights reserved. elektronical POS Data Transfer (POS-Converter) POS-Interface integrated Replenishment or Several Steps Replenishment 29

Replenishment: Overview Article Store Replenishment Inventory Update Procurement Inventory Management © 2014 SAP SE

Inventory Management – Planning of Replenishment Net-Change. Model ATP Requirements Planning Follow on Documents

Coupon and Bonus Buy © 2014 SAP SE or an SAP affiliate company. All

Definition Coupons are cuttings from leaflets or newspapers when presented at POS special conditions are granted for certain products. Coupons in SAP Retail are treated like articles. Bonus buys are deals, which grant special prices, discounts or free articles, if certain prerequisites and general conditions are fulfilled. In the Bonus Buy, Coupons can be assigned as prerequisite. © 2014 SAP SE or an SAP affiliate company. All rights reserved. 33

Specification - Usage Relationship between dynamic groupings of articles and. . . If you buy 5 promotion articles. . . subject to certain prerequisites. . . spending over a total amount of 50 USD. . . general requirements. . . We‘ll give you a certain article with 10 % discount. . . resulting in certain condition being granted. . . based on certain scales. . . © 2014 SAP SE or an SAP affiliate company. All rights reserved. . 5 % discount for 3 articles. . . 10 % discount for 5 articles. . . 34

Conditions are: fixed prices Free goods discounts Fixed discounts Percentage discounts Conditions are agreed upon : Single Article All articles purchased together Article grouping All Prerequisites © 2014 SAP SE or an SAP affiliate company. All rights reserved. 35

Specification Types of Coupons Identification Generated by Manufacturor Barcode on POS Generated by Retailer

Scope Item POS Coupon Promotion Product Catalog Coupon Master Data POSDownload Conditions Infosystem POS - System POS-Upload FI Store © 2014 SAP SE or an SAP affiliate company. All rights reserved. Central System 37

Store Connectivity © 2014 SAP SE or an SAP affiliate company. All rights reserved.

Title not found © 2014 SAP SE or an SAP affiliate company. All rights

© 2014 SAP SE or an SAP affiliate company. All rights reserved. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company. SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. Please see http: //global 12. sap. com/corporate-en/legal/copyright/index. epx for additional trademark information and notices. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product specifications may vary. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty. In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions. © 2014 SAP SE or an SAP affiliate company. All rights reserved. 42