cancel
Showing results for 
Search instead for 
Did you mean: 

How to determine if a database is SBO2005 or SBO2007?

rasmuswulff_jensen
Active Contributor
0 Kudos

Hi All

Is the any way in the SDK or SQL in a database to determine if a database is SBO2005A, SBO2005B, SBO2007A or SBO2007B...

We have an add-on that run on both SBO2005 and SBO2007, but it have some functionality that changed in the new SAP version adn therefore we need to do one thing in our code if SBO2005 and another thing if it is run on SBO2007

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can query the company database or SBO-COMMON via SQL to get the integer value for the database version.

Company Database:

SELECT Version FROM CINF

SBO-COMMON database:

SELECT Version FROM [SBO-COMMON].[dbo].SINF

The first 3 digits indicate the main Version Release whereby the last three digits might change with a new patch.

Current Versions are:

SBO 2004A: 670XXX

SBO 2004.2B: 730XXX

SBO 2004C: 770XXX

SBO 2005A: 680XXX (SP00 680100-680200, SP01 680300-680XXX)

SBO 2005B: 740XXX

SBO 2007A: 800XXX

SBO 2007B: 860XXX

Regards,

Friederike.

rasmuswulff_jensen
Active Contributor
0 Kudos

Thank you all... That was just what I needed

Answers (1)

Answers (1)

Nussi
Active Contributor
0 Kudos

Hi,

in the CINF Table theres a field called Version

so far i know:

680xxx -> 2005 A

740xxx-> 2005 B

800xxx -> 2007 A

regards

David