SAP Reports / Programs
RGCBILA0 SAP ABAP Report - Consolidation Data Extract
RGCBILA0 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 RGCBILA0 into the relevant SAP transactions such as SE38 or SE80
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 RGCBILA0. "Basic submit
SUBMIT RGCBILA0 AND RETURN. "Return to original report after report execution complete
SUBMIT RGCBILA0 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: Consolidation Data Extract
Text Symbol: 001 = * Audit trail for FI-LC data extract *
Text Symbol: 002 = Item Account TTy TrPtr Year Per
Text Symbol: 040 = Extract creation
Text Symbol: 100 = There is no financial statement
Text Symbol: 101 = item in items tble for the financial statement key
Text Symbol: 102 = Balance Gen.Ledger <> GLT3 --> Transfer Gen.Ledger
Text Symbol: 103 = Company code has
Text Symbol: 104 = not been assigned to a company
Text Symbol: 105 = Assigmnt missing: local BA to consolidation BA
INCLUDES used within this REPORT RGCBILA0
INCLUDE RGCMBUD0.
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:
MESSAGES_INITIALIZE CALL FUNCTION 'MESSAGES_INITIALIZE' "wdu20195 EXPORTING "wdu20195 reset = space. "wdu20195
G_EXTRACT CALL FUNCTION 'G_EXTRACT' EXPORTING * I_RVERS = M_RVERS "wdu26549 i_rvers = version "wdu26549 i_rcomp = gesnr "xhe118306 i_exgsber = f_gsberk i_filename = gd_filename.
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' "xrp250698 EXPORTING "xrp250698 arbgb = 'G00' "xrp250698 msgty = 'S' "xrp250698 msgv1 = gd_filename "xrp250698 txtnr = '006' "xrp250698 IMPORTING "xrp250698 act_severity = grad "xrp250698 max_severity = mgrad. "xrp250698
MESSAGES_SHOW CALL FUNCTION 'MESSAGES_SHOW' "xrp250698 EXPORTING "xrp250698 corrections_option = ' ' "xrp250698 object = text-040 "xrp250698 send_if_one = 'X' "xrp250698 show_linno = ' ' "xrp250698 IMPORTING "xrp250698 corrections_wanted = ld_flag "xrp250698 EXCEPTIONS "xrp250698 inconsistent_range = 01 "xrp250698 no_messages = 02. "xrp250698
MESSAGES_INITIALIZE * CALL FUNCTION 'MESSAGES_INITIALIZE'. "wdu20195
G_CHCK_GSBER_KONS CALL FUNCTION 'G_CHCK_GSBER_KONS'.
G_GET_FILENAME CALL FUNCTION 'G_GET_FILENAME' EXPORTING e_rcomp = gesnr * E_RVERS = M_RVERS "wdu26549 * E_RVERS = VERSION "wdu26549 e_rvers = rvers_lc "wdu26549 e_param1 = gesnr "xhe311097 e_param2 = rvers_lc "xhe311097 e_use_pserver = ' ' IMPORTING i_filename = gd_filename i_fileformat = gd_fileformat EXCEPTIONS file_not_found = 01.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = id_filename parameter_1 = 'EXTRACT_CS_CO' use_presentation_server = ' ' IMPORTING file_name = gd_filename.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = id_filename parameter_1 = 'EXTRACT_CS_BA' use_presentation_server = ' ' IMPORTING file_name = gd_filename.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' "begin "n1858700 EXPORTING logical_filename = gc_fname parameter_1 = sy-cprog CHANGING physical_filename = gd_filename EXCEPTIONS OTHERS = 1.
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' "xrp020205 EXPORTING "xrp020205 arbgb = 'G3' "xrp020205 msgty = 'W' "xrp020205 msgv1 = bukrs "xrp020205 msgv2 = konto "xrp020205 txtnr = '046' "xrp020205 IMPORTING "xrp020205 act_severity = grad "xrp020205 max_severity = mgrad. "xrp020205
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' EXPORTING arbgb = 'GC' "Nachrichten-ID exception_if_not_active = 'X' "X = Exception not_active wird ausgelöst msgty = 'E' "Art der Nachricht (I, S, W, E, A) * Variable Parameter msgv1 = e_txt1 msgv2 = e_txt2 msgv3 = e_txt3 * MSGV4 = E_TXT4 txtnr = e_number "Nr der Nachricht IMPORTING act_severity = grad "Schweregrad der aktuellen Nachricht max_severity = mgrad "Maximal aufgetretener Schweregrad EXCEPTIONS message_type_not_valid = 0001 "Art der Nachricht nicht I, S, W, E, A not_active = 0002. "Sammeln von Nachrichten nicht aktiviert
MESSAGES_STOP CALL FUNCTION 'MESSAGES_STOP' EXCEPTIONS i_message = 1 w_message = 2 e_message = 3 a_message = 4 OTHERS = 8.
MESSAGES_SHOW CALL FUNCTION 'MESSAGES_SHOW' EXPORTING corrections_option = ' ' object = text-040 send_if_one = ' ' "=x Ausgabe in Fusszeile show_linno = ' ' "Ausgabe der Spalte 'POS' IMPORTING corrections_wanted = flag "mit Zeilennummer EXCEPTIONS inconsistent_range = 01 no_messages = 02.
FILE_GET_NAME * CALL FUNCTION 'FILE_GET_NAME' * EXPORTING * LOGICAL_FILENAME = ID_FILENAME ** PARAMETER_1 = 'EXTRACT_CS_CO' "xrp290799 * USE_PRESENTATION_SERVER = 'X' * IMPORTING * FILE_NAME = LD_FNAME.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = id_filename * PARAMETER_1 = 'EXTRACT_CS_BA' "xrp290799 use_presentation_server = 'X' IMPORTING file_name = ld_fname.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' "begin "n1858700 EXPORTING logical_filename = gc_fname parameter_1 = sy-cprog CHANGING physical_filename = id_appl_fname EXCEPTIONS OTHERS = 1.
WS_DOWNLOAD * CALL FUNCTION 'WS_DOWNLOAD' "begin xrp040803 * EXPORTING * filename = ld_fname * TABLES * data_tab = pcsatz * 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 * gui_refuse_filetransfer = 8 * OTHERS = 9.
CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = ld_file TABLES data_tab = pcsatz EXCEPTIONS OTHERS = 1.
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' EXPORTING arbgb = 'G00' msgty = 'S' msgv1 = ld_fname txtnr = '007' IMPORTING act_severity = grad max_severity = mgrad.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' "begin "n1858700 EXPORTING logical_filename = gc_fname parameter_1 = sy-cprog CHANGING physical_filename = id_fname_temp EXCEPTIONS OTHERS = 1.
FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = id_fname_out use_presentation_server = id_pres IMPORTING file_name = ld_fname_out.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' "begin "n1858700 EXPORTING logical_filename = gc_fname parameter_1 = sy-cprog CHANGING physical_filename = ld_fname_out EXCEPTIONS OTHERS = 1.
GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = ld_fname_out write_field_separator = 'X' TABLES data_tab = lt_data_out EXCEPTIONS OTHERS = 1.
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' EXPORTING arbgb = 'G00' msgty = 'S' msgv1 = ld_fname_out txtnr = '006' IMPORTING act_severity = grad max_severity = mgrad.
MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' EXPORTING arbgb = 'G00' msgty = 'S' msgv1 = ld_fname_out txtnr = '007'.
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 RGCBILA0 or its description.