How To See Change Log For A Table Entry

[ajoy_chakraborty]

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

[Former Member]

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

[Former Member]

Hi,

Try this function module..

BAL_DSP_LOG_DISPLAY

Regards

Kiran

[GauthamV]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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!

[Former Member]

hi,

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

[Former Member]

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.....

[mukesh_mahadik]

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