Skip to Content
0
Former Member
Feb 03, 2016 at 04:46 AM

NEED querry to create Alert for OHEM updates

44 Views

Hi experts

Am using sap b1 8.82 v, i need a query to create alert Based on Employee Master Data

am having total 200-210 Fields in Employee Master data including Standard and UDF

in this all table if the user update any table in an alert mentioning the specified Fields has updated

this is the out put i required

Empid Updated Feild New value Old value Updated Date

1010 Salary 1000 2000 12/01/2016

1031 Nationality IN SA 10/01/2016

1041 U_EmailID 1041@g.com abc@g.com 01/01/2016

Like this i need it

pls help me to sort out this issue

Regards