Tracking the table changes

aaparanjpe — Thu, 06 Sep 2007 07:59:10 GMT

Hi All,

We need to have a trace on the changes(direct/transactional) made to one particular field of a table (LFA1-ESRNR). We have already explored the following options:

--> Attempting the change log in the table is expected to have a huge hit on the system memory.

--> Another option of tracking this field is the data base level is ruled out because it's not recommended practice.

--> The option of logging the changes through vendor master changes is also ruled out because requirement is to track the changes done directly to the table.

Any pointers to this direction would be highly appreciated.

Thanks and Regards,

Ashish

Re: Tracking the table changes

varma_narayana — Thu, 06 Sep 2007 08:09:13 GMT

Hi Ashish ..

The best way to do is using Change douments .. Since SAP provided the Change doc mainly for this..

Tables: CDHDR and CDPOS.

Tcode: SCDO. Vendor Master : KRED is the Change doc object.

For this the Corresponding data element of LFA1-ESRNR i.e ESRNR is already flagged with Change Document property.

What do u mean by directly updating table .. is it in SE11 or SM30 ..

Then In the Generated Table maintenance program incorporate the Change document logic also .

<b>reward if helpful</b>

topic Re: Tracking the table changes in Application Development and Automation Discussions

Tracking the table changes

Re: Tracking the table changes