cancel
Showing results for 
Search instead for 
Did you mean: 

User Id and Date Updated in Item Master

RajuParmar
Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

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

Answers (0)