Show TOC

Loss Prevention Analytics Locate this document in the navigation structure

Technical Data

Product Version

SAP NetWeaver 7.0 BI Content Add-On 5 SP00

Area

SAP Retail

Country Relevance

Valid for all countries

 

As of SAP NetWeaver 7.0 BI Content Add-On 5 SP00, the following new and reused BI Content is available for Loss Prevention Analytics:

New BI Content

Infoareas::

  • Loss Prevention Analytics (0RT_LPA)

Roles:

  • Loss Prevention Officer (SAP_BW_LPA_LPO)

Characteristics:

  • Pattern (0LPA_PTRN)

  • Pattern Status (0LPA_PSTAT)

  • Pattern Changed On(0LPA_CHANGE)

  • Pattern Created On (0LPA_CREATE)

  • Transaction Time (0LPA_TTIM)

Datasources:

  • Fraudulent Transactions (0RT_LPA_TRAN_FRAUD)

  • Pattern Attribute Master Data (0RT_LPA_PTN_ATTR)

  • Pattern Text Data (0RT_LPA_PTN_TEXT)

Infosources:

  • Fraudulent Transactions (0RT_LPA_TRAN_FRAUD _TR)

Infoproviders:

  • Multiprovider - Full and Exception Data (0LPA_MP01)

  • Infocube - LPA Exception Data (0LPA_C01)

Queries:

  • Exception Report (0LPA_MP01_Q0001)

  • Exception Reporting - Day Level (0LPA_MP01_TXN_Q0001)

  • Tender Usage Report (0LPA_MC21_Q0002)

  • Tender Usage Transaction Report (0LPA_MC21_TXN_Q0002)

  • Excessive Credit Card Usage Report (0LPA_MC21_Q0003)

  • Excessive Credit Card Usage -Transaction Report (0LPA_MC21_Q0003_1)

  • Refunds Amount/Day Report (0LPA_MP01_Q0004)

  • Refund Amount/Day Transaction Report (0LPA_MPC21_Q0004)

  • Department Sales Report (0LPA_MP01_Q0006)

  • Department Sales Transaction Report (0LPA_MC21_Q0006)

  • Refund Count/Day Report (0LPA_MP01_Q0007)

  • Refund Count/Day Transaction Report (0LPA_MC21_Q0007)

  • Item Discount Summary Report (0LPA_MP01_Q0008)

  • Item Discount Transaction Report (0LPA_MC21_Q0008)

  • Over/Short Summary Report (0LPA_MP01_Q0009)

  • Post Voids Summary Report (0LPA_MP01_Q0010)

  • Post Voids Transaction Report (0LPA_MC21_Q0010)

  • Refunds Summary Report (0LPA_MP01_Q0011)

  • Refunds Transaction Report (0LPA_MC21_Q0011)

  • Sales Summary Report (0LPA_MP01_Q0012)

  • Sales Summary Transaction Report (BWBCT_QR_0LPA_MC21_Q0012)

  • Transaction Discount Summary Report (0LPA_MP01_Q0013)

  • Transaction Discount Details (0LPA_MC21_Q0013)

  • Transaction Snapshot Summary Report (0LPA_MP01_Q0014)

  • Transaction Snapshot Detail Report (0LPA_MC21_Q0014)

  • Open Cash Drawer Report (0LPA_MP01_Q0015)

  • Report Card Template (0LPA_MP01_Q0016)

  • Credit Card Number Lookup Report (0LPA_MP01_Q0017)

Key Figures:

Restricted Key Figures:

  • Total Amount (0LPA_MP_01_RK_001)

  • Cashier Sales by Store (0LPA_MP01_RK002)

  • Post Void Total (0LPA_MP01_RK003)

  • Post Void Count (0LPA_MP01_RK004)

  • Cashier Sales by Department (0LPA_MP01_RK005)

  • Refund Total (0LPA_MP01_RK006)

  • Refund Count (0LPA_MP01_RK007)

Calculated Key Figures:

  • Average Amount (0LPA_MP01_CK001)

  • Item Discount Count (0LPA_MP01_CK009)

Key Figures

  • Transaction Discount (0LPA_MC21_Q0012)

  • Tender Usage Count (0LPA_MC21_Q0012)

  • Tax Amount (BWBCT_KYF_0LPA_TAM)

  • Transaction Discount Count (0LPA_MP01_CK009)

  • Item Discount (0LPA_REAMER)

  • Card Usage Count (0LPA_CCNR)

  • Transaction Discount (0LPA_REA)

Variables (SAP EXIT):

  • Transaction Type (0P_TRANTYPE)

  • Credit Card Number (0P_CRCARDNO)

Web Templates:

  • Transaction Discount Report (0TPL_0LPA_MP01_Q0013)

  • Sales Summary Report (0TPL_0LPA_MP01_Q0012)

  • Excessive Credit Card Usage Report (0TPL_0LPA_MC21_Q0003)

  • Credit Card Number Lookup Report (0TPL_0LPA_MC21_Q0017)

  • Transaction Snapshot Summary Report (0TPL_0LPA_MP01_Q0014)

  • Open Cash Drawer Report (0TPL_0LPA_MP01_Q0015)

  • Department Sales Report (0TPL_0LPA_MP01_Q0006)

  • Over/Short Summary Report (0TPL_0LPA_MP01_Q0000)

  • Exception Report (0TPL_0LPA_MP01_Q0001)

  • Report Card (0TPL_0LPA_MP01_Q0016)

  • Tender Usage Report (0TPL_0LPA_MP21_Q0002)

  • Refund Amount/Day Report (0TPL_0LPA_MP01_Q0004)

  • Refund Count/Day Report (0TPL_0LPA_MP01_Q0007)

  • Item Discount Summary Report (0TPL_0LPA_MP01_Q0008)

  • Post Voids Summary Report (0TPL_0LPA_MP01_Q0010)

  • Refunds Summary Report (0TPL_0LPA_MP01_Q0011)

Reused BI Content:

Datasources:

  • Total Transactions (0RT_PA_TRAN_TOTALS)

  • Transaction Control (0RT_PA_TRAN_CONTROL)

Infosources:

  • Retail Control (0RT_PA_TRAN_CONTROL_TR)

  • Transaction Totals (0RT_PA_TRAN_TOTALS_TR)

Infoproviders:

  • Infocube – Cashier Statistics (0RPA_C05)

  • Infocube — Daily Cube (0RPA_C21)

  • Multiprovider – Daily Cube (0RPA_MC21)