In this post, I will try and describe everything you need to know about the SAP crmd_mktlist_h 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_MKTLIST_H 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_MKTLIST_H....Right lets get started!
Object Name: CRMD_MKTLIST_H
Dictionary Type: Transparent table
Description: External List - Header
| 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) | T000 | Client | MANDT | TEST | CRM | ||||
| LIST_GUID | CRMT_MKTLIST_LIST_GUID | RAW | 16(0) | CRM Marketing: GUID for an External List | CRM_MKTLIST_LIST_GUID | CRM | ||||||
| LIST_ID | CRMT_MKTLIST_LIST_ID | CHAR | 28(0) | CRM Marketing: ID for External List | CRM_MKTLIST_LIST_ID | CRM | ||||||
| LIST_ID_LOGSYS | CRMT_MKTLIST_LIST_ID_LOGSYS | CHAR | 10(0) | * | CRM Marketing: External List - Logical System for ID | LOGSYS | CRM | |||||
| ORIGIN | CRMT_MKTLIST_ORIGIN | CHAR | 6(0) | CRMC_MKTLIST_O | CRM Marketing: External List - Origin | CRM_MKTLIST_ORIGIN | CRM | |||||
| TYPE | CRMT_MKTLIST_TYPE | CHAR | 2(0) | CRMC_MKTLIST_T | CRM Marketing: External List - Type | CRM_MKTLIST_TYPE | CRM | |||||
| VALID_DATE_TO | CRMT_MKTLIST_VALID_DATE_TO | DATS | 8(0) | CRM Marketing: Recommended End-of-Use Date | CRM_MKTLIST_VALID_DATE_TO | CRM | ||||||
| MAX_USAGE_NO | CRMT_MKTLIST_MAX_USAGE | NUMC | 4(0) | CRM Marketing: Permitted Number of Uses | CRM_MKTLIST_MAX_USAGE | CRM | ||||||
| MAX_USAGE_DATE | CRMT_MKTLIST_USAGE_DATE | DATS | 8(0) | CRM Marketing: Permitted End-of-Use Date | CRM_MKTLIST_USAGE_DATE | CRM | ||||||
| NO_GROSS | CRMT_MKTLIST_NO_GROSS | NUMC | 8(0) | CRM Marketing: External List - Gross Number | CRM_MKTLIST_NO_GROSS | CRM | ||||||
| COSTS | CRMT_MKTLIST_COST | CURR | 15(2) | CRM Marketing: External List - Costs | WERTV8 | CRM | ||||||
| COSTS_CURRENCY | CRMT_MKTLIST_CURRENCY | CUKY | 5(0) | * | CRM Marketing: External List - Currency | WAERS | 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 | ||||||
| DELETED | CRMT_MKTLIST_DELETED | CHAR | 1(0) | CRM Marketing: External List - Deleted - Flag | CRM_MKTLIST_DELETED | CRM | ||||||
| APPL_LOG_ID | BALLOGHNDL | CHAR | 22(0) | Application Log: Log Handle | SYSUUID_22 | CRM |