on 09-30-2008 11:23 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.