SAP Table CRMD_OPPORT_H stores Opportunitydata

  

In this post, I will try and describe everything you need to know about the SAP crmd_opport_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_OPPORT_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_OPPORT_H....Right lets get started!


SAP CRMD_OPPORT_H dictionary attributes

Object Name: CRMD_OPPORT_H
Dictionary Type: Transparent table
Description: Opportunity


CRMD_OPPORT_H field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
EXP_REVENUECRMT_REPORT_EXP_REVENUECURR15(2) Expected Sales RevenueWERTV8CRM
BUDGET_BPCRMT_BUDGET_BPCURR15(2) Budget ProspectWERTV8CRM
STARTDATECRMT_STARTDATEDATS8(0) Opportunity Start DateDATUMCRM
EXPECT_ENDCRMT_EXPECT_ENDDATS8(0) Expected Closing DateDATUMCRM
CURR_PHASECRMT_CURR_PHASECHAR3(0) CRMC_PHASEPhaseCRM_PHASECRM_PHASEPHASECRM
PHASE_SINCECRMT_PHASE_SINCEDATS8(0) Phase SinceDATUMCRM
PROBABILITYCRMT_PROBABILITYNUMC3(0) Chance of SuccessCRM_PROBABILITYCRM
FORECAST_RELCRMT_FORECAST_RELCHAR1(0) Forecast RelevanceCRM_FORECAST_RELCRM
SOURCECRMT_SOURCECHAR3(0) CRMC_SOURCEOrigin of Opportunity/LeadCRM_SOURCECRM
IMPORTANCECRMT_IMPORTANCECHAR1(0) CRMC_OPPIMPOROpportunity/Lead PriorityCRM_IMPORTANCECRM
SALESCYCLECRMT_SALESCYCLECHAR5(0) CRMC_CYCLESales CycleCRM_SALESCYCLECRM
ADDRESS_NOCRMT_OPP_ADDRESSCHAR10(0) *Opportunity AddressAD_ADDRNUMCRM
TYPECRMT_OPPORT_TYPECHAR4(0) CRMC_OPPT_TYPEOpportunity GroupCRM_OPPORT_TYPECRM
STATUS_SINCECRMT_STATUS_SINCEDATS8(0) Status SinceDATUMCRM
SYS_PROBABILITYCRMT_SYSTEM_PROBABILITYNUMC3(0) Chance of Success of Opportunity - Calculated by SystemCRM_SYSTEM_PROBABILITYCRM
DESCRIPTION_OPPCRMT_DESCRIPTION_OPPCHAR40(0) Opportunity DescriptionTEXT40CRM
CUSTOMER_STATUSCRMT_CUSTSTATCHAR4(0) *Phase of registration projectCRM_CUSTSTATCRM


View list of all tables