SAP ABAP Table CRMS_MKTHV_MC_DATA (CRM Marketing: Marketing Prospect Data Structure)

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_DATA	Table Relationship Diagram
Short Description	CRM Marketing: Marketing Prospect Data Structure

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 Prospect Structure
2	ID	☐	CRMT_MKTHV_MC_ID	CRM_MKTHV_MC_ID	CHAR	10	0	Marketing Prospect ID
3	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
4	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
5	NAME_FIRST	☐	CRMT_MKTHV_MC_FNAME	CRM_MKTHV_MC_FNAME	CHAR	40	0	CRM Marketing: Marketing Prospect First Name
6	NAME_LAST	☐	CRMT_MKTHV_MC_LNAME	CRM_MKTHV_MC_LNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Last Name
7	NAMEMIDDLE	☐	CRMT_MKTHV_MC_MNAME	CRM_MKTHV_MC_MNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Middle Name
8	FULLNAME	☐	CRMT_MKTHV_MC_FULL_NAME	CRM_MKTHV_MC_FULL_NAME	CHAR	80	0	CRM Marketing: Marketing Prospect Full Name
9	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
10	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
11	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
12	PREFIX1	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
13	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
14	LANGU_CORR	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
15	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
16	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
17	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
18	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
19	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
20	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
21	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
22	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
23	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect EEW Include for Customer
24	MC_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
25	.INCLUDE	☐				0	0	Marketing Permission
26	CONSENT_TEL	☐	CRMT_MC_MKTPERM_CONSENT_TEL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Telephone
27	CONSENT_EMAIL	☐	CRMT_MC_MKTPERM_CONSENT_EMAIL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for E-Mail
28	CONSENT_FAX	☐	CRMT_MC_MKTPERM_CONSENT_FAX	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Fax
29	CONSENT_SMS	☐	CRMT_MC_MKTPERM_CONSENT_SMS	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for SMS
30	ORIGIN	☐	CRMT_BU_MKTPERM_ORIGIN	CRMT_BU_MKTPERM_ORIGIN	CHAR	3	0	Form of Consent	*
31	DATE_OF_CONSENT	☐	CRMT_BU_MKTPERM_ORIGIN_DATE	DATS	DATS	8	0	Marketing Permission: Date of Consent
32	EXTRN_LIST_GUID	☐	CRMT_MKTLIST_LIST_GUID	CRM_MKTLIST_LIST_GUID	RAW	16	0	CRM Marketing: GUID for an External List
33	MC_MKT_ATTR_TAB	☐	CRMT_MKTHV_MC_MKT_ATTR		TTYP	0	0
34	MC_SMI_USER_TAB	☐	CRMT_MP_SOCIAL_USER_T		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMS_MKTHV_MC_DATA	COUNTRY	T005	LAND1	REF	1	CN
2	CRMS_MKTHV_MC_DATA	LANGU_CORR	T002	SPRAS
3	CRMS_MKTHV_MC_DATA	REGION	T005S	BLAND	REF	C	CN

History

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