In this post, I will try and describe everything you need to know about the SAP crmd_mktru_svy table. What it is, including what type of data it stores.
A list of fields which make up the table structure and on an S/4Hana System for CRMD_MKTRU_SVY what does this table look like.
And what relationships it has with other SAP tables.
Also see here for example ABAP code to select data from CRMD_MKTRU_SVY....Right lets get started!
Object Name: CRMD_MKTRU_SVY
Dictionary Type: Transparent table
Description: Assignment Business Partner / Surveys
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CLIENT | MANDT | CLNT | 3(0) | * | Client | MANDT | TEST | CRM | ||||
| BP_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| CP_GUID | BU_PARTNER_GUID | RAW | 16(0) | Business Partner GUID | SYSUUID | CRM | ||||||
| SVY_ID | CRM_SVY_DB_SID | CHAR | 32(0) | CRM Surveys: Survey ID | CHAR32 | CRM_SVY_DB_SID | CRM | |||||
| SVY_VERSION | CRM_SVY_DB_SVERS | NUMC | 10(0) | CRM Surveys: Survey Version | NUMC10 | CRM | ||||||
| SVY_VAL_GUID | CRM_SVY_DB_SV_GUID | CHAR | 32(0) | CRM Surveys: Survey Values GUID | CHAR32 | CRM | ||||||
| SVY_VAL_VERSION | CRM_SVY_DB_SV_VERS | NUMC | 10(0) | CRM Surveys: Survey Values Version | NUMC10 | CRM | ||||||
| CREAT_MODIF_AT | CTMT_MKTRU_SVY_VAL_TSTAMP | DEC | 15(0) | Time Create/Last Change of Completed Survey | CRM_SVY_DB_TIMESTAMP | CRM | ||||||
| PROJECT_GUID | CGPL_PROJECT_GUID | RAW | 16(0) | Project Planning: 16 Character GUID for Projects | CGPL_PROJECT_GUID | CRM | ||||||
| TASK_GUID | CGPL_TASK_GUID | RAW | 16(0) | Project Planning: 16 Character GUID for Tasks | CGPL_PROJECT_GUID | CRM | ||||||
| ORDER_GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM |