topic Re: How To See Change Log For A Table Entry in Application Development and Automation Discussions

How To See Change Log For A Table Entry

Former Member — Wed, 11 Feb 2009 09:35:25 GMT

Hi Experts,

One entry is created in a table. I want to know, when that entry was created/ changed.

Is there a way to find it out.

PLZ NOTE: Table doesn't contain any DATE field.

Regards

Re: How To See Change Log For A Table Entry

Former Member — Wed, 11 Feb 2009 09:38:19 GMT

You can log the changes of data like append, modification or delete fields in a table.

When you create your transparent table, you can go to the technical settings screen and set the flag "Log data changes".

SE11 -> Technical Settings -> tick the Log data changes

Remember that you must have the parameter rec/client set in the system profile.

RZ10 - Extended Maintenance

rec/client = ALL (log all clients)

rec/client = 000(,...) (log all specified clients)

rec/client = OFF (do not log)

You can see the changes to the table in the transaction OY18 or SCU3.

Logging is independent of update. Obviously, it will slow down the accesses when you change the table as record have to be written into the log table for each change.

DBTABPRT - Table of log records for table changes

Re: How To See Change Log For A Table Entry

Former Member — Wed, 11 Feb 2009 09:38:32 GMT

Hi,

Try this function module..

BAL_DSP_LOG_DISPLAY

Regards

Kiran

Re: How To See Change Log For A Table Entry

GauthamV — Wed, 11 Feb 2009 09:39:48 GMT

If the field for which you want change log is having change document used at

data element level then it will be stored in CDHDR,CDPOS tables.

Re: How To See Change Log For A Table Entry

Former Member — Wed, 11 Feb 2009 09:42:41 GMT

Hi,

try CDHDR and CDPOS tables.

In the CDPOS - item table.

pass the table name and field name and whatever details you can pass.

get the values of these fields.

OBJECTCLAS

OBJECTID

CHANGENR

Pass these values into CDHDR and get the date which will be available in this table.

Regards,

Venkatesh

Re: How To See Change Log For A Table Entry

Former Member — Wed, 11 Feb 2009 09:43:24 GMT

Hello Ajoy,

Check this [help|http://help.sap.com/saphelp_nw04s/helpdata/en/c7/69bcd2f36611d3a6510000e835363f/content.htm]

and also chekc in the CDHDR and CDPOS

hope it helps you.

Regards!

Re: How To See Change Log For A Table Entry

Former Member — Wed, 11 Feb 2009 09:55:45 GMT

hi,

You can see the Table log history in SCU3 if the Table is logged for changes..> Technical settings-->Log data changes.

Re: How To See Change Log For A Table Entry

Former Member — Wed, 11 Feb 2009 10:33:26 GMT

Hi,

or else do like this...

In order to maintain the log changes the main pre reuisite is to checkmark the checkbox in dataelement of table filed.

To do this...

goto transaction SE11~~>enter ur table name>cleck on fields tab>cleick on dataelement->click on Furthercharacterstics tab~~-->select the checkbox'Change Document'.

If u dont select dis the u cannot see the log entry of the particuylar field..Do like this for each dataelement for each table field...selecting all the fields is not mandatory..u can choose the table field u want to see the log report..

Once u done with dat...

Goto SCDO transaction~~> click on create>give a name change doc startwith Z or Y only>Follow the prodedure and in~~--~~>name of table field~~>enter u r TABLE NAME~~->click on individual field checkbox.~~--->insertentries..

Once u done with dis..

Goto SE16~~->enter CHDIR or CDPOS~~->press ENTER~~->enter u r object id~~>F8

U can see the new and old value of a table entry.....

Re: How To See Change Log For A Table Entry

mukesh_mahadik — Fri, 26 Aug 2016 10:16:54 GMT

Hi Ajoy,

I was able to view change logs using SCU3 t-code. But for this you need rec\client parameter to be set as your client number and also SE11 -> Technical Settings -> tick the Log data changes

Re: How To See Change Log For A Table Entry

Former Member — Fri, 26 Aug 2016 16:00:16 GMT

I agree with his solution. As we need to use both the tables: CDHDR and CDPOS to get change log details of any document.