SAP ABAP Table CRMT_LEAD_MONITOR_SEL (CRM Structure for Selection Criteria in Lead Monitor)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-LEA (Application Component) Lead Management
     ⤷ CRM_LEAD_MONITOR (Package) CRM Lead: Monitor Tools

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_LEAD_MONITOR_SEL	Table Relationship Diagram
Short Description	CRM Structure for Selection Criteria in Lead Monitor

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	Lead
2	.INCLUDE	☐				0	0	One Order: Key Fields
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
5	.INCLUDE	☐				0	0	Lead Header Data: Structure with External Fields
6	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	CRMC_SOURCE
7	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	CRMC_OPPIMPOR
8	LEAD_TYPE	☐	CRMT_LEAD_TYPE	CRM_LEAD_TYPE	CHAR	4	0	Lead Group	CRMC_LEAD_TYPE
9	STATUS_SINCE	☐	CRMT_STATUS_SINCE	DATUM	DATS	8	0	Status Since
10	QUAL_LEVEL_MAN	☐	CRMT_LEAD_QUAL_LEVEL_MAN	CRM_LEAD_QUAL_LEVEL	CHAR	2	0	Lead Qualification Level	CRMC_LEAD_QL
11	QUAL_LEVEL_AUTO	☐	CRMT_LEAD_QUAL_LEVEL_AUTO	CRM_LEAD_QUAL_LEVEL	CHAR	2	0	Lead Qualification Level (Automatic)	CRMC_LEAD_QL
12	QUAL_LEVEL_SVY	☐	CRMT_LEAD_QUAL_LEVEL_AUTO_SVY	CHAR32	CHAR	32	0	Questionnaire that Q-Level Sets (Automatically)
13	.INCLUDE	☐				0	0	EEW Include
14	LEAD_H_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
15	.INCLUDE	☐				0	0
16	.INCLUDE	☐				0	0	CRM Structure Selection Criteria - Addition for Leads
17	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
18	DATE_FROM	☐	SC_DATEFRO	DATUM	DATS	8	0	Start Date
19	DATE_TO	☐	SC_DATETO	DATUM	DATS	8	0	End Date
20	.INCLUDE	☐				0	0	CRM Structure Selection Criteria - Business Partner
21	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
22	SALES_EMPLOYEE	☐	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
23	PERSON_RESP	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
24	CONTACT_PERSON	☐	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
25	IND_SECTOR	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	*
26	COUNTRY	☐	BU_IDCOUNTRY	LAND1	CHAR	3	0	Country in Which ID Number is Valid or Was Assigned	T005
27	.INCLUDE	☐				0	0	CRM Structure Selection Criteria - Organizational Data
28	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
29	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	CRMC_DISTCHAN
30	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	CRMC_DIVISION
31	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
32	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
33	.INCLUDE	☐				0	0	CRM Structure Selection Criteria - Product
34	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	COMC_PR_TYPE
35	PROD_HIERARCHY	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_LEAD_MONITOR_SEL	COUNTRY	T005	LAND1
2	CRMT_LEAD_MONITOR_SEL	DIS_CHANNEL	CRMC_DISTCHAN	DISTCHAN
3	CRMT_LEAD_MONITOR_SEL	DIVISION	CRMC_DIVISION	DIVISION
4	CRMT_LEAD_MONITOR_SEL	IMPORTANCE	CRMC_OPPIMPOR	IMPORTANCE
5	CRMT_LEAD_MONITOR_SEL	LEAD_TYPE	CRMC_LEAD_TYPE	LEAD_TYPE
6	CRMT_LEAD_MONITOR_SEL	PRODUCT_TYPE	COMC_PR_TYPE	PRODUCT_TYPE
7	CRMT_LEAD_MONITOR_SEL	QUAL_LEVEL_AUTO	CRMC_LEAD_QL	QUAL_LEVEL
8	CRMT_LEAD_MONITOR_SEL	QUAL_LEVEL_MAN	CRMC_LEAD_QL	QUAL_LEVEL
9	CRMT_LEAD_MONITOR_SEL	SOURCE	CRMC_SOURCE	SOURCE

History

Last changed by/on	SAP	20130604
SAP Release Created in	30A