SAP Reports / Programs | Financial Accounting | Special Purpose Ledger | Basic Functions(FI-SL-SL) SAP FI
RGUSLSEPH SAP ABAP Report - Compare HDB Totals Records with Total from HDB Line Items
RGUSLSEPH is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for The program RGUSLSEPH can be used to reconcile the totals records from an SL-type ledger with the line items on the secondary database...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 RGUSLSEPH 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 RGUSLSEPH. "Basic submit
SUBMIT RGUSLSEPH AND RETURN. "Return to original report after report execution complete
SUBMIT RGUSLSEPH 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: VERSION = Version
Selection Text: SATZART = Record Type
Selection Text: P_DEF_DB = Default Connection
Selection Text: P_DEFNAM = Default Connection
Selection Text: P_DBCON = Alternative Connection
Selection Text: PERIODE = Period
Selection Text: LEDGER = Ledger
Selection Text: KONTO = Account
Selection Text: JAHR = Fiscal Year
Selection Text: GES_BER = Business Area
Selection Text: C_FIELD3 = Additional Field 3
Selection Text: C_FIELD2 = Additional Field 2
Selection Text: C_FIELD = Additional Field 1
Selection Text: COMPANY = Company
Selection Text: BUKREIS = Company Code
Title: Compare HDB Totals Records with Total from HDB Line Items
Text Symbol: T04 = Select. for Ledger &
Text Symbol: T03 = Display Related Line Items
Text Symbol: T02 = Display Related Totals Records
Text Symbol: T01 = The differences for the selected data records are:
Text Symbol: DBC = Database Connection
Text Symbol: 030 = Connection Details
Text Symbol: 029 = Default
Text Symbol: 028 = Default Connection
Text Symbol: 027 = Comparison of Totals Record and Total Calculated from the Line Items
Text Symbol: 025 = Ledger & has the following differences
Text Symbol: 022 = Additional Fields for List Format
Text Symbol: 006 = Ledger
Text Symbol: 005 = Selection Data
INCLUDES used within this REPORT RGUSLSEPH
INCLUDE RKASMAWF. "#EC INCL_OK
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:
G_CHECK_DB_IS_HDB CALL FUNCTION 'G_CHECK_DB_IS_HDB' IMPORTING ed_db_is_hdb = soh.
HDB_DBCON_GET_APPL CALL FUNCTION 'HDB_DBCON_GET_APPL' IMPORTING e_dbcon_name = p_defnam EXCEPTIONS dbcon_not_exist = 1 dbcon_no_use = 2 dbcon_error = 3 OTHERS = 4.
HDB_DBCON_CHECK CALL FUNCTION 'HDB_DBCON_CHECK' CHANGING c_dbcon_name = dbcon_name EXCEPTIONS dbcon_not_exist = 1 dbcon_no_use = 2 dbcon_error = 3 OTHERS = 4.
DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING dyname = 'RGUSLSEPH' dynumb = '1000' translate_to_upper = 'X' * REQUEST = ' ' * PERFORM_CONVERSION_EXITS = ' ' * PERFORM_INPUT_CONVERSION = ' ' TABLES dynpfields = t_dynpfields EXCEPTIONS invalid_abapworkarea = 1 invalid_dynprofield = 2 invalid_dynproname = 3 invalid_dynpronummer = 4 invalid_request = 5 no_fielddescription = 6 invalid_parameter = 7 undefind_error = 8 double_conversion = 9 OTHERS = 10.
G_CONVERT_INPUT CALL FUNCTION 'G_CONVERT_INPUT' EXPORTING convexit = 'ALPHA' input_value = s_dynpfields-fieldvalue input_length = 2 IMPORTING converted_value = s_t881-rldnr.
G_GIVE_FIELDS_FOR_TABLE CALL FUNCTION 'G_GIVE_FIELDS_FOR_TABLE' EXPORTING i_table = s_t881-tab TABLES e_t_fields = t_fields e_t_fieldsandtext = t_help_fields EXCEPTIONS not_found = 1 OTHERS = 2.
REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = gs_repid i_structure_name = 'DFIES' CHANGING ct_fieldcat = gt_fieldcat[] EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.
REUSE_ALV_POPUP_TO_SELECT CALL FUNCTION 'REUSE_ALV_POPUP_TO_SELECT' EXPORTING i_title = help_text i_selection = 'X' i_zebra = ' ' i_scroll_to_sel_line = 'X' i_tabname = 'TABLE_CHOOSE' it_fieldcat = gt_fieldcat[] IMPORTING es_selfield = selfield e_exit = g_exit TABLES t_outtab = table_choose EXCEPTIONS program_error = 1 OTHERS = 2.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING fieldname = z_field TABLE = stab_name EXCEPTIONS not_found = 1 OTHERS = 2.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING fieldname = z_field TABLE = 'GLU1' EXCEPTIONS not_found = 1 OTHERS = 2.
FAGL_DBCON_GET_APPL * CALL FUNCTION 'FAGL_DBCON_GET_APPL' * EXPORTING * it_required_table = t_tables * IMPORTING * et_message = t_messages * EXCEPTIONS * dbcon_not_exist = 1 * dbcon_no_use = 2 * dbcon_error = 3 * dbcon_others = 4 * function_not_exist = 5 * OTHERS = 6.
G_TABLE_SELECT_WITH_CURSOR * CALL FUNCTION 'G_TABLE_SELECT_WITH_CURSOR' * EXPORTING * i_tabname = gl_table * i_selection = sel_int_compare_glu1 * i_fieldlist = l_t_fields * i_sortlist = l_t_fields * i_aggregation = gusl_c_true * i_dbcon_name = dbcon_name * CHANGING * c_t_glu1 = totals * EXCEPTIONS * OTHERS = 1.
G_TABLE_SELECT_WITH_CURSOR * CALL FUNCTION 'G_TABLE_SELECT_WITH_CURSOR' * EXPORTING * i_tabname = gl_table * i_selection = sel_int_compare_glu1 * i_fieldlist = l_t_fields * i_aggregation = gusl_c_true * i_dbcon_name = dbcon_name * CHANGING * c_t_glu1 = totals * EXCEPTIONS * OTHERS = 1.
G_TABLE_SELECT_WITH_CURSOR * CALL FUNCTION 'G_TABLE_SELECT_WITH_CURSOR' * EXPORTING * i_tabname = gl_table * i_selection = sel_int_compare_glu1 * i_fieldlist = l_t_fields * i_sortlist = l_t_fields * i_aggregation = gusl_c_true * i_dbcon_name = dbcon_name * CHANGING * c_t_glu1 = actuals * EXCEPTIONS * OTHERS = 1.
G_TABLE_SELECT_WITH_CURSOR * CALL FUNCTION 'G_TABLE_SELECT_WITH_CURSOR' * EXPORTING * i_tabname = gl_table * i_selection = sel_int_compare_glu1 * i_fieldlist = l_t_fields * i_aggregation = gusl_c_true * i_dbcon_name = dbcon_name * CHANGING * c_t_glu1 = actuals * EXCEPTIONS * OTHERS = 1.
G_TABLE_SELECT_WITH_CURSOR * CALL FUNCTION 'G_TABLE_SELECT_WITH_CURSOR' * EXPORTING * i_tabname = gl_table * i_selection = sel_int_compare_glu1 * i_fieldlist = l_t_fields * i_sortlist = l_t_fields * i_aggregation = gusl_c_true * i_dbcon_name = dbcon_name * CHANGING * c_t_glu1 = plan * EXCEPTIONS * OTHERS = 1.
G_TABLE_SELECT_WITH_CURSOR * CALL FUNCTION 'G_TABLE_SELECT_WITH_CURSOR' * EXPORTING * i_tabname = gl_table * i_selection = sel_int_compare_glu1 * i_fieldlist = l_t_fields * i_aggregation = gusl_c_true * i_dbcon_name = dbcon_name * CHANGING * c_t_glu1 = plan * EXCEPTIONS * OTHERS = 1.
G_GET_ORGANIZATIONAL_DATA * CALL FUNCTION 'G_GET_ORGANIZATIONAL_DATA' * EXPORTING * i_rldnr = ledger * i_orgunit = unit_rcomp * IMPORTING * organizational_info = info * EXCEPTIONS * no_info_found = 1 * OTHERS = 2.
* CALL FUNCTION 'G_GET_ORGANIZATIONAL_DATA' * EXPORTING * i_rldnr = ledger * i_orgunit = unit_bukrs * IMPORTING * organizational_info = info * EXCEPTIONS * no_info_found = 1 * OTHERS = 2.
G_GET_ORGANIZATIONAL_DATA * CALL FUNCTION 'G_GET_ORGANIZATIONAL_DATA' * EXPORTING * i_rldnr = ledger * i_orgunit = unit_bukrs * IMPORTING * organizational_info = info * EXCEPTIONS * no_info_found = 1 * OTHERS = 2.
REUSE_ALV_FIELDCATALOG_MERGE * CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' * EXPORTING * i_program_name = g_repid * i_structure_name = lv_admi_files * CHANGING * ct_fieldcat = lt_fieldcat * EXCEPTIONS * OTHERS = 1.
G_GET_ORGANIZATIONAL_DATA * CALL FUNCTION 'G_GET_ORGANIZATIONAL_DATA' * EXPORTING * i_rldnr = ledger * i_orgunit = s_all_oe-oe * IMPORTING * organizational_info = info * EXCEPTIONS * no_info_found = 1 * error_in_setup = 2 * OTHERS = 3.
G_GET_ORGANIZATIONAL_DATA * CALL FUNCTION 'G_GET_ORGANIZATIONAL_DATA' * EXPORTING * i_rldnr = ledger * i_orgunit = s_all_oe-oe * IMPORTING * organizational_info = info * EXCEPTIONS * no_info_found = 1 * error_in_setup = 2 * OTHERS = 3.
G_GET_ORGANIZATIONAL_DATA * CALL FUNCTION 'G_GET_ORGANIZATIONAL_DATA' * EXPORTING * i_rldnr = ledger * i_orgunit = s_all_oe-oe * IMPORTING * organizational_info = info * EXCEPTIONS * no_info_found = 1 * error_in_setup = 2 * OTHERS = 3.
G_TEXT_FOR_CT_GET * CALL FUNCTION 'G_TEXT_FOR_CT_GET' * EXPORTING * ct = '00' * IMPORTING * text_10 = lt_fieldcat_line-seltext_s * text_15 = lt_fieldcat_line-seltext_m * text_20 = lt_fieldcat_line-seltext_l.
G_TEXT_FOR_CT_GET * CALL FUNCTION 'G_TEXT_FOR_CT_GET' * EXPORTING * ct = s_t881-curt1 * IMPORTING * text_10 = lt_fieldcat_line-seltext_s * text_15 = lt_fieldcat_line-seltext_m * text_20 = lt_fieldcat_line-seltext_l.
G_TEXT_FOR_CT_GET * CALL FUNCTION 'G_TEXT_FOR_CT_GET' * EXPORTING * ct = s_t881-curt2 * IMPORTING * text_10 = lt_fieldcat_line-seltext_s * text_15 = lt_fieldcat_line-seltext_m * text_20 = lt_fieldcat_line-seltext_l.
REUSE_ALV_EVENTS_GET * CALL FUNCTION 'REUSE_ALV_EVENTS_GET' * EXPORTING * i_list_type = 2 * IMPORTING * et_events = gt_events * EXCEPTIONS * OTHERS = 1.
REUSE_ALV_LIST_DISPLAY * CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' * EXPORTING * i_callback_program = g_repid * i_callback_user_command = g_user_command * it_fieldcat = lt_fieldcat * is_layout = gs_layout * it_events = gt_events ** i_text = string * TABLES * t_outtab = t_ausgab * EXCEPTIONS * OTHERS = 1.
G_TOTALS_GLU1_LIST_DISPLAY * CALL FUNCTION 'G_TOTALS_GLU1_LIST_DISPLAY' * EXPORTING * i_buffer_active = space * i_drill_down = 'X' * i_ledger = ledger * i_totals = set_totals * i_cwcode = 'X' * i_zscode = ' ' * i_text = TEXT-t01 * i_text2 = TEXT-t02 * i_text3 = TEXT-t03 * i_ledgerfield = range_cat * i_selection = sel_periods * i_prompt = ' ' * i_user_specific = 'FI_SL_SHOW_TOT_LIST' * IMPORTING * e_t_listcat = alv_fieldcat * e_t_selection_for_set = sel_nr_poper * e_t_totals_per = totals_per * e_t_fieldcat = fieldcat * e_t_ledgerfield = test * EXCEPTIONS * internal_error = 1 * OTHERS = 2.
SELOPTS_AND_PARAMS * CALL FUNCTION 'SELOPTS_AND_PARAMS' * EXPORTING * PROGRAM = 'RGUSLSEPH' * TABLES * selpars = selpars * EXCEPTIONS * program_non_existent = 1 * subroutine_pool = 2 * load_problems = 3 * OTHERS = 4.
KPEP_MONI_INIT_RECORD * CALL FUNCTION 'KPEP_MONI_INIT_RECORD' * EXPORTING * ls_detail = ls_detail * ls_witem = ls_witem * IMPORTING * ls_key = ls_key_static * TABLES * lt_selkrit = lt_selkrit * lt_param = lt_param.
KPEP_MONI_CLOSE_RECORD * CALL FUNCTION 'KPEP_MONI_CLOSE_RECORD' * EXPORTING * ls_key = ls_key_static * ls_scma_event = ls_scma_event * CHANGING * ld_aplstat = ld_aplstat * EXCEPTIONS * no_id_given = 1 * OTHERS = 0.
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 RGUSLSEPH or its description.
RGUSLSEPH - Compare HDB Totals Records with Total from HDB Line Items RGUSLSEPH - Compare HDB Totals Records with Total from HDB Line Items RGUSLSEP - Compare Totals Records with Total from Line Items RGUSLSEP - Compare Totals Records with Total from Line Items RGUSLARCFIND - Finding archives with fixed fields RGUSLARCFIND - Finding archives with fixed fields