Supplier Registration Table

[former_member463021]

Hello,

We have created our own questionnaires at IMG SRM + Supplier Registration + Basic Settings + Create / Change Questionnaire.

Where are loaded this data in SRM?. Which tables?.

Thanks

[former_member463021]

Thank you,

Ive actived this infocube 0WS_C01 (Web Survey) and i've loaded transactional data with 0WS_DATA_1 datasource, but when i load text or attributes 0 records have extracted selecting WebSurvey Application.

Which is the transaction for customizing those text and attributes?.

Thanks in advance.

[former_member463021]

Hi,

I'd like to know this tables because I need to extract the results of this questionnarie to BW, i think that there aren't any standar infocube so i'll do a generic datasource. Then it is neccesary to find where the questionarie and vendor answer has been loaded, which tables.

Thanks a lot.

[Ramki]

Hi Pedro

Yo should have told about this early...

We do have standard extractions..

FOund from RSA5:

0CA_SUR Web Survey

0CA_SUR-IO Web Survey Master Data

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

0WS_DATA_1 Web Survey: Survey Results

We can get the extract structures by searching in SE11: UWS_S_BW*

Best regards

Ramki

[former_member1313287]

Hi Guys

How do I use these standard extractions to transfer questionaire data to SRM classification tables. Do I actually have to access actual tables to do this? If so, which table(s) do these extractions point to.

[former_member463021]

Hi again.

I was checking this tables, but they have data about questionnarie implementation (aplication, id questionnarie ...).

But when the vendor recieves an email with this questionnarie, he fill it and send it to Srm, Which tables contain the vendor answer? .

Thanks

[Former Member]

Hi,

See if the foll FM's help:

ROS_GET_ANSWER_FOR_SURVEY

ROS_GET_DATA_FOR_SURVEY

OS_READ_SURVEY_DATA

OS_READ_SURVEY_ENTRIES

BR,

Disha.

Pls reward points for useful answers.

[Former Member]

Hi

Are you not getting the data in the tables, I mentioned in the earlier post ?

What is the requirement ? why you need to know table names ?

Anyways, try these tables out ->

<u><b>Table Description</b></u>

ROST_LANG_QSTN   -> Language Selection for Question
ROST_PCAT_QSTN   -> Assign Product Category and Questionnaire to Lan
ROST_SEL_PRODCAT -> Product Categories for Regis
ROST_WS_QSTN     -> WebSurvey Questionnai
ROS_BP_PC_SURVEY -> Assign Vendor, Product Category, Survey
CRMD_IC_SCRATTR      Script/Survey attributes (Interactive Script Editor)
ROST_WS_QSTN         WebSurvey Questionnaire                             
ROS_BP_PC_SURVEY     Assign Vendor, Product Category, Survey             
TUWS_SURVEY          Survey                                              
TUWS_SURVEY_LOG      Survey Log                                          
TUWS_SURVEY_PUB      Survey Publishing                                   
TUWS_TAROBJ          Survey: Recipients                                  
TUWS_TAROBJ_ATTR     Survey: Recipient Attributes                       

Hope this will help.

Please reward suitable points.

Regards

- Atul

[Former Member]

Hi

<b>Please refer to following SRM Tables</b>

Table Name           Short text                                                                                
TUWS_DATA            XML Data                                                       
TUWS_DATAT           Descriptions to TUWS_DATA                                      
TUWS_FORMSERVICE     XML Data                                                       
TUWS_FORMSERVICT     Descriptions to TUWS_FORMSERVICE                               
TUWS_LDAPKEY         Assignment LDAP Server <-> Technical Key and Variant           
TUWS_LDAPKEYLANG     Language Table for TUWS_LDAPKEY                                
TUWS_LDAPVARIANT     LDAP Server Parameter Variants                                 
TUWS_LDAPVARLANG     Language Table for TUWS_LDAPVARIANT                            
TUWS_SURVEY          Survey                                                         
TUWS_SURVEYT         Descriptions for TUWS_SURVEY                                   
TUWS_SURVEY_LOG      Survey Log                                                     
TUWS_SURVEY_PUB      Survey Publishing                                              
TUWS_TARGETHIER      XML Data                                                       
TUWS_TARGETHIERT     Descriptions for TUWS_TARGETHIER                               
TUWS_TAROBJ          Survey: Recipients                                             
TUWS_TAROBJ_ATTR     Survey: Recipient Attributes   

Hope this will help.

Please reward suitable points.

Regards

- Atul

[former_member195032]

Hi Pedro,

Please look at tables.

ROST_LANG_QSTN:Language Selection for Questionnaires

ROST_PCAT_QSTN :Assign Product Category and Questionnaire to Languages

ROST_SEL_PRODCAT:n Product Categories for Registr

ROSV_PCAT_QSTN:Assign Product Category and Questionnaire to Languages

regards,Nishant

Please reward points if this helps

[former_member463021]

Hi again,

I'd like to know when the vendor fill the questionnaire where his answers are loaded, so this results could be extracted to BW.

I checked this tables but i think that it is only questionnaire customizing.

Thanks a lot.