SAP ABAP Table CRMT_MKTLIST_DUP_CHECK (CRM Marketing: External List - Data for Duplicate Check)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTLIST_TOOLS (Package) CRM Marketing: External List Management - Tools

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKTLIST_DUP_CHECK	Table Relationship Diagram
Short Description	CRM Marketing: External List - Data for Duplicate Check

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: ELM - Key for Data Records to Be Checked
2	GUID	☐	CRMT_MKTLIST_DATA_CHECK_GUID	SYSUUID	RAW	16	0	CRM Marketing: Ext. List - GUID of Data Record to be Checked
3	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Address
4	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
5	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
6	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
7	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
8	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
9	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
10	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
11	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
12	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
13	ID_NUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
14	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
15	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Person details
16	PERS_TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
17	PERS_FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
18	PERS_LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
19	PERS_INITIAL	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
20	PERS_TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
21	PERS_BIRTHDATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
22	PERS_SEX	☐	BU_SEXID	BU_SEXID	CHAR	1	0	Sex of business partner (person)
23	PERS_MARITALSTAT	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	*
24	PERS_TELEPHON	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
25	PERS_TEL_EXT	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
26	PERS_FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
27	PERS_FAX_EXT	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
28	PERS_E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
29	PERS_PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
30	PERS_LANGUAGE	☐	CRMT_MKTLIST_BU_LANG	LAISO	CHAR	2	0	Business Partner: Language
31	PERS_LANGU_CORR	☐	CRMT_MKTLIST_BU_CORR_LANG	LAISO	CHAR	2	0	Business Partner: Correspondence Language
32	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Org details
33	ORG_TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
34	ORG_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
35	ORG_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
36	ORG_NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
37	ORG_LEGALFORM	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
38	ORG_FOUND_DATE	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
39	ORG_TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
40	ORG_TEL_EXT	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
41	ORG_FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
42	ORG_FAX_EXT	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
43	ORG_URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
44	ORG_LANGUAGE	☐	CRMT_MKTLIST_BU_LANG	LAISO	CHAR	2	0	Business Partner: Language
45	ORG_URI_TYPE	☐	AD_URITYPE	AD_URITYPE	CHAR	3	0	URI type flag
46	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Attribute Data
47	ATTRIBUTE_SET	☐	CRMT_MKTLIST_ATTRIBUTE_SET	KLASSE	CHAR	18	0	Attribute Set
48	ATTRIBUTE	☐	CRMT_MKTLIST_ATTRIBUTE_NAME	ATNAM	CHAR	30	0	Marketing Attribute
49	VALUE	☐	CRMT_MKTLIST_ATTRIBUTE_VALUE	ATWRT	CHAR	30	0	Marketing Attribute Value
50	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Mkt. Con. Addr
51	ID	☐	CRMT_MKTHV_MC_ID	CRM_MKTHV_MC_ID	CHAR	10	0	Marketing Prospect ID
52	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
53	NAME_FIRST	☐	CRMT_MKTHV_MC_FNAME	CRM_MKTHV_MC_FNAME	CHAR	40	0	CRM Marketing: Marketing Prospect First Name
54	NAME_LAST	☐	CRMT_MKTHV_MC_LNAME	CRM_MKTHV_MC_LNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Last Name
55	NAMEMIDDLE	☐	CRMT_MKTHV_MC_MNAME	CRM_MKTHV_MC_MNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Middle Name
56	FULLNAME	☐	CRMT_MKTHV_MC_FULL_NAME	CRM_MKTHV_MC_FULL_NAME	CHAR	80	0	CRM Marketing: Marketing Prospect Full Name
57	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
58	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
59	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
60	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
61	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
62	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
63	COMPANY_COUNTRY	☐	CRMT_MKTHV_MC_COMP_LAND1	LAND1	CHAR	3	0	Company Country Key	*
64	COMPANY_REGION	☐	CRMT_MKTHV_MC_COMP_REGIO	REGIO	CHAR	3	0	Company Region (State, Province, County)	*
65	COMPANY_CITY	☐	CRMT_MKTHV_MC_COMP_CITY1	TEXT40	CHAR	40	0	Company City
66	COMP_POSTAL_CODE	☐	CRMT_MKTHV_MC_COMP_PSTCD1	CHAR10	CHAR	10	0	Company City Postal Code
67	COMPANY_PO_BOX	☐	CRMT_MKTHV_MC_COMP_POBX	CHAR10	CHAR	10	0	Company PO Box
68	COMPANY_STREET	☐	CRMT_MKTHV_MC_COMP_STREET	TEXT60	CHAR	60	0	Company Street
69	COMPANY_HOUSE_NO	☐	CRMT_MKTHV_MC_COMP_HSNM1	CHAR10	CHAR	10	0	Company House Number
70	COMPANY_EMAIL	☐	CRMT_MKTHV_MC_COMP_SMTPADR	AD_SMTPADR	CHAR	241	0	Company E-Mail Address
71	.INCLUDE	☐				0	0	Social Media Organization: Data for external List
72	ORG_SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
73	ORG_SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
74	ORG_SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
75	ORG_SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
76	ORG_SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
77	ORG_SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
78	ORG_GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
79	ORG_NUMBEROFSOCIALUSERCONTACT	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
80	ORG_SOCLUSRINFLUENCESCOREVAL	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score
81	.INCLUDE	☐				0	0	Social Media Person: Data for external List
82	PERS_SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
83	PERS_SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
84	PERS_SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
85	PERS_SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
86	PERS_SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
87	PERS_SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
88	PERS_GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
89	PERS_NUMBEROFSOCIALUSERCONTACT	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
90	PERS_SOCLUSRINFLUENCESCOREVAL	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score
91	.INCLUDE	☐				0	0	Social Media Marketing Prospect: Data for external List
92	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
93	SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
94	SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
95	SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
96	SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
97	SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
98	GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
99	NUMBEROFSOCIALUSERCONTACTS	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
100	SOCIALUSERINFLUENCESCOREVALUE	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score

Foreign Keys

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

History

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