SAP ABAP Table SMI_S_SOCIALUSERINFO_BUFFER (Buffer structure for SOCIALUSERINFO)

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	INTTAB	Structure
Structure	SMI_S_SOCIALUSERINFO_BUFFER	Table Relationship Diagram
Short Description	Buffer structure for SOCIALUSERINFO

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	Structure for socialuserinfo table
2	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
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
20	STATUS	☐	SMI_ACTION_STATUS	SMI_ACTION_STATUS	CHAR	1	0	Database action status

History

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