cancel
Showing results for 
Search instead for 
Did you mean: 

query for item master data

Former Member
0 Kudos

hi all,

i want to create a query for items in the item master data that shows the changed field, the old value, the new value, user name and the date it was changed .

can anyone help please.

ciao

Accepted Solutions (1)

Accepted Solutions (1)

former_member583013
Active Contributor
0 Kudos

When you are on the Item Master..Select the Item.. Go To Tools > Change Log

Highlight any two rows and click on Show differences..this will display old value and new value with the Field Names

Former Member
0 Kudos

thanks for the reply

my clients internal auditors require that they have Exception Reports in SAP , i.e reports that can show changes made, date and by which user etc...

1. changes made to item master data

2. changes made to business partner master data

3. changes made to invoices, purchase orders etc..

this reports can be set in query form or xl reporter..

i tried but couldent find the tables ....

any sugestion will be appriciated..

former_member583013
Active Contributor
0 Kudos

Satish,

Using the out of box Change log would be easier. If you want to write these reports it is going to be a daunting task with several hours of efforts. If you still want to do this..

BP Change log table - ACRD

Items Change log table - AITM

Document Change log table - ADOC

Former Member
0 Kudos

Hi Satish,

For Item and BP log, query will be pretty simple. Something like:


Select T0.ItemCode, T0.ItemName, T1.U_NAME, T0.UpdateDate
From AITM T0
Inner Join OUSR T1 on T0.UserSign = T1.USERID
Where T0.UpdateDate >= '[%0]'

For Documents, you have to identify them by Objcode from ADOC.

Thanks,

Gordon

Former Member
0 Kudos

hi all,

can any one help me with this code... when i click on the existing values, it shows me the variables but it dosnt display on the query form....

SELECT T0.CardName, T0.NumAtCard, T1.U_NAME, T0.UpdateDate FROM ADOC T0 INNER JOIN OUSR T1 ON T0.UserSign = T1.userSign WHERE T0.UpdateDate >= '[%0]'

any help will be appriciated plz...

regards

former_member583013
Active Contributor
0 Kudos

Hello,

Your JOIN is incorrect, please use Gordon's query. It should give you what you need.

Suda

Answers (1)

Answers (1)

jitin_chawla
Advisor
Advisor
0 Kudos

Hi,

Any specific reson you require a query as you can get the same results from the Tools > Change Log in the Main Menu when the Item Master Data window is active.

The Change Log Report displays the changes made field wise and the date when done it done and by which user.

You can also check the changes made between two instances as well nu Show Differences pushbox.

Regards,

Jitin