how to get status of transaction

[Former Member]

Hi Gurus,

can anyone tell me how to get status of the transaction in crm.

regards,

[Former Member · Accepted solution]

Hi,

You can find it in table CRM_JEST.

The status of the transaction is stored in table CRM_JEST.

Join tables CRMD_ORDERADM_H, CRMD_LINK and CRM_JEST

Regards,

PD

[former_member184067 · Accepted solution]

hi Prashant,

i think no need to join table CRMD_LINK.

just get the guid of the document in table CRMD_ORDERADM_H and based on the guid you can get the status by querying to table CRM_JEST.

cheers.

[Former Member]

Hi,

Call CRM_STATUS_READ_OW and pass the header or item guid, this will give you the current system and user status and as well all previous status which were set in differnt reutn parameters

~Kiran

[Former Member]

Apart from the above metnioned, another table u can use is CRM_JCDS

[former_member184067]

hi vijay,

what kind of transaction did you want to get the status ?

for order, complaint, activity, and task, you can used function modul 'CRM_ORDER_READ' for getting status of the document.

hopes it helps

cheers