Questionnaire Fields in CRMD_ORDER Transaction

[former_member184632]

Hi Friends,

I am new to CRM, I have a requirement that I need to show the Opportunity report and in CRMD_ORDER Transaction I went to Business Transaction in menu and I created a opportunity-Inst, In that there is a tab named "ASSESSMENTS Tab" is having Questionnaire fields and I need to fetch the project card questionnaire fields such as "Type of project", "Nature of project","Stage of project " and "no of structures" and i found that it is been saved in table CRM_SVY_DB_SVS under Field "XML" ..... Am I correct in finding the table or else these questionnaire fields are stored in some other tables????

Thanks & Regards,

Vishall

[Former Member]

Hi try to search for CRM_SVY* or CRMD_SURVEY, CRM_SVY_RE_QSTNR

CRM_SVY_RE_QUEST in se11 transaction maybe there you will find something.

[robert_kunstelj]

You can use the folowing steps to get survey values...

- read survey data with fm 'CRM_SURVEY_READ_OW'

- create survey object with 'lo_survey_texts'

- get values with method 'lo_survey_texts->get_all_values'

[former_member184632]

Hi Robert ,

Thanks for your reply ..... From your response whether I can confirm that the questionnaire fields are stored in table CRM_SVY_DB_SVS under field "XML".

Thanks ,

Vishall

[robert_kunstelj]

Probably, but I'm not sure because I never read it directly from table. You can just use CL_CRM_SVY_SURVEY_TEXTS=>GET_ALL_TEXTS, which is much simplier.