The CRMD_OPPORT_H table in SAP ERP or S/4HANA stores Opportunity data. There are total 20 fields in CRMD_OPPORT_H table. The Opportunity 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_OPPORT_H table. It is in CRM Opportunity Header Data (CRM_OPPORT_H) ABAP package and is part of the Opportunities (CRM-BTX-OPP) module.
SAP CRMD_OPPORT_H Table Fields
Following is the list of fields that are available in SAP CRMD_OPPORT_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) | |
| EXP_REVENUE | Expected Sales Revenue | CRMT_REPORT_EXP_REVENUE | CURR (15) | |
| BUDGET_BP | Budget Prospect | CRMT_BUDGET_BP | CURR (15) | |
| STARTDATE | Opportunity Start Date | CRMT_STARTDATE | DATS (8) | |
| EXPECT_END | Expected Closing Date | CRMT_EXPECT_END | DATS (8) | |
| CURR_PHASE | Sales Stage | CRMT_CURR_PHASE | CRMC_PHASE | CHAR (3) |
| PHASE_SINCE | Sales Stage Since | CRMT_PHASE_SINCE | DATS (8) | |
| PROBABILITY | Chance of Success | CRMT_PROBABILITY | NUMC (3) | |
| FORECAST_REL | Forecast Relevance | CRMT_FORECAST_REL | CHAR (1) | |
| SOURCE | Origin of Opportunity/Lead | CRMT_SOURCE | CRMC_SOURCE | CHAR (3) |
| IMPORTANCE | Activity Priority | CRMT_PRIORITY | SCPRIO | NUMC (1) |
| SALESCYCLE | Sales Cycle | CRMT_SALESCYCLE | CRMC_CYCLE | CHAR (5) |
| ADDRESS_NO | Opportunity Address | CRMT_OPP_ADDRESS | * | CHAR (10) |
| TYPE | Opportunity Type | CRMT_OPPORT_TYPE | CRMC_OPPT_TYPE | CHAR (4) |
| STATUS_SINCE | Status Since | CRMT_STATUS_SINCE | DATS (8) | |
| SYS_PROBABILITY | Chance of Success of Opportunity – Calculated by System | CRMT_SYSTEM_PROBABILITY | NUMC (3) | |
| DESCRIPTION_OPP | Opportunity Description | CRMT_DESCRIPTION_OPP | CHAR (40) | |
| DESCR_OPP_UC | Opportunity Description in UC | CRMT_DESCRIPTION_OPP_UC | CHAR (40) | |
| OPPORT_H_DUMMY | Dummy function in length 1 | DUMMY | CHAR (1) |
