SAP ABAP Table SMI_S_SEARCHQUERY (Social Post Search Query Structure)

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_SEARCHQUERY	Table Relationship Diagram
Short Description	Social Post Search Query Structure

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	SOCIALMEDIACHANNEL	☐	SMI_SOCIALMEDIACHANNEL	SMI_UNIQUE_ID	CHAR	4	0	Social Media Channel Code
2	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
3	SOCIALPOSTSEARCHTERM	☐	SMI_SOCIALPOSTSEARCHTERM	SMI_UNIQUE_ID	CHAR	4	0	Keyword IDs from Search Terms
4	ISSCHEDULINGQUERY	☐	SMI_ISSCHEDULINGQUERY	SMI_SOC_STATUS	CHAR	1	0	Indicator of Scheduling or Streaming
5	NUMBEROFSOCIALPOSTPERPAGE	☐	SMI_NUMBEROFSOCIALPOSTPERPAGE	SMI_COUNT	INT4	10	0	Number of Social Post Requested per Page
6	NUMBEROFGETREQUESTSALLOWED	☐	SMI_NUMBEROFGETREQUESTSALLOWED	SMI_COUNT	INT4	10	0	Maximum Number of Queries on Social Media
7	LASTPROCESSEDSOCIALPOST	☐	SMI_LASTPROCESSEDSOCIALPOST	SMI_LASTPROCESSEDSOCIALPOST	CHAR	50	0	Last Retrieved Social Post Details
8	SOCIALMEDIAQUERYISACTIVE	☐	SMI_SOCIALMEDIAQUERYISACTIVE	SMI_SOC_STATUS	CHAR	1	0	Checks if the Query is Active
9	SEARCHQUERYEXECUTIONINTERVAL	☐	SMI_SEARCHQUERYEXECUTEINTERVAL	SMI_COUNT	INT4	10	0	Scheduling Frequency in Minutes
10	LASTCHANGEDDATETIME	☐	SMI_LASTCHANGEDDATETIME	SMI_DATETIME	CHAR	50	0	Search Query Last Changed Timestamp
11	CREATIONDATETIME	☐	SMI_CREATIONDATETIME	SMI_DATETIME	CHAR	50	0	Post Creation Timestamp

History

Last changed by/on	SAP	20131122
SAP Release Created in