FAGL_OBJCHECK SAP ABAP Report - NewGL Analysis: Check Object Number Inconsistencies
FAGL_OBJCHECK is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This report analyzes object number inconsistencies in the tables in new General Ledger Accounting...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 FAGL_OBJCHECK 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 FAGL_OBJCHECK. "Basic submit
SUBMIT FAGL_OBJCHECK AND RETURN. "Return to original report after report execution complete
SUBMIT FAGL_OBJCHECK VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: NewGL Analysis: Check Object Number Inconsistencies
Text Symbol: 059 = List: Only Summary
Text Symbol: 061 = Check Object Number Inconsistencies
Text Symbol: 062 = Ledger and Table Group
Text Symbol: 063 = Additional Restrictions
Text Symbol: 064 = Analyze Object Numbers
Text Symbol: 065 = Repair Object Numbers
Text Symbol: 066 = Deletion Parameters
Text Symbol: 071 = Repair totals AND delete selected object tables
Text Symbol: 072 = Delete selected object tables
Text Symbol: 073 = Delete Object Table 0
Text Symbol: 074 = Delete Object Table 1
Text Symbol: 075 = Delete Object Table 2
Text Symbol: 076 = Delete Object Table 3
Text Symbol: 077 = Delete Object Table 4
Text Symbol: 078 = Delete Object Table 5
Text Symbol: 079 = Delete Object Table 6
Text Symbol: 080 = Delete Object Table 7
Text Symbol: 081 = Delete Object Table 8
Text Symbol: 082 = Update Run
Text Symbol: 083 = Full Table: Processing order based on primary key
Text Symbol: 084 = Full Table: Separate Portions / Highest Year no. first
Text Symbol: 085 = *** For Experts only *** Repair specific Fiscal Year
Text Symbol: 086 = Commit Counter
Text Symbol: 100 = No object number inconsistencies found in summary table $ (in selection range)
Text Symbol: 101 = At least one of the object tables is not unique
Text Symbol: 111 = Error Counter
Text Symbol: 112 = Error Text
Text Symbol: 113 = Errors in Summary Table
Text Symbol: 114 = Current Object Number
Text Symbol: 115 = DB Maximum Object Number
Text Symbol: 116 = Unique
Text Symbol: 117 = Process
Text Symbol: 118 = No.of Records
Text Symbol: 058 = Anmerkung an Übersetzung: Text 059: Liste: Nur Zusammenfassung
Text Symbol: 001 = Field $: Object Number exists in table $ but not in $
Text Symbol: 002 = Field $: one object no. in sum.table $ relates to several entries in obj.table $
Text Symbol: 003 = Table $ and $ do not match - same obj.no different field values
Text Symbol: 004 = Field $: Summary table has obj.number '0' though field values are not INITIAL
Text Symbol: 005 = Table $ contains no accounting fields but one obj.no. > 0 exist in $ and $
Text Symbol: 006 = Table $ contains no accounting fields but several obj.no. > 0 exist in $ and $
Text Symbol: 007 = Error
Text Symbol: 008 = Object Table
Text Symbol: 009 = Selection Parameters:
Text Symbol: 010 = Result of object table check:
Text Symbol: 011 = Summary Table $ contains fields with NULL values (checked: all rows in table)
Text Symbol: 012 =
Text Symbol: 013 = The following tables have been processed:
Text Symbol: 021 = Missing entry in object table $ for affected dimensions
Text Symbol: 022 = Field $: Several entries for same combinations in obj.table $
Text Symbol: 023 = Same combinations in Table $ and $ but different object numbers
Text Symbol: 024 = FIELD $: Dimensions in summary table are INITIAL but field $ is not equal 0
Text Symbol: 025 = At least one defect line has been detected:
Text Symbol: 026 = $: RYEAR=$,RBUKRS=$,RACCT=$
Text Symbol: 027 = Table $
Text Symbol: 028 = Analyzing $ lines in $
Text Symbol: 029 = No.of Records $
Text Symbol: 030 = Processing: Year $, CoCode $ RRCTY = $
Text Symbol: 031 = Analysing data distribution(Year/Comp.Code)
Text Symbol: 032 = Repaired: Year $, CoCode $ RRCTY = $
Text Symbol: 050 = Detail List: Defect entries of sum.table $ and referring object table $
Text Symbol: 051 = Ledger
Text Symbol: 052 = Record Type
Text Symbol: 053 = Version
Text Symbol: 054 = Fiscal Year
Text Symbol: 055 = Company Code
Text Symbol: 056 = Account Number
Text Symbol: 057 = All Ledgers of Assigned Table
INCLUDES used within this REPORT FAGL_OBJCHECK
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:
FAGL_CHECK_IF_LEDGER_IS_GLFLEX CALL FUNCTION 'FAGL_CHECK_IF_LEDGER_IS_GLFLEX' EXPORTING i_rldnr = p1_rldnr EXCEPTIONS not_found = 1 no_glflex_ledger = 2 glflex_rollup_ledger = 3 OTHERS = 4.
G_FIELDTAB_GET CALL FUNCTION 'G_FIELDTAB_GET' EXPORTING table = ls_t800a-tab ftype = 'K' no_glx_obj_processing = 'X' TABLES t_fieldtab = t_sumfields.
G_FIELDTAB_GET CALL FUNCTION 'G_FIELDTAB_GET' EXPORTING table = ls_t800a-tab ftype = 'K' no_glx_obj_processing = ' ' TABLES t_fieldtab = t_h_sumfields.
G_FIELDTAB_GET CALL FUNCTION 'G_FIELDTAB_GET' EXPORTING table = ls_t800a-tab ftype = 'D' no_glx_obj_processing = ' ' TABLES t_fieldtab = t_d_sumfields.
G_FIELDTAB_GET CALL FUNCTION 'G_FIELDTAB_GET' EXPORTING table = ls_t800a-tab ftype = 'K' no_glx_obj_processing = 'X' TABLES t_fieldtab = t_k_sumfields.
G_FIELDTAB_GET CALL FUNCTION 'G_FIELDTAB_GET' EXPORTING table = gs_fagl_tabs-tab ftype = 'A' no_glx_obj_processing = 'X' TABLES t_fieldtab = lt_objfields.
CALL FUNCTION 0 0 'CALL FUNCTION ''DB_COMMIT''.' space.
CALL FUNCTION USING 0 0 'CALL FUNCTION ''DB_SET_ISOLATION_LEVEL''.' space.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = t800a-tab fieldname = h_fieldname EXCEPTIONS not_found = 1 OTHERS = 2.
CALL FUNCTION 0 0 'CALL FUNCTION ''DB_COMMIT''.' space, "#EC NOTEXT
CALL FUNCTION 'CALL FUNCTION ''DB_RESET_ISOLATION_TO_DEFAULT''.' "#EC NOTEXT
CALL FUNCTION 4 0 'CALL FUNCTION ''G_ADJUST_RECORD''' space, "#EC NOTEXT 0 0 ' EXPORTING' space, "#EC NOTEXT 0 0 ' RENUMBER_OBJ = ''X''' space, "#EC NOTEXT 0 0 ' TABELLENNAME = c_sumtab' space, "#EC NOTEXT 0 0 ' TABLES' space, "#EC NOTEXT 0 0 ' TABELLE = REPAIR_SUMTAB' space, "#EC NOTEXT 0 0 ' EXCEPTIONS' space, "#EC NOTEXT 0 0 ' OTHERS = 1.' space, "#EC NOTEXT
CALL FUNCTION 0 0 'CALL FUNCTION ''DB_COMMIT''.' space,
CALL FUNCTION 0 0 'CALL FUNCTION ''DB_COMMIT''.' space,
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = t800a-tab fieldname = cis_field EXCEPTIONS not_found = 1 OTHERS = 2.
G_SPLIT_LINE CALL FUNCTION 'G_SPLIT_LINE' EXPORTING input_line = unsplitted_line TABLES export_lines = splitted_code EXCEPTIONS OTHERS = 1.
FAGL_GET_OBJECT_TABLES CALL FUNCTION 'FAGL_GET_OBJECT_TABLES' EXPORTING iv_totals_table = ls_t800a-tab IMPORTING et_object_tables = lt_object_table EXCEPTIONS table_not_installed = 1 table_no_totals_table = 2 old_fashioned_table = 3 OTHERS = 4.
G_TABLE_READ_INACTIVE CALL FUNCTION 'G_TABLE_READ_INACTIVE' EXPORTING table = gs_fagl_tabs-tab EXCEPTIONS active_and_inactive = 1 not_found = 2 only_active = 3 only_inactive = 4 OTHERS = 5.
FAGL_GET_ALL_TABLES CALL FUNCTION 'FAGL_GET_ALL_TABLES' EXPORTING iv_only_active = 'X' IMPORTING et_tabnames = gt_all_gl_tabs.
NUMBER_GET_INFO CALL FUNCTION 'NUMBER_GET_INFO' EXPORTING nr_range_nr = '01' object = gs_fagl_tabs-no_object IMPORTING interval = ls_info EXCEPTIONS interval_not_found = 1 object_not_found = 2 OTHERS = 3.
REUSE_ALV_BLOCK_LIST_INIT CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT' EXPORTING i_callback_program = gd_repid i_callback_user_command = 'USER_COMMAND' i_callback_pf_status_set = 'PF_STATUS_SET'.
REUSE_ALV_BLOCK_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY' EXPORTING is_print = gt_print.
CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_INIT' EXPORTING i_callback_program = gd_repid i_callback_user_command = 'USER_COMMAND' i_callback_pf_status_set = 'PF_STATUS_SET'.
REUSE_ALV_BLOCK_LIST_DISPLAY CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_DISPLAY' EXPORTING is_print = gt_print.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd1_field is_layout = gs1_layout i_tabname = 'GT_TAB1DATA' it_events = gt1_events i_text = 'LIST1' TABLES t_outtab = gt_tab1data.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt20_events i_text = 'LIST2' TABLES t_outtab = gt0_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt21_events i_text = 'LIST2' TABLES t_outtab = gt1_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt22_events i_text = 'LIST2' TABLES t_outtab = gt2_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt23_events i_text = 'LIST2' TABLES t_outtab = gt3_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt24_events i_text = 'LIST2' TABLES t_outtab = gt4_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt25_events i_text = 'LIST2' TABLES t_outtab = gt5_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt26_events i_text = 'LIST2' TABLES t_outtab = gt6_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt27_events i_text = 'LIST2' TABLES t_outtab = gt7_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt28_events i_text = 'LIST2' TABLES t_outtab = gt8_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd2_field is_layout = gs2_layout i_tabname = 'GLU1' it_events = gt29_events i_text = 'LIST2' TABLES t_outtab = gtx_glu1x.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd3_field is_layout = gs3_layout i_tabname = 'GT_OBJ_STATISTICS' it_events = gt3_events i_text = 'LIST3' TABLES t_outtab = gt_obj_statistics.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = g_sumtab fieldname = gs_fagl_tabs-obj_fieldnam no_glx_obj_processing = 'X' EXCEPTIONS not_found = 1 OTHERS = 2.
REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING i_program_name = gd_repid i_structure_name = 'GLU1' CHANGING ct_fieldcat = gd2_field EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3.
G_FIELD_READ CALL FUNCTION 'G_FIELD_READ' EXPORTING table = g_sumtab fieldname = gdx_field-fieldname no_glx_obj_processing = 'X' IMPORTING field_attr = ls_dfies EXCEPTIONS not_found = 1 OTHERS = 2.
REUSE_ALV_BLOCK_LIST_APPEND CALL FUNCTION 'REUSE_ALV_BLOCK_LIST_APPEND' EXPORTING it_fieldcat = gd0_field is_layout = gs0_layout i_tabname = 'gt_result1' it_events = gt0_events i_text = 'LIST0' TABLES t_outtab = gt_result1.
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 FAGL_OBJCHECK or its description.
FAGL_OBJCHECK - NewGL Analysis: Check Object Number Inconsistencies FAGL_OBJCHECK - NewGL Analysis: Check Object Number Inconsistencies FAGL_NRIV20 - Document Number Ranges: Copy by Fiscal Year (General Ledger View) FAGL_NRIV20 - Document Number Ranges: Copy by Fiscal Year (General Ledger View) FAGL_NRIV10 - Document Number Ranges: Copy by Company Code (General Ledger View) FAGL_NRIV10 - Document Number Ranges: Copy by Company Code (General Ledger View)