SAP ABAP Table SOCIALDATA (Social Data 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	SOCIALDATA	Table Relationship Diagram
Short Description	Social Data 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	SOCIALDATAUUID	☑	SMI_SOCIALDATAUUID	SMI_SOCIALDATAUUID	CHAR	32	0	Social Data Identifier
3	SOCIALPOST	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
4	LANGUAGE	☐	SMI_LANGUAGE	SMI_LANGUAGE	CHAR	10	0	Language Description
5	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code	SMI_CHNLDEF
6	CREATEDBYUSER	☐	SMI_CREATEDBYUSER	SMI_USER	CHAR	50	0	Created By User ID
7	CREATIONDATETIME	☐	SMI_CREATIONDATETIME	SMI_DATETIME	CHAR	50	0	Post Creation Timestamp
8	SOCIALPOSTTYPE	☐	SMI_SOCIALPOSTTYPE	SMI_SOCIALPOSTTYPE	CHAR	255	0	Type of Feeds Like Video, Photo, Status, Etc.
9	SOCIALPOSTLINK	☐	SMI_SOCIALPOSTLINK	SMI_SOCIALPOSTLINK	CHAR	255	0	Link to the Post in a Particular Social Media Channel
10	NUMBEROFPOSITIVEVOTES	☐	SMI_NUMBEROFPOSITIVEVOTES	SMI_NUMBEROFPOSITIVEVOTES	CHAR	255	0	Count of Likes or Shares for a Post in Media Channel
11	LOCATIONNAME	☐	SMI_LOCATIONNAME	SMI_LOCATIONNAME	CHAR	50	0	Location
12	COUNTRYNAME	☐	SMI_COUNTRYNAME	SMI_COUNTRYNAME	CHAR	50	0	Country
13	LONGITUDEMEASURE	☐	SMI_LONGITUDEMEASURE	SMI_GEOMEASURE	CHAR	50	0	Longitude
14	LATITUDEMEASURE	☐	SMI_LATITUDEMEASURE	SMI_GEOMEASURE	CHAR	50	0	Latitude
15	SOCIALPOSTACTIONSTATUS	☐	SMI_SOCIALPOSTACTIONSTATUS	SMI_SOCIALPOSTACTIONSTATUS	CHAR	1	0	Social Post Action Status
16	SOCIALPOSTCATEGORY	☐	SMI_SOCIALPOSTCATEGORY	SMI_SOCIALPOSTCATEGORY	CHAR	50	0	Categorization of Social Post
17	CREATIONUSERNAME	☐	SMI_CREATIONUSERNAME	SMI_USERNAME	CHAR	255	0	Social Media User Name
18	SOCIALPOSTRETRIVEDBYUSER	☐	SMI_SOCIALPOSTRETRIEVEDBYUSER	SMI_USERNAME	CHAR	255	0	User Details Used to Retrieve Social Post
19	SOCIALPOSTSEARCHTERMTEXT	☐	SMI_SOCIALPOSTSEARCHTERMTEXT	SMI_SOCIALPOSTSEARCHTERMTEXT	CHAR	50	0	Search Term
20	CREATEDAT	☐	SMI_CREATEDAT	TZNTSTMPS	DEC	15	0	Creation Date and Time in System (UTC Timestamp)
21	SOCIALPOSTTEXT	☐	SMI_SOCIALPOSTTEXT	SMI_SOCIALPOSTTEXT	STRG	0	0	Mention Text
22	CREATIONDATETIME_UTC	☐	SMI_CREATIONDATETIME_UTC	TZNTSTMPS	DEC	15	0	Creation Date and Time in Socl Media Channel (UTC Timestamp)
23	SOCIALPOSTPARENT	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
24	SOCIALPOSTROOT	☐	SMI_SOCIALPOST	SMI_SOCIALPOST	CHAR	50	0	Social Media Data ID String
25	COUNTRYCODE	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
26	SOCIALDATARETRIEVALMODE	☐	SMI_SOCIALDATARETRIEVALMODE	SMI_SOCIALDATARETRIEVALMODE	CHAR	4	0	Social Media Data Retrieval Mode	SMI_RTREVALMDE
27	.INCLU--AP	☐				0	0	Append strcuture of CRM social media post
28	.INCLUDE	☐				0	0	Reuse strcuture to include CRM post fields into BS_FND layer
29	INTERNAL_ID	☐	CRMT_SOC_POST_INTERNAL_ID	CRM_SOC_POST_INTERNAL_ID	CHAR	12	0	Internal ID of Social Media Post
30	TYPE	☐	CRMT_SOC_DATA_TYPE	CRM_SOC_DATA_TYPE	CHAR	1	0	Social Media Post Type
31	POST_STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
32	MAIN_CATEGORY	☐	CRMT_SOC_MAIN_CATEGORY	CHAR10	CHAR	10	0	Assigned Main Category
33	SENTIMENT	☐	CRMT_SOC_DATA_SENTIMENT	CRM_SOC_DATA_SENTIMENT	CHAR	2	0	Sentiment of Social Media Post	*
34	SOCIAL_ACC_CODE	☐	CRMT_SOC_ACC_CODE	CHAR4	CHAR	4	0	ID of Social Media User Account
35	PROCESSOR	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
36	REPLY_CREATED_BY	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
37	CONTENT_UC	☐	CRMT_SOC_DATA_CONTENT_UC	CHAR255	CHAR	255	0	Social data content upper case
38	SENDER_USER_ACCOUNT_UC	☐	CRMT_SOC_USER_ACCOUNT_UC	CHAR100	CHAR	100	0	Upper case of social user account
39	SENDER_USER_ACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
40	RECEIVER_USER_ACCOUNT	☐	SMI_SOCIALUSERACCOUNT	SMI_SOCIALUSERACCOUNT	CHAR	100	0	Social Media User Account
41	RECEIVER_USER_ID	☐	SMI_SOCIALUSER	SMI_USER	CHAR	50	0	Social Media User ID
42	RECEIVER_USER_ACCOUNT_UC	☐	CRMT_SOC_USER_ACCOUNT_UC	CHAR100	CHAR	100	0	Upper case of social user account

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SOCIALDATA	SOCIALDATARETRIEVALMODE	SMI_RTREVALMDE	SOCIALDATARETRIEVALMODE
2	SOCIALDATA	SOCIALMEDIACHANNEL	SMI_CHNLDEF	SOCIALMEDIACHANNEL

History

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