Change LOG Report

[Former Member]

Dear All

I have required report for Business partner change log history report through the SQL Script.  Please suggest me or share the Quires

[former_member188586]

HI Prakash

Check bellow Thread it may help you

Thanks&regards

AndakondaRamudu

[Former Member]

Hi Andakonda

how to fetch   Previous  value and  and new value  of update information .

[kothandaraman_nagarajan]

Hi,

Try with OCRD and ACRD.

Thanks & Regards,

Nagarajan

[Former Member]

Hi

I Know but how to do compare both table I want to out put like this :

Vendor CODE

Vendor Name

Update DATE

Update By

Creation Date

Created by

Change Filed

Previous Value

New Value

[kothandaraman_nagarajan]

It is not easy to get changes of all field values in single query. Please advice exact field to know the history.