Tables Relating Support Msg and its partners along with the subject Profile

Dear Friends,

Every support Msg is uniquely identified by ticket nos...

Every support msg thus has Priorities, partners, Short text msg, long txt msg, subject associatated with it...

Please open a ticket using crmd_order..

I want to have all the information about the ticket like who are the partners, what is the subject.

I know of two tables :

crmd_orderadm_H and crmd_activity_h( for determining priority based on the Guid of the ticket).

But i am looking for the table which associates Subject and partners ( like Sold to party, Msg processor, Support team ) with either the ticket nos or the GUID of the ticket.

Any contributions to this thread woiuld be rewarded..

Revert back if u have ny information about it...