How to get server details of BO 6.5 and query system tables of BO 6.5?

[Former Member]

Hi All, We need this urgent.

1. How to get server details of BO 6.5 SP4?

2. How to query system tables - CI_SYSTEMOBJECTS and CI_INFOOBJECTS in BO 6.5 SP4?

3. Will Query Builder of SAP BO 3.1 work in BO 6.5 SP4?

Thanks and Regards, Amit

[Joe_Peters]

1. Can you elaborate on exactly what you're looking for?

2 & 3. The repository in pre-XI versions was more "human-readable" than afterwards; it's pretty easy to perform direct queries against the repository tables to get metadata. For example, the obj_m_actor table contains data on all users and groups in the system.

So, all you need is direct access to the database tables that house the repository

There was a document ("The Business Object Repository Reference Guide") which provides a decent amount of detail on the various tables. I wasn't able to locate it on sap.com, but tech support may be able to provide it to you.

[denis_konovalov]

I don't think there are anyone in support that still has 6.x docs or white papers.
As the product is way out of support, opening an Incident on this topic will be fruitless.

[Joe_Peters]

You are probably correct, but I can't think of any other way to get the documentation. I have it, would I would be hestitant to upload it since it's copywrited.

[denis_konovalov]

maybe at BOB forums 😉

[Former Member]

Hi All,

We are working on Crytal Reports for Visual Studio.

In .Net code we found these queries-

1. "SELECT TOP 1 * FROM CI_INFOOBJECTS WHERE SI_NAME = '" + tName + IFMGEnvPrefix + "' AND SI_INSTANCE = 0"

2. "SELECT TOP 1 * FROM CI_SYSTEMOBJECTS WHERE SI_ID =" + iStoreU.EnterpriseSession.UserInfo.UserID

These queries are being used for populating parameters in the web page. So where to run these queries?

[Joe_Peters]

You will need to perform queries directly against the repository to get that info.

To query for reports by name use:

select * from obj_m_documents where m_doc_c_name = 'xyz'

To query for users, use:

select * from obj_m_actor where m_actor_c_name = 'xyz'

Note that the information stored in those tables is completely different than ci_infoobjects / ci_systemobjects.

[denis_konovalov]

1. I think there was cluster console or cluster config tool in 6.5 that did this.
2. There are no such things as CI-SYSTEMOBJECTS and CI_INFOOBJECTS In 6.5. Repository architecture is completely different and those views/tables do not exist there.
3. No, it will not. You need to use Supervisor.