Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Tracking the table changes

aaparanjpe
Explorer

‎2007 Sep 06 8:59 AM

0 Kudos
187

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

1 REPLY 1

varma_narayana
Active Contributor

‎2007 Sep 06 9:09 AM

0 Kudos
97

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>