SAP ABAP Table CRMT_BW_OPPORTUNITY_DATA_H (OPPORT_H Data for BW DataSources)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
     ⤷ CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_OPPORTUNITY_DATA_H	Table Relationship Diagram
Short Description	OPPORT_H Data for BW DataSources

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OPPT_GUID	☐	CDBT_OPPORT_H_GUID	SYSUUID	RAW	16	0	Opportunity header own guid.
2	STARTDATE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
3	EXPECT_END	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
4	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
5	PHASE_SINCE	☐	CRMT_PHASE_SINCE	DATUM	DATS	8	0	Sales Stage Since
6	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	*
7	SALESCYCLE	☐	CRMT_SALESCYCLE	CRM_SALESCYCLE	CHAR	5	0	Sales Cycle	*
8	TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	*
9	CONTROL_PHASE	☐	CRMT_CON_PHASE	CRM_CON_PHASE	CHAR	3	0	Analysis Stage	*
10	EXP_REVENUE	☐	CRMT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Volume
11	BUDGET_BP	☐	CRMT_BUDGET_BP	WERTV8	CURR	15	2	Budget Prospect
12	PROBABILITY	☐	CRMT_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Chance of Success
13	DURATION	☐	CRMT_DURATION	CRM_DURATION	NUMC	3	0	Expected Duration of Sales Stage in Days
14	STATUS_OPPT	☐	CRMT_STATUS_OPPORTUNITY	CRM_J_STATUS	CHAR	5	0	Opportunity Status
15	STATUS_SINCE	☐	CRMT_STATUS_SINCE	DATUM	DATS	8	0	Status Since
16	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
17	NUMBER_OF_H	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
18	SYS_PROBABILITY	☐	CRMT_SYSTEM_PROBABILITY	CRM_SYSTEM_PROBABILITY	NUMC	3	0	Chance of Success of Opportunity - Calculated by System
19	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
20	FORECAST_REL	☐	CRMT_FORECAST_REL	CRM_FORECAST_REL	CHAR	1	0	Forecast Relevance
21	DESCRIPTION_OPP	☐	CRMT_DESCRIPTION_OPP	TEXT40	CHAR	40	0	Opportunity Description

History

Last changed by/on	SAP	20110908
SAP Release Created in	20C