Table's for Survey in SAP CRM2007

[Former Member]

We require to create a report in BW for CRM Survey, based on Survey Questionnaire.

Please guide which are tables related to CRM Survey in CRM 2007, which could help us to create the required report. We actually require to pull in only some question & its response in the form of Text, RadioButtons & Check Box into report with other Standard fields.

Regards,

Rajesh Banka

[Former Member · Accepted solution]

Hi, Rajesh Banka:

I check the table of the survey in CRM, the survey content was stored as xml string in the table ,i think you could not get the useful information from the table , you should parse the xml string .

My method , when save the survey , i enhanced the pai FUNCTION, save the value i want to get in Z table (customer table ) .

[Former Member]

Hi Rajesh,

Please find the process to get the survey details :

Take the guid of your activity document and put into the table CRMD_SURVEY

Pick value guid guid from this table and pass it to the class CL_CRM_SVY_SURVEY_TEXTS

you can use the different methods of this class to get the required texts.

*Please reward if helpful.*

Rewards

Manish

[Former Member]

Hi,

Use the FM's

CRM_SURVEY_DATA_GET

By passing GUID and get the et_survey_ui

CRM_SVY_GET_SURVEY_TEXTS

Pass the et_survey_ui-applicationid and et_survey_ui-surveyid and get the survey_texts and survey_version.

CRM_SVY_DB_S_READ

Pass et_survey_ui-surveyid et_survey_ui-surveyversion and get the lt_crm_svy_db_s.

Use the FM,CRM_SVY_DB_CONVERT_HEX2STRING

For reading the XML data of the survey.

To get Answer text use the FM 'CRM_SVY_GET_SURVEY_TEXTS.

By using above function modules you can get the survey details.

Regards,

Uday