SAP for Retail Discussions
Join conversations about personalization, omnichannel strategies, and operational excellence in retail using SAP for Retail software.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Deleting data from Fraudwatch database for a specific time period or store

Go to solution
Former Member

‎12-10-2010 1:53 AM

0 Kudos

Hello,

We currently have three stores running SAP POS and the transaction logs are loaded to SAP Fraudwatch. We would like to know, how we could purge the data loaded for a specific store, for a particular day from the SAP Fraudwatch database.

Regards,

Jason

1 ACCEPTED SOLUTION

Go to solution
William_Laverde
Product and Topic Expert
Product and Topic Expert

‎12-10-2010 4:03 PM

0 Kudos

In FW 3.5, there is a stored procedure (u201Cpr_PurgeDataByEntityu201D) to purge the data by entity id. Entity id can be a store, a cashier or regionu2026 etc. You need to find the entity id for the store you want to purge at hierarchy table. This will purge all the data for that entity. Please test this first on a non production system

View solution in original post

1 REPLY 1

Go to solution
William_Laverde
Product and Topic Expert
Product and Topic Expert

‎12-10-2010 4:03 PM

0 Kudos

In FW 3.5, there is a stored procedure (u201Cpr_PurgeDataByEntityu201D) to purge the data by entity id. Entity id can be a store, a cashier or regionu2026 etc. You need to find the entity id for the store you want to purge at hierarchy table. This will purge all the data for that entity. Please test this first on a non production system