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.

 

Regards,

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

     

    Rewards

    Manish

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

      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

Actions