List of changes on loan (LD)

Hi,

Is there any solution to see which columns has been changed in certain LDxxxxxxxxxx in every history record in LD.LOANS.AND.DEPOSITS$HIS table?
For example:
LD1234567890;2 - Int.Rate
LD1234567890;3 - Maturity.Date, Int.Rate
LD1234567890;3 - Define schedule, Limit.Reference
etc.

Of course, I'll exclude system changes.

p.s: I know about viewing history in T24, but it's not a solution for that task, because I've plan to make it in batch.

There is no out-of-the-box solution.
You have to create your own routine that e.g. reads two records to compare and then loops thru all fields (FOR I = 1 TO LD.AUDIT.DATE.TIME) comparing the contents.
You may define fields to compare or to exclude as you like or step over records with "system"-inputter.
To get field names you may use the routine FIELD.NUMBERS.TO.NAMES(IN.FLD.NBR,R.STD.SELECTION,OUT.FLD.NAME,DATA.TYPE,ERR.MSG).

Hi,

Thanks for reply.

In browser mode there is very nice tab called "Changes", it's stores information that I'm talking about. But it's not a "sub-screen", as I understand it's only browser feature. Is it possible to use this feature for batch information extracting? It's not screen, otherwise I would have used this screen for batch extracting purpose.