Need to validate why the value is differing from ERP in Table
Hi,
At the table level, for item SU103216, we are seeing the inverse usage rate value as 1000000000, with a last update timestamp of 2025-05-19T10:33:22.169+00:00. However, in the Application UI, the value displayed is 6.478149099, with the same update timestamp: 2025-05-19T10:33:22.169+00:00.
Need to validate why the value in the table differs from what is shown in the UI. The value shown in the UI should be accurately reflected in the table.
The SQL query uses the following tables to fetch the data:
WIS_WD_OPERATION_RESOURCES (wworu) – for the inverse usage rate value
EGP_SYSTEM_ITEMS (esti) – for the item number.