In this post, I will try and describe everything you need to know about the SAP crmd_mktca_usopt 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_MKTCA_USOPT 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_MKTCA_USOPT....Right lets get started!
Object Name: CRMD_MKTCA_USOPT
Dictionary Type: Transparent table
Description: User Settings Campaign Automation
| 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 | ||||
| OPTUSER | SYUNAME | CHAR | 12(0) | User Name | SYCHAR12 | SYST | CRM | |||||
| ALIGNEDWITHGRID | CHAR | 10(0) | CRM | |||||||||
| GRIDVISIBILITY | CHAR | 10(0) | CRM | |||||||||
| GRIDLINESPACING | CHAR | 10(0) | CRM | |||||||||
| GRIDLINECOLOR | CHAR | 10(0) | CRM | |||||||||
| COLORELEMENTREL | CHAR | 10(0) | CRM | |||||||||
| COLORGRAPHNORMAL | CHAR | 10(0) | CRM | |||||||||
| COLORGRAPHLOCKED | CHAR | 10(0) | CRM | |||||||||
| COLGRAPHWORKLIST | CHAR | 10(0) | CRM | |||||||||
| COLORELEMENT00 | CHAR | 10(0) | CRM | |||||||||
| COLORELEMENT01 | CHAR | 10(0) | CRM | |||||||||
| COLORELEMENT02 | CHAR | 10(0) | CRM | |||||||||
| COLORELEMENT03 | CHAR | 10(0) | CRM | |||||||||
| COLELEM00BORDER | CHAR | 10(0) | CRM | |||||||||
| COLELEM01BORDER | CHAR | 10(0) | CRM | |||||||||
| COLELEM02BORDER | CHAR | 10(0) | CRM | |||||||||
| COLELEM03BORDER | CHAR | 10(0) | CRM | |||||||||
| SHOWCOUNTERS | CHAR | 10(0) | CRM | |||||||||
| COUNTERSPACING | CHAR | 10(0) | CRM | |||||||||
| COUNTEROFFSET | CHAR | 10(0) | CRM | |||||||||
| COUNTERTYPE | CHAR | 10(0) | CRM |