Item Master Update/Create

[former_member209725]

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.

Regards,

Ravi

[Former Member · Accepted solution]

select UserSign2,CreateDate,UpdateDate,* from OITM

Select * from OUSR

After that you can filter by Date in Query manager windows.

Thanks

Manvendra Singh Niranjan

[former_member209725 · Accepted solution]

Hi Manvendra.

Thanks for your prompt reply.

I tried your query but I just need ItemCode, Desp, username & date only.

Regards,

Ravi

[former_member206488 · Accepted solution]

hi ravi,

try this:

select Itemcode,ItemName ,UserSign2,CreateDate,UpdateDate from OITM

or SELECT T0.[ItemCode], T0.[ItemName],T0.UpdateDate ,T0.UserSign2 FROM [dbo].[OITM] T0

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

thanks,

neetu

[Former Member · Accepted solution]

Hello Ravi,

I think got your solution which given by neetu

Thanks

Manvendra Singh Niranjan

[former_member209725 · Accepted solution]

Hi Mam.

Can't I get User Name instead of Usersign2?

Regards,

Ravi

[former_member206488 · Accepted solution]

try this:

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

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

Thanks,

Neetu

[Former Member · Accepted solution]

Hello Ravi,

There must be Leftouter join because all SAP user not have rights for make new item.

Thanks

Manvendra Singh Niranjan

[former_member209725 · Accepted solution]

Hi Mam.

Thanks for Help. Report is right.

Still have one issue. Can we get report for Item Master for very first or earlier UpdateDate/CreateDate?

This is just for additional information. Bcoz Item Master Data has been updated around 4-5 times.

and I need that creator Name alongwith Item Code.

Thanks.

Ravi

[former_member206488 · Accepted solution]

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.

Thanks,

Neetu

[former_member209725 · Accepted solution]

Hi Mam.

Thanks a lot.

This query has fulfill my requirements.

Solved.

Regards,

Ravi