Get Started. It's Free
or sign up with your email address

1. POS Analytics

1.1. based on BI

1.1.1. deployed as part of BI_CONT

1.2. default views on transaction data

1.2.1. by Article/Store

1.2.2. by Receipt/Article

1.2.3. Store Performance

1.2.4. Cashier Performance

1.3. role-based reporting

1.3.1. default roles: Store Manager Regional Manager National Manager

1.3.2. different levels of reports

1.3.3. delivered via portal & BI web reports

1.4. uses BI InfoObjects for data storage

2. Important TCodes

2.1. BI

2.1.1. display info object: rsd2

2.2. POSDM

2.2.1. TCodes generally start with /posdw/

2.2.2. Workbench: /posdw/mon0

2.2.3. Customising: /posdw/img

2.2.4. 1-step Outbound Dispatcher: /posdw/pdis

2.2.5. 2-step Outbound Dispatcher: /posdw/odis

2.2.6. delete (without archiving): /posdw/dele

2.2.7. change task status: /posdw/tsch

2.2.8. recreate workbench index: /posdw/refi

2.2.9. Message Logs view logs across branches: sa38 -> /posdw/display_messagelog enhanced error report inc. financial impact: sa38 -> /posdw/display_messages_agg

2.2.10. XML transaction import: /posdw/xml_in export: /posdw/xml_out

2.3. Basis

2.3.1. Archive administration: sara

2.3.2. view application log: slg1

2.3.3. list TCodes: se93

2.3.4. BFC/BAPI function builder: se37

2.3.5. IDoc create: we19 process from queue: bd87 find: we02 process all selected: we14

2.3.6. Database DB structure: se11 DB data: se16

3. Standard Architecture

3.1. POSDM Benefits

3.1.1. decoupling of POS system(s) with back end

3.1.2. perform data checks and validation

3.1.3. reprocess failed transaction data

3.1.4. data processing aggregation forward data to different receiving systems master data look-up (enrichment)

3.1.5. increased performance of ERP (less transactional load)

3.2. Data Model

3.2.1. Transaction Log (TLog) XML-based standard data model of a POS transaction maps directly to a customer interaction at the POS Header-level information about a transaction operator ID store ID start & end date etc. Records for each article purchased as line items article identifier (e.g. EAN barcode) quantity Unit of Measure (UOM) Price Tax impact Supplemental Data Records for each tender action allows for multiple different methods of payment may contain payment details (e.g. cheque number) Supplemental Data free-form XML space for customer-specific extensions at the transaction level logically at the same level as header elements

3.3. installed on a BI system

3.3.1. included with BI_CONT (POS Analytics only)

3.3.2. logically separate and independent from SAP BI

3.3.3. Application Component BW-BCT-ISR-PIPE (PIPE only)


4.1. stands for POS Inbound Processing Engine

4.2. storage

4.2.1. /POSDW/TLOGS - TLog information

4.2.2. /POSDW/TLOGL - TLog information for very large TLogs to improve storage efficiency rarely used

4.2.3. only header fields are visible using SE16 line items and supplemental data stored as binary strings in LRAW fields not visible in SE16 can be accessed using function modules


5.1. more content coming soon