SAP SQLD_ST05_READ_GENERIC Function Module for read statements (ST05) from MONI - RDBMS: GENERIC









SQLD_ST05_READ_GENERIC is a standard sqld st05 read generic SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for read statements (ST05) from MONI - RDBMS: GENERIC processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for sqld st05 read generic FM, simply by entering the name SQLD_ST05_READ_GENERIC into the relevant SAP transaction such as SE37 or SE38.

Function Group: SQLD
Program Name: SAPLSQLD
Main Program: SAPLSQLD
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function SQLD_ST05_READ_GENERIC pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'SQLD_ST05_READ_GENERIC'"read statements (ST05) from MONI - RDBMS: GENERIC
  EXPORTING
   ADDONKEY =  "

 IMPORTING
   ADMIN_INFO =  "administrative information on the SQL trace (ST05)

TABLES
*  STATEMENT_SUMMARY =  "list of identical SQL statements (ST05)
*  DDIC_PHYS_TABLES =  "V-VIEWTABLE: View auf Basistabellen eines Views
*  JOIN_COND =  "Internal structure for joins of views
*  SELECT_COND =  "Internal structure for selections of views
*  STATISTICS_DIALOG =  "SAP Workload: Stat. record: Main statistical record
*  STATISTICS_BATCH =  "SAP Workload: Stat. record: Batch: Statistical record
*  TRACE_GAPS =  "SQL Trace Gaps
*  SQL_STATEMENT =  "SAPscript: text lines
*  SQL_EXPLAIN =  "Explain für SQL Trace Download
*  ABAP_PROGRAM =  "information on ABAP program in SQL trace (ST05)
*  ABAP_SOURCE =  "Statement ID / Source text
*  DDIC_TABLES =  "Table headers
*  DDIC_TABLE_FIELDS =  "Table fields
*  DDIC_INDICES =  "Index header
*  DDIC_INDEX_FIELDS =  "Index positions

EXCEPTIONS
   NO_DOWNLOAD_FOUND = 1
.



IMPORTING Parameters details for SQLD_ST05_READ_GENERIC

ADDONKEY -

Data type: BDLADDON-ADDONKEY
Optional: No
Call by Reference: No ( called with pass by value option)

EXPORTING Parameters details for SQLD_ST05_READ_GENERIC

ADMIN_INFO - administrative information on the SQL trace (ST05)

Data type: SQLD_ADMIN
Optional: No
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for SQLD_ST05_READ_GENERIC

STATEMENT_SUMMARY - list of identical SQL statements (ST05)

Data type: SQLD_ST05
Optional: Yes
Call by Reference: Yes

DDIC_PHYS_TABLES - V-VIEWTABLE: View auf Basistabellen eines Views

Data type: SQLD_PHT
Optional: Yes
Call by Reference: Yes

JOIN_COND - Internal structure for joins of views

Data type: SQLD_JOIN
Optional: Yes
Call by Reference: Yes

SELECT_COND - Internal structure for selections of views

Data type: SQLD_SEL
Optional: Yes
Call by Reference: Yes

STATISTICS_DIALOG - SAP Workload: Stat. record: Main statistical record

Data type: SQLD_WDIA
Optional: Yes
Call by Reference: Yes

STATISTICS_BATCH - SAP Workload: Stat. record: Batch: Statistical record

Data type: SQLD_WBTC
Optional: Yes
Call by Reference: Yes

TRACE_GAPS - SQL Trace Gaps

Data type: SQLDTRCGAP
Optional: Yes
Call by Reference: Yes

SQL_STATEMENT - SAPscript: text lines

Data type: SQLD_SQL
Optional: Yes
Call by Reference: Yes

SQL_EXPLAIN - Explain für SQL Trace Download

Data type: SQLD_EXPL
Optional: Yes
Call by Reference: Yes

ABAP_PROGRAM - information on ABAP program in SQL trace (ST05)

Data type: SQLD_ABAP
Optional: Yes
Call by Reference: Yes

