SAP ABAP Table SMI_SRCHQRY (Search Query 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 SMI_SRCHQRY   Table Relationship Diagram
Short Description Search Query Definition    
Delivery and Maintenance
Pool/cluster      
Delivery Class G   Customizing table, protected against SAP Upd., only INS all. 
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 SOCIALMEDIACHANNEL SMI_SOCIALMEDIACHANNEL SMI_UNIQUE_ID CHAR 4   0   Social Media Channel Code SMI_CHNLDEF
3 LANGUAGE SPRAS SPRAS LANG 1   0   Language Key SMI_VOCLANG
4 SOCIALPOSTSEARCHTERM SMI_SOCIALPOSTSEARCHTERM SMI_UNIQUE_ID CHAR 4   0   Keyword IDs from Search Terms SMI_SRCHTERM
5 ISSCHEDULINGQUERY SMI_ISSCHEDULINGQUERY SMI_SOC_STATUS CHAR 1   0   Indicator of Scheduling or Streaming  
6 NUMBEROFSOCIALPOSTPERPAGE SMI_NUMBEROFSOCIALPOSTPERPAGE SMI_COUNT INT4 10   0   Number of Social Post Requested per Page  
7 NUMBEROFGETREQUESTSALLOWED SMI_NUMBEROFGETREQUESTSALLOWED SMI_COUNT INT4 10   0   Maximum Number of Queries on Social Media  
8 LASTPROCESSEDSOCIALPOST SMI_LASTPROCESSEDSOCIALPOST SMI_LASTPROCESSEDSOCIALPOST CHAR 50   0   Last Retrieved Social Post Details  
9 SOCIALMEDIAQUERYISACTIVE SMI_SOCIALMEDIAQUERYISACTIVE SMI_SOC_STATUS CHAR 1   0   Checks if the Query is Active  
10 SEARCHQUERYEXECUTIONINTERVAL SMI_SEARCHQUERYEXECUTEINTERVAL SMI_COUNT INT4 10   0   Scheduling Frequency in Minutes  
11 LASTCHANGEDDATETIME SMI_LASTCHANGEDDATETIME SMI_DATETIME CHAR 50   0   Search Query Last Changed Timestamp  
12 CREATIONDATETIME SMI_CREATIONDATETIME SMI_DATETIME CHAR 50   0   Post Creation Timestamp  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SMI_SRCHQRY LANGUAGE SMI_VOCLANG LANGUAGE    
2 SMI_SRCHQRY SOCIALMEDIACHANNEL SMI_CHNLDEF SOCIALMEDIACHANNEL    
3 SMI_SRCHQRY SOCIALPOSTSEARCHTERM SMI_SRCHTERM SOCIALPOSTSEARCHTERM    
History
Last changed by/on SAP  20131122 
SAP Release Created in 747