SAP Reports / Programs | Trader's and Scheduler's Workbench | Industry Solution Oil | Trader's and Scheduler's Workbench(IS-OIL-DS-TSW) SAP IS

ROIJRDU2 SAP ABAP Report - Remove expired entries from SP database







ROIJRDU2 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter ROIJRDU2 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 ROIJRDU2. "Basic submit
SUBMIT ROIJRDU2 AND RETURN. "Return to original report after report execution complete
SUBMIT ROIJRDU2 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: P_NOLOG = No processing log
Selection Text: P_NOUPD = No update (test mode)
Title: Remove expired entries from SP database
Text Symbol: 100 = Start of processing
Text Symbol: 101 = End of processing
Text Symbol: 102 = - processing log
Text Symbol: 113 = - return code was
Text Symbol: 114 = Completed successfully
Text Symbol: 115 = Completed with warnings
Text Symbol: 116 = Completed with errors
Text Symbol: 117 = Abnormal completion
Text Symbol: 118 = No objects found with last SPW horizons earlier than today
Text Symbol: 126 = Unable to enqueue SPW object
Text Symbol: 138 = Program is running in test mode - no database updates will occur
Text Symbol: 139 = Program completed in test mode - no database updates were made
Text Symbol: 146 = Object deletion carried out for TS + mat object
Text Symbol: 147 = Object deletion carried out for loc + mat object
Text Symbol: 202 = SPW housekeeping utility: control


INCLUDES used within this REPORT ROIJRDU2

INCLUDE OIJRAUDD.
INCLUDE OIJRAUTH.


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:

OIJD_GET_OIJX CALL FUNCTION 'OIJD_GET_OIJX' TABLES T_OIJX = G_OIJX EXCEPTIONS READ_ERROR = 1 OTHERS = 2.

OIJU_RD_CALCULATE_PERIOD CALL FUNCTION 'OIJU_RD_CALCULATE_PERIOD' EXPORTING i_roijrdhead = ls_oijrdhead i_timebucket = ls_timebuckets i_oijx = g_oijx i_repdate = oij_rdhead-aedat CHANGING c_from_date = l_date_lo c_to_date = l_date_hi.

ENQUEUE_E_OIJRD CALL FUNCTION 'ENQUEUE_E_OIJRD' EXPORTING tsyst = g_oijrdh_del_tab-tsyst matnr = g_oijrdh_del_tab-matnr x_locid = c_enqueue_as_initial_value EXCEPTIONS foreign_lock = 1 system_failure = 2 OTHERS = 3.

OIJU_RD_DELETE_COMPLETE_OBJECT CALL FUNCTION 'OIJU_RD_DELETE_COMPLETE_OBJECT' IN UPDATE TASK EXPORTING i_oijrdh = g_oijrdh_del_tab EXCEPTIONS OTHERS = 1.

ENQUEUE_E_OIJRD CALL FUNCTION 'ENQUEUE_E_OIJRD' EXPORTING locid = g_oijrdh_del_tab-locid matnr = g_oijrdh_del_tab-matnr x_tsyst = c_enqueue_as_initial_value EXCEPTIONS foreign_lock = 1 system_failure = 2 OTHERS = 3.

OIJU_RD_DELETE_COMPLETE_OBJECT CALL FUNCTION 'OIJU_RD_DELETE_COMPLETE_OBJECT' IN UPDATE TASK EXPORTING i_oijrdh = g_oijrdh_del_tab EXCEPTIONS OTHERS = 1.



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 ROIJRDU2 or its description.