CRMT_OPPORTUNITY_ALV SAP (CRM: Structre for Applicaiton Workplace - Opportunities) Structure details

Dictionary Type: Structure
Description: CRM: Structre for Applicaiton Workplace - Opportunities




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




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

CRMT_OPPORTUNITY_ALV is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "CRM: Structre for Applicaiton Workplace - Opportunities" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CRMT_OPPORTUNITY_ALV TYPE CRMT_OPPORTUNITY_ALV.

The CRMT_OPPORTUNITY_ALV table consists of various fields, each holding specific information or linking keys about CRM: Structre for Applicaiton Workplace - Opportunities data available in SAP. These include OBJECT_ID (Transaction Number), PROCESS_TYPE (Business Transaction Type), POSTING_DATE (Posting Date for a Business Transaction), DESCRIPTION (Transaction Description).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP CRMT_OPPORTUNITY_ALV structure 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
OBJECT_IDTransaction Number CRMT_OBJECT_ID_DBCHAR10ALPHACRM_OBJECT_ID
PROCESS_TYPEBusiness Transaction Type CRMT_PROCESS_TYPE_DBCHAR4Assigned to domainCRM_PROCESS_TYPE
POSTING_DATEPosting Date for a Business Transaction CRMT_POSTING_DATEDATS8
DESCRIPTIONTransaction Description CRMT_PROCESS_DESCRIPTIONCHAR40CRM_PROCESS_DESCRIPTION
DESCR_LANGUAGELanguage Key of Description CRMT_PROCESS_DESCRIPTION_LANGULANG1Assigned to domainISOLASPRAS
LOGICAL_SYSTEMLogical System CRMT_LOGSYSCHAR10Assigned to domainALPHALOGSYS
CRM_RELEASESAP Release SAPRELEASECHAR10CHAR10
SCENARIOScenario Identity CRMT_SCENARIOCHAR10CRM_SCENARIO
TEMPLATE_TYPETemplate Type of CRM Transaction CRMT_TEMPLATE_TYPE_DBCHAR1CRM_TEMPLATE_TYPE
CREATED_ATCreated At (Output in User Time Zone) COMT_CREATED_AT_USRDEC15TSTLCCOM_TSTMP
CREATED_BYUser that Created the Transaction CRMT_CREATED_BYCHAR12UNAMEUSER_ADDR
CHANGED_ATChanged At (Output in User Time Zone) COMT_CHANGED_AT_USRDEC15TSTLCCOM_TSTMP
CHANGED_BYTransaction Last Changed By CRMT_CHANGED_BYCHAR12UNAME
HEAD_CHANGED_ATTime of Last Change to the Transaction CRMT_CHANGED_ATDEC15TSTPSBCOS_TSTMP
ORDERADM_H_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
INPUT_CHANNELInput channel CRMT_INPUT_CHANNELCHAR3CRM_INPUT_CHANNEL
OBJECT_TYPEBusiness Trans. Cat. CRMT_SUBOBJECT_CATEGORY_DBCHAR10Assigned to domainCRM_OJ_NAME_PROCESS
ARCHIVING_FLAGIndicator Whether the Business Transaction Can Be Archived CRMT_ARCHIVING_FLAGCHAR1CRM_BOOLEAN
DESCRIPTION_UCTransaction Description (Upper Case) CRMT_PROCESS_DESCRIPTION_UCCHAR40CRM_PROCESS_DESCRIPTION_UC
OBJECT_ID_OKIndicator Whether Business Transaction Number is Correct CRMT_OBJECT_ID_OKCHAR1CRM_BOOLEAN
VERIFY_DATETime Period of Last Archiving Attempt CRMT_VERIFY_DATEDEC15TSTPSBCOS_TSTMP
CRM_CHANGED_ATTime of Last Change in CRM Online CRMT_ONLINE_CHANGED_ATDEC15TSTPSBCOS_TSTMP
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
CREATE_DATECRM Reporting: 'Created on' Date CRMT_RPRTNG_CREATED_ATDATS8CRM_RPRTNG_DATE
OPPTYPE_TEXTDescription (20 Characters) CRMT_DESCRIPTION_20CHAR20TEXT20
PHASE_DESCRIPTIONDescription CRMT_DESCRIPTIONCHAR40TEXT40
FCT_DESCRIPTIONPartner Function: Long Text CRMT_REPORT_FNKT_LONGCHAR30TEXT30
FCT_SHORT_DESCPartner Function: Short Text CRMT_REPORT_FNKT_SHORTCHAR4TEXT4
MAIN_BP_1Additional Business Partner CRMT_RPRTNG_ADDPARTNERCHAR35NAME
MAIN_BP_1_NOPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
MAIN_BP_1_FCTRole of an Additional Business Partner for Display CRMT_RPRTNG_ADDFUNCTIONCHAR8CHAR8
MAIN_BP_1_DESCPartner Function: Long Text CRMT_REPORT_FNKT_LONGCHAR30TEXT30
MAIN_BP_1_DESC_SPartner Function: Short Text CRMT_REPORT_FNKT_SHORTCHAR4TEXT4
MAIN_BP_1_NAMELISTOne-line short form of formatted address AD_LINE_SCHAR80CHAR80
MAIN_BP_2Additional Business Partner CRMT_RPRTNG_ADDPARTNERCHAR35NAME
MAIN_BP_2_NOPartner Number CRMT_PARTNER_NOCHAR32CRM_PARTNER_NO
MAIN_BP_2_FCTRole of an Additional Business Partner for Display CRMT_RPRTNG_ADDFUNCTIONCHAR8CHAR8
MAIN_BP_2_DESCPartner Function: Long Text CRMT_REPORT_FNKT_LONGCHAR30TEXT30
MAIN_BP_2_DESC_SPartner Function: Short Text CRMT_REPORT_FNKT_SHORTCHAR4TEXT4
MAIN_BP_2_NAMELISTOne-line short form of formatted address AD_LINE_SCHAR80CHAR80
STATObject status J_STATUSCHAR5J_STATUS
STATUSLongform Status CRMT_REPORT_STATUS_LCHAR100CHAR100
STATUS_USER_LONGLongform User Status CRMT_REPORT_STATUS_ULCHAR100CHAR100
STATUS_USERShortform Status CRMT_REPORT_STATUS_UCHAR40CHAR40
CURRENCYCurrency CRMT_CURRENCYCUKY5Assigned to domainWAERSFWS

Key field Non-key field



How do I retrieve data from SAP structure CRMT_OPPORTUNITY_ALV using ABAP code?

As CRMT_OPPORTUNITY_ALV is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_OPPORTUNITY_ALV as there is no data to select.

How to access SAP table CRMT_OPPORTUNITY_ALV

Within an ECC or HANA version of SAP you can also view further information about CRMT_OPPORTUNITY_ALV 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!