SAP ABAP Table V_SMI_SRCHQRY (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_SMI_SRCHQRY   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 SOCIALMEDIACHANNELDESC SMI_SOCIALMEDIACHANNELDESC SMI_SOCIALMEDIACHANNELDESC CHAR 100   0   Social Media Channel Description  
6 ISSCHEDULINGQUERY SMI_ISSCHEDULINGQUERY SMI_SOC_STATUS CHAR 1   0   Indicator of Scheduling or Streaming  
7 SEARCHQUERYEXECUTIONINTERVAL SMI_SEARCHQUERYEXECUTEINTERVAL SMI_COUNT INT4 10   0   Scheduling Frequency in Minutes  
8 NUMBEROFSOCIALPOSTPERPAGE SMI_NUMBEROFSOCIALPOSTPERPAGE SMI_COUNT INT4 10   0   Number of Social Post Requested per Page  
9 NUMBEROFGETREQUESTSALLOWED SMI_NUMBEROFGETREQUESTSALLOWED SMI_COUNT INT4 10   0   Maximum Number of Queries on Social Media  
10 SOCIALMEDIAQUERYISACTIVE SMI_SOCIALMEDIAQUERYISACTIVE SMI_SOC_STATUS CHAR 1   0   Checks if the Query is Active  
11 SOCIALPOSTSEARCHTERMTEXT SMI_SOCIALPOSTSEARCHTERMTEXT SMI_SOCIALPOSTSEARCHTERMTEXT CHAR 50   0   Search Term  
12 LANGU SMI_LANGUAGE SMI_LANGUAGE CHAR 10   0   Language Description  
13 SEARCHTERMISACTIVE SMI_SEARCHTERM_ACTIVE XFELD CHAR 1   0   Exclude Search Term from the Search Query  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_SMI_SRCHQRY LANGUAGE SMI_VOCLANG LANGUAGE    
2 V_SMI_SRCHQRY SOCIALMEDIACHANNEL SMI_CHNLDEF SOCIALMEDIACHANNEL    
3 V_SMI_SRCHQRY SOCIALPOSTSEARCHTERM SMI_SRCHTERM SOCIALPOSTSEARCHTERM    
History
Last changed by/on SAP  20140802 
SAP Release Created in