June 23, 2015

Getting components versions directly from the DB in SAP (Abap and Java)

We are currently working on a project that involves the upgrade of some systems, both ABAP and Java systems. For the ABAP systems there are not too much problems with the XMLs used by the SUM, but for Java the story is quite different, it can lead to a lot of errors during the execution of the upgrade.

One of the checks that we take into account while creating the XMLs is to check that source components detected by the MOpz include all the existing components of the system, for that we have to check the actual components of the system, and check this directly from the system was not as flexible as we would like it to be, so our solution was to find the tables on the DB storing the components and its versions, and we found the following:

For java:
select SCNAME, SAPRELEASE, SERVICELEVEL, PATCHLEVEL, LOCATION, CAPTION from SAPSR3DB.BC_COMPVERS where NAME=SCNAME order by SCNAME;

For Abap:
SELECT COMPONENT, RELEASE, EXTRELEASE, COMP_TYPE from SAPSR3.CVERS;