SAP Reports / Programs | Cross-Application Components | General Application Functions | Business Application Support(CA-GTF-BS) SAP CA

CNVCDOP_SQLTR_DOWNLD_TRACEFILE SAP ABAP Report - Download SQL trace file from Application server to Frontend







CNVCDOP_SQLTR_DOWNLD_TRACEFILE is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter CNVCDOP_SQLTR_DOWNLD_TRACEFILE 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

CNV_CDOP_TRFILEDWNLD - CDOP:Download Trace file to Frontend


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 CNVCDOP_SQLTR_DOWNLD_TRACEFILE. "Basic submit
SUBMIT CNVCDOP_SQLTR_DOWNLD_TRACEFILE AND RETURN. "Return to original report after report execution complete
SUBMIT CNVCDOP_SQLTR_DOWNLD_TRACEFILE 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: P_APPFIL = File on application server
Selection Text: P_FLGOVR = Overwrite
Selection Text: P_SQFILE = Target file on frontend
Title: Download SQL trace file from Application server to Frontend
Text Symbol: 001 = Download File Parameters


INCLUDES used within this REPORT CNVCDOP_SQLTR_DOWNLD_TRACEFILE

INCLUDE CNVCDOPCA_SQLTR_DOWNLD_TOP.


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:

KD_GET_FILENAME_ON_F4 CALL FUNCTION 'KD_GET_FILENAME_ON_F4' EXPORTING program_name = 'CNVCDOP_SQLTR_DOWNLD_TRACEFILE' dynpro_number = '1000' field_name = 'P_SQFILE' CHANGING file_name = p_sqfile EXCEPTIONS mask_too_long = 1 OTHERS = 2.

AUTHORITY_CHECK_DATASET CALL FUNCTION 'AUTHORITY_CHECK_DATASET' EXPORTING * PROGRAM = activity = sabc_act_read filename = gv_auth_filename EXCEPTIONS no_authority = 1 activity_unknown = 2 OTHERS = 3.

WS_QUERY CALL FUNCTION 'WS_QUERY' EXPORTING * ENVIRONMENT = ' ' filename = p_sqfile query = 'FE' * WINID = ' ' IMPORTING return = gv_return EXCEPTIONS inv_query = 1 no_batch = 2 frontend_error = 3 OTHERS = 4.

WS_DOWNLOAD CALL FUNCTION 'WS_DOWNLOAD' EXPORTING bin_filesize = gv_filelength * CODEPAGE = ' ' filename = gv_filename filetype = 'BIN' * mode = ' ' * WK1_N_FORMAT = ' ' * WK1_N_SIZE = ' ' * WK1_T_FORMAT = ' ' * WK1_T_SIZE = ' ' * COL_SELECT = ' ' * COL_SELECTMASK = ' ' IMPORTING filelength = gv_filelength TABLES data_tab = gt_data_tab * FIELDNAMES = EXCEPTIONS file_open_error = 1 file_write_error = 2 invalid_filesize = 3 invalid_table_width = 4 invalid_type = 5 no_batch = 6 unknown_error = 7 OTHERS = 8.

NAME_OF_CURRENT_TRACE_FILE CALL FUNCTION 'NAME_OF_CURRENT_TRACE_FILE' IMPORTING pathname = gv_pathname EXCEPTIONS buffer_overflow = 1 OTHERS = 2.



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 CNVCDOP_SQLTR_DOWNLD_TRACEFILE or its description.