SAP ABAP Table CRMT_MKTLIST_MC_EXTN (CRM Marketing : External List Converted Cache-Mkt. Con. Addr)

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	INTTAB	Structure
Structure	CRMT_MKTLIST_MC_EXTN	Table Relationship Diagram
Short Description	CRM Marketing : External List Converted Cache-Mkt. Con. Addr

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	ID	☐	CRMT_MKTHV_MC_ID	CRM_MKTHV_MC_ID	CHAR	10	0	Marketing Prospect ID
2	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
3	NAME_FIRST	☐	CRMT_MKTHV_MC_FNAME	CRM_MKTHV_MC_FNAME	CHAR	40	0	CRM Marketing: Marketing Prospect First Name
4	NAME_LAST	☐	CRMT_MKTHV_MC_LNAME	CRM_MKTHV_MC_LNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Last Name
5	NAMEMIDDLE	☐	CRMT_MKTHV_MC_MNAME	CRM_MKTHV_MC_MNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Middle Name
6	FULLNAME	☐	CRMT_MKTHV_MC_FULL_NAME	CRM_MKTHV_MC_FULL_NAME	CHAR	80	0	CRM Marketing: Marketing Prospect Full Name
7	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
8	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
9	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
10	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
11	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
12	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
13	COMPANY_COUNTRY	☐	CRMT_MKTHV_MC_COMP_LAND1	LAND1	CHAR	3	0	Company Country Key	*
14	COMPANY_REGION	☐	CRMT_MKTHV_MC_COMP_REGIO	REGIO	CHAR	3	0	Company Region (State, Province, County)	*
15	COMPANY_CITY	☐	CRMT_MKTHV_MC_COMP_CITY1	TEXT40	CHAR	40	0	Company City
16	COMP_POSTAL_CODE	☐	CRMT_MKTHV_MC_COMP_PSTCD1	CHAR10	CHAR	10	0	Company City Postal Code
17	COMPANY_PO_BOX	☐	CRMT_MKTHV_MC_COMP_POBX	CHAR10	CHAR	10	0	Company PO Box
18	COMPANY_STREET	☐	CRMT_MKTHV_MC_COMP_STREET	TEXT60	CHAR	60	0	Company Street
19	COMPANY_HOUSE_NO	☐	CRMT_MKTHV_MC_COMP_HSNM1	CHAR10	CHAR	10	0	Company House Number
20	COMPANY_EMAIL	☐	CRMT_MKTHV_MC_COMP_SMTPADR	AD_SMTPADR	CHAR	241	0	Company E-Mail Address

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_MKTLIST_MC_EXTN	COUNTRY	T005	LAND1	REF	1	CN

History

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