ABAP_SOURCE - Statement ID / Source text

Data type: SQLD_ABAPS
Optional: Yes
Call by Reference: Yes

DDIC_TABLES - Table headers

Data type: SQLDSE11TH
Optional: Yes
Call by Reference: Yes

DDIC_TABLE_FIELDS - Table fields

Data type: SQLDSE11TP
Optional: Yes
Call by Reference: Yes

DDIC_INDICES - Index header

Data type: SQLDSE11IH
Optional: Yes
Call by Reference: Yes

DDIC_INDEX_FIELDS - Index positions

Data type: SQLDSE11IP
Optional: Yes
Call by Reference: Yes

EXCEPTIONS details

NO_DOWNLOAD_FOUND - Kein Download gefunden

Data type:
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for SQLD_ST05_READ_GENERIC Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

DATA:
lv_addonkey  TYPE BDLADDON-ADDONKEY, "   
lv_admin_info  TYPE SQLD_ADMIN, "   
lv_no_download_found  TYPE SQLD_ADMIN, "   
lt_statement_summary  TYPE STANDARD TABLE OF SQLD_ST05, "   
lt_ddic_phys_tables  TYPE STANDARD TABLE OF SQLD_PHT, "   
lt_join_cond  TYPE STANDARD TABLE OF SQLD_JOIN, "   
lt_select_cond  TYPE STANDARD TABLE OF SQLD_SEL, "   
lt_statistics_dialog  TYPE STANDARD TABLE OF SQLD_WDIA, "   
lt_statistics_batch  TYPE STANDARD TABLE OF SQLD_WBTC, "   
lt_trace_gaps  TYPE STANDARD TABLE OF SQLDTRCGAP, "   
lt_sql_statement  TYPE STANDARD TABLE OF SQLD_SQL, "   
lt_sql_explain  TYPE STANDARD TABLE OF SQLD_EXPL, "   
lt_abap_program  TYPE STANDARD TABLE OF SQLD_ABAP, "   
lt_abap_source  TYPE STANDARD TABLE OF SQLD_ABAPS, "   
lt_ddic_tables  TYPE STANDARD TABLE OF SQLDSE11TH, "   
lt_ddic_table_fields  TYPE STANDARD TABLE OF SQLDSE11TP, "   
lt_ddic_indices  TYPE STANDARD TABLE OF SQLDSE11IH, "   
lt_ddic_index_fields  TYPE STANDARD TABLE OF SQLDSE11IP. "   

  CALL FUNCTION 'SQLD_ST05_READ_GENERIC'  "read statements (ST05) from MONI - RDBMS: GENERIC
    EXPORTING
         ADDONKEY = lv_addonkey
    IMPORTING
         ADMIN_INFO = lv_admin_info
    TABLES
         STATEMENT_SUMMARY = lt_statement_summary
         DDIC_PHYS_TABLES = lt_ddic_phys_tables
         JOIN_COND = lt_join_cond
         SELECT_COND = lt_select_cond
         STATISTICS_DIALOG = lt_statistics_dialog
         STATISTICS_BATCH = lt_statistics_batch
         TRACE_GAPS = lt_trace_gaps
         SQL_STATEMENT = lt_sql_statement
         SQL_EXPLAIN = lt_sql_explain
         ABAP_PROGRAM = lt_abap_program
         ABAP_SOURCE = lt_abap_source
         DDIC_TABLES = lt_ddic_tables
         DDIC_TABLE_FIELDS = lt_ddic_table_fields
         DDIC_INDICES = lt_ddic_indices
         DDIC_INDEX_FIELDS = lt_ddic_index_fields
    EXCEPTIONS
        NO_DOWNLOAD_FOUND = 1
. " SQLD_ST05_READ_GENERIC




ABAP code using 7.40 inline data declarations to call FM SQLD_ST05_READ_GENERIC

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

"SELECT single ADDONKEY FROM BDLADDON INTO @DATA(ld_addonkey).
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!