Enterprise Repository reporting

[Former Member]

Hello,

I am interested in developing a simple report ( in ABAP or Java) to list down the names of Message Types existing under a particular SWC /namespace. ( active or inactive).

I am finding out how SAP stores the Repository content and in which tables. If anyone has any knowledge on any tables where this information is stored would be helpful.

Cheers

Mustafa

Edited by: Mustafa Mohammed on Dec 7, 2009 3:58 PM

[Former Member]

Very helpful

[Former Member]

Hello,

Special authorization needed for this purpose (standard SAP<SID>DB user).

Please refer to:

How to create a new user which sees all tables?

BR,

Dzmitry

[Former Member]

How to access SAP_<SID>DB.XI_REP* tables

[Former Member]

Hello,

I think that this is tables which you are looking for.

XI Tables

http://wiki.sdn.sap.com/wiki/display/XI/XI+Tables

Tables:

SAP_<SID>DB.XI_REP* Repository objects

SAP_<SID>DB.XI_DIR* Directory objects

BR,

Dzmitry

[Former Member]

Hi Dzmitry,

Thanks for a helpful reply, any ideas on how to acces these tables, cannot view them from se11.

Do I need to query Database at generic level to access these tables?

regards

Mustafa

[Former Member]

Hi,

Probably you can get some help in finding the tables from this blog..

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417200)ID0935294850DB11714568045007346696End...

Regards,

Sarvesh

[Former Member]

Hi Sarvesh,

Thanks for replying, but this blog talks about runtime tables not design tables.

Cheers

Mustafa