SAP CRM survey .

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.

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.

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

.there is a unique ID generated for every question and answer of the questionnaire.

You will get those ID's in the below table:

CRM_SVY_RE_QUEST---for question ID's

CRM_SVY_RE_ANSW---for Answer ID's.