In this post, I will try and describe everything you need to know about the SAP crmd_lead_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_LEAD_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_LEAD_H....Right lets get started!
Object Name: CRMD_LEAD_H
Dictionary Type: Transparent table
Description: Lead
| 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 | ||||
| GUID | CRMT_OBJECT_GUID | RAW | 16(0) | GUID of a CRM Order Object | SYSUUID | CRM | ||||||
| SOURCE | CRMT_SOURCE | CHAR | 3(0) | CRMC_SOURCE | Origin of Opportunity/Lead | CRM_SOURCE | CRM | |||||
| IMPORTANCE | CRMT_IMPORTANCE | CHAR | 1(0) | CRMC_OPPIMPOR | Opportunity/Lead Priority | CRM_IMPORTANCE | CRM | |||||
| LEAD_TYPE | CRMT_LEAD_TYPE | CHAR | 4(0) | CRMC_LEAD_TYPE | Lead Group | CRM_LEAD_TYPE | CRM | |||||
| STATUS_SINCE | CRMT_STATUS_SINCE | DATS | 8(0) | Status Since | DATUM | CRM | ||||||
| QUAL_LEVEL_MAN | CRMT_LEAD_QUAL_LEVEL_MAN | CHAR | 2(0) | CRMC_LEAD_QL | Lead Qualification Level | CRM_LEAD_QUAL_LEVEL | CRM | |||||
| QUAL_LEVEL_AUTO | CRMT_LEAD_QUAL_LEVEL_AUTO | CHAR | 2(0) | CRMC_LEAD_QL | Lead Qualification Level (Automatic) | CRM_LEAD_QUAL_LEVEL | CRM | |||||
| QUAL_LEVEL_SVY | CRMT_LEAD_QUAL_LEVEL_AUTO_SVY | CHAR | 32(0) | Questionnaire that Q-Level Sets (Automatically) | CHAR32 | CRM |