CRMD_OPPORT_H - Opportunity

Opportunity information is stored in SAP table CRMD_OPPORT_H.
It is part of development package CRM_OPPORT_H in software component CRM-BTX-OPP. This development package consists of objects that can be grouped under "CRM Opportunity Header Data".

Fields for table CRMD_OPPORT_H

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMT_OBJECT_KEY	0
CLIENT	Client	X	MANDT	CLNT	6	*
GUID	GUID of a CRM Order Object	X	CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMT_OPPORT_H_EXT	0
EXP_REVENUE	Expected Sales Revenue		CRMT_REPORT_EXP_REVENUE	CURR	8
BUDGET_BP	Budget Prospect		CRMT_BUDGET_BP	CURR	8
STARTDATE	Opportunity Start Date		CRMT_STARTDATE	DATS	16
EXPECT_END	Expected Closing Date		CRMT_EXPECT_END	DATS	16
CURR_PHASE	Sales Stage		CRMT_CURR_PHASE	CHAR	6	CRMC_PHASE
PHASE_SINCE	Sales Stage Since		CRMT_PHASE_SINCE	DATS	16
PROBABILITY	Chance of Success		CRMT_PROBABILITY	NUMC	6
FORECAST_REL	Forecast Relevance		CRMT_FORECAST_REL	CHAR	2
SOURCE	Origin of Opportunity/Lead		CRMT_SOURCE	CHAR	6	CRMC_SOURCE
IMPORTANCE	Activity Priority		CRMT_PRIORITY	NUMC	2	SCPRIO
SALESCYCLE	Sales Cycle		CRMT_SALESCYCLE	CHAR	10	CRMC_CYCLE
ADDRESS_NO	Opportunity Address		CRMT_OPP_ADDRESS	CHAR	20	*
TYPE	Opportunity Type		CRMT_OPPORT_TYPE	CHAR	8	CRMC_OPPT_TYPE
STATUS_SINCE	Status Since		CRMT_STATUS_SINCE	DATS	16
SYS_PROBABILITY	Chance of Success of Opportunity - Calculated by System		CRMT_SYSTEM_PROBABILITY	NUMC	6
DESCRIPTION_OPP	Opportunity Description		CRMT_DESCRIPTION_OPP	CHAR	80
DESCR_OPP_UC	Opportunity Description in UC		CRMT_DESCRIPTION_OPP_UC	CHAR	80
CUSTOMER_STATUS	OBSOLETE			CHAR	8
.INCLUDE				INCL_EEW_OPPORT_H	0
OPPORT_H_DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				CI_EEW_OPPORT_H	0