SAP ABAP Table VCRMM_MP_SMIUSER (Change Document Structure; Generated by RSSCD000)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MKT-EAL (Application Component) External List Management
     ⤷ CRM_MKTHV_MC (Package) CRM Marketing: Marketing Contact - High Volume

Basic Data

Table Category	INTTAB	Structure
Structure	VCRMM_MP_SMIUSER	Table Relationship Diagram
Short Description	Change Document Structure; Generated by RSSCD000

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	Marketing Prospect Social Media User Database
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	.INCLUDE	☐				0	0	Marketing Prospect Social Media Users Key
4	RECORD_GUID	☐	CRMT_MP_SOCIAL_USER_GUID	SYSUUID	RAW	16	0	Marketing Prospect: GUID of Social Media User
5	MP_GUID	☐	CRMT_MKTHV_MC_GENERIC_GUID	SYSUUID	RAW	16	0	CRM Marketing: Marketing Prospect Generic GUID
6	.INCLUDE	☐				0	0	Marketing Prospect Social Media User Data
7	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code	SMI_CHNLDEF
8	SOCIALUSER	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
9	.INCLUDE	☐				0	0	Marketing Prospect Social Media User Data
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	NUMBEROFSOCIALUSERCONTACTS	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
13	SOCIALUSERINFLUENCESCOREVALUE	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score
14	SOCIALUSERNAME	☐	SMI_SOCIALUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
15	SOCIALUSEREMAILADDRESS	☐	SMI_SOCIALUSEREMAILADDRESS	SMI_SOCIALUSEREMAILADDRESS	CHAR	255	0	Social Media User E-mail Address
16	GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
17	SOCIALUSERNAME_UC	☐	SMI_SOCIALUSERNAME_UC	SMI_USERNAME_UC	CHAR	255	0	Social Media User Name in Upper Case
18	SOCIALUSERACCOUNT_UC	☐	SMI_SOCIALUSERACCOUNT_UC	SMI_SOCIALUSERACCOUNT_UC	CHAR	100	0	Social Media User Account
19	.INCLUDE	☐				0	0	Structures for generating change document update programs
20	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VCRMM_MP_SMIUSER	SOCIALMEDIACHANNEL	SMI_CHNLDEF	SOCIALMEDIACHANNEL

History

Last changed by/on	SAP	20131122
SAP Release Created in