table name, that store ticket's status in solman..

[Former Member]

Dear All,

Can anyone give me a table name, that store every ticketu2019s status and priority in solution manager.

or else is there any standard function module available, that return particular ticket's status and priority.

Thanks and Regards,

Kaushik Savaliya

[Former Member · Accepted solution]

Hi ,

CRMD_ORDERADM_H( GUID listed)

CRM_JEST(user current status, givce GUID as input)

crm_jcds(all previous status)

Thanks,

Jansi

[Former Member]

I have listed some solman related tables below.

each and every time the status changed there will be two entries in CRM_JEST for user status and System Status.

CRMD_ACTIVITY_H Activity

CRMC_ACTIVITY_H Process Type-Activity-Control Parameter

CRMC_OBJECTS Business Transaction - Sub-object Type

CRMD_ORDERADM_H Business Transactions CRM

CRMD_ORDER_INDEX Index table for one-order document

CRM_JEST Individual Object Status

CRMD_LINK Transaction - Set u2013 Link

CRMD_PARTNER Partner

CRMD_SALES Business Transaction - Sales Set

CRMD_ESCAL Service Response Time Schema

Regards,

Umesh

[Former Member]

Hii UmeshEssMss

Thanks for your valuable help...

Regards

Kaushik Savaliya