SAP ABAP Table CRMD_MKTLIST_MPS (Staging - Import Marketing Prospect Social Media)

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_MPS	Table Relationship Diagram
Short Description	Staging - Import Marketing Prospect Social Media

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	MPS_GUID	☑	CRMT_MKTLIST_LIST_GUID	CRM_MKTLIST_LIST_GUID	RAW	16	0	CRM Marketing: GUID for an External List
7	.INCLUDE	☐				0	0	Social Media Marketing Prospect: Data for external List
8	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
9	SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
10	SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
11	SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
12	SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
13	SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
14	GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
15	NUMBEROFSOCIALUSERCONTACTS	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
16	SOCIALUSERINFLUENCESCOREVALUE	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score

History

Last changed by/on	SAP	20131122
SAP Release Created in