SAP ABAP Table CRMD_MKTLIST_MCA (Staging - Import Marketing Contact Address)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTLIST_STAGING (Package) CRM Marketing: External List Management - Staging Engine 4.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CRMD_MKTLIST_MCA	Table Relationship Diagram
Short Description	Staging - Import Marketing Contact Address

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	.INCLUDE	☑				0	0	CRM Marketing : External List Converted Cache-Address
2	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
3	PACKAGE_GUID	☑	CRMT_MKTLIST_PACKAGE_GUID	CRM_MKTLIST_PACKAGE_GUID	RAW	16	0	CRM Marketing: GUID of a Working Package
4	C_HEAD_GUID	☑	CRMT_MKTLIST_C_HEAD	CRM_MKTLIST_C_HEAD	RAW	16	0	External List Converted Cache Header GUID
5	C_ITEM_GUID	☑	CRMT_MKTLIST_C_ITEM	CRM_MKTLIST_C_ITEM	RAW	16	0	External List Converted Cache Item GUID
6	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Structure
7	ID	☐	CRMT_MKTHV_MC_ID	CRM_MKTHV_MC_ID	CHAR	10	0	Marketing Prospect ID
8	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
9	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
10	NAME_FIRST	☐	CRMT_MKTHV_MC_FNAME	CRM_MKTHV_MC_FNAME	CHAR	40	0	CRM Marketing: Marketing Prospect First Name
11	NAME_LAST	☐	CRMT_MKTHV_MC_LNAME	CRM_MKTHV_MC_LNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Last Name
12	NAMEMIDDLE	☐	CRMT_MKTHV_MC_MNAME	CRM_MKTHV_MC_MNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Middle Name
13	FULLNAME	☐	CRMT_MKTHV_MC_FULL_NAME	CRM_MKTHV_MC_FULL_NAME	CHAR	80	0	CRM Marketing: Marketing Prospect Full Name
14	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
15	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
16	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
17	PREFIX1	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
18	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
19	LANGU_CORR	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
20	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
21	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
22	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
23	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
24	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
25	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
26	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
27	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
28	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect EEW Include for Customer
29	MC_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
30	.INCLUDE	☐				0	0	Marketing Permission
31	CONSENT_TEL	☐	CRMT_MC_MKTPERM_CONSENT_TEL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Telephone
32	CONSENT_EMAIL	☐	CRMT_MC_MKTPERM_CONSENT_EMAIL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for E-Mail
33	CONSENT_FAX	☐	CRMT_MC_MKTPERM_CONSENT_FAX	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Fax
34	CONSENT_SMS	☐	CRMT_MC_MKTPERM_CONSENT_SMS	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for SMS
35	ORIGIN	☐	CRMT_BU_MKTPERM_ORIGIN	CRMT_BU_MKTPERM_ORIGIN	CHAR	3	0	Form of Consent	*
36	DATE_OF_CONSENT	☐	CRMT_BU_MKTPERM_ORIGIN_DATE	DATS	DATS	8	0	Marketing Permission: Date of Consent
37	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Organization Data
38	COMPANY_ID	☐	CRMT_MKTHV_MC_COMP_ID	BU_PARTNER	CHAR	10	0	Company ID	*
39	COMPANY_TITLE	☐	CRMT_MKTHV_MC_COMP_TITLE	AD_TITLE	CHAR	4	0	Company Title	TSAD3
40	COMPANY_NAME	☐	CRMT_MKTHV_MC_COMP_NAME	BU_NAME	CHAR	40	0	Company Name
41	COMP_LEGAL_FORM	☐	CRMT_MKTHV_MC_COMP_LEGENTY	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
42	COMP_TELNR_LONG	☐	CRMT_MKTHV_MC_COMP_TELNR	CHAR30	CHAR	30	0	Company First Telephone No.: Dialling code+Number
43	COMP_FAXNR_LONG	☐	CRMT_MKTHV_MC_COMP_FXNRLNG	CHAR30	CHAR	30	0	Company Fax Number: Dialling Code+Number+Extension
44	COMPANY_URL	☐	CRMT_MKTHV_MC_COMP_URISCR	AD_URISCR	CHAR	132	0	Company URI, e.g. Homepage or ftp Address
45	COMPANY_COUNTRY	☐	CRMT_MKTHV_MC_COMP_LAND1	LAND1	CHAR	3	0	Company Country Key	T005
46	COMPANY_REGION	☐	CRMT_MKTHV_MC_COMP_REGIO	REGIO	CHAR	3	0	Company Region (State, Province, County)	T005S
47	COMPANY_CITY	☐	CRMT_MKTHV_MC_COMP_CITY1	TEXT40	CHAR	40	0	Company City
48	COMP_POSTAL_CODE	☐	CRMT_MKTHV_MC_COMP_PSTCD1	CHAR10	CHAR	10	0	Company City Postal Code
49	COMPANY_PO_BOX	☐	CRMT_MKTHV_MC_COMP_POBX	CHAR10	CHAR	10	0	Company PO Box
50	COMPANY_STREET	☐	CRMT_MKTHV_MC_COMP_STREET	TEXT60	CHAR	60	0	Company Street
51	COMPANY_HOUSE_NO	☐	CRMT_MKTHV_MC_COMP_HSNM1	CHAR10	CHAR	10	0	Company House Number
52	COMPANY_EMAIL	☐	CRMT_MKTHV_MC_COMP_SMTPADR	AD_SMTPADR	CHAR	241	0	Company E-Mail Address
53	PROSP_FUN_NAME	☐	CRMT_MKTHV_MC_COMP_FNCTN	TEXT40	CHAR	40	0	Function Name of Partner
54	PROSPECT_FUN_KEY	☐	CRMT_MKTHV_MC_COMP_PAFKT	BU_PAFKT	CHAR	4	0	Function of Partner	*

Foreign Keys

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

History

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