Skip to Content

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 22, 2014 at 08:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded