In this post, I will try and describe everything you need to know about the SAP crmd_mktobj_val 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_MKTOBJ_VAL 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_MKTOBJ_VAL....Right lets get started!
Object Name: CRMD_MKTOBJ_VAL
Dictionary Type: Transparent table
Description: CRM Marketing: Attribute Characteristics of an Object
| Field | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| MANDT | MANDT | CLNT | 3(0) | T000 | Client | MANDT | TEST | CRM | ||||
| OBJ_GUID | CRMT_MKTSET_OBJ_GUID | RAW | 16(0) | CRM Marketing: Object GUID | SYSUUID | CRM | ||||||
| ATNAM | ATNAM | CHAR | 30(0) | Characteristic Name | ATNAM | FEA | CT | CRM | ||||
| ATZHL | ATZHL | NUMC | 4(0) | Int counter | ATZHL | CT | CRM | |||||
| OBJ_ID | CRMT_MKTOBJ_PARTNER_ID | CHAR | 10(0) | * | CRM Marketing: ID for a Business Partner | BU_PARTNER | CRM | |||||
| ATWRT | ATWRT | CHAR | 30(0) | Characteristic Value | ATWRT | CT | CRM | |||||
| ATFLV | ATFLV | FLTP | 16(16) | Internal floating point from | FLTP | CT | CRM | |||||
| ATFLB | ATFLB | FLTP | 16(16) | Internal floating point value to | FLTP | CT | CRM | |||||
| ATCOD | ATCOD | CHAR | 1(0) | Code for value dependency | ATCOD | CT | CRM | |||||
| OBJ_TYP | CRMT_MKTSET_OBJ_TYPE | CHAR | 30(0) | * | CRM Marketing: Identifier for Object Type | AS4TAB | CRM | |||||
| CREATED_AT | CRMT_MKT_CREATED_AT | DEC | 15(0) | Marketing Object: Creation Date | BCOS_TSTMP | CRM | ||||||
| CREATED_BY | CRMT_MKT_CREATED_BY | CHAR | 12(0) | Marketing Object: Created By User | UNAME | CRM | ||||||
| CHANGED_AT | CRMT_MKT_CHANGED_AT | DEC | 15(0) | Marketing Object: Date of Last Change | BCOS_TSTMP | CRM | ||||||
| CHANGED_BY | CRMT_MKT_CHANGED_BY | CHAR | 12(0) | Marketing Object: Last Changed By | UNAME | CRM | ||||||
| SFAAUSP | SMO_SFAAUS | CHAR | 32(0) | SFA key: Characterization of an object | SMO_GUID | CRM |