Table that stores Object Version

[suwandi_cahyadi]

Dear Experts,

Is there any table in SAP PI that stores the object version (activation date, time, by)? I want to use it to compare object's version between different servers

This is to make me easier to check for comparing objects version between different severs (DEV, QA, PROD). Because every time I try to compare the object version I have to open the ESR / ID and open the object's history to check if both objects are on the same version or not.

Thank you,

Suwandi C.

[former_member184720 · Accepted solution]

Hi Suwandi - I'm not sure of the database table but if you just want to compare the versions between all your PI systems then you can make use of simple query URL

http://host:port/rep/support/SimpleQuery

http://wiki.scn.sap.com/wiki/display/XI/Access+SAP+PI+objects+simply+with+SimpleQuery

below sample screenshot : Ofcourse you can get more values

Just export into excel and compare..

[suwandi_cahyadi · Accepted solution]

Hi Hareesh,

Just for confirmation,

So the idea is to use the simplequery to get the list of objects along with their version ID in each server. Then export the information to excel and compares the versions?

Thank you,

Suwandi C.

[former_member184720 · Accepted solution]

Exactly

[iaki_vila · Accepted solution]

Great Haresh!, i didnt know this utility!, all the days it's possible to learn something new in SCN.

Regards.