SMI_SRCHQRY - Search Query Definition

Search Query Definition information is stored in SAP table SMI_SRCHQRY.
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_SRCHQRY

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
CLIENT	Client	X	MANDT	CLNT	6	*
SOCIALMEDIACHANNEL	Social Media Channel Code	X	SMI_SOCIALMEDIACHANNEL	CHAR	8	SMI_CHNLDEF
LANGUAGE	Language Key	X	SPRAS	LANG	2	SMI_VOCLANG
SOCIALPOSTSEARCHTERM	Keyword IDs from Search Terms	X	SMI_SOCIALPOSTSEARCHTERM	CHAR	8	SMI_SRCHTERM
ISSCHEDULINGQUERY	Indicator of Scheduling or Streaming		SMI_ISSCHEDULINGQUERY	CHAR	2
NUMBEROFSOCIALPOSTPERPAGE	Number of Social Post Requested per Page		SMI_NUMBEROFSOCIALPOSTPERPAGE	INT4	4
NUMBEROFGETREQUESTSALLOWED	Maximum Number of Queries on Social Media		SMI_NUMBEROFGETREQUESTSALLOWED	INT4	4
LASTPROCESSEDSOCIALPOST	Last Retrieved Social Post Details		SMI_LASTPROCESSEDSOCIALPOST	CHAR	100
SOCIALMEDIAQUERYISACTIVE	Checks if the Query is Active		SMI_SOCIALMEDIAQUERYISACTIVE	CHAR	2
SEARCHQUERYEXECUTIONINTERVAL	Scheduling Frequency in Minutes		SMI_SEARCHQUERYEXECUTEINTERVAL	INT4	4
LASTCHANGEDDATETIME	Search Query Last Changed Timestamp		SMI_LASTCHANGEDDATETIME	CHAR	100
CREATIONDATETIME	Post Creation Timestamp		SMI_CREATIONDATETIME	CHAR	100
LASTACTIVATEDDATETIME	Search Query Last Activated Timestamp (UTC)		SMI_LASTACTIVATEDDATETIME	DEC	11