440 likes | 746 Views
Store Connectivity. SAP Best Practices for Retail. Purpose, Benefits, and Key Process Steps. Purpose This scenario describes the connection of POS systems to SAP Retail.
E N D
Store Connectivity SAP Best Practices for Retail
Purpose, Benefits, and Key Process Steps • Purpose • This scenario 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
Required SAP Applications and Company Roles • Required SAP Applications • SAP SAP enhancement package 3 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
Process Flow Diagram Store Connectivity Retail Store Manager POS Interface (Outbound) / Download Master Data to Cash Desk Initialization in POS Outbound Manual Selection for POS Outbound Displaying created Idocs in POS Monitor Creating Change Message Download of Article Data Download of Informtion on Merchandise Categories POS Outbound in Detail Displaying created Idocs in POS Monitor EAN References Download Download of Follow-On Items Download of Setting Assignments Download of Personal Data Download Bonus Buy Data Idoc Types for HPR and Standard Assortment List Integration Assortment List Download Promotion Discounts Differences between Standard Assortment List and HPR Assortment List Functional Scope Initialization and Full Version Manual Request Displaying IDoc
Process Flow Diagram Store Connectivity Process POS Inbound Sales Retail Store Manager Sales as per Receipts to Anonymous Customer:Payment with credit card and customer cards as well as Granting Item Discounts Sales as per Receipts to Anonymous Customer:Payment with credit card and customer cards as well as Granting Header Discounts Sales as per Receipts to Anonymous Customer: Cash Payment with different currencies Sales as per Receipts: Sales of Voucher Sales as per Receipts to Anonymous Customer: Return Clearing of Credit Cards Financial Transaction - Cash Removal Means of Payment Aggregated Sales Sales as per Receipts: Payment with Voucher Displaying Clearing Account Executing Settlement Displaying Settlement Accounting Document Posting Incoming Payments Displaying Incoming Payments Accounting Document
Process Flow Diagram Store Connectivity Retail Store Manager Store Order Prerequisites 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 Confirmation 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 “Unrestricted Use“ Redisplaying Stock in DC Returning Goods to Vendor Displaying Stock in DC Store Procurement directly from Vendor External Purchase Order; Inbound via POS Goods Receipt Displaying Purchase Order Invoice Verification
Process Flow Diagram Store Connectivity Retail Store Manager Store Replenishment Prerequisites for Replenishment Store Sales Stock Transport Order Replenishment Planning Processing Process Delivery Multistep Replenishment Checking Store Store Goods Receipt for Delivery Checking Stock before Store Goods Receipt Changing Delivery Store Physical Inventory and Freeze Book Inventory Checking Stock Preparing Physical Inventory Freezing Book Inventory Sending Physical Inventory Document to Store Counting Physical Inventory Physical Inventory with Posting Block Process differences Goods Movement before count Posting Checking Status in Physical Inventory Document Sending back count results Setting Posting Block Sending Physical Inventory Document to Store Sending back count results Checking Status in Physical Inventory Document Goods Movement before count posting Process differences Physical Inventory Controlling Physical Inventory Overview Evaluate Physical Inventory
Process Flow Diagram Store Connectivity Retail Store Manager Goods Movement Goods Receipt in Store Special Store Goods Movements POS Messages Messages from cash Register Bonus Buy and Coupons Outbound error message Inbound error message Messages to cash Register Retail Pricing Manager Download of Bonus Buy POS Sales including coupon (Bonus Buy) discount Analysis Reports WPER2 POS Outbound Tools Object Analysis (RWDDOWNLOAD) Reorganization check (RWDREORGCHECK) IDoc Analysis (RWDIDOCPOS) Dummy Initialization (RWDSLDUM) Reprocess (RWDREPROCESS) IDoc Analysis (RWDIDOCSL) Reorganization check (RWDREORGCHECK2) Assortment List Tools Dummy Initialization (RWDPOSDU) Reprocess (RWDREPROCESS2) General Download Tools Pointer Deletion (RBDCPCLR) Reorganization (RWDPOSRS) Sales Analysis in Business Intelligence (BI) Overview SAP BI POS in BI Retail Content
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
POS-Interface Input Unit Output Unit POS- Monitor Article Maste Data Sales Orders Conditions Store Orders Delivery Note Store Goods Receipts IDoc POS - Cash Register : Interfaces SAP Retail ALE/EDI POS-Converter Conversion IDoc Communication Stores/Point-Of-Sale
POS Cash Register: Outbound Article Master Data incl. Conditions WP_PLU03 Exchange Rates WPDCUR01 Merchandise Categories WPDWGR01 Tax Rates WPDTAX01 Set-Assignments WPDSET01 Customer Data WP_PER01 POS-Outbound EAN-Assignments WP_EAN01 Follow on Item WPDNAC01 Bonus Buy WPDBBY01
R/3-System ALE Application POS EDI Data Preparation Transfer into the communication files Master- IDoc Comm.- IDoc Comm.- datei Handling in POS-Outbound Data Status Communication Converter Store System
POS-Inbound POS Cash Register: Inbound Sales as per receipts : WPUBON01 aggregated: WPUUMS01 Store Orders WGSREQ02 Payment Information WPUTAB01 Cashier Satistics WPUKSR01 Store Inventory WVINVE03 Financial Transactions WPUFIB01 Goods Movements WPUWBW01 Master Data Article, EAN- Assignments WP_PLU03 WP_EAN01
Comm.- IDoc Comm.- datei Handling in POS - Inbound R/3-System Application ALE Idoc File Workflow Application Data Application Function Data Status Communication Converter Store System
Customers Bank Retailers Bank Clearing house Customer / Cardholder Retailer POS : Handling of Payment Cards Debits amount from the cardholder and transfers it to the bank of the retailer • Authorization via • POS- systems • - settlespayments Usespayment card to buy Delivers goods and accepts payment cards
Scenario Distribution Center Purchase Orders Store / Franchisee Ordered Merchandise
Communication R/3 Central R/3 System Store System Stock Transport Order DC IDoc maintained: VZ01 Confirmation Store maintained: M002
Store Physical Inventory Periodic physical inventory Create and postphysical inventory document Block storage location Send physical inventory document to store Print count list at storeor convert to MDE Count, weigh, measure, estimate Send back counted results Post physical inventory differences Unblock storage location Physical inventory analysis Difference
Inventory Document Creating and Sending the Inventory Documents Document date Planned count date IDoc Store Storage Location Article Store Head Office
Inventurumsatz Inventurdifferenz Di Mo Posting Block Physical Counting Analysis of physical inventory Transfer of count results causes delay of time Inventory postings are blocked for the duration of the physical inventory
Counting results Phys. inv. Results Sent back to Central System POS-Simulation
Counting Results Clearing of Phys. inv. Differences Inventory Management Book Actual Counted 99 Stock 100 Difference 1 I-Differenz 1 100 100 Initialize recount or posting differences
Store Replenishment 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)
Store Replenishment Information Store DC Merchandise
IDoc Store Sales Sales Central SAP R/3 Retail System POS-Interface integrated Replenishment or Sales in Store elektronicalPOS Data Transfer(POS-Converter) Several Steps Replenishment
Replenishment: Overview Article Store Replenishment Inventory Update Procurement Inventory Management
Follow on Documents Purchase Order Inventory Management – Planning of Replenishment Net-Change-Model ATP Requirements Planning
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.
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 ... ... 5 % discount for 3 articles ... 10 % discount for 5 articles... ... based on certain scales ...
Conditions Conditionsare: fixed prices Free goods discounts Fixed discounts Percentage discounts Conditions are agreed upon : Single Article All articles purchased together Article grouping All Prerequisites
Generated by Manufacturor Generated by Retailer Barcode on POS Specification Types of Coupons Identification
POS - System Central System Store Scenario POS Promotion Product Catalog Coupon Coupon Master Data Conditions POSDownload Infosystem POS-Upload FI