SAP Reports / Programs

comments icon Comments

ESH_QUERY_LOG_MONITOR SAP ABAP Report - Enterprise Search Query Log







ESH_QUERY_LOG_MONITOR is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The SAP NetWeaver Enterprise Search Query Log records data about search queries and search executions...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter ESH_QUERY_LOG_MONITOR into the relevant SAP transactions such as SE38 or SE80


Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

ESH_QUERY_LOG - Enterprise Search Query Log


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT ESH_QUERY_LOG_MONITOR. "Basic submit
SUBMIT ESH_QUERY_LOG_MONITOR AND RETURN. "Return to original report after report execution complete
SUBMIT ESH_QUERY_LOG_MONITOR VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: PR_STI1H = Last Hour
Selection Text: PR_STI5M = Last 5 Mins
Selection Text: PR_STINT = Other Selection
Selection Text: PR_STNRE = No Limitation
Selection Text: PR_STTOD = Today
Selection Text: PR_STYES = Yesterday
Selection Text: P_AREG_Q = Queries with User Action Only
Selection Text: P_CATEG = Category
Selection Text: P_CONNID = Connector ID
Selection Text: P_ERRORS = Executions with Errors Only
Selection Text: P_FROM_D = From Date
Selection Text: P_FROM_T = From Time
Selection Text: P_KWD = Keyword
Selection Text: P_NOFHS = Maximum No. of Hits
Selection Text: P_OTYP = Object Type
Selection Text: P_QLANGU = Query Language
Selection Text: P_QRYTXT = Search Term/Query Content
Selection Text: P_QTYPE = Query Type
Selection Text: P_SUCC_Q = Successful Executions Only
Selection Text: P_TBSD_O = Term-Based Queries Only
Selection Text: P_TO_D = To Date
Selection Text: P_TO_T = To Time
Selection Text: P_USER = Execution User
Title: Enterprise Search Query Log
Text Symbol: 040 = Failed
Text Symbol: 041 = Timeout
Text Symbol: 042 = No messages
Text Symbol: 043 = Errors and Messages for Selected Log Entry
Text Symbol: 044 = Query (User Input Format)
Text Symbol: 045 = Query (Resolved Internal Format)
Text Symbol: 046 = No Query
Text Symbol: 047 = Search Query Scope
Text Symbol: 048 = No actions recorded
Text Symbol: 049 = Click Registrator: User Actions on Result List
Text Symbol: 050 = Search request could not be reinstantiated
Text Symbol: 051 = Output Error
Text Symbol: 052 = Output Error
Text Symbol: 053 = Error reading metadata buffer





Text Symbol: 039 = Actions
Text Symbol: 001 = Time Interval
Text Symbol: 002 = No Limitation
Text Symbol: 003 = Yesterday
Text Symbol: 004 = Today
Text Symbol: 005 = Last Hour
Text Symbol: 006 = Last 5 Mins
Text Symbol: 007 = Other Selection
Text Symbol: 008 = Asynchronous Request
Text Symbol: 009 = Search Request: Search Engine Errors
Text Symbol: 010 = Search Query Executions
Text Symbol: 011 = Status
Text Symbol: 012 = Date
Text Symbol: 013 = Time
Text Symbol: 014 = System
Text Symbol: 015 = Client
Text Symbol: 016 = Hits
Text Symbol: 017 = Total Hits
Text Symbol: 018 = Select a single row
Text Symbol: 019 = Select a valid row
Text Symbol: 020 = Scope
Text Symbol: 021 = application
Text Symbol: 022 = Search Request in Application Format
Text Symbol: 023 = Search Request in TREX Format
Text Symbol: 024 = Key not found. Cannot execute again
Text Symbol: 025 = Search request has not been logged in full
Text Symbol: 026 = Cannot execute again
Text Symbol: 027 = Connector or request currently not searchable
Text Symbol: 028 = Object Type
Text Symbol: 029 = Type
Text Symbol: 030 = Expand Scope
Text Symbol: 031 = Collapse Scope
Text Symbol: 032 = Scope Element
Text Symbol: 033 = Single Query
Text Symbol: 034 = Output Error
Text Symbol: 035 = ALV Error
Text Symbol: 036 = Output Error
Text Symbol: 037 = Output Error
Text Symbol: 038 = Mode





INCLUDES used within this REPORT ESH_QUERY_LOG_MONITOR

No INCLUDES are used within this REPORT code!


TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

ICON_CREATE
          CALL FUNCTION 'ICON_CREATE'
            EXPORTING
              name   = icon_column_right      " icon_positive
              info   = 'Expand Scope'(030)
            IMPORTING
              result = -fldicon.

ICON_CREATE
          CALL FUNCTION 'ICON_CREATE'
            EXPORTING
              name   = icon_previous_value    " icon_negative
              info   = 'Collapse Scope'(031)
            IMPORTING
              result = -fldicon.

ICON_CREATE
          CALL FUNCTION 'ICON_CREATE'
            EXPORTING
              name   = icon_element
              info   = 'Scope Element'(032)
            IMPORTING
              result = -fldicon.

ICON_CREATE
        CALL FUNCTION 'ICON_CREATE'
          EXPORTING
            name   = icon_radiobutton
            info   = 'Single Query'(033)
          IMPORTING
            result = -fldicon.

F4IF_INT_TABLE_VALUE_REQUEST
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      retfield        = 'OBJECT_TYPE_NAME'
      dynpprog        = sy-repid
      dynpnr          = sy-dynnr
      dynprofield     = 'P_OTYP'
      value_org       = 'S'
    TABLES
      field_tab       = lt_fieldtab
      value_tab       = lt_active_otypt
    EXCEPTIONS
      parameter_error = 1
      no_values_found = 2
      OTHERS          = 3.

F4IF_INT_TABLE_VALUE_REQUEST
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      retfield        = 'CONNECTOR_ID'
      dynpprog        = sy-repid
      dynpnr          = sy-dynnr
      dynprofield     = 'P_CONNID'
      value_org       = 'S'
    TABLES
      field_tab       = lt_fieldtab
      value_tab       = lt_conn_f4
    EXCEPTIONS
      parameter_error = 1
      no_values_found = 2
      OTHERS          = 3.

F4IF_INT_TABLE_VALUE_REQUEST
  CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
    EXPORTING
      retfield        = 'CATEGORY'
      dynpprog        = sy-repid
      dynpnr          = sy-dynnr
      dynprofield     = 'P_CATEG'
      value_org       = 'S'
    TABLES
      field_tab       = lt_fieldtab
      value_tab       = lt_categ_f4
    EXCEPTIONS
      parameter_error = 1
      no_values_found = 2
      OTHERS          = 3.


Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name ESH_QUERY_LOG_MONITOR or its description.


   
 

ESH_QUERY_LOG_MONITOR - Enterprise Search Query Log
ESH_QUERY_LOG_MONITOR - Enterprise Search Query Log
ESH_QP_INVALIDATE_QG_CACHE - Invalidate ESH Query Grammar Cache
ESH_QP_INVALIDATE_QG_CACHE - Invalidate ESH Query Grammar Cache
ESH_QP_CHECK_QUERY_GRAMMAR - Check ESH Query Parser Grammar
ESH_QP_CHECK_QUERY_GRAMMAR - Check ESH Query Parser Grammar