SAP ABAP Table CRMS_MKTHV_MC_UI_DATA (CRM Marketing: Marketing Prospect Data from UI)

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

Table Category	INTTAB	Structure
Structure	CRMS_MKTHV_MC_UI_DATA	Table Relationship Diagram
Short Description	CRM Marketing: Marketing Prospect Data from UI

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	CRM Marketing: Marketing Contact IL Structure
2	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Generic Key Structure
3	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
4	GUID	☐	CRMT_MKTHV_MC_GENERIC_GUID	SYSUUID	RAW	16	0	CRM Marketing: Marketing Prospect Generic GUID
5	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Structure
6	ID	☐	CRMT_MKTHV_MC_ID	CRM_MKTHV_MC_ID	CHAR	10	0	Marketing Prospect ID
7	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
8	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
9	NAME_FIRST	☐	CRMT_MKTHV_MC_FNAME	CRM_MKTHV_MC_FNAME	CHAR	40	0	CRM Marketing: Marketing Prospect First Name
10	NAME_LAST	☐	CRMT_MKTHV_MC_LNAME	CRM_MKTHV_MC_LNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Last Name
11	NAMEMIDDLE	☐	CRMT_MKTHV_MC_MNAME	CRM_MKTHV_MC_MNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Middle Name
12	FULLNAME	☐	CRMT_MKTHV_MC_FULL_NAME	CRM_MKTHV_MC_FULL_NAME	CHAR	80	0	CRM Marketing: Marketing Prospect Full Name
13	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
14	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
15	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
16	PREFIX1	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
17	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
18	LANGU_CORR	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
19	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
20	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
21	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
22	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
23	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
24	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
25	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
26	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
27	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect EEW Include for Customer
28	MC_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
29	.INCLUDE	☐				0	0	Marketing Permission
30	CONSENT_TEL	☐	CRMT_MC_MKTPERM_CONSENT_TEL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Telephone
31	CONSENT_EMAIL	☐	CRMT_MC_MKTPERM_CONSENT_EMAIL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for E-Mail
32	CONSENT_FAX	☐	CRMT_MC_MKTPERM_CONSENT_FAX	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Fax
33	CONSENT_SMS	☐	CRMT_MC_MKTPERM_CONSENT_SMS	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for SMS
34	ORIGIN	☐	CRMT_BU_MKTPERM_ORIGIN	CRMT_BU_MKTPERM_ORIGIN	CHAR	3	0	Form of Consent	*
35	DATE_OF_CONSENT	☐	CRMT_BU_MKTPERM_ORIGIN_DATE	DATS	DATS	8	0	Marketing Permission: Date of Consent
36	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Text Structure
37	COUNTRY_TEXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
38	REGION_TEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
39	TITLE_TEXT	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
40	LANGU_CORR_TEXT	☐	SPTXT	SPTXT16	CHAR	16	0	Name of Language
41	TITLE_ACA1_TEXT	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
42	TITLE_ACA2_TEXT	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
43	TITLE_ROYL_TEXT	☐	AD_TITLEST	TEXT20	CHAR	20	0	Name supplement, e.g. noble title (written form)
44	PREFIX1_TEXT	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
45	PREFIX2_TEXT	☐	AD_PREFIXT	TEXT20	CHAR	20	0	Name prefix
46	COMPANY_COUNTRY_TXT	☐	LANDX	TEXT15	CHAR	15	0	Country Name
47	COMPANY_REGION_TXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
48	COMPANY_TITLE_TXT	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
49	COMP_LEGAL_FORM_TXT	☐	BU_TEXT40	BU_TEXT40	CHAR	40	0	Description
50	ACCOUNT_NAME	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
51	PROSPECT_FUN_KEY_DESCR	☐	CHAR80	CHAR80	CHAR	80	0	Char 80
52	.INCLUDE	☐				0	0	Marketing Permission Texts
53	CONSENT_TEL_TEXT	☐	CRMT_MC_MKTPERM_CONSENT_TEL_T	DDTEXT	CHAR	60	0	Description of Consent for Telephone
54	CONSENT_FAX_TEXT	☐	CRMT_MC_MKTPERM_CONSENT_FAX_T	DDTEXT	CHAR	60	0	Description of consent for Fax
55	CONSENT_EMAIL_TEXT	☐	CRMT_MC_MKTPERM_CONSENT_MAIL_T	DDTEXT	CHAR	60	0	Description of consent for E-Mail
56	CONSENT_SMS_TEXT	☐	CRMT_MC_MKTPERM_CONSENT_SMS_T	DDTEXT	CHAR	60	0	Description of Consent for SMS
57	ORIGIN_TEXT	☐	CRMT_MC_MKTPERM_ORIGIN_TEXT	CRMT_BU_MKTPERM_ORIGIN_TEXT	CHAR	40	0	Marketing Permission: Form of Consent Text
58	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Technical Structure
59	BP_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
60	EXTRN_LIST_ID	☐	CRMT_MKTLIST_LIST_ID	CRM_MKTLIST_LIST_ID	CHAR	28	0	CRM Marketing: ID for External List
61	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Miscellaneous Attr Struct.
62	INVALID_EMAIL	☐	CRMT_MKTHV_MC_INVALID_EMAIL	CRMT_MKTHV_MC_BOOLEAN	CHAR	1	0	CRM Marketing: Marketing Prospect Invalid E-Mail
63	USAGE_COUNT	☐	INT4	INT4	INT4	10	0	Natural number
64	RENTED	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
65	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Organization Data
66	COMPANY_ID	☐	CRMT_MKTHV_MC_COMP_ID	BU_PARTNER	CHAR	10	0	Company ID	*
67	COMPANY_TITLE	☐	CRMT_MKTHV_MC_COMP_TITLE	AD_TITLE	CHAR	4	0	Company Title	TSAD3
68	COMPANY_NAME	☐	CRMT_MKTHV_MC_COMP_NAME	BU_NAME	CHAR	40	0	Company Name
69	COMP_LEGAL_FORM	☐	CRMT_MKTHV_MC_COMP_LEGENTY	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
70	COMP_TELNR_LONG	☐	CRMT_MKTHV_MC_COMP_TELNR	CHAR30	CHAR	30	0	Company First Telephone No.: Dialling code+Number
71	COMP_FAXNR_LONG	☐	CRMT_MKTHV_MC_COMP_FXNRLNG	CHAR30	CHAR	30	0	Company Fax Number: Dialling Code+Number+Extension
72	COMPANY_URL	☐	CRMT_MKTHV_MC_COMP_URISCR	AD_URISCR	CHAR	132	0	Company URI, e.g. Homepage or ftp Address
73	COMPANY_COUNTRY	☐	CRMT_MKTHV_MC_COMP_LAND1	LAND1	CHAR	3	0	Company Country Key	T005
74	COMPANY_REGION	☐	CRMT_MKTHV_MC_COMP_REGIO	REGIO	CHAR	3	0	Company Region (State, Province, County)	T005S
75	COMPANY_CITY	☐	CRMT_MKTHV_MC_COMP_CITY1	TEXT40	CHAR	40	0	Company City
76	COMP_POSTAL_CODE	☐	CRMT_MKTHV_MC_COMP_PSTCD1	CHAR10	CHAR	10	0	Company City Postal Code
77	COMPANY_PO_BOX	☐	CRMT_MKTHV_MC_COMP_POBX	CHAR10	CHAR	10	0	Company PO Box
78	COMPANY_STREET	☐	CRMT_MKTHV_MC_COMP_STREET	TEXT60	CHAR	60	0	Company Street
79	COMPANY_HOUSE_NO	☐	CRMT_MKTHV_MC_COMP_HSNM1	CHAR10	CHAR	10	0	Company House Number
80	COMPANY_EMAIL	☐	CRMT_MKTHV_MC_COMP_SMTPADR	AD_SMTPADR	CHAR	241	0	Company E-Mail Address
81	PROSP_FUN_NAME	☐	CRMT_MKTHV_MC_COMP_FNCTN	TEXT40	CHAR	40	0	Function Name of Partner
82	PROSPECT_FUN_KEY	☐	CRMT_MKTHV_MC_COMP_PAFKT	BU_PAFKT	CHAR	4	0	Function of Partner	*
83	.INCLUDE	☐				0	0	CRM MArketing : MP Technil Attribute IL structure
84	CONVTD_TO_BP	☐	CRMT_MKTHV_MC_CONVTDTOBP	CRMT_MKTHV_MC_CONVTDTOBP_BOOL	CHAR	1	0	Boolean Value(Yes/No)
85	SCORE	☐	CRMT_MKTHV_MC_SCORE	CRMT_MKTHV_MC_SCORE	NUMC	4	0	Marketing Prospect: Qualification Score
86	BP_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
87	CREATED_BY	☐	CRMT_MP_USER_ID	UNAME	CHAR	12	0	User ID
88	CREATED_BY_NAME	☐	CRMT_MP_USER_NAME	TEXT80UEB	CHAR	80	0	User Name
89	CREATED_ON_DATE	☐	CRMT_MP_DATE	DATUM	DATS	8	0	Date
90	CREATED_AT_TIME	☐	CRMT_MP_TIME	UZEIT	TIMS	6	0	Time
91	CHANGED_BY	☐	CRMT_MP_USER_ID	UNAME	CHAR	12	0	User ID
92	CHANGED_BY_NAME	☐	CRMT_MP_USER_NAME	TEXT80UEB	CHAR	80	0	User Name
93	CHANGED_ON_DATE	☐	CRMT_MP_DATE	DATUM	DATS	8	0	Date
94	CHANGED_AT_TIME	☐	CRMT_MP_TIME	UZEIT	TIMS	6	0	Time
95	COMPANY_EXIST	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTHV_MC_UI_DATA	COMPANY_COUNTRY	T005	LAND1	REF	1	CN
2	CRMS_MKTHV_MC_UI_DATA	COMPANY_REGION	T005S	BLAND	REF	C	CN
3	CRMS_MKTHV_MC_UI_DATA	COMPANY_TITLE	TSAD3	TITLE	REF	1	CN
4	CRMS_MKTHV_MC_UI_DATA	COMP_LEGAL_FORM	TB019	LEGAL_ENTY	KEY	1	CN
5	CRMS_MKTHV_MC_UI_DATA	COUNTRY	T005	LAND1	REF	1	CN
6	CRMS_MKTHV_MC_UI_DATA	LANGU_CORR	T002	SPRAS
7	CRMS_MKTHV_MC_UI_DATA	REGION	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20140117
SAP Release Created in	701