query for item master data
i want to create a query for items in the item master data that shows the changed field, the old value, the new value, user name and the date it was changed .
can anyone help please.
Gordon Du replied
For Item and BP log, query will be pretty simple. Something like:
Select T0.ItemCode, T0.ItemName, T1.U_NAME, T0.UpdateDate From AITM T0 Inner Join OUSR T1 on T0.UserSign = T1.USERID Where T0.UpdateDate >= '[%0]'
For Documents, you have to identify them by Objcode from ADOC.