CRM Survey Tables

[Former Member]

Can anyone tell me what tables are used by surveys created in Survey Suite(HTML) to store the answers and rankings? I was able to find CRM_SVY_RE_ANSW and this is the only table I saw that gives me the survey data but I can't find the relationship to CRMD_ORDEADM_H. Would anyone happen to know? Thanks!

Noel De Olazo

ndeolazo@gmail.com

[Former Member]

Hi,

Can anyone please tell me that how to find survey id?

Thanks

[Former Member]

Hi Doris,

I was able to get the actual values of the survey including the

question_ids and asnwer_ids. This includes the question and answer

texts which you have defined in CRM_SURVEY_SUITE when creating the

questionnaire.

What you need here is the GUID of the transaction to start off the

process. Using CRMD_ORDERADM_H table, get the GUID value using your

selection parameters. Once you get the GUID, you can call FM

'CRM_SURVEY_DATA_GET' to get the survey header data (ET_SURVEY_UI).

You must determine the survey version and the values version that you

need because these would give different values if you have multiple

versions of your survey. Create an object for this class

'CL_CRM_SVY_SURVEY_TEXTS' and from here, you can get all the values

that you need in a single table.

I hope this helps. Reply if you've been able to work with it or if you

have any questions. Thanks.

Regards,

Noel De Olazo

[Former Member]

Hi Noel,

many thanks for the informations. Now I am able to extract the hole texts whith ids.

I have 3 more questions, perhaps you can help:

1. Do you have any idea, how to implement this link between activity and surveyvalues into BW?

2. The table CRMD_SURVEY contains 3 GUIDS. I guess the second one represents the Survey GUID and the third one the Value GUID. What does the first GUID contain?

3. In BW the question ist compounded with a questionnaire and the application. Where does this questionnaire come from? In CRM I only see the GUID of the Survey.

Many thanks in advance.

Doris

[Former Member]

Noel sorry, I saw it too late, you are CRM-Expert, not analytical CRM. So please forget the first question, but perhaps you can help for both other questions.

Thanks

[Former Member]

Hi Susana,

First you manually maintain the data in your activity questionaire and save it while saving go the "Debug mode" and check there are few SVY FMs are using for creating the questionaire values with version.

I think, no other way other than debug.

Regards

Bala.c

[Former Member]

1. You can use CRM_SURVEY_DATA_GET FM and pass the GUID for the transaction and get the survey data from et_survey_ui table.

2. Read the Survey data from CRM_SVY_SURVEY_READ FM.

3. Create the Object for an class cl_crm_svy_values and pass the XML and HXML.

4. Call question_ids_get, answer_ids_get and values_get method you can get the Value.

If you need more information reply back.

Regards

Bala.c

[Former Member]

Thanks a lot for the information.

I was able to find the link with the tables that store the answers results, without using the XML.

Now I am with another problem.

I need to load survey results in activities created in CRM.

These survey results will be available in a txt file.

Do you have any idea how to load this data in CRM?

Thanks a lot!

Susana Messias

[apachon]

Hello, Somebody has some example in ABAP of explained here. Thank you very much.

[Former Member]

Hi Susana,

Can you please provide me the link between the tables to get teh answer results

[Former Member]

The link betwen surveys and transactions is in CRMD_SURVEY

and CRMD_LINK (OBJTYPE_HI - 05 , OBJTYPE_SET = 58 - survey).

The link between CRMD_SURVEY and CRMD_LINK is based on CRMD_LINK-guid_set and CRMD_SURVEY-set_guid.

From CRMD_SURVEY you will take the SURVEY_GUID and use this value to interogate the other tables.

BR,

Florin.

[Former Member]

And in addition to that you need to look at the following tables:

CRM_SVY_DB_SV and CRM_SVY_DB_SVS. These tables contain the actual survey response but encrypted in XML format. So you will find VALUEGUID in the CRMD_SURVEY table that will join to the VALUEGUID in the above 2 tables.

Thanks,

Piyush

[Former Member]

Hi,

do you know hoe to desencrypte this XML to get the answers to each question?

Thanks,

SM

[Former Member]

Hi Susana,

What are the table links that you found? Can you please email them to me? Thanks a lot!

Regards,

Noel De Olazo

[Former Member]

Hello Noel,

Send a reply to my e-mail susana.messias@gmail.com and I 'll send you the logic.

Regards,

SM

[Former Member]

Hi Susana,

I have the same problem identifying the survey tables. Can you please help?

We have a survey report in BW and the Questionaires in CRM and cannot find the linkage between the data sets.

Regards, Lotte

[Former Member]

Hi Susana & Bala,

as Bala propose, I implement the coding to get the et_survey_ui table, read the survey attributes with the FM, create the object for the class and pass XML. But I don’t get the question_ids, answer_ids or values. Could you please give me more information or send me the right coding?

Thanks in advance

Doris