Activity Result Table

[former_member227806]

Hi All,

I created a Task in CRM...

It is having the following fields STATUS, RESULT....

I selected STATUS as completed, and Result as "Personal reminder".....

Now i want to check the activities based on the Result field = "Personal reminder"....

Which table the Result value of each activity is getting stored?

Or any other way to search.

Please help.

[Former Member · Accepted solution]

Hi Ramkumar,

The result field data is stored in table CRMD_SRV_SUBJECT.

What I have understood is that you want to fetch all the orders(Task) which have Result as "Personal Reminder".

If this is your requirement then below is the path from where you can get the order no.

1. You need to fetch the REF_GUID from table CRMD_SRV_SUBJECT

where KATALOGART = 'XX'

and CODEGRUPPE = 'XXX'

and CODE = 'XX'' (your code no for Personal Reminder'.)

2. Then get (GUID_SET) all the entries from table CRMD_SRV_OSS where guid = CRMD_SRV_SUBJECT - ref_guid.

3. Then get (GUID_HI) all entries from table CRMD_LINK where guid_set = CRMD_SRV_OSS - GUID_SET.

4. Then get the document number from CRMD_ORDERADM_H where GUID = CRMD_LINK-GUID_HI.

In short, link is from

CRMD_SRV_SUBJECT - REF_GUID = CRMD_SRV_OSS - GUID

CRMD_SRV_OSS - GUID_SET = CRMD_LINK - GUID_SET

CRMD_LINK - GUID_HI = CRMD_ORDERADM_H - GUID.

HOPE it solves your problem.

Regards,

Shailesh Jadhav

[Former Member]

Hi Ramkumar,

For Searching the Activities Based on Status of an Activity

Use Table:CRMV_INDEX_JEST

Enter the Status ID of your Object in the Status Field and execute this shall show you all the Activities present in at your required Status also you may Enter the Date Range for Defined Search.

Also you may Use Table: "CRM_JCDS"

Just Enter your Status of the Transaction and the Date range for Search and you may get your Required Output

Hope it Answered your Query..

Thanks and Regards,

RK.