SAP ABAP Table CRMT_BW_OPPT_H (BW Datasource for CRM Opportunities: Header Data)

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_OPPT_H	Table Relationship Diagram
Short Description	BW Datasource for CRM Opportunities: Header Data

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	.INCLUDE	☐				0	0	ORDERADM_H Data for BW DataSources
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION_UC	☐	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
10	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
11	CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
12	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	CHANGED_AT	☐	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
14	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	RECORDMODE	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
16	NUM_OF_HEAD	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
17	OCCURRENCE	☐	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
18	SCENARIO	☐	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	☐	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	OCCURR_QUOT	☐	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
21	OCCURR_CONT	☐	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	REF_UPDATE	☐	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
23	INPUT_CHANNEL	☐	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
24	CREATED_TS	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CHANGED_TS	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
26	.INCLUDE	☐				0	0	OPPORT_H Data for BW DataSources
27	OPPT_GUID	☐	CDBT_OPPORT_H_GUID	SYSUUID	RAW	16	0	Opportunity header own guid.
28	STARTDATE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
29	EXPECT_END	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
30	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
31	PHASE_SINCE	☐	CRMT_PHASE_SINCE	DATUM	DATS	8	0	Sales Stage Since
32	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	*
33	SALESCYCLE	☐	CRMT_SALESCYCLE	CRM_SALESCYCLE	CHAR	5	0	Sales Cycle	*
34	TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	*
35	CONTROL_PHASE	☐	CRMT_CON_PHASE	CRM_CON_PHASE	CHAR	3	0	Analysis Stage	*
36	EXP_REVENUE	☐	CRMT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Volume
37	BUDGET_BP	☐	CRMT_BUDGET_BP	WERTV8	CURR	15	2	Budget Prospect
38	PROBABILITY	☐	CRMT_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Chance of Success
39	DURATION	☐	CRMT_DURATION	CRM_DURATION	NUMC	3	0	Expected Duration of Sales Stage in Days
40	STATUS_OPPT	☐	CRMT_STATUS_OPPORTUNITY	CRM_J_STATUS	CHAR	5	0	Opportunity Status
41	STATUS_SINCE	☐	CRMT_STATUS_SINCE	DATUM	DATS	8	0	Status Since
42	BW_POST_DATE	☐	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
43	NUMBER_OF_H	☐	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
44	SYS_PROBABILITY	☐	CRMT_SYSTEM_PROBABILITY	CRM_SYSTEM_PROBABILITY	NUMC	3	0	Chance of Success of Opportunity - Calculated by System
45	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
46	FORECAST_REL	☐	CRMT_FORECAST_REL	CRM_FORECAST_REL	CHAR	1	0	Forecast Relevance
47	DESCRIPTION_OPP	☐	CRMT_DESCRIPTION_OPP	TEXT40	CHAR	40	0	Opportunity Description
48	.INCLUDE	☐				0	0	PARTNER (General) Data for BW DataSoures
49	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
50	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
51	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
52	SALESPARTNER	☐	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
53	RESP_GROUP_RFW	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
54	PLANNING_ACCOUNT	☐	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
55	.INCLUDE	☐				0	0	PARTNER (Opportunity/Activity) Data for BW DataSoures
56	COMPETITOR	☐	CRMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitors	*
57	PROSPECT	☐	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
58	ACTIVITY_PARTNER	☐	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
59	.INCLUDE	☐				0	0	PARTNER (Call Center) Data for BW Datasoures
60	EXECUTING_CC	☐	CRMT_EXECUTING_CC	BU_PARTNER	CHAR	10	0	Executing Interaction Center	*
61	RESP_GROUP	☐	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
62	.INCLUDE	☐				0	0	ORGMAN Data for BW DataSources
63	SALES_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
64	SALES_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
65	SALES_OFFICE	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
66	SALES_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
67	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
68	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
69	SERVICE_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
70	SERVICE_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
71	PURCH_ORG_RESP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
72	PURCH_ORG	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
73	PURCH_GROUP	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
74	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
75	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
76	.INCLUDE	☐				0	0	PRICING_H Data for BW DataSources
77	EXCHG_TYPE	☐	CRMT_EXCHG_TYPE	KURST	CHAR	4	0	Exchange Rate Type	*
78	EXCHG_DATE	☐	CRMT_EXCHG_DATE	CRM_EXCHG_DATE	DATS	8	0	Exchange Rate Date
79	EXCHG_RATE	☐	CRMT_EXCHG_RATE	CRM_EXCHG_RATE	DEC	9	5	Exchange Rate
80	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
81	PRICE_DATE	☐	CRMT_PRICE_DATE	CRM_PRICE_DATE	DATS	8	0	Pricing Date
82	REF_CURRENCY	☐	CRMT_REF_CURRENCY	WAERS	CUKY	5	0	Reference Currency	*
83	PMNTTRMS	☐	CRMT_PMNTTRMS	CRM_PMNTTRMS	CHAR	4	0	Terms of Payment	*
84	CUST_GROUP	☐	CRMT_CUST_GROUP	CRM_CUST_GROUP	CHAR	2	0	Customer Group	*
85	CUSTOMER_TYPE	☐	CRMT_CUSTOMER_TYPE	BU_KIND	CHAR	4	0	Business Partner Type	*
86	.INCLUDE	☐				0	0	SRV_OSSET Data for BW DataSources
87	KATALOGART	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
88	CODEGRUPPE	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
89	CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
90	ACT_REASON_CAT	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
91	ACT_REASON_GROUP	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
92	ACT_REASON_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
93	EXT_REFOBJ	☐	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
94	.INCLUDE	☐				0	0	Time Characteristics for BW Reporting
95	CALDAY	☐	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
96	CALDAY_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
97	.INCLUDE	☐				0	0	DOC_FLOW Data for BW DataSources
98	PREDEC_OBJKEY	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
99	PREDEC_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
100	LOGSYS_PRED	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
101	MKT_ELEMENT	☐	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
102	PRED_LEAD_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
103	LEAD_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
104	PRED_OPPT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
105	OPPT_CREATED_AT	☐	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
106	PRED_ACT_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
107	ACT_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
108	ACT_DIRECTION	☐	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
109	QUOTATION_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
110	QUOT_VALID_FROM	☐	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
111	PROCESS_CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
112	PROCESS_CATALOG	☐	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
113	PROCESS_CODEGR	☐	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
114	PROCESS_CODE	☐	QCODE	QCODE	CHAR	4	0	Code	*
115	PROCESS_OBJTYPE	☐	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
116	PO_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
117	PO_ITEM_NUMBER	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
118	LEAD_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
119	OPPT_CREATED_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
120	QUOT_VALID_TS	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
121	.INCLUDE	☐				0	0	STATUS GROUPS Data for BW Datasources
122	BWSTONESYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
123	BWSTONESYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
124	BWSTONESYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
125	BWSTONESYS3	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
126	BWSTONESYS4	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
127	BWSTONESYS5	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
128	BWSTONESYS6	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
129	BWSTONESYS7	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
130	BWSTONESYS8	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
131	BWSTONESYS9	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
132	BWSTONESYSA	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
133	BWSTTECSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
134	BWSTTECSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
135	BWSTTECSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
136	BWSTLOCSYS0	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
137	BWSTLOCSYS1	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
138	BWSTLOCSYS2	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
139	BWSTONESYSB	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
140	BWSTONESYSC	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status
141	.INCLUDE	☐				0	0	Territory Data for BW Data Sources (Partner Attribute)
142	PATH_GUID	☐	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
143	TERR_GUID	☐	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
144	.INCLUDE	☐				0	0	Opportunity Hierarchy Data for BW Data Sources
145	MAST_OPP_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
146	MAST_OPITEM_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
147	SUB_OPP_GUID	☐	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
148	MASTEROPP_FLAG	☐	CRMT_MASTEROPP_FLAG	CRMT_MASTEROPP_FLAG	CHAR	1	0	Flag to indicate master opportunity
149	.INCLUDE	☐				0	0	Object References for BW DataSources
150	REF_IOBJECT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
151	REF_IOBJECT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
152	REF_CONF_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
153	REF_CONF_PROD_GU	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
154	REF_PROD_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
155	REF_PROD_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
156	REF_OBJ_FAM	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
157	REF_BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
158	REF_BUAG_GUID	☐	CRMT_BUAG_GUID_C	SYSUUID_C	CHAR	32	0	GUID of Business Agreement in Character Format
159	REF_NO_ITEMS	☐	CRMT_NUMBER_OF_I	INT4	INT4	10	0	Order Item Number
160	.INCLUDE	☐				0	0	CUOBJ for BW DataSources
161	CUOBJ	☐	CRMT_INT_OBJ_NO	IB_INSTANCE	NUMC	18	0	Configuration (Internal Object Number)
162	.INCLUDE	☐				0	0	PARTNER (Locator) Various Partner Functions
163	INSTALL_AT	☐	CRMT_INSTALL_AT_PART	BU_PARTNER	CHAR	10	0	Installed At	*
164	INSTALL_AT_LIST	☐	CRMT_INSTALL_AT_LIST	CHAR80	CHAR	80	0	Installed At - Name
165	RESPONS_AT_PARTNER	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
166	END_CUSTOMER	☐	CRMT_END_CUSTOMER	BU_PARTNER	CHAR	10	0	End Customer (Channel Management)	*
167	RESP_AT_PART	☐	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
168	.INCLUDE	☐				0	0	Specific Opportunity Header Fields for BW DataSource
169	BWSTONEOPPT	☐	CRMBWST	J_STONR	NUMC	2	0	BW Status

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BW_OPPT_H	OBJECT_TYPE	CRMC_SUBOB_CAT	SUBOBJ_CATEGORY

History

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