cancel
Showing results for 
Search instead for 
Did you mean: 

Questionnaire in SAP CRM - Opportunity transaction

saumya_govil
Active Contributor
0 Kudos

Hi Experts,

Questionnaires are configured in SAP CRM and linked to a transaction type in CRM.

I need to check where / in which table, the details of the questionnaire are stored in SAP CRM?

Is there any unique ID that gets generated for every questionnaire that is configured in SAP CRM( Could be an ID for a questionnaire or an ID for each question in a Questionnaire)?

In case the user answers the questions, where are the answers stored?

Any help regarding the table details would be highly appreciated.

Regards,

Saumya

View Entire Topic
former_member200342
Active Contributor
0 Kudos

Hi Saumya,

You are right.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.

Regards,

PePe

saumya_govil
Active Contributor
0 Kudos

Thanks PePe for the prompt reply!

Just had one query, would these tables help me to get the answers entered by the user for the questionnaire?

I need a way to get the answers entered for a particular questionnaire for a particular opportunity GUID.

Please clarify my doubt!

Regards,

Saumya

former_member200342
Active Contributor
0 Kudos

Hi,

Yes,these tables can get the answers entered by the user for the questionnaire.

First from CRM_ORDER_READ ---> ET_SURVEY...u can get the answer id for a particular opportunity.

Then from the tables u can pass this values and match it with resp answer id and u will get the exact answer.

Regards,

PePe