SAP SMI_S_SEARCHQUERY table - Social Post Search Query Structure details in SAP

SAP SMI_S_SEARCHQUERY table summary

Object Name: SMI_S_SEARCHQUERY
Dictionary Type: Structure
Description: Social Post Search Query Structure

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

Details

SMI_S_SEARCHQUERY-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:
Conversion Routine:
Domain Name: SMI_UNIQUE_ID
MemoryID:
AppClass:
SHLP: SMI_SOCIALMEDIACHANNEL
SHLP Field: SOCIALMEDIACHANNEL
ConvExit:

See all SAP tables containing field SOCIALMEDIACHANNEL

SMI_S_SEARCHQUERY-LANGUAGE table field - Language Key ▼

Description: Language Key
Field Name: LANGUAGE
Data Element: SPRAS
Data Type: LANG
length (Dec): 1(0)
Check table: *
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_S_SEARCHQUERY-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:
Conversion Routine:
Domain Name: SMI_UNIQUE_ID
MemoryID:
AppClass:
SHLP: SMI_SOCIALPOSTSEARCHTERM
SHLP Field: SOCIALPOSTSEARCHTERM
ConvExit:

See all SAP tables containing field SOCIALPOSTSEARCHTERM

SMI_S_SEARCHQUERY-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_S_SEARCHQUERY-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_S_SEARCHQUERY-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_S_SEARCHQUERY-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_S_SEARCHQUERY-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_S_SEARCHQUERY-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_S_SEARCHQUERY-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_S_SEARCHQUERY-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

View list of all SAP tables(S4H/ECC)

Select data from SAP table