POS Analytics: Loyalty Program

: 0RT_PA_TRAN_LOYALTY

This DataSource serves to provide data on the loyalty program for sales transactions. The PIPE provides the DataSource with data, based on specific receipts. Besides the customer data, the principal key figures are loyalty points and eligible sales values. The provided data consists of transaction header data, the sales item data, and the data of the loyalty program of POS transactions. Depending on the usage, information on the loyalty program is provided at transaction level or also at item level.

Technical Data

Application Component	IS-R
Available as of Release	Notes SAP NetWeaver 7.0 BI Content Add-On 3 SP08
Shipment	BI703
Content Versions	Content version
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	‎No

Prerequisites

The DataSource contributes to the delta update. The delta procedure used is ADDD (‘ADD’ using the delta queue).

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
`RECORDQUALIFIER`	Record type
`BWTRANSINDEX`	Transaction Index
`RETAILSTOREID`	Store
`BUSINESSDAYDATE`	Posting Date
`TRANSTYPECODE`	Transaction Type
`WORKSTATIONID`	POS Number
`TRANSNUMBER`	Transaction Number
`BEGINTIMESTAMP`	Start of Trans.
`ENDTIMESTAMP`	End of Trans.
`DEPARTMENT`	Department
`OPERATORQUAL`	Operator Qualifier
`OPERATORID`	Cashier
`TRANSCURRENCY`	Transaction Currency
`PARTNERQUALIFIER`	Partner Qualifier
`PARTNERID`	Partner Number
`TRANSINDEX`	Transaction Index
`NONCOMPFLAG`	Non-Comparable Sls
`TRANSTYPEGROUP`	Trans. Type Group
`BUSINESSTYPE`	Transaction
`REVERSALFLAG`	Cancellation Indicator
`TRANSDEBITFLAG`	Credit/Debit Indicator
`PLANT`	Plant
`STORECURRENCY`	Local Currency
`PLANTCUSTOMER`	Cust. No. of Plant
`BUSINESSLOCATION`	Location ID
`TURNOVER`	Sales Totals
`INDEXCURRENCY`	Currency
`VERSION`	Version
`RETAILNUMBER`	Sales Item Number
`RETAILTYPECODE`	Sales Item Type
`RETAILREASONCODE`	Sls Trans. Reason
`ITEMIDQUALIFIER`	Qualif. for Art. ID
`ITEMID`	Article Identifier
`RETAILQUANTITY`	Sales Quantity
`SALESUOM`	Sales unit
`SALESAMOUNT`	Retail
`NORMALSALESAMT`	Norm. Sales Value
`COST`	Cost
`SERIALNUMBER`	Serial Number
`PROMOTIONID`	Promotion Number
`BATCHID`	Batches
`ENTRYMETHODCODE`	Entry Method
`ACTUALUNITPRICE`	Sales Price
`UNITS`	Sales Quantity
`MATERIALNUMBER`	Material Number
`MERCHANDISECAT`	Material Group
`BASEQUANTITY`	Quantity in Base UN
`BASEUOM`	Base Unit
`RETAILTYPEGROUP`	Sales Item Type Grp
`RETAILDEBITFLAG`	Credit/Debit Indicator
`RETAILREASONGRP`	Reasons Group
`RETL_ITEM_CAT`	Category
`RETL_ITEM_SCAT`	Subcategory
`LOYNUMBER`	Loy. Prog. Item No.
`CUSTCARDNUMBER`	Card Number
`LOYPROGRAMID`	Loyalty Program
`LOYPNTSAWARDED`	Awarded Loyalty Pnts
`ELIGIBLEAMOUNT`	Eligible Sales Value
`ELIGIBLEQUANTITY`	Eligible Quantity
`ELIGIBLEQUANUOM`	Unit of Measure
`LOYPNTSREDEEMED`	Redeemed Loyalty Pts
`LOYPNTSTOTAL`	Total Loyalty Points
`CUSTCARDHOLDNAME`	Cardholder
`CUSTCARDTYPE`	Customer Card Cat.
`CUSTCARDVALIDFR`	Card Valid From
`CUSTCARDVALIDTO`	Card Valid To
`VOIDFLAG`	Cancelled Item