RSREQREDUCE

This is the main t-code which can be used to monitor the growth of the requests in the system.This gives the growth of all types of infoproviders - DSO/W.DSO/Infocubes/Master data objects

Green   : Good, No reduction needed

yellow  : Can be useful to reduce/delete the request list

Red      : Request list should be reduced/deleted.

Maintain a single datatarget

This gives overview of the single datasource selected.

Filter for Mass Actions

This gives us the ability to filter the report display using various options like only yellow data targets, data targets with more than 1000 records etc.

Mass Reduction of Requests

This option can be used to reduce the requests from InfoCubes and Std. DSOs.

Underlying FM : RSSM_REDUCE_REQUESTLIST

Mass Deletion of Requests

This is for Write Optimized DSOs and Master Data InfoObjects.

Underlying FMs:

WDSO  Deletion of requests : RSM1_DELETE_WO_DSO_REQUESTS

Master Data and Texts : RSS2_AUTODEL_REQU_MASTER_TEXT

RSSM_REDUCE_REQUESTLIST

Points to note

- This is the used for maintaining DSOs and InfoCubes.

- Change log should be deleted before running this program.

- The standard program needs 1000 requests  and min. of 1 month to delete the requests.

- As of 7.4 upgrade, enqueue and dequeue locks are added to the program, which ensures safe    running. before that version, program dumps/acts wierd when run when loading process is going on.

RSM1_DELETE_WO_DSO_REQUESTS

This is for deleting requests from Write Optimized DSOs.

In order to use this program, the requests in the W.DSO need to archived, else we cannot run the deletion. 

( ?? I ran the program the first time and it ran fine with out archiving. Next time, I ran it started giving me message, " Data target ZWDSOSALES is already reduced; no further deletion allowed. First undo the reduction" . Not sure why it reduced it the first time )

Points to Note

-          Min of 1 day is necessary to delete the entries

-          Min no. or requests = 1

RSSM_AUTODEL_REQU_MASTER_TEXT

This is used to delete requests from Master Data and Texts.

Only administration information and status manager information will be deleted.

-          Min no of days : 1

-          Min no. of records to remain : 1

-          The same program deletes Master data Attributes and Master data text.

o   When deleting attributes, give ‘0MATERIAL’ on the selection screen

o   For texts ‘0Material$T’.

Control tables

rsmonreqdelredu  - Creates an entry with the deletion job name and other details

RSICCONT - Has list of all requests in the infoprovider

Related Notes
Housekeeping for BW requests  : Notes
2248065 - P14; DTP; REDUCE: Dump CL_RSSM_STATMAN/CHECK_REQUESTS_EXIST