I_SrchQrySttng

View to fetch data from SMI_SRCHQRY | view: ISRCHQRYSTTNG | Extraction: Not supported | Component: Social Media Intelligence Foundation
Tables used: SMI_SRCHQRY
Column Name Description
SocialMediaChannel FK Social Media Channel Code
SocialPostSearchTerm FK Keyword IDs from Search Terms
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsSocialMediaQueryActivated Checks if the Query is Active Show values
Column Name Description Domain name
SclMdaQryLstActivatedDateTime Search Query Last Activated Timestamp (UTC) TZNTSTMPL
Master Data Relations Join Conditions
Social Media Channel Code
  • Social Media Channel Code
  • Client
  • I_SRCHQRYSTTNG.SOCIALMEDIACHANNEL == SMI_CHNLDEF.SOCIALMEDIACHANNEL
  • I_SRCHQRYSTTNG.MANDT == SMI_CHNLDEF.CLIENT
Other Relations Join Conditions
Keyword IDs from Search Terms
  • Keyword IDs from Search Terms
  • Client