topic Re: Table Maintaince in Application Development and Automation Discussions

Table Maintaince

Former Member — Mon, 15 Oct 2007 14:44:30 GMT

Hi to all,

Actually i create a ztable and then assigned it to a transaction, i now want to keep a track of all records that has been changed.

I have also done the events steps in table maintenance genarator.i created two extra fields in my ztable like zchanged by and zchanged date.

But my problem is that im not able to get what value had been changed?

By using table CDHDR... i enter my tcode,udate,utime,uname...

but i get this message.....no table enteries found for the specified key.

Please help.

thanx in advance

Re: Table Maintaince

Former Member — Mon, 15 Oct 2007 14:50:40 GMT

Please confirm Check box Log Data changes are checked in Technical setting of the table.

Re: Table Maintaince

Former Member — Mon, 15 Oct 2007 14:52:16 GMT

Use FM

CHANGEDOCUMENT_READ_HEADERS

CHANGEDOCUMENT_READ_POSITIONS

Message was edited by:

Alvaro Tejada Galindo

Re: Table Maintaince

ferry_lianto — Mon, 15 Oct 2007 14:57:01 GMT

Hi,

You can setup change document (SCDO) for any changes to your ztable.

Please check this online help on how to setup and use change document.

http://help.sap.com/saphelp_nw04/helpdata/en/2a/fa015b493111d182b70000e829fbfe/frameset.htm

Regards,

Ferry Lianto

Re: Table Maintaince

Former Member — Mon, 15 Oct 2007 15:00:51 GMT

If you activate the log data changes in technical settings you can see the logs by using transaction SCU3 but if you have a lot of data changes the log tables will get quite big and it also has an effect on performance because every table change will create a log entry as well.

Since this is a z table and you probably add/change data in that table through your own custom coding anyway, why don't you just update the changed-by and the changed-at fields with sy-uname and sy-udate whenever you add/change table entries in your coding?

Regards,

Michael

Re: Table Maintaince

Former Member — Tue, 16 Oct 2007 04:52:54 GMT

Hi micheal ,

Thanx, perhaps this is the best answer....

I hv activated the log data changes in tech.settings (se11).i hv also used sy-datum and sy-uname for storing the respective values.

In tcode scu3 its telling table logging is not currently active in ur system..

How do i get rid of this problem.

but in (se16) when i execute my tcode, sy-uname and sydatum fields are reflecting.

how do i activate my table logging.

please help.

Re: Table Maintaince

Former Member — Tue, 16 Oct 2007 04:57:48 GMT

Also when i am executing table CDHDR in se16 and giving the uname,udate,utime,and executing it..im getting a message..no enteries selected ...what can i do for this..

please reply.