3 Replies Latest reply: Jul 21, 2008 6:38 AM by Uday Kumar RSS

Table's for Survey in SAP CRM2007

Rajesh Banka
Currently Being Moderated

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.



Rajesh Banka

  • Re: Table's for Survey in SAP CRM2007
    cheney cai
    Currently Being Moderated

    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 ) .

  • Re: Table's for Survey in SAP CRM2007
    Manish Mittal
    Currently Being Moderated

    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.*




    • Re: Table's for Survey in SAP CRM2007
      Uday Kumar
      Currently Being Moderated


      Use the FM's


      By passing GUID and get the et_survey_ui


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


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


      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.