SAP Reports / Programs | Financial Accounting | Special Purpose Ledger | Basic Functions(FI-SL-SL) SAP FI
RGUSLSEP SAP ABAP Report - Compare Totals Records with Total from Line Items
RGUSLSEP is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program RGUSLSEP (transaction GCGS) allows you to reconcile a special purpose ledger or ledger based on totals table V_GLFLEXT for totals records and line items...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 RGUSLSEP 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
GCGS - Reconciliation of Total Line Items
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 RGUSLSEP. "Basic submit
SUBMIT RGUSLSEP AND RETURN. "Return to original report after report execution complete
SUBMIT RGUSLSEP 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: BUKREIS = Company Code
Selection Text: COMPANY = Global Company
Selection Text: C_FIELD = Additional Field 1
Selection Text: C_FIELD2 = Additional Field 2
Selection Text: C_FIELD3 = Additional Field 3
Selection Text: GES_BER = Business Area
Selection Text: JAHR = Fiscal Year
Selection Text: KONTO = Account
Selection Text: LEDGER = Ledger
Selection Text: PERIODE = Period
Selection Text: SATZART = Record Type
Selection Text: VERSION = Version
Title: Compare Totals Records with Total from 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: 027 = Comparison of totals record and total calculated from the line items
Text Symbol: 026 = to rec type
Text Symbol: 025 = Ledger & has the following differences
Text Symbol: 024 = Result for organizational unit &
Text Symbol: 023 = Charact.
Text Symbol: 001 = Comparison between
Text Symbol: 002 = Totals Record
Text Symbol: 003 = and
Text Symbol: 004 = total calculated from &
Text Symbol: 005 = Selection Data
Text Symbol: 006 = Ledger
Text Symbol: 007 = Company Code
Text Symbol: 008 = Fiscal Year
Text Symbol: 009 = of Record Type
Text Symbol: 010 = Version
Text Symbol: 011 = From Period
Text Symbol: 012 = To Period
Text Symbol: 013 = Acct No.
Text Symbol: 014 = Period
Text Symbol: 015 = Transaction Currency
Text Symbol: 016 = Local Currency
Text Symbol: 017 = Group Currency
Text Symbol: 018 = Line Items
Text Symbol: 019 = Plan Line Items
Text Symbol: 020 = Differences occurred in &
Text Symbol: 021 = The totals match
Text Symbol: 022 = Additional fields for list format
INCLUDES used within this REPORT RGUSLSEP
INCLUDE RKASMAWF. " NECESSARY FOR WORKFLOW
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:
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 = hp_dbco 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 = hp_dbco 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 = hp_dbco 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 = hp_dbco 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 = hp_dbco 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 = hp_dbco CHANGING C_T_GLU1 = PLAN EXCEPTIONS OTHERS = 1.
G_CONVERT_OUTPUT * CALL FUNCTION 'G_CONVERT_OUTPUT' * EXPORTING * CONVEXIT = FIELDS-CONVEXIT * DATATYPE = FIELDS-DATATYPE * VALUE_TO_CONVERT =
* IMPORTING * OUTPUT_VALUE = * EXCEPTIONS * ILLEGAL_LENGTH = 1 * OTHERS = 2.
G_FIELD_SET CALL FUNCTION 'G_FIELD_SET' EXPORTING TABLE = TABLE FTYPE = 'K'.
G_FIELD_GET CALL FUNCTION 'G_FIELD_GET' IMPORTING FIELD_ATTR = HELP_DFIES SUBRC = RC.
G_FIELD_GET CALL FUNCTION 'G_FIELD_GET' IMPORTING FIELD_ATTR = HELP_DFIES SUBRC = RC.
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.
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.
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.
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 = 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 = 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 = 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 = 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 = 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.
DYNP_VALUES_READ CALL FUNCTION 'DYNP_VALUES_READ' EXPORTING DYNAME = 'RGUSLSEP' 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 = T_DYNPFIELDS-FIELDVALUE INPUT_LENGTH = 2 IMPORTING CONVERTED_VALUE = T881-RLDNR.
G_GIVE_FIELDS_FOR_TABLE CALL FUNCTION 'G_GIVE_FIELDS_FOR_TABLE' EXPORTING I_TABLE = 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.
SELOPTS_AND_PARAMS CALL FUNCTION 'SELOPTS_AND_PARAMS' EXPORTING PROGRAM = 'RGUSLSEP' 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.
CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = lt_top_of_page.
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 RGUSLSEP or its description.
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 RGUSLAFI - Finding archives with fixed fields RGUSLAFI - Finding archives with fixed fields