SOCIALDATA - Social Data Definition

Social Data Definition information is stored in SAP table SOCIALDATA.
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 SOCIALDATA

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6
SOCIALDATAUUID	Social Data Identifier	X	SMI_SOCIALDATAUUID	CHAR	64
SOCIALPOST	Social Media Data ID String		SMI_SOCIALPOST	CHAR	100
LANGUAGE	Language Description		SMI_LANGUAGE	CHAR	20
SOCIALMEDIACHANNEL	Social Media Channel Code		SMI_SOCIALMEDIACHANNEL	CHAR	8	SMI_CHNLDEF
CREATEDBYUSER	Created By User ID		SMI_CREATEDBYUSER	CHAR	100
CREATIONDATETIME	Post Creation Timestamp		SMI_CREATIONDATETIME	CHAR	100
SOCIALPOSTTYPE	Type of Feeds Like Video, Photo, Status, Etc.		SMI_SOCIALPOSTTYPE	CHAR	510
SOCIALPOSTLINK	Link to the Post in a Particular Social Media Channel		SMI_SOCIALPOSTLINK	CHAR	510
NUMBEROFPOSITIVEVOTES	Count of Likes or Shares for a Post in Media Channel		SMI_NUMBEROFPOSITIVEVOTES	CHAR	510
LOCATIONNAME	Location		SMI_LOCATIONNAME	CHAR	100
COUNTRYNAME	Country		SMI_COUNTRYNAME	CHAR	100
LONGITUDEMEASURE	Longitude		SMI_LONGITUDEMEASURE	CHAR	100
LATITUDEMEASURE	Latitude		SMI_LATITUDEMEASURE	CHAR	100
SOCIALPOSTACTIONSTATUS	Social Post Action Status		SMI_SOCIALPOSTACTIONSTATUS	CHAR	2
SOCIALPOSTCATEGORY	Categorization of Social Post		SMI_SOCIALPOSTCATEGORY	CHAR	100
CREATIONUSERNAME	Social Media User Name		SMI_CREATIONUSERNAME	CHAR	510
SOCIALPOSTRETRIVEDBYUSER	User Details Used to Retrieve Social Post		SMI_SOCIALPOSTRETRIEVEDBYUSER	CHAR	510
SOCIALPOSTSEARCHTERMTEXT	Search Term		SMI_SOCIALPOSTSEARCHTERMTEXT	CHAR	100
CREATEDAT	Creation Date and Time in System (UTC Timestamp)		SMI_CREATEDAT	DEC	8
SOCIALPOSTTEXT	Mention Text		SMI_SOCIALPOSTTEXT	STRG	8
CREATIONDATETIME_UTC	Creation Date and Time in Socl Media Channel (UTC Timestamp)		SMI_CREATIONDATETIME_UTC	DEC	8
SOCIALPOSTPARENT	Social Media Data ID String		SMI_SOCIALPOST	CHAR	100
SOCIALPOSTROOT	Social Media Data ID String		SMI_SOCIALPOST	CHAR	100
COUNTRYCODE	Country/Region Key		LAND1	CHAR	6
SOCIALDATARETRIEVALMODE	Social Media Data Retrieval Mode		SMI_SOCIALDATARETRIEVALMODE	CHAR	8	SMI_RTREVALMDE
.INCLUDE				CI_SMI_SOCIALDATA	0
.INCLU--AP				CRMT_SOC_POST_APPEND	0
.INCLUDE				CRMT_SOC_POST_INCLUDE	0
INTERNAL_ID	Internal ID of Social Media Post		CRMT_SOC_POST_INTERNAL_ID	CHAR	24
TYPE	Social Media Post Type		CRMT_SOC_DATA_TYPE	CHAR	2
POST_STATUS	Object Status		CRM_J_STATUS	CHAR	10
MAIN_CATEGORY	Assigned Main Category		CRMT_SOC_MAIN_CATEGORY	CHAR	20
SENTIMENT	Sentiment of Social Media Post		CRMT_SOC_DATA_SENTIMENT	CHAR	4	*
SOCIAL_ACC_CODE	ID of Social Media User Account		CRMT_SOC_ACC_CODE	CHAR	8
PROCESSOR	User Name in User Master Record		XUBNAME	CHAR	24	*
REPLY_CREATED_BY	User Name in User Master Record		XUBNAME	CHAR	24	*
CONTENT_UC	Social data content upper case		CRMT_SOC_DATA_CONTENT_UC	CHAR	510
SENDER_USER_ACCOUNT_UC	Upper case of social user account		CRMT_SOC_USER_ACCOUNT_UC	CHAR	200
SENDER_USER_ACCOUNT	Social Media User Account		SMI_SOCIALUSERACCOUNT	CHAR	200
RECEIVER_USER_ACCOUNT	Social Media User Account		SMI_SOCIALUSERACCOUNT	CHAR	200
RECEIVER_USER_ID	Social Media User ID		SMI_SOCIALUSER	CHAR	100
RECEIVER_USER_ACCOUNT_UC	Upper case of social user account		CRMT_SOC_USER_ACCOUNT_UC	CHAR	200