FMS for first update user

[former_member209725]

Dear Experts...

I need FMS for first update user for Item MAster Data. Name for who had create Master Data.

Thanks in advance

Regards,

Ravi.

[Former Member · Accepted solution]

HI Ravi ,

Do you need FMS , which return the User who created the Item Master Data

OR

A Report which provide data , that who created the Item Master Data.

Thanks

--

Ashish Ranjan

[Former Member · Accepted solution]

Hi Ravi,

Try this

SELECT T0.[ItemCode], T2.[ItemName], T1.[U_NAME],  T2.[CreateDate], T2.[UpdateDate] FROM OITW T0  INNER JOIN OUSR T1 ON T0.userSign2 = T1.USERID INNER JOIN OITM T2 ON T0.ItemCode = T2.ItemCode
Group By
T0.[ItemCode], T2.[ItemName], T1.[U_NAME],  T2.[CreateDate], T2.[UpdateDate]

You have to put this query into Alert & set frequancy to execute.

Thanks,

Srujal Patel

[former_member209725 · Accepted solution]

Hi Ashish...

I need FMS for the same which I'll have to set on Item Master Data where I have an UDF.

Regards,

Ravi

Edited by: RAVI_JHA_SAP on Jun 16, 2011 8:32 AM

[former_member204969 · Accepted solution]

To get the name of the creator you can use this fms:

SELECT T1.U_name
  FROM OUSR T1 Where $[OITM.UserSign] = T1.USERID

And to get the last updater

SELECT T1.U_name
  FROM OUSR T1 Where $[OITM.UserSign2] = T1.USERID

[former_member209725 · Accepted solution]

Hi Istvan...

Thanks for your help.

I tried your query but in some item mastrer data the result is not right, I mean what username FMS returns that name I can't find in change log.

Regards,

Ravi

[former_member204969 · Accepted solution]

The change log (AITM) contains only limited number of entries. May be the first is fallen out. The creator is stored in the OITM table.