Skip to Content

Sometimes we need to get a list of changed objects by the given user at the given time period, there is a small tip to quickly get this list with little effort.

approach1: query the table VRSD with user name and date as query parameter:

/wp-content/uploads/2014/02/clipboard1_382479.png

Each entry of list contains a corresponding transport request number ( in column KORRNUM )

/wp-content/uploads/2014/02/clipboard2_382480.png

However, this approach could not contain modifications on local objects.

The version number (5) and transport request number(AG3K074711) could also be reviewed in class builder menu Utilities

->Versions->Version management:

/wp-content/uploads/2014/02/clipboard3_382517.png

/wp-content/uploads/2014/02/clipboard4_382518.png

/wp-content/uploads/2014/02/clipboard5_382519.png

Approach2: query table TRDIR:

/wp-content/uploads/2014/02/clipboard6_382526.png

/wp-content/uploads/2014/02/clipboard7_382527.png

The list entry still contains the version number which could be found in version database.

/wp-content/uploads/2014/02/clipboard8_382528.png

/wp-content/uploads/2014/02/clipboard9_382532.png

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Ravi Shankar

    Hi ,

    Useful tip if we go to version management of that particular object we can get this details can you please explain where it is more useful.

    Regards,

    Ravi Shankar L

    (0) 

Leave a Reply