Tracking changes to fields in a Table

[Former Member]

Hi ,

I have a created a table with N number of fields. Without using table logging is there any way to track changes only for few fields.

Thanks in Advance

Rajavardhana Reddy

[former_member194669]

create a change document for that table using tranx SCDO and using it in your program after table update.

it will give change documet entries in table CDHDR and CDPOS.

aRs

[Former Member]

Hi,

if you are using Table maintenance to update the table, then you can write a module in PAI of the Table Maintenance screen to generate a log. You can create a Z table to log the chagnes.

In that module:

At the time of save you can check whether those fields are changed by comparing with the current values in a table.

If they are changed, you can write that field name, old value, new value to the Z table.

Darshil

[Former Member]

in this case we need do some coding to update the changes to CDHDR/CDPOS. we have a decided to add new field to the table which shows the status(as in HR module) and add new entry with the new data