Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 03, 2017 at 06:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 06, 2017 at 01:10 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.