Date of BP Update

[Former Member]

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!

[javier_facessantos]

Hello Bernard

Check ACRD.UpdateDate field, and also check following post:

Query for Change Log | SCN

Regards

[Former Member]

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!

[kothandaraman_nagarajan]

Hi,

Then you have to query all fields using OCRD and ACRD table. It is not easy to create such query. It may be possible for few important fields.

You can get idea from above thread.

Thanks

[Former Member]

Thank you, Nagarajan - I'm still working on this, but I accept it may not be possible.

[Former Member]

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.