updated record

[Former Member]

how to see the last updated record in a table?

[Former Member]

hi,

If you have a 'Log changes' checkbox being checked in the Technical attributes of the table run report RSTBPROT ... by giving the table name on the selection screen for versions <4.7 or RSVTPROT for versions >=4.7 which displays all the changes made to the records of that table.

Regards,

Santosh

[Former Member]

create a change document for the field and chaeck it from CDHDR and CDPOS table.

for details for creation of change document check the link

http://help.sap.com/saphelp_nw2004s/helpdata/en/2a/fa015b493111d182b70000e829fbfe/content.htm

REMEMBER SAP TRACKS CHANGES IN ONLY THOSE RECORDS FOR WHICH CHANGE DOC IS CREATED.

Regards,

Anirban

[Former Member]

Hi Vijaya,

Lets say if have changed the material records in MM02 transaction... Goto SE11 and check the entries if CDHDR (header table of changed documents) and check the entries of that particular material by mentioning the user & date values.. so that you could find the corresponding entry... and in CDPOS actual value is stored which is changed... in that also specify the material number and change id as 'U' and field name.

so you would get the entries... and if possible copy the CHANGENR value from CDHDR and specify that even in CDPOS so that you would get the exact record..

If every thing is 'Z' then make sure that you check the log checkbox in data element --> further characteristics.

and create you own change document object and write a simple by calling the update function module generated by the system during creation of changed document object in SCDO transaction.

Any queries Revert Back.

Hope this would help you.

Regards

Narin Nandivada.

[Former Member]

Tx Very Help full answer,

[Former Member]

hi the tables CDPOS and CDHRD contains the changed records ...

IF THE CHANGED USE IS KNOWN THEN FOLLOW THIS

the table DBTABLOG is used to store the changes done by the user.

use the table REPOSRC to get the details of the user who changes the program

to get the changes done by any user it will be seen in D010SINF.

program RSUSR002contains the data for user changed details

[former_member787646]

Hi

Create a change document object for that table using the transaction code "SCDO" to track the modifications on that table.

Use the transaction code "RSSCD100" to view the changes on that table.

Hope it helps.

Murthy

Edited by: Kalyanam Seetha Rama Murthy on Jul 28, 2008 7:41 AM