topic Re: updated record in Application Development and Automation Discussions

updated record

Former Member — Thu, 24 Jul 2008 08:58:58 GMT

how to see the last updated record in a table?

Re: updated record

Former Member — Thu, 24 Jul 2008 09:01:39 GMT

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

Re: updated record

Former Member — Thu, 24 Jul 2008 10:06:22 GMT

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

Re: updated record

Former Member — Thu, 24 Jul 2008 12:41:46 GMT

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.

Re: updated record

Former Member — Thu, 24 Jul 2008 13:17:42 GMT

Tx Very Help full answer,

Re: updated record

Former Member — Fri, 25 Jul 2008 09:14:50 GMT

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

Re: updated record

former_member787646 — Mon, 28 Jul 2008 05:40:37 GMT

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