topic Tracking changes to fields in a Table in Application Development and Automation Discussions

Tracking changes to fields in a Table

Former Member — Tue, 05 Jun 2007 18:07:49 GMT

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

Re: Tracking changes to fields in a Table

former_member194669 — Tue, 05 Jun 2007 18:14:29 GMT

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

Re: Tracking changes to fields in a Table

Former Member — Tue, 05 Jun 2007 18:41:20 GMT

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

Re: Tracking changes to fields in a Table

Former Member — Tue, 05 Jun 2007 22:55:52 GMT

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