Read CRM Survey question and answers

[Former Member]

Hi,

I have a requirement, where-in I need to read the Survey question and answers.

I am able to read the order data using CRMD_ORDER_READ and able to retrieve the xml id from the table CRM_SVY_DB_SVS. But unable to go further and retrieve the Survey data in text format.

Any suggestion would be of great help and I promise to reward all the helpful answers.

Thanks in advance,

Shankar.

[Former Member]

Hi Shankar-san

When I had a same inquiry, I used class 'cl_crm_svy_survey_texts' like below.

data:

imp_guid type CRMT_OBJECT_GUID

v_valueg TYPE crmd_survey-valueguid,

i_surveyt TYPE REF TO cl_crm_svy_survey_texts.

SELECT SINGLE s~valueguid

FROM crmd_orderadm_h AS h

JOIN crmd_link AS l

ON h_{guid = l}guid_hi

JOIN crmd_survey AS s

ON l_{guid_set = s}set_guid

INTO v_valueg

WHERE h~guid = imp_guid.

CREATE OBJECT i_surveyt

EXPORTING

i_valueguid = v_valueg

EXCEPTIONS

survey_not_found = 1

values_not_found = 2

OTHERS = 3.