Skip to Content

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

User Id and Date Updated in Item Master

Dear All,

I have created 2 User Defined Field in OITM.

U_Userid (3 Character AlphaNumeric)

U_DateUpdate (Date Field)

I would like to pick the User Login who Updated the Item Master and the Date (Todays Date) when the Item Master was Updated.

I can use the Audit Trail but my Client would like to see the field on the Item Master.

I want to know from which Table can i get User Login and Todays so i can used FMS for Display

Kind Regards

Raju Parmar.

replied

Hi,

To get date of update, use below FMS and set auto refresh based on date of update:

SELECT T0.[UpdateDate] FROM OITM T0 WHERE T0.[ItemCode] = $[OITM.itemcode]

To get updated user I, use below FMS,

SELECT t1.userid FROM OITM T0 left join OUSR T1 on t0.usersign2 = t1.userID WHERE T0.[ItemCode] = $[OITM.itemcode]

Thanks & Regards,

Nagarajan

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