SAP ABAP Table CRMV_SVY_OPPT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	CRMV_SVY_OPPT	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
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	RESTRICTION_ID	☑	CRMT_SURVEY_RESTRICTION_ID		CHAR	10	0	CRM Survey: Criteria Set ID
3	DESCRIPTION	☐	CRMT_DESCRIPTION	TEXT40	CHAR	40	0	Description
4	STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status
5	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	CRMC_OPPIMPOR
6	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	CRMC_SOURCE
7	OPP_TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	CRMC_OPPT_TYPE
8	PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	CRMC_PHASE
9	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
10	DISTRIBUTION	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel
11	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division
12	EXP_REVENUE	☐	CRMT_REPORT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Revenue
13	NET_VALUE_MAN	☐	CRMT_NET_VALUE_MAN_CUM	WERTV8	CURR	15	2	Expected Total Net Value of Products in Document Currency
14	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	CRMV_SVY_OPPT	CURRENCY	TCURC	WAERS
2	CRMV_SVY_OPPT	IMPORTANCE	CRMC_OPPIMPOR	IMPORTANCE
3	CRMV_SVY_OPPT	OPP_TYPE	CRMC_OPPT_TYPE	TYPE
4	CRMV_SVY_OPPT	PHASE	CRMC_PHASE	PHASE
5	CRMV_SVY_OPPT	SOURCE	CRMC_SOURCE	SOURCE

History

Last changed by/on	SAP	20130604
SAP Release Created in