R D - POS Interface.doc
8.2 TO-BE PROCESS
SAP IS-Retail system is being used for procurement, inventory management and sales. The specific scenario of selling through Point of sales system needs to be interfaced with SAP. SAP POS interface enable you to provide your store POS systems, with all the relevant data required to handle the store processes independently.
The IDoc technique enables all the messages that can be exchanged between SAP Systems and the store systems. Settings are made to define which information (messages) is exchanged in the form of intermediate documents (IDocs). Checks are made to ensure that the data arrives even if the receiving system cannot be accessed when the data is sent. You can regularly supply the POS systems in the stores with current data (master data, such as EANs, conditions, and merchandise categories) via the POS interface - outbound. This means that the master data only has to be maintained in the central system.
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 70
Information can be uploaded from the POS systems to the central Retail system via the POS interface - inbound.In addition to the initial supply of data, another important aspect is the continuous preparation of change data, such as price changes. If master data is changed, the system prepares the data in question in IDoc format after initialization (initial supply of data to the store), taking account of the current store assortment.
As soon as a user maintains master data, the application creates a change document. If the modified field is relevant for the store, a change pointer is created.
The Idocs and related features with XI will assist in transfer of data between SAP Retail and POS.
The required fields (vendor etc , if required) need to be specified and will be mapped in the Idocs. The detailed mapping of fields (discounts, coupons etc) will be carried out in the realisation phase alongwith Triversity integration.
Types of business information that SAP Retail sends through the POS outbound interface to store system are as under.
Article master data
Merchandise Category Master Label data
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 71
Assortment List Promotion
Types of business information that SAP Retail can receive through the POS inbound interface from store system are as under.
Sales Data (receipt based and aggregated) Cashier data
Payment types Store Order
Financial Transaction Inventory
Other business information (like customer based data & pricing) will be covered in POS blueprint.
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 72
9.0 LIST OF REPORTS (AS PER THE AS-IS)
Demos of standard reports in the system will be shown to PRHPL after the unit testing and based on PRHPL‟s priority reports will be developed.
9.1 CATEGORY WISE REPORTS
9.1.1 COPY OF DEPARTMENTAL PROGRESS REPORT NEXT
Copy of
Departmental Progress Report NEXT.xls
9.1.2 DEBENHAMS
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 73
DEBENHAMS.xls
9.1.3 TBS (THE BODY SHOP)
TBS.xls
9.2 LOYALTY (LYB) PROMOTION (TO BE TAKEN IN PHASE II)
9.2.1 DAILY
9.2.1.1 DAILY_LYB_KIT_SALES_REPORTS
Daily_LYB_KIT_Sales _Report.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 74
9.2.1.2 DAILY_LYB_NET_SALES_REPORTS_FEB
Daily_LYB_Net_Sale_
Report_Feb.xls
9.2.1.3 LYB_NET_SALE_REPORT_FEB_08
LYB_Net_Sale_Repor t_Feb_08.xls
9.2.1.4 LYB_SALES_ANALYSIS_FEB08
LYB-SALES-ANALYSI S-Feb08.xls
9.2.1.5 TOP_20_SPENCERS_FEB
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 75
Top_20_Spenders_F eb.xls
9.2.1.6. TOP_20_SPENCERS_SALES_DETAILS_REPORT
Top_20_Spenders_S ales_Detail_Report.xls
9.2.2 WEEKLY
9.2.2.1 BIRTHDAY_REMINDER_REPORT
Birthday_Reminder_
Report.xls
9.2.2.2 CARD_REGISTRATION_REPORT
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 76
Card_Registration_R eport.xls
9.2.2.3 KNOW_CUSTOMER_REPORT
Know_Customer_Re port.xls
9.3 MANUAL REPORTS FROM STORE
9.3.1 DSR
Dsr.xls
9.3.2 EXPENSE_PETTY_CASH_123
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 77
EXPENSE__PETTY_C ASH_123.xls
9.4 POS REPORTS
9.4.1 RPT_CONSOLIDATED_PAYMENT_SUMMARY
rpt_consolidated_pa yment_summary.xls
9.4.2 RPT_DAILYSALES_HOURLY
rpt_dailysales_hourly .xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 78
9.4.3 RPT_DETAILEDSALES
rpt_detailedsales.xls
9.4.4 RPT_DETAILEDSALES_DIVISION
rpt_detailedsales_div ision.xls
9.4.5 RPT_DETAILEDSALES_STYLE
rpt_detailedsales_st yle.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 79
9.4.6 RPT_DETAILEDSALES_STYLE_BEST_SELLER
rpt_detailedsales_st yle_best_seller.xls
9.4.7 RPT_PAYMENTSUMMARY
rpt_paymentsummar y.xls
9.4.8 RPT_SALESPERSONRESULTSSUMMARY
rpt_salespersonresul tssummary.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 80
9.4.9 RPT_SALESSUMMARY
rpt_salessummary.xl s
9.4.10 STCARD2
stcard2.xls
9.4.11 STDLEDGER
stkledger.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 81
9.5 SALE ANALYSIS
9.5.1 ABC ANALYSIS
ABC Analysis.xls
9.5.2 BEST SELLER REPORTS
Best Seller Report.xls
9.5.3 CALENDER YEAR ANALYSIS
Calendar Year Analysis.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 82
9.5.4 FY SALE ANALYSIS
FY Sale Analysis.xls
9.5.5 LIKE FOR LIKE (LFL) REPORT
Like for Like (LFL) Report.xls
9.5.6 NEW PRODUCT SALE PERFORMANCE REPORT
New Product Sale Performance Report.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 83
9.5.7 NO_OF_BILL_COUNT_FEB
No_Of_Bill_Count_Fe b.xls
9.5.8 SKU WISE SALES
SKU wise sales.xls
9.6 WALK IN ANALYSIS REPORTS
9.6.1 NEXT-WALKINS DETAILS REPORT
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 84
Next - WALKINS Details Report.xls
9.7 WEEKLY DSR
9.7.1 ACCESSORIZE
Accessorize.xls
9.7.2 BODYSHOP
BodyShop.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 85
9.7.3 CONSOLIDATED BRAND WISE
CONSOLIDATED BRAND WISE.xls
9.7.4 DEBENHAMS
Debenhams.xls
9.7.5 MALL WISE DSR
MALL WISE DSR.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 86
9.7.6 MONTHLY DSR BRAND WISE
MONTHLY DSR BRAND WISE.xls
9.7.7 NEXT
NEXT.xls
9.8 EFFICIENCY REPORT GENERATION
Efficiency Report Generation.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 87
9.9 MALL WISE SALES ANALYSIS
MALL-WISE-SALE-AN ALYSIS.xls
9.10 MARKDOWN & SALES WISE SALE
MARKDOWN &
SPACE WISE SALE.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 88
9.11 MONTHLY OPERATING SUMMARY
Monthly Operating Summary.ppt
9.12 NEW STORE OPENING TRACING
NEW STORE OPENING TRACKING.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 89
9.13 NEXT_WEST_GATE_ATT.SHEET
NEXT_WEST_GATE_
ATT.SHEET.xls
9.14 VENDOR REQUEST FORM
Vendor Request Form.xls
SALES AND DISTRIBUTION SAP IS-RETAIL
IMPLEMENTATION TO-BE BUSINESS PROCESS SCRIPTS VERSION NO – 3.0
LOCATION : GURGAON PAGE 90
10.0 OPEN & CLOSED ISSUES
SAP Comments and PwC response discussion
BBP_Planet_Retail_R eview Report SD.doc
10.1 CLOSED ISSUES
Mark down planning to be covered in phase II.
Best practices for Export sales will be configured. BBP will be updated accordingly.
Returns samples will be mapped through the sub-contracting process. Non returnable samples to be debited against cost center.
Standard Document types will be used. Details about parameters of configurations will be covered in the configuration document. BBP will be updated accordingly.
FI Configuration document will document GL mapping and other related accounting configurations.
Pricing components & pricing schema for stock transfer will be covered in MM module and for POS sales will be covered in Triversity.
After configuration PwC will give a demo and PRPHL will take the final call on the parameters for pricing calculation which is to be fed into the system. BBP will be updated accordingly.