SAP ABAP View CRMV_MKTPROSPECT (Marketing Prospect Search)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTHV_MC (Package) CRM Marketing: Marketing Contact - High Volume

Basic Data

View Type	H	Help View
Help View	CRMV_MKTPROSPECT
Short Description	Marketing Prospect Search
Root table	CRMD_MKTHV_MC	CRM Marketing: Marketing Prospect Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CRMD_MKTHV_MC	CRMD_MKTHV_MC
2	CRMD_MKTHV_MC_TC	CRMD_MKTHV_MC	MC_GUID	I

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CRMD_MKTHV_MC	CLIENT		☐	MANDT	☐	Client
2	GUID	CRMD_MKTHV_MC	GUID		☐	CRMT_MKTHV_MC_GENERIC_GUID	☐	CRM Marketing: Marketing Prospect Generic GUID
3	ID	CRMD_MKTHV_MC	ID		☐	CRMT_MKTHV_MC_ID	☐	Marketing Prospect ID
4	TITLE	CRMD_MKTHV_MC	TITLE		☐	AD_TITLE	☐	Form-of-Address Key
5	NAME_FIRST	CRMD_MKTHV_MC	NAME_FIRST		☐	CRMT_MKTHV_MC_FNAME	☐	CRM Marketing: Marketing Prospect First Name
6	NAMEMIDDLE	CRMD_MKTHV_MC	NAMEMIDDLE		☐	CRMT_MKTHV_MC_MNAME	☐	CRM Marketing: Marketing Prospect Middle Name
7	NAME_LAST	CRMD_MKTHV_MC	NAME_LAST		☐	CRMT_MKTHV_MC_LNAME	☐	CRM Marketing: Marketing Prospect Last Name
8	FULLNAME	CRMD_MKTHV_MC	FULLNAME		☐	CRMT_MKTHV_MC_FULL_NAME	☐	CRM Marketing: Marketing Prospect Full Name
9	POST_CODE1	CRMD_MKTHV_MC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
10	CITY1	CRMD_MKTHV_MC	CITY1		☐	AD_CITY1	☐	City
11	COUNTRY	CRMD_MKTHV_MC	COUNTRY		☐	LAND1	☐	Country Key
12	REGION	CRMD_MKTHV_MC	REGION		☐	REGIO	☐	Region (State, Province, County)
13	STREET	CRMD_MKTHV_MC	STREET		☐	AD_STREET	☐	Street
14	HOUSE_NUM1	CRMD_MKTHV_MC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
15	SMTP_ADDR	CRMD_MKTHV_MC	SMTP_ADDR		☐	AD_SMTPADR	☐	E-Mail Address
16	TELNR_LONG	CRMD_MKTHV_MC	TELNR_LONG		☐	AD_TELNRLG	☐	Complete number: dialling code+number+extension
17	LANGU_CORR	CRMD_MKTHV_MC	LANGU_CORR		☐	LANGU	☐	Language Key
18	COMPANY_ID	CRMD_MKTHV_MC	COMPANY_ID		☐	CRMT_MKTHV_MC_COMP_ID	☐	Company ID
19	NAME_FIRST_UC	CRMD_MKTHV_MC	NAME_FIRST_UC		☐	CRMT_MKTHV_MC_FNAME_UC	☐	Marketing Prospect: First Name
20	NAME_LAST_UC	CRMD_MKTHV_MC	NAME_LAST_UC		☐	CRMT_MKTHV_MC_LNAME_UC	☐	Marketing Prospect: Last Name
21	NAMEMIDDLE_UC	CRMD_MKTHV_MC	NAMEMIDDLE_UC		☐	CRMT_MKTHV_MC_MNAME_UC	☐	Marketing Prospect: Middle Name
22	FULLNAME_UC	CRMD_MKTHV_MC	FULLNAME_UC		☐	CRMT_MKTHV_MC_FULL_NAME_UC	☐	Marketing Prospect: Full Name
23	CITY1_UC	CRMD_MKTHV_MC	CITY1_UC		☐	CRMT_MKTHV_MC_CITY1_UC	☐	City
24	STREET_UC	CRMD_MKTHV_MC	STREET_UC		☐	CRMT_MKTHV_MC_STREET_UC	☐	Street
25	SCORE	CRMD_MKTHV_MC_TC	SCORE		☐	CRMT_MKTHV_MC_SCORE	☐	Marketing Prospect: Qualification Score
26	CONVTD_TO_BP	CRMD_MKTHV_MC_TC	CONVTD_TO_BP		☐	CRMT_MP_CONVTD_TO_BP	☐	Converted to Account

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140117
SAP Release Created in