RHCHECKRELATIONS_OLD is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for TRADOS memory: ndbw_hr_paos CHECKING THE CONSISTENCY OF RELATIONSHIPS This report eliminates all inconsistent relationship records from the 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 RHCHECKRELATIONS_OLD into the relevant SAP transactions such as SE38 or SE80
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.
Selection Text: USERNAME = User Name
Selection Text: PLANVAR = Plan Version
Selection Text: OBJTYPE = Object Type
Selection Text: OBJID = Object ID / Personnel No.
Selection Text: DIRDEL = Direct delete (X=yes)
Title: Delete relationships without existing objects
Text Symbol: 032 = Delete relationships
Text Symbol: 031 = No inconsistent records available
Text Symbol: 030 = Inconsistent recs
Text Symbol: 029 = Error in config. of ALV
Text Symbol: 028 = Deleted records
Text Symbol: 027 = LIST OF INCONSISTENT RECORDS
Text Symbol: 026 = LIST OF DELETED RECORDS
Text Symbol: 025 = Delete selected records?
Text Symbol: 024 = Plan version does not exist (use F4 help)
Text Symbol: 023 = Following records were deleted
Text Symbol: 022 = User name not permitted (letters only)
Text Symbol: 021 = Entry not permitted for 'Direct delete' (X=yes)
Text Symbol: 019 = Delete selected objects?
Text Symbol: 018 = Select records to be deleted
Text Symbol: 015 = Deletion from database not possible
Text Symbol: 014 = Obj.type not permitted
Text Symbol: 013 = Error with ALV field catalog
Text Symbol: 012 = Due to error with ALV functionality, a simple list is to be produced
Text Symbol: 011 = Number of del. records:
No INCLUDES are used within this REPORT code!
No SAP DATABASE tables are accessed within this REPORT code!
TR_GET_SAPR3_TYPE CALL FUNCTION 'TR_GET_SAPR3_TYPE' TABLES TT_CVERS = l_components EXCEPTIONS NO_TSYST_ENTRY = 1 OTHERS = 2.
TR_GET_SAPR3_TYPE CALL FUNCTION 'TR_GET_SAPR3_TYPE' TABLES tt_cvers = lt_cvers EXCEPTIONS no_tsyst_entry = 1 OTHERS = 2.
POPUP_TO_CONFIRM_DEL CALL FUNCTION 'POPUP_TO_CONFIRM_DEL' EXPORTING titel = text-032 * PFKEY = * KEYFLAG = ' ' * SHORTFLAG = ' ' begda = '01011900' endda = '12319999' * DEFIBEGDA = * DEFIENDDA = * OTYPE_1 = * REALO_1 = * SHORT_1 = stext_1 = del_text * OTYPE_2 = * REALO_2 = * SHORT_2 = * STEXT_2 = IMPORTING answer = go_on * DBEGDA = * DENDDA = * CONFL = * TABLES * NODETB = .
RH_TURN_RELATION CALL FUNCTION 'RH_TURN_RELATION' EXPORTING otype = object_type EXCEPTIONS relation_not_reversible = 1 OTHERS = 2.
RH_INVERT_RELA_INFTY CALL FUNCTION 'RH_INVERT_RELA_INFTY' EXPORTING p1001_imp = int_p1001 IMPORTING p1001_exp = inv_p1001 EXCEPTIONS relation_not_reversible = 1 OTHERS = 2.
REUSE_ALV_GRID_LAYOUT_INFO_GET CALL FUNCTION 'REUSE_ALV_GRID_LAYOUT_INFO_GET' IMPORTING es_layout = p1001_alv_layout et_fieldcat = fieldcat_alv_p1001 * ET_SORT = * ET_FILTER = * ES_GRID_SCROLL = * ES_VARIANT = * ET_MARKED_COLUMNS = * ET_FILTERED_ENTRIES = EXCEPTIONS no_infos = 1 program_error = 2 OTHERS = 3 .
RH_INVERT_RELA_INFTY CALL FUNCTION 'RH_INVERT_RELA_INFTY' EXPORTING p1001_imp = int_p1001 IMPORTING p1001_exp = inv_p1001 EXCEPTIONS relation_not_reversible = 1 OTHERS = 2.
POPUP_TO_CONFIRM_DEL CALL FUNCTION 'POPUP_TO_CONFIRM_DEL' EXPORTING titel = text-032 * PFKEY = * KEYFLAG = ' ' * SHORTFLAG = ' ' begda = '01011900' endda = '12319999' * DEFIBEGDA = * DEFIENDDA = * OTYPE_1 = * REALO_1 = * SHORT_1 = stext_1 = del_text * OTYPE_2 = * REALO_2 = * SHORT_2 = * STEXT_2 = IMPORTING answer = go_on * DBEGDA = * DENDDA = * CONFL = * TABLES * NODETB = .
REUSE_ALV_GRID_LAYOUT_INFO_SET CALL FUNCTION 'REUSE_ALV_GRID_LAYOUT_INFO_SET' EXPORTING is_layout = p1001_alv_layout it_fieldcat = fieldcat_alv_p1001 * IT_SORT = * IT_FILTER = * IS_GRID_SCROLL = .
RHAP_SUPPR_INTE_SET CALL FUNCTION 'RHAP_SUPPR_INTE_SET' EXPORTING suppr_inte = 'X'.
RH_DELETE_INFTY_DIRECT CALL FUNCTION 'RH_DELETE_INFTY_DIRECT' EXPORTING vtask = 'D' order_flg = ' ' commit_flg = 'X' authy = ' ' "note377627 * KEEP_LUPD = * WORKF_ACTV = 'X' TABLES innnn = del_no_inte "note390337 * ILFCODE = EXCEPTIONS no_authorization = 1 error_during_delete = 2 corr_exit = 3 OTHERS = 4 .
RHAP_SUPPR_INTE_SET CALL FUNCTION 'RHAP_SUPPR_INTE_SET' EXPORTING suppr_inte = ' '.
RH_DELETE_INFTY_DIRECT CALL FUNCTION 'RH_DELETE_INFTY_DIRECT' EXPORTING vtask = 'D' order_flg = ' ' commit_flg = 'X' authy = ' ' "note377627 * KEEP_LUPD = * WORKF_ACTV = 'X' TABLES innnn = del_with_inte "note390337 * ILFCODE = EXCEPTIONS no_authorization = 1 error_during_delete = 2 corr_exit = 3 OTHERS = 4 .
RH_GET_EXTERNAL_OBJECT_INFO CALL FUNCTION 'RH_GET_EXTERNAL_OBJECT_INFO' EXPORTING otype = obj_type * IMPORTING * I77EO = EXCEPTIONS no_external_object = 1 OTHERS = 2 .
RH_EXIST_OBJECT CALL FUNCTION 'RH_EXIST_OBJECT' EXPORTING plvar = p_plog_plvar otype = p_plog_otype objid = p_plog_objid * REALO = ' ' * IMPORTING * EXTERNAL_OBJECT = " wenn ext. Obj. dann kein check
RH_READ_OBJECT * CALL FUNCTION 'RH_READ_OBJECT' * EXPORTING * plvar = p_plog_plvar * otype = p_plog_otype * objid = p_plog_objid ** REALO = ' ' ** ISTAT = ' ' ** BEGDA = SY-DATUM ** ENDDA = SY-DATUM ** LANGU = SY-LANGU ** OINTERVAL = 'X' ** STORE = 'X' ** CHECK_STRU_AUTH = 'X' ** READ_DB = ' ' * IMPORTING * obeg = obj_begda * oend = obj_endda ** OSTAT = ** HISTO = ** SHORT = ** STEXT = ** TISTAT = ** TLANGU = ** DISPLAY_TEXT = ** TABLES ** EXISTENCE = * EXCEPTIONS * not_found = 1 * OTHERS = 2.
RHEO_EXIST_EXTOBJ CALL FUNCTION 'RHEO_EXIST_EXTOBJ' EXPORTING otype = obj_type realo = p_realo begda = '19990101' endda = '99991231' IMPORTING subrc = out_subrc EXCEPTIONS illegal_otype = 1 method_not_supported = 2 OTHERS = 3.
REUSE_ALV_FIELDCATALOG_MERGE CALL FUNCTION 'REUSE_ALV_FIELDCATALOG_MERGE' EXPORTING * I_PROGRAM_NAME = * I_internal_tabname = i_structure_name = 'P1001' * I_CLIENT_NEVER_DISPLAY = 'X' * I_INCLNAME = CHANGING ct_fieldcat = fieldcat_alv_p1001 EXCEPTIONS inconsistent_interface = 1 program_error = 2 OTHERS = 3 .
CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY' EXPORTING * I_INTERFACE_CHECK = ' ' i_buffer_active = 'X' i_callback_program = 'RHCHECKRELATIONS_OLD' i_callback_pf_status_set = 'SET_ALV_DEL_PF_STATUS' i_callback_user_command = 'SET_USER_COMMAND' i_callback_top_of_page = 'SET_HEADER_TEXT' * I_CALLBACK_HTML_TOP_OF_PAGE = ' ' * I_CALLBACK_HTML_END_OF_LIST = ' ' * I_STRUCTURE_NAME = ' ' * I_BACKGROUND_ID = ' ' * I_GRID_TITLE = * I_GRID_SETTINGS = is_layout = p1001_alv_layout it_fieldcat = fieldcat_alv_p1001 * IT_EXCLUDING = * IT_SPECIAL_GROUPS = * IT_SORT = * IT_FILTER = * IS_SEL_HIDE = * I_DEFAULT = 'X' * I_SAVE = ' ' * IS_VARIANT = * IT_EVENTS = * IT_EVENT_EXIT = * IS_PRINT = * IS_REPREP_ID = * I_SCREEN_START_COLUMN = 0 * I_SCREEN_START_LINE = 0 * I_SCREEN_END_COLUMN = 0 * I_SCREEN_END_LINE = 0 * IMPORTING * E_EXIT_CAUSED_BY_CALLER = * ES_EXIT_CAUSED_BY_USER = TABLES t_outtab = p_alv_out_p1001 EXCEPTIONS program_error = 1 OTHERS = 2 .
REUSE_ALV_COMMENTARY_WRITE CALL FUNCTION 'REUSE_ALV_COMMENTARY_WRITE' EXPORTING it_list_commentary = my_slis_t_listheader * I_LOGO = * I_END_OF_LIST_GRID = .
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 RHCHECKRELATIONS_OLD or its description.
RHCHECKRELATIONS_OLD - Delete relationships without existing objects RHCHECKRELATIONS_OLD - Delete relationships without existing objects RHCHECKRELATIONS - Delete relationships without existing objects RHCHECKRELATIONS - Delete relationships without existing objects RHCHECKP - Consistency Check PD Database Table and Additional Data Pointers RHCHECKP - Consistency Check PD Database Table and Additional Data Pointers