SAP ABAP Table CRM_SVY_RE_ALV (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure CRM_SVY_RE_ALV   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 CLIENT_S MANDT MANDT CLNT 3   0   Client T000
2 SURVEYID_S CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID  
3 SURVEYVERSION_S CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version  
4 MASTERLANGUAGE LANGU SPRAS LANG 1   0   Language Key T002
5 SUPPORTQUERIES CRM_SVY_DB_SUPPORTQUERIES BOOLEAN CHAR 1   0   Flag: Simple Evaluation of Surveys  
6 SUPPORTBW CRM_SVY_DB_SUPPORTBW BOOLEAN CHAR 1   0   Flag: Evaluation of Surveys in Business Warehouse  
7 CLIENT_SVS MANDT MANDT CLNT 3   0   Client T000
8 VALUEGUID_SVS CRM_SVY_DB_SV_GUID CHAR32 CHAR 32   0   CRM Surveys: Survey Values GUID  
9 VALUEVERSION_SVS CRM_SVY_DB_SV_VERS NUMC10 NUMC 10   0   CRM Surveys: Survey Values Version  
10 STATUS CRM_SVY_DB_SVS_STATUS CRM_SVY_DB_SVS_STATUS CHAR 1   0   CRM Surveys: Survey Values Status  
11 SURVEYID_SVS CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID  
12 SURVEYVERSION_SV CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version  
13 CLIENT_QSTN MANDT MANDT CLNT 3   0   Client  
14 LANGUAGE_QSTN LANGU SPRAS LANG 1   0   Language Key  
15 APPLICATION_QSTN CRM_SVY_RE_BW_APPL   CHAR 8   0   CRM Survey: BW Application  
16 SURVEY_QSTN CRM_SVY_RE_SURVEY   CHAR 20   0   CRM Survey: BW Survey (Not Filled by CRM Survey)  
17 QSTNNR_QSTN CRM_SVY_RE_QSTNNR   CHAR 10   0   CRM Survey: Questionnaire  
18 TXTLG_QSTN CRM_SVY_RE_TXTLG   CHAR 60   0   CRM Survey: Long Description  
19 SURVEY_ID_QSTN CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID CRM_SVY_DB_S
20 SURVEY_VERSION_Q CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version CRM_SVY_DB_S
21 CLIENT_QUES MANDT MANDT CLNT 3   0   Client  
22 LANGUAGE_QUES LANGU SPRAS LANG 1   0   Language Key  
23 APPLICATION_QUES CRM_SVY_RE_BW_APPL   CHAR 8   0   CRM Survey: BW Application  
24 SURVEY_QUES CRM_SVY_RE_SURVEY   CHAR 20   0   CRM Survey: BW Survey (Not Filled by CRM Survey)  
25 QSTNNR_QUES CRM_SVY_RE_QSTNNR   CHAR 10   0   CRM Survey: Questionnaire  
26 CONSNR CRM_SVY_RE_CONSNR   NUMC 5   0   CRM Survey: Sequence Number for Questions  
27 QUEST_QUES CRM_SVY_RE_BW_QUEST   CHAR 32   0   Question  
28 TXTLG_QUES CRM_SVY_RE_TXTLG   CHAR 60   0   CRM Survey: Long Description  
29 SURVEY_ID_QUES CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID CRM_SVY_DB_S
30 SURVEY_VERSION_F CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version CRM_SVY_DB_S
31 CLIENT_ANSW MANDT MANDT CLNT 3   0   Client  
32 LANGUAGE_ANSW LANGU SPRAS LANG 1   0   Language Key  
33 APPLICATION_ANSW CRM_SVY_RE_BW_APPL   CHAR 8   0   CRM Survey: BW Application  
34 SURVEY_ANSW CRM_SVY_RE_SURVEY   CHAR 20   0   CRM Survey: BW Survey (Not Filled by CRM Survey)  
35 QSTNNR_ANSW CRM_SVY_RE_QSTNNR   CHAR 10   0   CRM Survey: Questionnaire  
36 QUEST_ANSW CRM_SVY_RE_BW_QUEST   CHAR 32   0   Question  
37 ANSWER CRM_SVY_RE_BW_ANSWER   CHAR 6   0   Answer Option  
38 TXTLG_ANSW CRM_SVY_RE_TXTLG   CHAR 60   0   CRM Survey: Long Description  
39 SURVEY_ID_ANSW CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID CRM_SVY_DB_S
40 SURVEY_VERSION_A CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version CRM_SVY_DB_S
41 QUEST_ID CRM_SVY_RE_QUEST_ID   CHAR 64   0   CRM Survey: Question ID  
42 ANSWER_ID CRM_SVY_RE_ANSWER_ID   CHAR 64   0   CRM Survey: Answer ID  
43 CLIENT_SV MANDT MANDT CLNT 3   0   Client T000
44 VALUEGUID_SV CRM_SVY_DB_SV_GUID CHAR32 CHAR 32   0   CRM Surveys: Survey Values GUID CRM_SVY_DB_SVS
45 VALUEVERSION_SV CRM_SVY_DB_SV_VERS NUMC10 NUMC 10   0   CRM Surveys: Survey Values Version  
46 NAME CRM_SVY_DB_SV_NAME TEXT128 CHAR 128   0   CRM Surveys: Survey Value Key Attribute  
47 INDX NUMC3 NUMC3 NUMC 3   0   Numc3, internal use  
48 VALUE CRM_SVY_DB_SV_VALUE TEXT255 CHAR 255   0   CRM Surveys: Survey Value Attribute  
49 XML CRM_SVY_DB_SVS_XML   RSTR 0   0   CRM Surveys: Survey Values Binary Long Object  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRM_SVY_RE_ALV CLIENT_S T000 MANDT KEY    
2 CRM_SVY_RE_ALV CLIENT_SV T000 MANDT KEY    
3 CRM_SVY_RE_ALV CLIENT_SVS T000 MANDT KEY    
4 CRM_SVY_RE_ALV MASTERLANGUAGE T002 SPRAS REF 1 CN
5 CRM_SVY_RE_ALV SURVEY_ID_ANSW CRM_SVY_DB_S SURVEYID    
6 CRM_SVY_RE_ALV SURVEY_ID_QSTN CRM_SVY_DB_S SURVEYID    
7 CRM_SVY_RE_ALV SURVEY_ID_QUES CRM_SVY_DB_S SURVEYID    
8 CRM_SVY_RE_ALV SURVEY_VERSION_A CRM_SVY_DB_S SURVEYVERSION    
9 CRM_SVY_RE_ALV SURVEY_VERSION_F CRM_SVY_DB_S SURVEYVERSION    
10 CRM_SVY_RE_ALV SURVEY_VERSION_Q CRM_SVY_DB_S SURVEYVERSION    
11 CRM_SVY_RE_ALV VALUEGUID_SV CRM_SVY_DB_SVS CLIENT    
History
Last changed by/on SAP  20130604 
SAP Release Created in