Tables for Opportunity "Status" and "Reason"

[Former Member]

Hi,

Can someone help me in finding the tables for determining "Status" and "Reason" for an opportunity along with the relvant text descriptions?

Regards,

Sandeep

[Former Member · Accepted solution]

Hi Sandeep,

If you are looking for user status, you can find it in table CRM_JEST (use opp guid and inact = ' ') to find the current status. table TJ30T gives the status description.

Reason codes can be found in table QPCT (catalog O1 or O2).

Hope this helps!

[P000636]

Hi Sandeep,

Status- code in field stat of CRM_JEST table

OBJNR = guid opportunity

INACT = SPACE

Text of status in TJ30T with your status profile

Reason- code in field code of CRMD_SRV_SUBJECT with

guid_ref equal to guid_set( of crmd_link with objtype_set = 29 )

Text of reason in QPCT

I hope this way help you.

Regards.

Manuel

[Former Member]

All,

Thanks so much for your help. The only missing link was the status profile which I found from table CRMC_PROC_TYPE. Without this I was getting multiple status values.

Thanks again!

Regards,

Sandeep

[siowfong_chen]

Hi! I am also looking for the reason codes from the table CRMD_SRV_SUBJECT but I cannot find the correct guid to input into the GUID_REF field. This is for a complaint item.

Thanks very much.

Regards

SF

[former_member788471]

Hi SF,

In addition to the tables mention before you will also need CRMD_SRV_OSSET to link all.

CRMD_OPPRT_H.GUID_REF --> CRMD_LINK.GUID_HI (objtype_set = 29)

CRMD_LINK.GUID_SET --> CRMD_SRV_OSSET.GUID_SET

CRMD_SRV_OSSET.GUID --> CRMD_SRV_SUBJECT.GUID

Regards,

Mischa