Schema for PI Tables needed

[Former Member]

Hi Experts,

Can you please provide me the schema for below mentioned PI Tables (Schema: SAPSR3,SAPSR3DB

)as I need to replicate the schema to avoid hitting the PI tables directly due to performance issues.

ABAP schema Database Transaction Codes -

Schema Name - SAPSR3

Transaction Codes - (SE11, SE 16)

SXMSPMAS XI Messages - Master

SXMSPHIST XI Messages - Master History table

SXMSPEMAS Integration Engine: Enhanced Message Queue (Master)

SXMSPVERS Integration Engine: Message Version

SXMSPERROR XML Message Broker: Message Queue (Incorrect Entries)

SMPPMAP3 Mapping Runtime: Mapping

SMPPREL3 Mapping Runtime: Mapping Relation

SMPPSPLIT XI Mapping: Merge and Split

SXMSPFRAWH Integration Engine - Header Table for Raw Data for Performance Evaluation

SXMSPFRAWD Integration Engine: Data Table for Raw Data for Performance

Adapter Engine Tables -

Schema Name - SAPSR3DB

XI_AF_MSG AF XI Message

XI_AF_MSG_AUDIT audit log entries

If runing on PI 7.1, table names are as follows -

BC_MSG AF PI 7.1 Message

BC_MSG_AUDIT PI 7.1 audit log entries (**)

Regards

Neha

[Former Member]

Thanks Shabarish,

Problem is that I don't have access to PI Box as of now and neither to the transactions SE11 & SE16 thus can you help me in providing the information on logical structure of the Schemas mentioned.I need the information on these schemas so that I can replicate the same.

Thanks in advance.

Regards

Neha

[Shabarish_Nair]

I suggest you contact your project team and get the access or ask them to send you the info.

It is quite large an information to be posted over the forum. So the best is to request the team you are working with for it.

[Shabarish_Nair]

to see the schema, go to the transaction se11 on the ABAP stack of XI.

Provide the table name and say display.

You will be able to see all the fields etc involved for that particular table you want.