SAP ABAP Table SMI_S_SOCIALDATA_BUFFER (Buffer structure for Social Data Table)

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_SOCIALDATA_BUFFER	Table Relationship Diagram
Short Description	Buffer structure for Social Data Table

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

Foreign Keys

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

History

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