Skip to Content

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

Item Master Update/Create

Hi Experts,

Where from I can see that Item Master when created/updated or removed by particular user.

I mean I can see Item Master Data in a particular Date Range by User.



Former Member
Former Member replied

try this for item history updates:

SELECT T0.LogInstanc, T0.ItemCode, T0.ItemName,T0.UpdateDate ,T0.UserSign2,T1.User_code,T1.U_Name FROM dbo.AITM T0 Inner Join OUSR T1 on T0.userSign2=T1.userId

Where T0.UpdateDate >= %0 and T0.UpdateDate< = %2

T0.LogInstanc column will show whether it is 1st update or next.

add T0.LogInstanc=1 condition in where clause to get 1st time updated item record.

similary T0.LogInstanc=2 will provide 2nd update data.



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