on 05-03-2016 5:21 PM
I need to know the date that a field was changed in a Business Partner. I know about the ACRD table but my query has to be able to use the data in the "Differences" display. (This comes up when you highlight two lines in the Change Log and click "Show Differences"). ACRD does not contain enough information. Can anyone help with what my SQL should look like? Thank you all!
Hello Bernard
Check ACRD.UpdateDate field, and also check following post:
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Javier, but this only shows the date that the BP form was updated. I need to know when the individual field was updated - the "Differences" display (from the Change Log) shows this but I don't know how to write a query that will give the actual field name. But I appreciate your feedback!
OK, I had some help, but I've figured it out. Let's assume I'm trying to calculate the date that a UDF was updated (say, U_USERFIELD). If I run a query on ACRD and look at the most recent entry I would find a NULL entered against the column U_USERFIELD. But then I look at the same field in OCRD and I find that there is a value assigned into it. This means that it is the most recent change that has been made to the BP: and since SAP 8.8 onwards, it will not be entered in the change log. So, the value I want for UpdateDate is the one in OCRD.
The full query will also verify that U_USERFIELD is NULL in the change log but non-null in OCRD. So it should be fairly easy to do an inner join on ACRD and OCRD and pull out the values that I need.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
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.