SAP ABAP Table CRMT_MKTLIST_C_FULL (CRM MKT ELM: Complete B2B Structure)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_MKTLIST_C_FULL	Table Relationship Diagram
Short Description	CRM MKT ELM: Complete B2B 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	RECORD_NO	☐	CRMT_MKTLIST_RECORD_NO	CRM_MKTLIST_RECORD_NO	INT4	10	0	Record Number
2	C_HEAD_GUID_ORG	☐	CRMT_MKTLIST_C_HEAD	CRM_MKTLIST_C_HEAD	RAW	16	0	External List Converted Cache Header GUID
3	C_HEAD_GUID_PER	☐	CRMT_MKTLIST_C_HEAD	CRM_MKTLIST_C_HEAD	RAW	16	0	External List Converted Cache Header GUID
4	C_ITEM_GUID_ORG	☐	CRMT_MKTLIST_C_ITEM	CRM_MKTLIST_C_ITEM	RAW	16	0	External List Converted Cache Item GUID
5	C_ITEM_GUID_PER	☐	CRMT_MKTLIST_C_ITEM	CRM_MKTLIST_C_ITEM	RAW	16	0	External List Converted Cache Item GUID
6	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Org details
7	ORG_TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
8	ORG_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
9	ORG_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
10	ORG_NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
11	ORG_LEGALFORM	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	*
12	ORG_FOUND_DATE	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
13	ORG_TELEPHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
14	ORG_TEL_EXT	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
15	ORG_FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
16	ORG_FAX_EXT	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
17	ORG_URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
18	ORG_LANGUAGE	☐	CRMT_MKTLIST_BU_LANG	LAISO	CHAR	2	0	Business Partner: Language
19	ORG_URI_TYPE	☐	AD_URITYPE	AD_URITYPE	CHAR	3	0	URI type flag
20	ORG_ADR	☐	CRMT_MKTLIST_ADR_EXT		STRU	0	0
21	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
22	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
23	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
24	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
25	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
26	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
27	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
28	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
29	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
30	ID_NUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
31	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
32	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Person details
33	PERS_TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
34	PERS_FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
35	PERS_LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
36	PERS_INITIAL	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
37	PERS_TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
38	PERS_BIRTHDATE	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
39	PERS_SEX	☐	BU_SEXID	BU_SEXID	CHAR	1	0	Sex of business partner (person)
40	PERS_MARITALSTAT	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	*
41	PERS_TELEPHON	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
42	PERS_TEL_EXT	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
43	PERS_FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
44	PERS_FAX_EXT	☐	AD_FXXTNS	CHAR10	CHAR	10	0	Fax no.: Extension
45	PERS_E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
46	PERS_PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
47	PERS_LANGUAGE	☐	CRMT_MKTLIST_BU_LANG	LAISO	CHAR	2	0	Business Partner: Language
48	PERS_LANGU_CORR	☐	CRMT_MKTLIST_BU_CORR_LANG	LAISO	CHAR	2	0	Business Partner: Correspondence Language
49	PER_ADR	☐	CRMT_MKTLIST_ADR_EXT		STRU	0	0
50	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
51	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
52	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
53	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
54	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
55	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
56	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
57	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
58	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)
59	ID_NUMBER	☐	BU_ID_NUMBER	CHAR60	CHAR	60	0	Identification Number
60	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses
61	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-Contactdetails
62	CP_FUNCTIONNAME	☐	BU_FNCTN	TEXT40	CHAR	40	0	Function name of partner
63	CP_FUNCTIONKEY	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	*
64	.INCLUDE	☐				0	0	CRM MKT ELM: Organisation and Person IDs
65	BP_ORG	☐	BU_PARTNER_ORGN	BU_PARTNER	CHAR	10	0	Business Partner ID (Organisation)	*
66	BP_PER	☐	BU_PARTNER_PER	BU_PARTNER	CHAR	10	0	Business Partner ID (Person)	*
67	BP_GUID_ORG	☐	CRMT_MKTLIST_BP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID for Business Partner
68	BP_GUID_PER	☐	CRMT_MKTLIST_BP_GUID	SYSUUID	RAW	16	0	CRM Marketing: GUID for Business Partner
69	ACTIVITY	☐	CRMT_MKTLIST_ACT_EXT		STRU	0	0
70	TEMPLATE_ID	☐	CRMT_MKTLIST_TEMPLATE_ID	CRM_OBJECT_ID	CHAR	10	0	Template ID
71	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type
72	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
73	ACTUAL_DATE_FROM	☐	CRMT_MKTLIST_ACTUAL_DATE_FROM	DATUM	DATS	8	0	Actual Date From
74	ACTUAL_TIME_FROM	☐	CRMT_MKTLIST_ACTUAL_TIME_FROM	SYTIME	TIMS	6	0	Actual Time From
75	ACTUAL_DATE_TO	☐	CRMT_MKTLIST_ACTUAL_DATE_TO	DATUM	DATS	8	0	Actual Date To
76	ACTUAL_TIME_TO	☐	CRMT_MKTLIST_ACTUAL_TIME_TO	SYTIME	TIMS	6	0	Actual Time To
77	USER_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
78	PRIORITY	☐	CRMT_PRIORITY	SC_PRIO	NUMC	1	0	Activity Priority
79	CATEGORY	☐	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)
80	LEAD	☐	CRMT_MKTLIST_LEA_EXT		STRU	0	0
81	TEMPLATE_ID	☐	CRMT_MKTLIST_TEMPLATE_ID	CRM_OBJECT_ID	CHAR	10	0	Template ID
82	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type
83	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
84	START_DATE	☐	CRMT_MKTLIST_LEAD_START_DATE	DATUM	DATS	8	0	Start Date of the Lead
85	EXP_END_DATE	☐	CRMT_MKTLIST_LEAD_END_DATE	DATUM	DATS	8	0	Expected End Date of the Lead
86	USER_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
87	LEAD_PRIORITY	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority
88	LEAD_GROUP	☐	CRMT_LEAD_TYPE	CRM_LEAD_TYPE	CHAR	4	0	Lead Group
89	MANUAL_QUAL_LEV	☐	CRMT_LEAD_QUAL_LEVEL_MAN	CRM_LEAD_QUAL_LEVEL	CHAR	2	0	Lead Qualification Level
90	ORIGIN	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead
91	BCI	☐	CRMT_MKTLIST_BCI_EXT		STRU	0	0
92	PERS_RESP_CODE	☐	CRMT_MKT_ICRH_PRC_CHAR	CRM_MKT_ICRH_PRC_CHAR	CHAR	12	0	CRM Marketing: ICRH - Personalized Response Code - character
93	COUPON_CODE	☐	CRM_MKTPL_OFRCODE	CRM_MKTPL_OFRCODE	CHAR	16	0	Coupon Code
94	CAMPAIGN_ELEMENT	☐	CRM_MKTPL_CAMPAIGN_TASKID	CGPL_EXTID	CHAR	24	0	Campaign Element
95	ORG_NUMBER	☐	CRMT_MKTLIST_ORG_ID	BU_PARTNER	CHAR	10	0	ID of the Organization
96	PER_NUMBER	☐	CRMT_MKTLIST_PER_ID	BU_PARTNER	CHAR	10	0	ID of the Person
97	TRANSACTION_GUID	☐	CRMT_MKTLIST_TRANSACTION_GUID	CRM_MKTLIST_TRANSACTION_GUID	RAW	16	0	Transaction ID
98	TRANSACTION_ID	☐	CRMT_MKTLIST_TRANSACTION_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
99	ORG_CASE_NUMBER	☐	CRMT_MKTLIST_BPORG_CASE_NUMBER	CRM_MKTLIST_CLRCASE_NUMBER	CHAR	10	0	Organization Cleansing Case Number
100	PERS_CASE_NUMBER	☐	CRMT_MKTLIST_BPPER_CASE_NUMBER	CRM_MKTLIST_CLRCASE_NUMBER	CHAR	10	0	Person Cleansing Case Number
101	.INCLUDE	☐				0	0	CRM Marketing : External List Converted Cache-MP & Org data
102	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Structure
103	ID	☐	CRMT_MKTHV_MC_ID	CRM_MKTHV_MC_ID	CHAR	10	0	Marketing Prospect ID
104	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
105	TITLE_LET	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
106	NAME_FIRST	☐	CRMT_MKTHV_MC_FNAME	CRM_MKTHV_MC_FNAME	CHAR	40	0	CRM Marketing: Marketing Prospect First Name
107	NAME_LAST	☐	CRMT_MKTHV_MC_LNAME	CRM_MKTHV_MC_LNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Last Name
108	NAMEMIDDLE	☐	CRMT_MKTHV_MC_MNAME	CRM_MKTHV_MC_MNAME	CHAR	40	0	CRM Marketing: Marketing Prospect Middle Name
109	FULLNAME	☐	CRMT_MKTHV_MC_FULL_NAME	CRM_MKTHV_MC_FULL_NAME	CHAR	80	0	CRM Marketing: Marketing Prospect Full Name
110	TITLE_ACA1	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
111	TITLE_ACA2	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	*
112	TITLE_ROYL	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	*
113	PREFIX1	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
114	PREFIX2	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	*
115	LANGU_CORR	☐	LANGU	SPRAS	LANG	1	0	Language Key	T002
116	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
117	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
118	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
119	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
120	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
121	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
122	TELNR_LONG	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
123	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
124	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect EEW Include for Customer
125	MC_EEW_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
126	.INCLUDE	☐				0	0	Marketing Permission
127	CONSENT_TEL	☐	CRMT_MC_MKTPERM_CONSENT_TEL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Telephone
128	CONSENT_EMAIL	☐	CRMT_MC_MKTPERM_CONSENT_EMAIL	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for E-Mail
129	CONSENT_FAX	☐	CRMT_MC_MKTPERM_CONSENT_FAX	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for Fax
130	CONSENT_SMS	☐	CRMT_MC_MKTPERM_CONSENT_SMS	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent ID for SMS
131	ORIGIN	☐	CRMT_BU_MKTPERM_ORIGIN	CRMT_BU_MKTPERM_ORIGIN	CHAR	3	0	Form of Consent	*
132	DATE_OF_CONSENT	☐	CRMT_BU_MKTPERM_ORIGIN_DATE	DATS	DATS	8	0	Marketing Permission: Date of Consent
133	.INCLUDE	☐				0	0	CRM Marketing: Marketing Prospect Organization Data
134	COMPANY_ID	☐	CRMT_MKTHV_MC_COMP_ID	BU_PARTNER	CHAR	10	0	Company ID	*
135	COMPANY_TITLE	☐	CRMT_MKTHV_MC_COMP_TITLE	AD_TITLE	CHAR	4	0	Company Title	TSAD3
136	COMPANY_NAME	☐	CRMT_MKTHV_MC_COMP_NAME	BU_NAME	CHAR	40	0	Company Name
137	COMP_LEGAL_FORM	☐	CRMT_MKTHV_MC_COMP_LEGENTY	BU_LEGENTY	CHAR	2	0	Legal Form of Organization	TB019
138	COMP_TELNR_LONG	☐	CRMT_MKTHV_MC_COMP_TELNR	CHAR30	CHAR	30	0	Company First Telephone No.: Dialling code+Number
139	COMP_FAXNR_LONG	☐	CRMT_MKTHV_MC_COMP_FXNRLNG	CHAR30	CHAR	30	0	Company Fax Number: Dialling Code+Number+Extension
140	COMPANY_URL	☐	CRMT_MKTHV_MC_COMP_URISCR	AD_URISCR	CHAR	132	0	Company URI, e.g. Homepage or ftp Address
141	COMPANY_COUNTRY	☐	CRMT_MKTHV_MC_COMP_LAND1	LAND1	CHAR	3	0	Company Country Key	T005
142	COMPANY_REGION	☐	CRMT_MKTHV_MC_COMP_REGIO	REGIO	CHAR	3	0	Company Region (State, Province, County)	T005S
143	COMPANY_CITY	☐	CRMT_MKTHV_MC_COMP_CITY1	TEXT40	CHAR	40	0	Company City
144	COMP_POSTAL_CODE	☐	CRMT_MKTHV_MC_COMP_PSTCD1	CHAR10	CHAR	10	0	Company City Postal Code
145	COMPANY_PO_BOX	☐	CRMT_MKTHV_MC_COMP_POBX	CHAR10	CHAR	10	0	Company PO Box
146	COMPANY_STREET	☐	CRMT_MKTHV_MC_COMP_STREET	TEXT60	CHAR	60	0	Company Street
147	COMPANY_HOUSE_NO	☐	CRMT_MKTHV_MC_COMP_HSNM1	CHAR10	CHAR	10	0	Company House Number
148	COMPANY_EMAIL	☐	CRMT_MKTHV_MC_COMP_SMTPADR	AD_SMTPADR	CHAR	241	0	Company E-Mail Address
149	PROSP_FUN_NAME	☐	CRMT_MKTHV_MC_COMP_FNCTN	TEXT40	CHAR	40	0	Function Name of Partner
150	PROSPECT_FUN_KEY	☐	CRMT_MKTHV_MC_COMP_PAFKT	BU_PAFKT	CHAR	4	0	Function of Partner	*
151	.INCLUDE	☐				0	0	Marketing Permission: Data for external List
152	BP_PARTNERGUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
153	BP_CONTPGUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
154	.INCLU--AP	☐				0	0	Marketing Permission: Data for external List Append
155	BP_CHANNEL	☐	CRMT_BU_MKTPERM_CHAN	CRMT_BU_MKTPERM_CHAN	CHAR	3	0	Communication Channel	*
156	BP_PERMISSION	☐	CRMT_BU_MKTPERM_PERMISSION	CRMT_BU_MKTPERM_PERMISSION	NUMC	3	0	Consent
157	BP_ORIGIN	☐	CRMT_BU_MKTPERM_ORIGIN	CRMT_BU_MKTPERM_ORIGIN	CHAR	3	0	Form of Consent	*
158	BP_VALID_FROM	☐	CRMT_BU_MKTPERM_ORIGIN_DATE	DATS	DATS	8	0	Marketing Permission: Date of Consent
159	BP_VALUE	☐	CRMT_BU_MKTPERM_COM	CRMT_BU_MKTPERM_COM	CHAR	241	0	Communication Details
160	C_HEAD_GUID_MC	☐	CRMT_MKTLIST_C_HEAD	CRM_MKTLIST_C_HEAD	RAW	16	0	External List Converted Cache Header GUID
161	C_ITEM_GUID_MC	☐	CRMT_MKTLIST_C_ITEM	CRM_MKTLIST_C_ITEM	RAW	16	0	External List Converted Cache Item GUID
162	MCI	☐	CRMS_MKTLIST_MCI_EXT		STRU	0	0
163	PROSPECT_ID	☐	CRMT_MKTHV_MC_ID	CRM_MKTHV_MC_ID	CHAR	10	0	Marketing Prospect ID
164	CAMPAIGN_ID	☐	CRM_MKTPL_CAMPAIGNID	CGPL_EXTID	CHAR	24	0	Campaign
165	.INCLUDE	☐				0	0	Social Media Organization: Data for external List
166	ORG_SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
167	ORG_SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
168	ORG_SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
169	ORG_SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
170	ORG_SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
171	ORG_SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
172	ORG_GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
173	ORG_NUMBEROFSOCIALUSERCONTACT	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
174	ORG_SOCLUSRINFLUENCESCOREVAL	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score
175	.INCLUDE	☐				0	0	Social Media Person: Data for external List
176	PERS_SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
177	PERS_SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
178	PERS_SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
179	PERS_SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
180	PERS_SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
181	PERS_SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
182	PERS_GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
183	PERS_NUMBEROFSOCIALUSERCONTACT	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
184	PERS_SOCLUSRINFLUENCESCOREVAL	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score
185	.INCLUDE	☐				0	0	Social Media Marketing Prospect: Data for external List
186	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
187	SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
188	SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
189	SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
190	SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
191	SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
192	GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
193	NUMBEROFSOCIALUSERCONTACTS	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
194	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_C_FULL	COMPANY_COUNTRY	T005	LAND1	REF	1	CN
2	CRMT_MKTLIST_C_FULL	COMPANY_REGION	T005S	BLAND	REF	C	CN
3	CRMT_MKTLIST_C_FULL	COMPANY_TITLE	TSAD3	TITLE	REF	1	CN
4	CRMT_MKTLIST_C_FULL	COMP_LEGAL_FORM	TB019	LEGAL_ENTY	KEY	1	CN
5	CRMT_MKTLIST_C_FULL	COUNTRY	T005	LAND1	REF	1	CN
6	CRMT_MKTLIST_C_FULL	LANGU_CORR	T002	SPRAS
7	CRMT_MKTLIST_C_FULL	REGION	T005S	BLAND	REF	C	CN

History

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