where questionnaires are stored?

[Former Member]

Hi experts

Iu2019m working on ROS SRM and Iu2019d like to know where the questionnaires filled in by the vendor, during the registration procedure and during evaluation procedure, are stored.

I knew that they are NOT stored into tables like a normal Shopping Cart, isnu2019t it? But they are transformed into binary files. Howvever iu2019d like to know where they are stored.

Regards

Andrea

[Former Member · Accepted solution]

Hi Andrea,

Please click on the following link to see PDF document explaining all details about Questionnaires.

THe PDF document is Vendor Evaluation. This should explain where data

for questions and answers is stored.

Following are the tables where all the information i.e

questionnaires, layout, answers are stored.

TUWS_DATA

TUWS_DATAT

UXS_DATA

UXS_DATAT

TUWS_FORMSERVICE

TUWS_FORMSERVICT

TUWS_SURVEY

TUWS_SURVEY_LOG

TUWS_SURVEY_PUB

TUWS_SURVEYT

TUWS_TARGETHIER

TUWS_TARGETHIERT

If you need the answers of the questionnaires then you can use BW

extraction (or) you can write own coding using function modules

of the function group UWS_BW_EX_SERVICES.

You can find the following function modules in the above function

group.

UWS_BW_GET_ANSWER_FOR_SURVEY

UWS_BW_GET_DATA_FOR_SURVEY

UWS_BW_GET_QSTNNR_FOR_SURVEY

UWS_BW_GET_QUEST_FOR_SURVEY

UWS_BW_GET_TAROBJ_FOR_SURVEY

UWS_BW_GET_TAR_ATTR_FOR_SURVEY.

The questionnaires are not in fact stored in tables, they are stored in XML's. From here the data is extracted in quite a complicated way.

The data sources are all the OWS_* objects, perhaps these will help

you for further evaluation. You can use RSA3 (Extractor Checker) for a

review of the transfered/extracted data for BW.

Hope this answers your question,

Kind Regards,

Matthew

[pappu_kumar2]

Hi CRM Expert,

Can you tell anyone how to use this FM "UWS_BW_GET_ANSWER_FOR_SURVEY" . i am new of CRM .

So, please tell me about this FM .

My Need.

while filling the survey form, On the form i have long description input box .  in that long description value we are not able to fetch . so please give some helpful input.

Thanks & Regard.

Pappu Kumar

[Former Member]

Sorry I forgot the link

https://sapmats-de.sap-ag.de/download/download.cgi?id=RYDOJFRGFO3KMLTH4VW824DRZ58UKVJSUGSPTPRL1SPUY7...