SAP ABAP Table SOCIALUSERINFO (Social User Info Definition)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-EPT-SMI (Application Component) Social Media Intelligence Foundation
     ⤷ BS_SOMI_DATA_MODELS (Package) Datta Models for Social Media Intelligence

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SOCIALUSERINFO	Table Relationship Diagram
Short Description	Social User Info Definition

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SOCIALMEDIACHANNEL	☑	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code	SMI_CHNLDEF
3	SOCIALUSER	☑	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
4	SOCIALUSERPROFILELINK	☐	SMI_SOCIALUSERPROFILELINK	SMI_SOCIALUSERPROFILELINK	CHAR	255	0	Link to User Profile in a Social Media Channel
5	SOCIALUSERACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
6	GENDERCODE	☐	SMI_GENDERCODE	SMI_GENDERCODE	CHAR	1	0	Gender
7	NUMBEROFSOCIALUSERCONTACTS	☐	SMI_NUMBEROFSOCIALUSERCONTACTS	SMI_COUNT	INT4	10	0	Count of User Contacts in Social Media
8	SOCIALUSERINFLUENCESCOREVALUE	☐	SMI_SOCLUSRINFLUENCESCOREVALUE	SMI_SOCLUSRINFLUENCESCOREVALUE	CHAR	20	0	Influence Score
9	CREATIONDATETIME	☐	SMI_CREATIONDATETIME	SMI_DATETIME	CHAR	50	0	Post Creation Timestamp
10	LOCATIONNAME	☐	SMI_LOCATIONNAME	SMI_LOCATIONNAME	CHAR	50	0	Location
11	COUNTRYNAME	☐	SMI_COUNTRYNAME	SMI_COUNTRYNAME	CHAR	50	0	Country
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	SOCIALUSERNAME_UC	☐	SMI_SOCIALUSERNAME_UC	SMI_USERNAME_UC	CHAR	255	0	Social Media User Name in Upper Case
15	CREATEDAT	☐	SMI_CREATEDAT	TZNTSTMPS	DEC	15	0	Creation Date and Time in System (UTC Timestamp)
16	ISUSERIDSURROGATE	☐	SMI_ISUSERIDSURROGATE	SMI_SOC_STATUS	CHAR	1	0	Is Social Media User ID Surrogate
17	SOCIALUSERIMAGELINK	☐	SMI_SOCIALUSERIMAGEURL	SMI_SOCIALUSERIMAGEURL	CHAR	512	0	Social User Profile Image URL
18	SOCIALUSERTYPE	☐	SMI_SOCIALUSERTYPE	SMI_SOCIALUSERTYPE	CHAR	4	0	Social User Type
19	ISPSEUDOUSER	☐	SMI_ISPSEUDOUSER	SMI_SOC_STATUS	CHAR	1	0	Is User a Pseudo User

Foreign Keys

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

History

Last changed by/on	SAP	20140802
SAP Release Created in	747