SMI_USR_PROFILE - User Profile

User Profile information is stored in SAP table SMI_USR_PROFILE.
It is part of development package BS_SOMI_DATA_MODELS in software component CA-EPT-SMI. This development package consists of objects that can be grouped under "Datta Models for Social Media Intelligence".

Fields for table SMI_USR_PROFILE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	*
DATAPROVIDERNAME	Data Provider Name	X	SMI_DATAPROVIDERNAME	CHAR	20
USERIDINDATAPROVIDER	Social Media User ID in Data Provider	X	SMI_USERIDINDATAPROVIDER	CHAR	160
FIRSTNAME	First Name		SMI_FNAME	CHAR	510
LASTNAME	Last Name		SMI_LNAME	CHAR	510
NICKNAME	Nickname		SMI_NICKNAME	CHAR	160
PHOTOURL	Social User Profile Image URL		SMI_SOCIALUSERIMAGEURL	CHAR	1024
PROFILEURL	Link to User Profile in a Social Media Channel		SMI_SOCIALUSERPROFILELINK	CHAR	510
AGE	Social Media User Age		SMI_AGE	CHAR	6
GENDER	Gender		SMI_GENDERCODE	CHAR	2
BIRTHDAY	Birth Day		SMI_BIRTHDAY	CHAR	4
BIRTHMONTH	Birth Month		SMI_BIRTHMONTH	CHAR	4
BIRTHYEAR	Birth Year		SMI_BIRTHYEAR	CHAR	8
COUNTRY	Country/Region Key		LAND1	CHAR	6	*
STATE	State Name		SMI_STATE	CHAR	100
CITY	Location		SMI_LOCATIONNAME	CHAR	100
ADDRESS	Social Media User Address		SMI_ADDRESS	STRG	8
BIO	Social Media User Bio		SMI_BIO	STRG	8
THUMBNAILURL	Thumbnail URL		SMI_THUMBNAILURL	CHAR	1024
PROXYEMAIL	Proxy E-mail		SMI_PROXYEMAIL	CHAR	510
LANGUAGE	Languages Known		SMI_LANG	STRG	8
HONORS	Honors		SMI_HONORS	STRG	8
PROFESSIONALHEADLINE	Professional Headline		SMI_PROFESSIONALHEADLINE	STRG	8
INDUSTRY	Industry Name		SMI_INDUSTRY	CHAR	160
SPECIALITIES	Professional Strengths		SMI_SPECIALITIES	STRG	8
RELIGION	Religion		SMI_RELIGION	CHAR	100
INTERESTEDIN	Interests		SMI_INTERESTEDIN	CHAR	510
RELATIONSHIPSTATUS	Relationship Status		SMI_RELATIONSHIPSTATUS	CHAR	100
HOMETOWN	Hometown		SMI_HOMETOWN	CHAR	100
FOLLOWERSCOUNT	Number of Followers		SMI_FOLLOWERSCOUNT	INT4	4
FOLLOWINGCOUNT	Following Count		SMI_FOLLOWINGCOUNT	INT4	4
USERNAME	Social Media User Name		SMI_SOCIALUSERNAME	CHAR	510
NAME	Social Media User Name		SMI_SOCIALUSERNAME	CHAR	510
LOCALE	Language Code		SMI_LOCALE	CHAR	40
ISVERIFIED	Is Account Verified		SMI_ISVERIFIED	CHAR	2
USERTIMEZONE	Time Zone		SMI_TIMEZONE	CHAR	12	*
EDUCATIONLEVEL	Education		SMI_EDUCATIONLEVEL	CHAR	1024
.INCLUDE				SMI_S_USR_PROFILE_CI	0
DUMMY_USR_PROFILE	Dummy Description			CHAR	2