SAP Reports / Programs | Financial Accounting | Special Purpose Ledger | Basic Functions(FI-SL-SL) SAP FI
RGUDEL00 SAP ABAP Report - Delete Transaction Data from Ledgers
RGUDEL00 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Program RGUDEL00 enables you to prepare the FI-SL system for going into production...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 RGUDEL00 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
OCDZ - Cons stag. ledger: delete trans data
CXDL - Delete trans. data in Cons ledger
GLDE - Deletion of Flex G/L transactn data
OCDL - Delete FI-LC Ledger Transaction data
RTDE - Retail Ledger: Del. Transaction Data
GCDE - Delete FI-SL Transaction Data
FAGL_DEL - Delete Transaction Data from Ledger
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 RGUDEL00. "Basic submit
SUBMIT RGUDEL00 AND RETURN. "Return to original report after report execution complete
SUBMIT RGUDEL00 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Deletion Statistics
Selection Text: P_DELTAB = Totals Table
Selection Text: P_INDEX = Redundant index records
Selection Text: P_LISTE = Output list
Selection Text: P_POPER = Period
Selection Text: P_PSI = Plan Line Items
Selection Text: P_SI = Actual line items
Selection Text: P_TEST = Test run
Selection Text: P_TLISTE = Output list
Selection Text: P_TT = Totals records
Selection Text: P_TTEST = Test run
Selection Text: P_ACTIV = D .
Selection Text: P_AWTYP = D .
Selection Text: P_BUKRS = D .
Selection Text: P_LOGSYS = D .
Selection Text: P_RACCT = D .
Selection Text: P_RBUNIT = D .
Selection Text: P_RCOMP = D .
Selection Text: P_RDIMEN = D .
Selection Text: P_RLDNR = D .
Selection Text: P_RRCTY = D .
Selection Text: P_RVERS = D .
Selection Text: P_RYEAR = D .
Title: Delete Transaction Data from Ledgers
Text Symbol: 220 = Description
Text Symbol: 210 = Ver
Text Symbol: 200 = Choose Version
Text Symbol: 180 = Processing Options
Text Symbol: 176 = Number of deleted or changed records
Text Symbol: 175 = Table
Text Symbol: 174 = TEST RUN TEST RUN TEST RUN TEST RUN
Text Symbol: 001 = Period
Text Symbol: 002 = To
Text Symbol: 003 = Account
Text Symbol: 004 = To
Text Symbol: 005 = Account
Text Symbol: 006 = Logical system
Text Symbol: 007 = Selection
Text Symbol: 008 = Ledger in General Ledger: Reset Balance Carryforward
Text Symbol: 009 = Reset Balance Carryforward
Text Symbol: 100 = $$$ Summary records of table &&& deleted.
Text Symbol: 110 = $$$ Line item records of table &&& deleted.
Text Symbol: 120 = $$$ Plan line item records of table &&& deleted.
Text Symbol: 121 = $$$ Records of the allocation history (table &&& ) deleted.
Text Symbol: 125 = $$$ Index records of table &&& deleted.
Text Symbol: 126 = $$$ Non-assigned index records of table &&& deleted.
Text Symbol: 127 = $$$ Index records of table &&& deleted.
Text Symbol: 130 = Are you sure you want to delete?
Text Symbol: 150 = Confirmation prompt
Text Symbol: 160 = Delete the data of one ledger
Text Symbol: 161 = Scope of Deletion
Text Symbol: 162 = Deletion statistics for ledger &&&.
Text Symbol: 164 = Delete all FI-SL transaction data and initialization of the number ranges
Text Symbol: 165 = Delete the data of an entire table group
Text Symbol: 166 = Deletion statistics for summary table &&& and its dependent tables
Text Symbol: 167 = Do you want to delete table GLT2
Text Symbol: 168 = (consolidation) as well?
Text Symbol: 169 = Delete consolidation?
Text Symbol: 170 = Number ranges initialized for object GL GLOBAL
Text Symbol: 171 = Number ranges initialized for object GL LOCAL
Text Symbol: 172 = Number ranges initialized for object GL ROLLUP
Text Symbol: 173 = Number ranges initialized for object GL BUCHEN
INCLUDES used within this REPORT RGUDEL00
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:
SELECT_OPTIONS_RESTRICT CALL FUNCTION 'SELECT_OPTIONS_RESTRICT' EXPORTING restriction = rest EXCEPTIONS OTHERS = 1.
POPUP_TO_CONFIRM_LOSS_OF_DATA CALL FUNCTION 'POPUP_TO_CONFIRM_LOSS_OF_DATA' EXPORTING textline1 = text-130 titel = text-150 IMPORTING answer = answer.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = t800a-tab fieldname = 'LOGSYS' IMPORTING field_attr = h_dfies EXCEPTIONS OTHERS = 1.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = t800a-tab fieldname = 'RACCT' IMPORTING field_attr = h_dfies EXCEPTIONS OTHERS = 1.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = t800a-tab fieldname = 'AWTYP' IMPORTING field_attr = h_dfies EXCEPTIONS OTHERS = 1.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = t800a-tab fieldname = 'ACTIV' IMPORTING field_attr = h_dfies EXCEPTIONS OTHERS = 1.
G_ADMI_AUTHORITY_CHECK CALL FUNCTION 'G_ADMI_AUTHORITY_CHECK' EXPORTING activity = '04' EXCEPTIONS not_authorized = 01.
G_MAX_PERIOD_AND_OFFSET_GET CALL FUNCTION 'G_MAX_PERIOD_AND_OFFSET_GET' EXPORTING period = periods-poper table = ut881-tab IMPORTING rpmax = tab_rpmax-rpmax EXCEPTIONS table_not_found = 1 OTHERS = 2.
G_MAX_PERIOD_AND_OFFSET_GET CALL FUNCTION 'G_MAX_PERIOD_AND_OFFSET_GET' EXPORTING period = periods-poper table = ut881-tab IMPORTING rpmax = tab_rpmax-rpmax EXCEPTIONS table_not_found = 1 OTHERS = 2.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
G_DELETE_T811D CALL FUNCTION 'G_DELETE_T811D' EXPORTING rldnr = dr_rldnr rrcty = dr_rrcty rvers = dr_rvers bukrs = dr_bukrs rcomp = dr_rcomp ryear = dr_ryear poper_fr = ld_poper_from poper_to = ld_poper_to IMPORTING counter = t811d_count EXCEPTIONS OTHERS = 1.
G_DELETE_T811D CALL FUNCTION 'G_DELETE_T811D' EXPORTING tab = table IMPORTING counter = t811d_count EXCEPTIONS OTHERS = 1.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
DB_COMMIT CALL FUNCTION 'DB_COMMIT'.
G_DISPLAY_T800A_TABLES CALL FUNCTION 'G_DISPLAY_T800A_TABLES' EXPORTING gappl = h_appl-appl gsubappl = h_appl-subappl IMPORTING picked_tab = p_deltab EXCEPTIONS OTHERS = 1.
F4IF_FIELD_VALUE_REQUEST CALL FUNCTION 'F4IF_FIELD_VALUE_REQUEST' EXPORTING tabname = 'FAGLFLEXT' fieldname = 'RLDNR' searchhelp = 'FAGL_RLDNR_AND_ROLLUP_W_LEAD' shlpparam = 'RLDNR' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_RLDNR'.
F4IF_FIELD_VALUE_REQUEST CALL FUNCTION 'F4IF_FIELD_VALUE_REQUEST' EXPORTING tabname = 'FAGLFLEXT' fieldname = 'RLDNR' searchhelp = 'FAGL_RLDNR' shlpparam = 'RLDNR' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_RLDNR'.
F4IF_FIELD_VALUE_REQUEST CALL FUNCTION 'F4IF_FIELD_VALUE_REQUEST' EXPORTING tabname = 'GLU1' fieldname = 'RLDNR' searchhelp = 'H_T881_FREE' shlpparam = 'RLDNR' dynpprog = sy-repid dynpnr = sy-dynnr dynprofield = 'P_RLDNR'.
G_DISPLAY_LEDGERS_FOR_TABLE CALL FUNCTION 'G_DISPLAY_LEDGERS_FOR_TABLE' EXPORTING gappl = h_appl-appl gsubappl = h_appl-subappl only_free_ledgers = h_only_free_ledgers only_fixed_ledgers = h_only_fixed_ledgers only_display = ' ' with_dependent_ledgers = h_with_dependent_ledgers IMPORTING picked_ledger = p_rldnr TABLES allowed_tables = allowed_tables.
G_DISPLAY_SELECTION_DYNPRO CALL FUNCTION 'G_DISPLAY_SELECTION_DYNPRO' EXPORTING dynp_title = text-200 key_columns = 0 number_of_rows = 8 sel_title1 = disp_t894 sel_title2 = '-' start_column = 0 start_row = 3 width_of_titles = 'X' without_selection = ' ' IMPORTING sel_index = sel_index TABLES sel_table = disp_t894 EXCEPTIONS no_lines = 01 no_line_picked = 02 OTHERS = 03.
CALL FUNCTION 'REUSE_ALV_EVENTS_GET' EXPORTING i_list_type = 0 IMPORTING et_events = xt_eventstab EXCEPTIONS list_type_wrong = 1 OTHERS = 2.
REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = gv_repid i_structure_name = gc_structure CHANGING ct_fieldcat = xt_fieldcatalog EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.
REUSE_ALV_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY' EXPORTING i_callback_program = iv_repid is_layout = is_layout it_fieldcat = it_fieldcat i_save = ic_save is_variant = is_variant it_events = it_eventstab TABLES t_outtab = gt_output EXCEPTIONS program_error = 1 OTHERS = 2.
REUSE_ALV_LIST_LAYOUT_INFO_GET CALL FUNCTION 'REUSE_ALV_LIST_LAYOUT_INFO_GET' IMPORTING e_width = lv_linsz.
REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = gt_list_top_of_page.
RS_REFRESH_FROM_SELECTOPTIONS CALL FUNCTION 'RS_REFRESH_FROM_SELECTOPTIONS' EXPORTING CURR_REPORT = sy-repid TABLES SELECTION_TABLE = lt_rsparams.
G_UPDATE_T800HIST CALL FUNCTION 'G_UPDATE_T800HIST' EXPORTING I_OBJNAME = sy-repid TABLES T_RSPARAMS = lt_rsparams.
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 RGUDEL00 or its description.