SAP ABAP Table CDBC_SVY_OPPT (Sub table for Survey Determination : Opportunity Header)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CDBC_SVY_OPPT	Table Relationship Diagram
Short Description	Sub table for Survey Determination : Opportunity Header

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	CDBSVTOPPTKEY	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	RESTRICTION_ID	☐	CRMT_SURVEY_RESTRICTION_ID		CHAR	10	0	CRM Survey: Criteria Set ID
4	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	*
5	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
6	OPP_TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	*
7	PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	*
8	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
9	DISTRIBUTION	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
10	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
11	EXP_REVENUE	☐	CRMT_REPORT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Revenue
12	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
13	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
14	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
15	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
16	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
17	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
18	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
19	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
20	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
21	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status

History

Last changed by/on	SAP	20130604
SAP Release Created in	400