The CRMD_LEAD_H table in SAP ERP or S/4HANA stores Lead data. There are total 10 fields in CRMD_LEAD_H table. The Lead 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_LEAD_H table. It is in CRM Lead: Header Data (CRM_LEAD_H) ABAP package and is part of the Lead Management (CRM-BTX-LEA) module.
SAP CRMD_LEAD_H Table Fields
Following is the list of fields that are available in SAP CRMD_LEAD_H table. The primary key fields of the table are CLIENT (Client), GUID (GUID of a CRM Order Object).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| SOURCE | Origin of Opportunity/Lead | CRMT_SOURCE | CRMC_SOURCE | CHAR (3) |
| IMPORTANCE | Activity Priority | CRMT_PRIORITY | SCPRIO | NUMC (1) |
| LEAD_TYPE | Lead Group | CRMT_LEAD_TYPE | CRMC_LEAD_TYPE | CHAR (4) |
| STATUS_SINCE | Status Since | CRMT_STATUS_SINCE | DATS (8) | |
| QUAL_LEVEL_MAN | Lead Qualification Level | CRMT_LEAD_QUAL_LEVEL_MAN | CRMC_LEAD_QL | CHAR (2) |
| QUAL_LEVEL_AUTO | Lead Qualification Level (Automatic) | CRMT_LEAD_QUAL_LEVEL_AUTO | CRMC_LEAD_QL | CHAR (2) |
| QUAL_LEVEL_SVY | Questionnaire that Q-Level Sets (Automatically) | CRMT_LEAD_QUAL_LEVEL_AUTO_SVY | CHAR (32) | |
| LEAD_H_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) |
