CRMD_OPPORT_H SAP (Opportunity) Table details

Dictionary Type: Table
Description: Opportunity




ABAP Code to SELECT data from CRMD_OPPORT_H
Related tables to CRMD_OPPORT_H
Access table CRMD_OPPORT_H




Table field list including key, data, relationships and ABAP select examples

CRMD_OPPORT_H is a standard SAP Table which is used to store Opportunity data and is available within R/3 SAP systems depending on the version and release level.

The CRMD_OPPORT_H table consists of various fields, each holding specific information or linking keys about Opportunity data available in SAP. These include CLIENT (Client), GUID (GUID of a CRM Order Object), EXP_REVENUE (Expected Sales Revenue), BUDGET_BP (Budget Prospect).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMD_OPPORT_H table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
CLIENTClient MANDTCLNT3Assigned to domainMANDT
GUIDGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
EXP_REVENUEExpected Sales Revenue CRMT_REPORT_EXP_REVENUECURR15(2) WERTV8
BUDGET_BPBudget Prospect CRMT_BUDGET_BPCURR15(2) WERTV8
STARTDATEOpportunity Start Date CRMT_STARTDATEDATS8DATUM
EXPECT_ENDExpected Closing Date CRMT_EXPECT_ENDDATS8DATUM
CURR_PHASEPhase CRMT_CURR_PHASECHAR3CRMC_PHASECRM_PHASECRM_PHASE
PHASE_SINCEPhase Since CRMT_PHASE_SINCEDATS8DATUM
PROBABILITYChance of Success CRMT_PROBABILITYNUMC3CRM_PROBABILITY
FORECAST_RELForecast Relevance CRMT_FORECAST_RELCHAR1CRM_FORECAST_REL
SOURCEOrigin of Opportunity/Lead CRMT_SOURCECHAR3CRMC_SOURCECRM_SOURCE
IMPORTANCEOpportunity/Lead Priority CRMT_IMPORTANCECHAR1CRMC_OPPIMPORCRM_IMPORTANCE
SALESCYCLESales Cycle CRMT_SALESCYCLECHAR5CRMC_CYCLECRM_SALESCYCLE
ADDRESS_NOOpportunity Address CRMT_OPP_ADDRESSCHAR10Assigned to domainALPHAAD_ADDRNUM
TYPEOpportunity Group CRMT_OPPORT_TYPECHAR4CRMC_OPPT_TYPECRM_OPPORT_TYPE
STATUS_SINCEStatus Since CRMT_STATUS_SINCEDATS8DATUM
SYS_PROBABILITYChance of Success of Opportunity - Calculated by System CRMT_SYSTEM_PROBABILITYNUMC3CRM_SYSTEM_PROBABILITY
DESCRIPTION_OPPOpportunity Description CRMT_DESCRIPTION_OPPCHAR40TEXT40
CUSTOMER_STATUSPhase of registration project CRMT_CUSTSTATCHAR4Assigned to domainCRM_CUSTSTAT

Key field Non-key field



How do I retrieve data from SAP table CRMD_OPPORT_H using ABAP code

The following ABAP code Example will allow you to do a basic selection on CRMD_OPPORT_H to SELECT all data from the table
DATA: WA_CRMD_OPPORT_H TYPE CRMD_OPPORT_H.

SELECT SINGLE *
FROM CRMD_OPPORT_H
INTO CORRESPONDING FIELDS OF WA_CRMD_OPPORT_H
WHERE...

How to access SAP table CRMD_OPPORT_H

Within an ECC or HANA version of SAP you can also view further information about CRMD_OPPORT_H and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!