cancel
Showing results for 
Search instead for 
Did you mean: 

Change log for query generator in SAP B1 Version 9.3

fayeconde
Discoverer
0 Kudos

How can we track changes made by user in query generator in SAP B1 Version 10? Is there any other workaround aside from change log?

Accepted Solutions (0)

Answers (3)

Answers (3)

wenli_chen
Explorer
0 Kudos

Hi fayeconde,

Check if you have table CGEV in your database.

3288171 - Save User-Defined Query Change Log in Table CGEV

Regards,
Relle Chen

LoHa
Active Contributor
0 Kudos

Hi Florefe,

just deny changes in user permissions.

regards Lothar

Johan_H
Active Contributor
0 Kudos

Hi,

One option is to restore a backup and look at the query there, another option is to create a User Defined Table, and a stored procedure to copy all queries once or several times a day into that UDT. However, the change log is the only one that can tell you who made the change.

Can you tell us why the change log is not sufficient?

Regards,

Johan