Fraudulent Transactions 
DataSource Transactional Data: 0RT_LPA_TRAN_FRAUD
This DataSource for Loss Prevention Analytics (LPA) contains details of suspicious transactions from Point of Sales Data Management (POSDM). Suspicious transactions are based on patterns for suspicious activities, as defined by the loss prevention officer. This datasource contains transactional data from the Transaction Log (TLOG), which stores transaction details from POS counters. This DataSource contains around 40 fields and has a delta queue for delta loading of data. This DataSource does not support real-time data acquisition (RDA).
Technical Data
Application Component | 0RT_LPA |
|---|---|
Available as of Release | SAP NetWeaver 7.0 BI Content Add-On 5 |
Shipment | SP00 |
Content Versions | SAP RET700 |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Data Modeling
Delta Update
This DataSource is delta enabled and it uses the delta queue to load the delta data. This DataSource uses the delta method ADDD (additive extraction via the delta queue), which is similar to the method ADD, but via delta cue (cube-compatible).
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
ACTUALAMOUNT |
Actual Amount |
/POSDW/LPA_TXN_FRD |
ACTUALAMOUNT |
BANKAMOUNT |
Amount Transferred to Bank |
/POSDW/LPA_TXN_FRD |
BANKAMOUNT |
BASEQUANTITY |
Quantity in Base Unit of Measure |
/POSDW/LPA_TXN_FRD |
BASEQUANTITY |
BUSINESSTYPE |
Business Transaction |
/POSDW/LPA_TXN_FRD |
BUSINESSTYPE |
BWTRANSINDEX |
Transaction Index for BW as Character Field |
/POSDW/LPA_TXN_FRD |
BWTRANSINDEX |
CARDNUMBER |
Card Number |
/POSDW/LPA_TXN_FRD |
CARDNUMBER |
CARDTYPE |
Eurocheque Card Type |
/POSDW/LPA_TXN_FRD |
CARDTYPE |
DEPARTMENT |
Department |
/POSDW/LPA_TXN_FRD |
DEPARTMENT |
DISCOUNT |
Number of Discount Items |
/POSDW/LPA_TXN_FRD |
DISCOUNT |
DISCTYPECODE |
Discount Type |
/POSDW/LPA_TXN_FRD |
DISCTYPECODE |
DISCTYPEGROUP |
Discount Type Group |
/POSDW/LPA_TXN_FRD |
DISCTYPEGROUP |
DISTDISC |
Distributed Header Discount |
/POSDW/LPA_TXN_FRD |
DISTDISC |
IMMEDIATEVOIDAMT |
Value of Immediate Cancellations |
/POSDW/LPA_TXN_FRD |
IMMEDIATEVOIDAMT |
IMMEDIATEVOIDCNT |
Number of Immediate Cancellations |
/POSDW/LPA_TXN_FRD |
IMMEDIATEVOIDCNT |
LINEITEMCOUNT |
Number of Sales Items |
/POSDW/LPA_TXN_FRD |
/POSDW/LPA_TXN_FRD LINEITEMCOUNT |
LINEITEMVOIDAMT |
Value of Line Cancellations |
/POSDW/LPA_TXN_FRD |
LINEITEMVOIDAMT |
LINEITEMVOIDCNT |
Number of Line Cancellations |
/POSDW/LPA_TXN_FRD |
LINEITEMVOIDCNT |
NORMALSALESAMT |
Normal Sales Value |
/POSDW/LPA_TXN_FRD |
NORMALSALESAMT |
NOSALETRANSCNT |
Number of Void Receipts |
/POSDW/LPA_TXN_FRD |
NOSALETRANSCNT |
OPERATORID |
Cashier Number or Name |
/POSDW/LPA_TXN_FRD |
OPERATORID |
OVERAMOUNT |
Over Amount |
/POSDW/LPA_TXN_FRD |
OVERAMOUNT |
PLANT |
Plant |
/POSDW/LPA_TXN_FRD |
PLANT |
POSTVOIDAMT |
Value of Transaction Cancellations |
/POSDW/LPA_TXN_FRD |
POSTVOIDAMT |
POSTVOIDCNT |
Number of Transaction Cancellations |
/POSDW/LPA_TXN_FRD |
POSTVOIDCNT |
RECORDQUALIFIER |
Record Type of Transaction |
/POSDW/LPA_TXN_FRD |
RECORDQUALIFIER |
REMOVALAMOUNT |
Value Removed |
/POSDW/LPA_TXN_FRD |
REMOVALAMOUNT |
REDUCTIONAMOUNT |
Discount Value |
/POSDW/LPA_TXN_FRD |
REDUCTIONAMOUNT |
REMOVALCOUNT |
Number of Cash Removals |
/POSDW/LPA_TXN_FRD |
REMOVALCOUNT |
RETAILDEBITFLAG |
Debit/Credit Indicator |
/POSDW/LPA_TXN_FRD |
RETAILDEBITFLAG |
RETL_ITEM_CAT |
Classification of Sales Item: Category |
/POSDW/LPA_TXN_FRD |
RETL_ITEM_CAT |
RETL_ITEM_SCAT |
Classification of Sales Item: Subcategory |
/POSDW/LPA_TXN_FRD |
RETL_ITEM_SCAT |
REVERSALFLAG |
Reversal Indicator |
/POSDW/LPA_TXN_FRD |
REVERSALFLAG |
SALESAMOUNT |
Actual Retail Value |
/POSDW/LPA_TXN_FRD |
SALESAMOUNT |
SHORTAMOUNT |
Short Amount |
/POSDW/LPA_TXN_FRD |
SHORTAMOUNT |
TAXAMOUNT |
Tax Amount |
/POSDW/LPA_TXN_FRD |
TAXAMOUNT |
TENDERAMOUNT |
Tender Value |
/POSDW/LPA_TXN_FRD |
TENDERAMOUNT |
TENDERID |
Tender Identifier |
/POSDW/LPA_TXN_FRD |
TENDERID |
TENDERTYPECODE |
Means of Payment |
/POSDW/LPA_TXN_FRD |
TENDERTYPECODE |
TENDERTYPEGROUP |
Payment Means Group |
/POSDW/LPA_TXN_FRD |
TENDERTYPEGROUP |
TRANSCNT |
Number of Transactions |
/POSDW/LPA_TXN_FRD |
TRANSCNT |
TRANSTYPECODE |
Transaction Type |
/POSDW/LPA_TXN_FRD |
TRANSTYPECODE |
TURNOVER |
Sales Totals Per Transaction |
/POSDW/LPA_TXN_FRD |
TURNOVER |
WORKSTATIONID |
POS Number |
/POSDW/LPA_TXN_FRD |
WORKSTATIONID |
PTN_ID |
Pattern Identifier |
/POSDW/LPA_TXN_FRD |
PTN_ID |
BUSINESSDAYDATE |
Posting Date |
/POSDW/LPA_TXN_FRD |
BUSINESSDAYDATE |
ENDTIMESTAMP |
Second in Which Transaction Ends |
/POSDW/LPA_TXN_FRD |
ENDTIMESTAMP |
TRANSCURRENCY |
Transaction Currency |
/POSDW/LPA_TXN_FRD |
TRANSCURRENCY |
Extractor Logic
The extractor uses function module (complete interface) logic to access the data. Key figures are calculated in the transformation based on the ABAP routines for those transformations. Key figures are transferred one to one.
Extraction Method |
F1 (Function Module Extractor for Large Quantities of Data) |
Extractor |
/POSDW/BW_UPDATE_SOURCES |
Extract Structure |
/POSDW/LPA_TXN_FRD |
Unsychronized Backup Recovery in BI System
This DataSource uses the standard delta management based on the delta queue. If you are applying unsynchronized BW backup recovery, the delta procedure for the DataSource has to be reinitialized.