Repository Tables

[system]

Hi,

Does anyone know if there is a published data model for repository tables? What we are trying to do is locate the table name and column names for user account data (name, e-mail address, job title, user account name).

Any advice would be appreciated.

---

jsull2 (BOB member since 2009-06-04)

[system]

Going directly against the repository tables is not supported and should be avoided at almost any cost.

Instead you should be able to use SDK/APIs to access most of that information. Look at www.sap.com, there should be some information about it… somewhere

---

Andreas (BOB member since 2002-06-20)

[system]

Welcome to B:bob:B!

Review this utility that uses SDK to connect to CMS and extracts users’ information:

BOXI UserList & Group Extraction

Here is a little excel file with a bit of VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership… It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description. Platform: BO XI R2 / BOXI3.1 (it’s necessary to change the libs to fits XI3.1, s…

You may find it useful.

---

Marek Chladny (BOB member since 2003-11-27)

[system]

Thank you all for your help. Much appreciated.

---

jsull2 (BOB member since 2009-06-04)