SAP Knowledge Base Article - Preview

3137171 - General Information on Housekeeping for Request Administration tables (RSPM* tables)

Symptom

You want to know how to proceed in order to perform Housekeeping in RSPM Request Administration tables. These tables are either occupying huge disk size in your database or you are noticing increasing performance issues during data loads or data activation in InfoProviders. This document will try to detail all relevant information you must know in order to properly perform Housekeeping in your system and how to proceed for each table, as some of them cannot have their data deleted while others can. This KBA refers to such below tables and their respective RSPMHK* counterparts, if they exist:

  • RSPMADMIN
  • RSPMDATAPID
  • RSPMDATATARGET
  • RSPMDTASELECTION
  • RSPMFILTERCMD
  • RSPMLOG
  • RSPMPROCESS
  • RSPMPROCESSDTAV
  • RSPMPROCESSTYPE
  • RSPMPROCESSTYPET
  • RSPMREQSTATHIST
  • RSPMREQUEST
  • RSPMREQUESTPRO
  • RSPMSTATICEVENT
  • RSPMSTORAGESTAT
  • RSPMTRACE
  • RSPMVARIANT
  • RSPMXREF

Notice that the programs and processes delivered by SAP will account for all relevant tables where Housekeeping must be performed, regardless if they are listed here or not. The above list is just a reference, not necessarily including all relevant tables for Housekeeping.


Read more...

Environment

SAP NetWeaver Business Warehouse 7.5

SAP BW/4HANA - All versions

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; SAP NetWeaver 7.5

Keywords

RSPM, Housekeeping, doubts, questions, how to proceed, RSPM_Housekeeping, DTP, TSN, request, RSPM, ADSO, Cleanup, RSPMREQUEST, RSPMPROCESS, RSPMXREF, general, main, information, clean, up, cleanup, RSPMADMIN, RSPMDATAPID, RSPMDATATARGET, RSPMDTASELECTION, RSPMFILTERCMD, RSPMLOG, RSPMPROCESS, RSPMPROCESSDTAV, RSPMPROCESSTYPE, RSPMPROCESSTYPET, RSPMREQSTATHIST, RSPMREQUEST, RSPMREQUESTPRO, RSPMSTATICEVENT, RSPMSTORAGESTAT, RSPMTRACE, RSPMVARIANT, RSPMXREF, process chain variant, BW Request Status Management: Housekeeping , KBA , BW-WHM-DST-RSPM , BW Request Status and Process Management , BW4-DM-RSPM , Request Status and Process Management , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.