SAP SMI_SRCHQRY table - Search Query Definition details in SAP

SAP SMI_SRCHQRY table summary

Object Name: SMI_SRCHQRY
Dictionary Type: Transparent table
Description: Search Query Definition

Field list for SMI_SRCHQRY table on an S/4 SAP system

Details

SMI_SRCHQRY-CLIENT table field - Client ▼

Description: Client
Field Name: CLIENT
Data Element: MANDT
Data Type: CLNT
length (Dec): 3(0)
Check table: *
Conversion Routine:
Domain Name: MANDT
MemoryID:
AppClass: SAP
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CLIENT

SMI_SRCHQRY-SOCIALMEDIACHANNEL table field - Social Media Channel Code ▼

Description: Social Media Channel Code
Field Name: SOCIALMEDIACHANNEL
Data Element: SMI_SOCIALMEDIACHANNEL
Data Type: CHAR
length (Dec): 4(0)
Check table: SMI_CHNLDEF
Conversion Routine:
Domain Name: SMI_UNIQUE_ID
MemoryID:
AppClass:
SHLP: SMI_SOCIALMEDIACHANNEL
SHLP Field: SOCIALMEDIACHANNEL
ConvExit:

See all SAP tables containing field SOCIALMEDIACHANNEL

SMI_SRCHQRY-LANGUAGE table field - Language Key ▼

Description: Language Key
Field Name: LANGUAGE
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table: SMI_VOCLANG
Conversion Routine: ISOLA
Domain Name: SPRAS
MemoryID: SPR
AppClass: STXD
SHLP: H_T002
SHLP Field: SPRAS
ConvExit: ISOLA

See all SAP tables containing field LANGUAGE

SMI_SRCHQRY-SOCIALPOSTSEARCHTERM table field - Keyword IDs from Search Terms ▼

Description: Keyword IDs from Search Terms
Field Name: SOCIALPOSTSEARCHTERM
Data Element: SMI_SOCIALPOSTSEARCHTERM
Data Type: CHAR
length (Dec): 4(0)
Check table: SMI_SRCHTERM
Conversion Routine:
Domain Name: SMI_UNIQUE_ID
MemoryID:
AppClass:
SHLP: SMI_SOCIALPOSTSEARCHTERM
SHLP Field: SOCIALPOSTSEARCHTERM
ConvExit:

See all SAP tables containing field SOCIALPOSTSEARCHTERM

SMI_SRCHQRY-ISSCHEDULINGQUERY table field - Indicator of Scheduling or Streaming ▼

Description: Indicator of Scheduling or Streaming
Field Name: ISSCHEDULINGQUERY
Data Element: SMI_ISSCHEDULINGQUERY
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOC_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field ISSCHEDULINGQUERY

SMI_SRCHQRY-NUMBEROFSOCIALPOSTPERPAGE table field - Number of Social Post Requested per Page ▼

Description: Number of Social Post Requested per Page
Field Name: NUMBEROFSOCIALPOSTPERPAGE
Data Element: SMI_NUMBEROFSOCIALPOSTPERPAGE
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SMI_COUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMBEROFSOCIALPOSTPERPAGE

SMI_SRCHQRY-NUMBEROFGETREQUESTSALLOWED table field - Maximum Number of Queries on Social Media ▼

Description: Maximum Number of Queries on Social Media
Field Name: NUMBEROFGETREQUESTSALLOWED
Data Element: SMI_NUMBEROFGETREQUESTSALLOWED
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SMI_COUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field NUMBEROFGETREQUESTSALLOWED

SMI_SRCHQRY-LASTPROCESSEDSOCIALPOST table field - Last Retrieved Social Post Details ▼

Description: Last Retrieved Social Post Details
Field Name: LASTPROCESSEDSOCIALPOST
Data Element: SMI_LASTPROCESSEDSOCIALPOST
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_LASTPROCESSEDSOCIALPOST
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTPROCESSEDSOCIALPOST

SMI_SRCHQRY-SOCIALMEDIAQUERYISACTIVE table field - Checks if the Query is Active ▼

Description: Checks if the Query is Active
Field Name: SOCIALMEDIAQUERYISACTIVE
Data Element: SMI_SOCIALMEDIAQUERYISACTIVE
Data Type: CHAR
length (Dec): 1(0)
Check table:
Conversion Routine:
Domain Name: SMI_SOC_STATUS
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SOCIALMEDIAQUERYISACTIVE

SMI_SRCHQRY-SEARCHQUERYEXECUTIONINTERVAL table field - Scheduling Frequency in Minutes ▼

Description: Scheduling Frequency in Minutes
Field Name: SEARCHQUERYEXECUTIONINTERVAL
Data Element: SMI_SEARCHQUERYEXECUTEINTERVAL
Data Type: INT4
length (Dec): 10(0)
Check table:
Conversion Routine:
Domain Name: SMI_COUNT
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field SEARCHQUERYEXECUTIONINTERVAL

SMI_SRCHQRY-LASTCHANGEDDATETIME table field - Search Query Last Changed Timestamp ▼

Description: Search Query Last Changed Timestamp
Field Name: LASTCHANGEDDATETIME
Data Element: SMI_LASTCHANGEDDATETIME
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_DATETIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTCHANGEDDATETIME

SMI_SRCHQRY-CREATIONDATETIME table field - Post Creation Timestamp ▼

Description: Post Creation Timestamp
Field Name: CREATIONDATETIME
Data Element: SMI_CREATIONDATETIME
Data Type: CHAR
length (Dec): 50(0)
Check table:
Conversion Routine:
Domain Name: SMI_DATETIME
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field CREATIONDATETIME

SMI_SRCHQRY-LASTACTIVATEDDATETIME table field - Search Query Last Activated Timestamp (UTC) ▼

Description: Search Query Last Activated Timestamp (UTC)
Field Name: LASTACTIVATEDDATETIME
Data Element: SMI_LASTACTIVATEDDATETIME
Data Type: DEC
length (Dec): 21(7)
Check table:
Conversion Routine:
Domain Name: TZNTSTMPL
MemoryID:
AppClass:
SHLP:
SHLP Field:
ConvExit:

See all SAP tables containing field LASTACTIVATEDDATETIME

View list of all SAP tables(S4H/ECC)

Select data from SAP table