SAP ABAP Table CRMC_SVY_OPPT (Define Determination Criteria for Questionnaires (Opport.))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-SVY (Application Component) Survey
     ⤷ CRM_SURVEY (Package) CRM: Manage Survey GUIDs

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMC_SVY_OPPT	Table Relationship Diagram
Short Description	Define Determination Criteria for Questionnaires (Opport.)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	N	Display/Maintenance Not 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	RESTRICTION_ID	☑	CRMT_SURVEY_RESTRICTION_ID		CHAR	10	0	CRM Survey: Criteria Set ID
3	STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
4	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	CRMC_OPPIMPOR
5	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	CRMC_SOURCE
6	OPP_TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	CRMC_OPPT_TYPE
7	PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	CRMC_PHASE
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	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMC_SVY_OPPT	CURRENCY	TCURC	WAERS
2	CRMC_SVY_OPPT	IMPORTANCE	CRMC_OPPIMPOR	IMPORTANCE
3	CRMC_SVY_OPPT	OPP_TYPE	CRMC_OPPT_TYPE	TYPE
4	CRMC_SVY_OPPT	PHASE	CRMC_PHASE	PHASE
5	CRMC_SVY_OPPT	SOURCE	CRMC_SOURCE	SOURCE

History

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