The CRMD_MKTOBJ_VAL table in SAP ERP or S/4HANA stores CRM Marketing: Attribute Characteristics of an Object data. There are total 15 fields in CRMD_MKTOBJ_VAL table. The CRM Marketing: Attribute Characteristics of an Object table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMD_MKTOBJ_VAL table. It is in CRM Marketing: Marketing Attributes (CRM_MKTATTR) ABAP package and is part of the Segmentation (CRM-MKT-SEG) module.
SAP CRMD_MKTOBJ_VAL Table Fields
Following is the list of fields that are available in SAP CRMD_MKTOBJ_VAL table. The primary key fields of the table are MANDT (Client), OBJ_GUID (CRM Marketing: Object GUID), ATNAM (Characteristic Name), ATZHL (Int counter).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| OBJ_GUID | CRM Marketing: Object GUID | CRMT_MKTSET_OBJ_GUID | RAW (16) | |
| ATNAM | Characteristic Name | ATNAM | CHAR (30) | |
| ATZHL | Int counter | ATZHL | NUMC (4) | |
| OBJ_ID | CRM Marketing: ID for a Business Partner | CRMT_MKTOBJ_PARTNER_ID | CHAR (10) | |
| ATWRT | Characteristic Value | ATWRT | CHAR (70) | |
| ATFLV | Internal floating point from | ATFLV | FLTP (16) | |
| ATFLB | Internal floating point value to | ATFLB | FLTP (16) | |
| ATCOD | Code for value dependency | ATCOD | CHAR (1) | |
| OBJ_TYP | CRM Marketing: Identifier for Object Type | CRMT_MKTSET_OBJ_TYPE | CHAR (30) | |
| CREATED_AT | Marketing Object: Creation Date | CRMT_MKT_CREATED_AT | DEC (15) | |
| CREATED_BY | Marketing Object: Created By User | CRMT_MKT_CREATED_BY | CHAR (12) | |
| CHANGED_AT | Marketing Object: Date of Last Change | CRMT_MKT_CHANGED_AT | DEC (15) | |
| CHANGED_BY | Marketing Object: Last Changed By | CRMT_MKT_CHANGED_BY | CHAR (12) | |
| SFAAUSP | Character field, length 32 | CHAR32 | CHAR (32) |
