Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

query for item master data

hi all,

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.

ciao

Former Member
Former Member replied

Hi Satish,

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.

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question