Skip to Content
Author's profile photo Jerry Wang

A small tip to get a list of changed objects at the given time period

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

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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