SAP ABAP Table CRM_SVY_DB_S_QUERY (CRM Surveys: Survey)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BF-SVY (Application Component) Survey Suite
     ⤷ CRM_SVY_DB (Package) Database Interface for CRM Surveys
Basic Data
Table Category INTTAB    Structure 
Structure CRM_SVY_DB_S_QUERY   Table Relationship Diagram
Short Description CRM Surveys: Survey    
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 .INCLUDE       0   0   CRM Surveys: Survey  
2 CLIENT MANDT MANDT CLNT 3   0   Client T000
3 SURVEYID CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID  
4 SURVEYVERSION CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version  
5 .INCLUDE       0   0   CRM Surveys: Survey  
6 SURVEYGUID CRM_SVY_DB_SGUID CHAR32 CHAR 32   0   CRM Surveys: Survey GUID  
7 MASTERLANGUAGE LANGU SPRAS LANG 1   0   Language Key T002
8 .INCLUDE       0   0   CRM Surveys: Survey Attributes (Defaults from CRM_SVY_DB_SA)  
9 PERSISTVALUES CRM_SVY_DB_PERSISTVALUES BOOLEAN CHAR 1   0   Flag: Save Completed Questionnaires  
10 SUPPORTQUERIES CRM_SVY_DB_SUPPORTQUERIES BOOLEAN CHAR 1   0   Flag: Simple Evaluation of Surveys  
11 SUPPORTBW CRM_SVY_DB_SUPPORTBW BOOLEAN CHAR 1   0   Flag: Evaluation of Surveys in Business Warehouse  
12 VALUESVERSIONING CRM_SVY_DB_VALUESVERSIONING BOOLEAN CHAR 1   0   Flag: Create Versions of Completed Questionnaires  
13 VALUESDELETES CRM_SVY_DB_VALUESDELETES BOOLEAN CHAR 1   0   Flag: Deletion of Survey (Answers)  
14 VALUESUPDATES CRM_SVY_DB_VALUESUPDATES BOOLEAN CHAR 1   0   Flag: Completed Questionnaires Can Be Changed Later  
15 CALLBACKPBO CRM_SVY_DB_CALLBACK FUNCNAME CHAR 30   0   CRM Surveys: Callback Specification *
16 CALLBACKPAI CRM_SVY_DB_CALLBACK FUNCNAME CHAR 30   0   CRM Surveys: Callback Specification *
17 PUBLIC_SVY CRM_SVY_DB_PUBLIC BOOLEAN CHAR 1   0   Flag: Public Survey  
18 VALIDFROM CRM_SVY_DB_VALIDFROM CRM_SVY_DB_TIMESTAMP DEC 15   0   CRM Surveys: Survey Valid From Date  
19 VALIDTO CRM_SVY_DB_VALIDTO CRM_SVY_DB_TIMESTAMP DEC 15   0   CRM Surveys: Survey Valid To Date  
20 SCHEMAVERSION CRM_SVY_DB_SSC_VERSID CRM_SVY_DB_SSC_VERSID NUMC 10   0   CRM Surveys: Version Number of Survey Schema  
21 APPLICATIONID CRM_SVY_DB_APPL_ID CRM_SVY_DB_APPL_ID CHAR 32   0   CRM Surveys: Application CRM_SVY_DB_SA
22 TESTVALUEGUID CRM_SVY_DB_SV_GUID CHAR32 CHAR 32   0   CRM Surveys: Survey Values GUID  
23 TESTVALUEVERSION CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version  
24 TESTPASSED CRM_SVY_DB_TEST_PASSED BOOLEAN CHAR 1   0   Flag: Submit Test Ran Correctly  
25 CREATED_AT CRM_SVY_DB_CRTSTAMP CRM_SVY_DB_TIMESTAMP DEC 15   0   CRM Surveys: Creation Date  
26 CREATED_BY STAT_FUSER UNAME CHAR 12   0   Created By  
27 MODIFIED_AT CRM_SVY_DB_MODTSTAMP CRM_SVY_DB_TIMESTAMP DEC 15   0   CRM Surveys: Change Date  
28 MODIFIED_BY STAT_LUSER UNAME CHAR 12   0   Changed by  
29 LANGUAGE LANGU SPRAS LANG 1   0   Language Key *
30 SOURCELANGUAGE LANGU SPRAS LANG 1   0   Language Key *
31 STATUS CRM_SVY_DB_SD_STATUS CRM_SVY_DB_SD_STATUS CHAR 1   0   CRM Surveys: Translation Status  
32 .INCLUDE       0   0   CRM Surveys: References to a Survey Translation  
33 T_VALUEGUID CRM_SVY_DB_SV_GUID CHAR32 CHAR 32   0   CRM Surveys: Survey Values GUID  
34 T_VALUEVERSION CRM_SVY_DB_SV_VERS NUMC10 NUMC 10   0   CRM Surveys: Survey Values Version  
35 T_SURVEYID CRM_SVY_DB_SID CHAR32 CHAR 32   0   CRM Surveys: Survey ID  
36 T_SURVEYVERSION CRM_SVY_DB_SVERS NUMC10 NUMC 10   0   CRM Surveys: Survey Version  
37 .INCLUDE       0   0   CRM Surveys: Description (Short and Long)  
38 DESC_SHORT CRM_SVY_DB_SD_SHORT TEXT45 CHAR 45   0   CRM Surveys: Short Description  
39 DESC_LONG CRM_SVY_DB_SD_LONG TEXT128 CHAR 128   0   CRM Surveys: Description  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRM_SVY_DB_S_QUERY APPLICATIONID CRM_SVY_DB_SA APPLICATIONID REF 1 CN
2 CRM_SVY_DB_S_QUERY CLIENT T000 MANDT KEY    
3 CRM_SVY_DB_S_QUERY MASTERLANGUAGE T002 SPRAS REF 1 CN
History
Last changed by/on SAP  20131122 
SAP Release Created in 310