Question Re: t-code to see tables in Technology Q&A

t-code to see tables

Former Member — Tue, 21 Sep 2010 04:54:18 GMT

Hello All,

Is there any t-code which displays all the tables(ABAP/Java) in PI

Regards,

Moorthy

Former Member — Tue, 21 Sep 2010 05:26:16 GMT

Hello, DasikaMoorthy

Take a look at ABAP t-codes SE11/SE16.

Lists of PI tables you can find in this topic:

and this wiki:

Former Member — Tue, 21 Sep 2010 05:31:59 GMT

Hi,

you can try DB02 transaction.

In DB02 there is one detailed analysis is there if u are give tablespace for abap and java.

or if u give * it will show complete table details from database level

Regards

Pradeep P N

Former Member — Tue, 21 Sep 2010 05:36:43 GMT

SE 11.

Former Member — Tue, 21 Sep 2010 06:11:52 GMT

But I can't see XI_AF_MSG table in SE11.

Its saying table does not exist

Former Member — Tue, 21 Sep 2010 06:37:58 GMT

Hi,

The PI / XI tables that store the information of your interfaces and their messages are maintained in the Java Stack of the PI server.

SE11 transaction cannot be used to view these tables.

Either use the SQL Command in transaction DB02 or contact the Basis team to view the contents of these tables from the PI Server Database.

Regards,

Alka.