SAP ABAP Table CRM_SVY_DB_S (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 | TRANSP | Transparent table |
| Transparent table | CRM_SVY_DB_S |
|
| Short Description | CRM Surveys: Survey |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | E | Control table, SAP and customer have separate key areas |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
CRM_SVY_DB_SID | CHAR32 | CHAR | 32 | 0 | CRM Surveys: Survey ID | ||
| 3 | |
CRM_SVY_DB_SVERS | NUMC10 | NUMC | 10 | 0 | CRM Surveys: Survey Version | ||
| 4 | |
0 | 0 | CRM Surveys: Survey | |||||
| 5 | |
CRM_SVY_DB_SGUID | CHAR32 | CHAR | 32 | 0 | CRM Surveys: Survey GUID | ||
| 6 | |
LANGU | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
| 7 | |
0 | 0 | CRM Surveys: Survey Attributes (Defaults from CRM_SVY_DB_SA) | |||||
| 8 | |
CRM_SVY_DB_PERSISTVALUES | BOOLEAN | CHAR | 1 | 0 | Flag: Save Completed Questionnaires | ||
| 9 | |
CRM_SVY_DB_SUPPORTQUERIES | BOOLEAN | CHAR | 1 | 0 | Flag: Simple Evaluation of Surveys | ||
| 10 | |
CRM_SVY_DB_SUPPORTBW | BOOLEAN | CHAR | 1 | 0 | Flag: Evaluation of Surveys in Business Warehouse | ||
| 11 | |
CRM_SVY_DB_VALUESVERSIONING | BOOLEAN | CHAR | 1 | 0 | Flag: Create Versions of Completed Questionnaires | ||
| 12 | |
CRM_SVY_DB_VALUESDELETES | BOOLEAN | CHAR | 1 | 0 | Flag: Deletion of Survey (Answers) | ||
| 13 | |
CRM_SVY_DB_VALUESUPDATES | BOOLEAN | CHAR | 1 | 0 | Flag: Completed Questionnaires Can Be Changed Later | ||
| 14 | |
CRM_SVY_DB_CALLBACK | FUNCNAME | CHAR | 30 | 0 | CRM Surveys: Callback Specification | * | |
| 15 | |
CRM_SVY_DB_CALLBACK | FUNCNAME | CHAR | 30 | 0 | CRM Surveys: Callback Specification | * | |
| 16 | |
CRM_SVY_DB_PUBLIC | BOOLEAN | CHAR | 1 | 0 | Flag: Public Survey | ||
| 17 | |
CRM_SVY_DB_VALIDFROM | CRM_SVY_DB_TIMESTAMP | DEC | 15 | 0 | CRM Surveys: Survey Valid From Date | ||
| 18 | |
CRM_SVY_DB_VALIDTO | CRM_SVY_DB_TIMESTAMP | DEC | 15 | 0 | CRM Surveys: Survey Valid To Date | ||
| 19 | |
CRM_SVY_DB_SSC_VERSID | CRM_SVY_DB_SSC_VERSID | NUMC | 10 | 0 | CRM Surveys: Version Number of Survey Schema | ||
| 20 | |
CRM_SVY_DB_APPL_ID | CRM_SVY_DB_APPL_ID | CHAR | 32 | 0 | CRM Surveys: Application | CRM_SVY_DB_SA | |
| 21 | |
CRM_SVY_DB_SV_GUID | CHAR32 | CHAR | 32 | 0 | CRM Surveys: Survey Values GUID | ||
| 22 | |
CRM_SVY_DB_SVERS | NUMC10 | NUMC | 10 | 0 | CRM Surveys: Survey Version | ||
| 23 | |
CRM_SVY_DB_TEST_PASSED | BOOLEAN | CHAR | 1 | 0 | Flag: Submit Test Ran Correctly | ||
| 24 | |
CRM_SVY_DB_CRTSTAMP | CRM_SVY_DB_TIMESTAMP | DEC | 15 | 0 | CRM Surveys: Creation Date | ||
| 25 | |
STAT_FUSER | UNAME | CHAR | 12 | 0 | Created By | ||
| 26 | |
CRM_SVY_DB_MODTSTAMP | CRM_SVY_DB_TIMESTAMP | DEC | 15 | 0 | CRM Surveys: Change Date | ||
| 27 | |
STAT_LUSER | UNAME | CHAR | 12 | 0 | Changed by |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | CRM_SVY_DB_S | APPLICATIONID | |
|
REF | 1 | CN |
| 2 | CRM_SVY_DB_S | CLIENT | |
|
KEY | ||
| 3 | CRM_SVY_DB_S | MASTERLANGUAGE | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20131122 |
| SAP Release Created in |