Skip to Content
avatar image
Former Member

crm survey suite extractors into BW

Does anyone know whether there are some Business Content extractors for the survey data in CRM. My CRM colleagues have setup surveys using the CRM_SURVEY_SUITE transaction and it would seem to store at least some of this data in the table CRM_SVY_DB_SVS, but not all. However I cannot find any standard extractors to extract all the survey data.

There are extractors for the web survey stuff but the CRM_SURVEY_SUITE transaction does not appear to be a web survey.

Any help would be much appreciated on this.

We are using CRM 4.0 with BW 3.5

Thanks

David

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Jul 13, 2005 at 03:08 PM

    I do remembver seeing a lot of cockpits and datasources for Web Surveys ... check in Business content and more so in help.sap.com ..

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 13, 2005 at 04:16 PM

    Hi!

    you can find survey datasources under RSA5 Root->CRM->0crm_SURVEY. these are some datasources

    0SVY_ANSWER_TEXT CRM Survey: Answers

    0SVY_APPL_TEXT CRM Survey: Applications

    0SVY_DATA_1 CRM Survey: Results

    0SVY_QSTNNR_TEXT CRM Survey: Survey Header

    0SVY_QUEST_TEXT CRM Survey: Questions

    0SVY_STATUS_TEXT CRM Survey: Status of Question

    0SVY_SURV_TEXT CRM Survey: Campaign Texts

    0SVY_TAROBJ_ATTR CRM Survey: Recipient Attributes

    and web survey datasources under PI_BASIS->0CA_SUR

    0WS_ANSWER_TEXT Web Survey: Reply

    0WS_APPL_TEXT Web Survey: Applications

    0WS_KFIGTYP_TEXT Web Survey: Key Figure Types

    0WS_QSTNNR_TEXT Web Survey: Questionnaire

    0WS_QUEST_TEXT Web Survey: Questions

    0WS_STATUS_TEXT Web Survey: Question Status

    0WS_SURVEY_TEXT Web Survey: Survey

    0WS_TAROBJ_ATTR Web Survey: Recipient

    0WS_TAROBJ_TEXT Web Survey: Recipient

    hope it helps

    with regards

    ashwin

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Prasad,

      I am also looking for the configuring the survey. Kindly send me the procedure for configuring the 0SVY_DATA_1 data source. Currently it is giving the error in the crm system in rsa6

      Thanks

      naveen

  • avatar image
    Former Member
    Jul 22, 2005 at 02:40 PM

    Hi David!

    What you will propably see is that the business content for surveys does not allow analysis based on the business partners that are associated to the survey. We use this functionality in CRM3.1 and thought this was a big limitation. A crucial question is of course "who gave what answer on that question?". What you can do to overcome this, is to create a generic datasource based on a view that joins the tables:

    CRMD_ORDERADM_H <-> CRMD_LINK <-> CRMD_SURVEY

    You can also use the CHANGED_AT field for delta capability.

    Kind Regards

    Andreas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 04, 2010 at 10:40 PM

    Hello BW guru,

    I am having the same issues with 0SVY_DATA_1 for CRM 7.0 It seems like the extraction is loading XML translated data and it doesn't make sense. Does any know how to extract CRM Survey Suite data?

    Any help is appreciatedm,

    HarryT

    Add comment
    10|10000 characters needed characters exceeded