J_1GSPOOL2CD SAP ABAP Report - List from/to Text file
J_1GSPOOL2CD is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Export an ABAP list spool file to an ANSI text file...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 J_1GSPOOL2CD 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
J1GVL_T15 - WHB to CD utility
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 J_1GSPOOL2CD. "Basic submit
SUBMIT J_1GSPOOL2CD AND RETURN. "Return to original report after report execution complete
SUBMIT J_1GSPOOL2CD 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: D_EXPORT = Export list locally
Selection Text: D_IMPORT = Display list from local file
Selection Text: I_EXPSRV = Export list to server
Selection Text: I_IMPSRV = Display list from server file
Selection Text: I_SRV2PC = Get file from server
Selection Text: P_EXPPS = Size of export pack (pages)
Selection Text: P_FILE = Local file name
Selection Text: P_SPNUM = Spool request number
Selection Text: P_SRVFL = Server file name
Selection Text: P_W1253 = Force MS-Windows Greek coding
Title: List from/to Text file
Text Symbol: E01 = Only server operations can be performed in background mode.
Text Symbol: I01 = Spool dataset:
Text Symbol: I02 = Succesfully exported to file:
Text Symbol: I03 = No file created (probably empty spool).
Text Symbol: I11 = Server file:
Text Symbol: I12 = Succesfully copied to local file:
Text Symbol: I13 = Was not copied because it's empty.
INCLUDES used within this REPORT J_1GSPOOL2CD
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:
GUI_DELETE_FILE call function 'GUI_DELETE_FILE' exporting file_name = p_file exceptions failed = 1 others = 2.
J_1GSAC_AUTH_CHECK call function 'J_1GSAC_AUTH_CHECK' exporting i_area = 'CA' i_action = 'FILE'.
SCP_CODEPAGE_BY_EXTERNAL_NAME call function 'SCP_CODEPAGE_BY_EXTERNAL_NAME' exporting external_name = 'windows-1253' * KIND = 'H' importing sap_codepage = g_win_gr_cp exceptions not_found = 1 others = 2.
TRANSFER_NAMES_TO_FIELDS call function 'TRANSFER_NAMES_TO_FIELDS' exporting selectfield = fieldname tables fields = fields namelist = list_fields exceptions wrong_format_given = 1 others = 2.
RSPO_FIND_SPOOL_REQUESTS call function 'RSPO_FIND_SPOOL_REQUESTS' exporting authority = 'X' rqowner = '*' tables spoolrequests = w_rsporq exceptions no_permission = 1.
HELP_VALUES_GET_NO_DD_NAME call function 'HELP_VALUES_GET_NO_DD_NAME' exporting display = ' ' selectfield = fieldname titel = ' ' show_all_values_at_first_time = 'X' write_selectfield_in_colours = 'X' importing select_value = return_value tables fields = fields full_table = sptab exceptions full_table_empty = 1 no_tablestructure_given = 2 no_tablefields_in_dictionary = 3 more_then_one_selectfield = 4 no_selectfield = 5 others = 6.
WS_FILENAME_GET call function 'WS_FILENAME_GET' exporting def_filename = p_file mask = l_mask mode = l_wsmode * TITLE = ' ' importing filename = l_file * RC = exceptions inv_winsys = 01 no_batch = 02 selection_cancel = 03 selection_error = 04.
DYNP_UPDATE_FIELDS call function 'DYNP_UPDATE_FIELDS' exporting dyname = syst-cprog dynumb = syst-dynnr request = 'A' tables dynpfields = lt_dynp exceptions invalid_abapworkarea = 01 invalid_dynprofield = 02 invalid_dynproname = 03 invalid_dynpronummer = 04 invalid_request = 05 no_fielddescription = 06 undefind_error = 07.
RSPO_CHECK_JOB_PERMISSION call function 'RSPO_CHECK_JOB_PERMISSION' exporting access = 'DOWN' spoolreq = tsp01.
J_2GSERVER_FILES_F4 call function 'J_2GSERVER_FILES_F4' exporting pattern = '*' dirs = 'X' files = 'X' separator = ' ' importing fname = p_srvfl tables dxfile = lt_file exceptions unsupported_file_type = 1 others = 2.
AUTHORITY_CHECK_DATASET call function 'AUTHORITY_CHECK_DATASET' exporting activity = 'WRITE' filename = l_srvfl exceptions no_authority = 1 activity_unknown = 2 others = 3.
AUTHORITY_CHECK_DATASET call function 'AUTHORITY_CHECK_DATASET' exporting activity = 'READ' filename = l_srvfl exceptions no_authority = 1 activity_unknown = 2 others = 3.
RSTS_GET_ATTRIBUTES call function 'RSTS_GET_ATTRIBUTES' exporting authority = 'SP01' client = temse_client name = temse_name part = temse_part importing charco = gcodepage * CREATER = * CREDATE = * DELDATE = * MAX_CREDATE = * MAX_DELDATE = * NON_UNIQ = * NOOF_PARTS = rectyp = temse_rectyp * SIZE = * STOTYP = * type = objtype = temse_objtyp exceptions fb_error = 1 fb_rsts_other = 2 no_object = 3 no_permission = 4 others = 5.
RSPO_GET_SIZE_OF_LAYOUT call function 'RSPO_GET_SIZE_OF_LAYOUT' exporting layout = tsp01-rqpaper importing columns = gcol lines = glines.
RSPO_SPOOLDATA_WRITE_INIT call function 'RSPO_SPOOLDATA_WRITE_INIT' exporting codepage = gcodepage.
RSPO_SPOOLDATA_WRITE call function 'RSPO_SPOOLDATA_WRITE' exporting spool_data = data_set_line-data_line data_length = line_length2.
RSTS_GET_ATTRIBUTES call function 'RSTS_GET_ATTRIBUTES' exporting authority = 'SP01' client = temse_client name = temse_name part = temse_part importing charco = temse_charco * CREATER = * CREDATE = * DELDATE = * MAX_CREDATE = * MAX_DELDATE = * NON_UNIQ = * NOOF_PARTS = rectyp = temse_rectyp * SIZE = * STOTYP = * type = objtype = temse_objtyp exceptions fb_error = 1 fb_rsts_other = 2 no_object = 3 no_permission = 4 others = 5.
LIST_TO_ASCI call function 'LIST_TO_ASCI' exporting list_index = 0 * WITH_LINE_BREAK = ' ' tables listasci = itab exceptions empty_list = 1 list_index_invalid = 2 others = 3.
call function 'RSPO_GET_SIZE_OF_LAYOUT' exporting layout = tsp01-rqpaper importing columns = gcol lines = glines.
RSPO_RETURN_ABAP_SPOOLJOB call function 'RSPO_RETURN_ABAP_SPOOLJOB' exporting rqident = tsp01-rqident first_line = from_line last_line = to_line tables buffer = itab exceptions no_such_job = 1 not_abap_list = 2 job_contains_no_data = 3 selection_empty = 4 no_permission = 5 can_not_access = 6 read_error = 7 others = 8.
RSPO_RETURN_ABAP_SPOOLJOB_RAW call function 'RSPO_RETURN_ABAP_SPOOLJOB_RAW' exporting rqident = tsp01-rqident first_line = from_line last_line = to_line tables buffer = buff.
GUI_DOWNLOAD call function 'GUI_DOWNLOAD' exporting * BIN_FILESIZE = filename = l_file * FILETYPE = 'ASC' append = pf_append * WRITE_FIELD_SEPARATOR = ' ' * HEADER = '00' * TRUNC_TRAILING_BLANKS = ' ' * WRITE_LF = 'X' * CONFIRM_OVERWRITE = ' ' * NO_AUTH_CHECK = ' ' codepage = l_cp * IGNORE_CERR = ABAP_TRUE * REPLACEMENT = '#' * WRITE_BOM = ' ' * TRUNC_TRAILING_BLANKS_EOL = 'X' * IMPORTING * FILELENGTH = tables data_tab = itab exceptions file_write_error = 1 no_batch = 2 gui_refuse_filetransfer = 3 invalid_type = 4 no_authority = 5 unknown_error = 6 header_not_allowed = 7 separator_not_allowed = 8 filesize_not_allowed = 9 header_too_long = 10 dp_error_create = 11 dp_error_send = 12 dp_error_write = 13 unknown_dp_error = 14 access_denied = 15 dp_out_of_memory = 16 disk_full = 17 dp_timeout = 18 file_not_found = 19 dataprovider_exception = 20 control_flush_error = 21 others = 22.
GUI_DOWNLOAD call function 'GUI_DOWNLOAD' exporting bin_filesize = p_size filename = l_file filetype = 'BIN' append = pf_append * WRITE_FIELD_SEPARATOR = ' ' * HEADER = '00' * TRUNC_TRAILING_BLANKS = ' ' * WRITE_LF = 'X' * CONFIRM_OVERWRITE = ' ' * NO_AUTH_CHECK = ' ' * CODEPAGE = * IGNORE_CERR = ABAP_TRUE * REPLACEMENT = '#' * WRITE_BOM = ' ' * TRUNC_TRAILING_BLANKS_EOL = 'X' * IMPORTING * FILELENGTH = tables data_tab = itab exceptions file_write_error = 1 no_batch = 2 gui_refuse_filetransfer = 3 invalid_type = 4 no_authority = 5 unknown_error = 6 header_not_allowed = 7 separator_not_allowed = 8 filesize_not_allowed = 9 header_too_long = 10 dp_error_create = 11 dp_error_send = 12 dp_error_write = 13 unknown_dp_error = 14 access_denied = 15 dp_out_of_memory = 16 disk_full = 17 dp_timeout = 18 file_not_found = 19 dataprovider_exception = 20 control_flush_error = 21 others = 22.
GUI_UPLOAD call function 'GUI_UPLOAD' exporting filename = l_file * FILETYPE = 'ASC' * HAS_FIELD_SEPARATOR = ' ' * HEADER_LENGTH = 0 * READ_BY_LINE = 'X' * DAT_MODE = ' ' codepage = l_cp * IGNORE_CERR = ABAP_TRUE * REPLACEMENT = '#' * NO_AUTH_CHECK = ' ' * IMPORTING * FILELENGTH = * HEADER = tables data_tab = itab exceptions file_open_error = 1 file_read_error = 2 no_batch = 3 gui_refuse_filetransfer = 4 invalid_type = 5 no_authority = 6 unknown_error = 7 bad_data_format = 8 header_not_allowed = 9 separator_not_allowed = 10 header_too_long = 11 unknown_dp_error = 12 access_denied = 13 dp_out_of_memory = 14 disk_full = 15 dp_timeout = 16 others = 17.
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 J_1GSPOOL2CD or its description.