The amount of data is significant in technical tables.
This SAP Note covers data management for tables with a mainly technical background, e.g. used for:
It doesn't deal with application tables.
For a more comprehensive archiving overview you can check the Data Management Guide available in the Data Volume Management area. SAP Note 2243625 provides SAP Enterprise Support offerings in the context of data volume management.
This SAP Note is valid for all underlying databases.
In addition to the information in this SAP Note, see also SAP Note 16083 that describes the scheduling of standard and reorganization jobs.
You should regularly delete or archive the entries (listed in the tables below) that are no longer required. In addition to this, you must check to some extent whether the configuration is correct.
If you use a SAP HANA database, you can use the SQL command SQL: "HANA_Tables_LargestTables" and ONLY_TECHNICAL_TABLES = 'X' (SAP Note 1969700) to determine the largest of these tables.
If you use an Oracle database, you can use the SQL command SQL: "Space_LargestTables" and ONLY_BASIS_TABLES = 'X' (SAP Note 1438410) to determine the largest of these tables.
This SAP Note replaces SAP Note 706478.
The following table lists technical tables and related data management options. The place holder <bw_prefix> is typically 'BIC' and 'BI0', but there can be customer-dependant variations:
| Tables | Product / Stack | Area | SAP Note | Details |
$BPC$HC$*, $BPC$TMP* | BPC | temporary tables | 2445363 | report UJHANA_DELETE_BPC_TMP_TABLE |
/AIF/PERS_XML | ABAP | application interface framework | 2274361 2279909 | transaction /AIF/XML_COMPRESS |
/BI0/0* | ABAP | BW temporary data | 449891 1139396 2353663 | reports SAP_DROP_TMPTABLES, RSDU_DROP_TMPTABLES_HDB |
/<bw_prefix>/B* | BW | PSAs and DSO change logs | transaction RSPC | |
/<bw_prefix>/H* | BW | Hierarchies | report RRHI_OLD_HIEDIR_ENTRIES_DELETE | |
/IWFND/L_MET_COL, /IWFND/L_MET_DAT, /IWFND/SU_STATS | ABAP | Gateway | report /IWFND/R_SM_CLEANUP | |
/SAPAPO/LISLOG, /SAPAPO/LISMAP | SCM | Demand planning job logs | 512184 | transaction /SAPAPO/MC8K |
/SAPTRX/APPTALOG, /SAPTRX/AOTREF | Event management | application log | 972904 | transaction SARA, reports /SAPTRX/ARCHIVE_A0_DELETE, /SAPTRX/DELETE_AS_DATA, /SAPTRX/DEL_ARCHIVED_EH_DATA, ZDELAPPTALOG |
/SSF/PTAB | ABAP | Solution Manager | 2354694 | report /SSF/PTABBROWSER |
/TXINTF/TRACE | ABAP | SETI trace | report /TXINTF/TRACECLEANUP | |
APQD | ABAP | batch input | 36781 | transaction SM35, report RSBDCREO |
ARDB_STAT0, ARDB_STAT1, ARDB_STAT2, TAAN_DATA, TAAN_FLDS, TAAN_HEAD | ABAP | table analysis | transaction TAANA, report TAAN_DELETE_ANALYSES | |
ARFCRSTATE, ARFCSDATA, ARFCSSTATE, TRFCQDATA, TRFCQIN, TRFCQOUT, TRFCQSTATE | ABAP | RFC | 375566 | transactions SMQ1, SMQ2, SM58 |
BALC, BALDAT, BALHDR, BALHDRP, BAL_INDX, BALM, BALMP | ABAP | application log | 195157 | transaction SLG2, report SBAL_DELETE |
BC_MSG, BC_MSG_AUDIT, XI_AF_MSG, XI_AF_MSG_AUDIT | XI | adapter framework | 872388 | |
BC_SLD_CHANGELOG | SLD | change log | 1799613 | SLD administration UI -> "Administration" -> "Changes" -> "Cleanup Task Configuration" |
BDCP, BDCPS, BDCP2 | ABAP | ALE change pointers | 513454 | transaction BD22, report RBDCPCLR |
BCST_CAM, BCST_SR, SOC3, SOFFCONT1, SOOD, SOOS | ABAP | SAPoffice | 966854 | reports RSBCSRE03, RSSORE00, RSBCS_REORG |
CCMLOG, CCMLOGD, CCMSESSION, CCMOBJLST, CCMOBJKEYS | CRM | CIC logs | 608174 | transaction CIC4 |
COIX_DATA40 | CO | info system | transaction KE39 | |
CRM_ICI_TRACES | CRM | interaction center trace | 1058787 | transaction CRM_ICI_TRACE, function module CRM_ICI_DELETE_TRACES |
CROSS, WBCROSSGT, WBCROSSI | ABAP | where-used list | 2039618 | program RS_DEL_WBCROSSGT |
CS_AUDIT_LOG_ | HANA | audit log | 2308083 | command ALTER SYSTEM CLEAR AUDIT LOG |
DBTABLOG, DBTABPRT | ABAP | table logging | 2335014 | transaction SCU3, report RSTBPDEL |
DDLOG | ABAP | buffer synchronization | 36283 | TRUNCATE possible when SAP ABAP is stopped |
DDPRS | ABAP | dictionary logs | 370475 | reports RADPROTA, RADPROTB |
DFKKDOUBTD_W, DFKKDOUBTD_RET_W | CA | receivable adjustments | 1146889 | report RFKKDELE_DFKKDOUBTD |
DSVASRESULTSGEN, DSVASRESULTSSEL, DSVASRESULTSCHK, DSVASRESULTSATTR, DSVASREPODOCS, DSVASSESSADMIN, DOKCLU | Solution Manager | session information | 1300107 | report RDSMOPREDUCEDATA |
DYNPSOURCE, DYNPLOAD | BW | ABAP screens | 1953628 | report RSDQ_DYNP_GP_CLEAN |
D010TAB, REPOLOAD, REPOSRC | BW | ABAP repository | 1582301 | report RSDRI_INFOPROV_DELETE (be aware that beyond this special context it is usually not possible to clean these tables, because they contain ABAP source and load information) |
ECLOG_CALL, ECLOG_DATA, ECLOG_EXEC, ECLOG_EXT, ECLOG_HEAD, ECLOG_RESTAB, ECLOG_SCNT, ECLOG_SCR, ECLOG_SEL, ECLOG_XDAT | ABAP | eCATT | 1052908 | report RSECATTLOGDEL, archiving object ECATT_LOG |
EDI30C, EDI40, EDID4, EDIDC, EDIDOC, EDIDS | ABAP | IDoc | 40088 1574016 | reports RSEXARCA, RSEXARCB, RSEXARCD, RSEXARCL, RSEXARCR, RSETESTD |
ENHLOG | ABAP | enhancement logs | 2229441 | report ENH_SHRINK_ENHLOG |
GLOBAL_DEC_EXTRACTOR_STATUS_BASE, GLOBAL_DISKS_BASE, GLOBAL_INTERNAL_EVENTS_BASE, GLOBAL_PERSISTENCE_STATISTICS_BASE, GLOBAL_ROWSTORE_TABLES_SIZE_BASE, GLOBAL_TABLE_CONSISTENCY_BASE, GLOBAL_TABLE_PERSISTENCE_STATISTICS_BASE, HOST_BLOCKED_TRANSACTIONS_BASE, HOST_COLUMN_TABLES_PART_SIZE_BASE, HOST_CONNECTIONS_BASE, HOST_CONNECTION_STATISTICS_BASE, HOST_CS_UNLOADS_BASE,HOST_DATA_VOLUME_PAGE_STATISTICS_BASE, HOST_DATA_VOLUME_SUPERBLOCK_STATISTICS_BASE, HOST_DELTA_MERGE_STATISTICS_BASE, HOST_HEAP_ALLOCATORS_BASE, HOST_LIVECACHE_CONTAINER_STATISTICS_BASE, HOST_LIVECACHE_OMS_VERSIONS_BASE, HOST_LIVECACHE_PROCEDURE_STATISTICS_BASE, HOST_LIVECACHE_SCHEMA_STATISTICS_BASE, HOST_LONG_IDLE_CURSOR_BASE, HOST_LONG_RUNNING_STATEMENTS_BASE, HOST_LONG_SERIALIZABLE_TRANSACTION_BASE, HOST_MVCC_OVERVIEW_BASE, HOST_OBJECT_LOCKS_BASE, HOST_OBJECT_LOCK_STATISTICS_BASE, HOST_ONE_DAY_FILE_COUNT_BASE, HOST_RECORD_LOCKS_BASE, HOST_RESOURCE_UTILIZATION_STATISTICS_BASE, HOST_RS_INDEXES_BASE, HOST_RS_MEMORY_BASE, HOST_SAVEPOINTS_BASE HOST_SERVICE_COMPONENT_MEMORY_BASE, HOST_SERVICE_MEMORY_BASE, HOST_SERVICE_REPLICATION_BASE, HOST_SERVICE_STATISTICS_BASE, HOST_SERVICE_THREAD_SAMPLES_BASE, HOST_SQL_PLAN_CACHE_BASE, HOST_SQL_PLAN_CACHE_OVERVIEW_BASE, HOST_UNCOMMITTED_WRITE_TRANSACTION_BASE, HOST_VOLUME_FILES_BASE, HOST_VOLUME_IO_DETAILED_STATISTICS_BASE, HOST_VOLUME_IO_RETRY_STATISTICS_BASE, HOST_VOLUME_IO_TOTAL_STATISTICS_BASE, HOST_WORKLOAD_BASE, STATISTICS_ALERTS_BASE, STATISTICS_EMAIL_PROCESSING | HANA | statistics server | 2147247 | adjustments to retention time and data collection, manual cleanup tasks |
GVD_BGPROCESS, GVD_BUFF_POOL_ST, GVD_LATCH_MISSES, GVD_ENQUEUE_STAT, GVD_FILESTAT, GVD_INSTANCE, GVD_PGASTAT, GVD_PGA_TARGET_A, GVD_PGA_TARGET_H, GVD_SERVERLIST, GVD_SESSION_EVT, GVD_SESSION_WAIT, GVD_SESSION, GVD_PROCESS, GVD_PX_SESSION, GVD_WPTOTALINFO, GVD_ROWCACHE, GVD_SEGMENT_STAT, GVD_SESSTAT, GVD_SGACURRRESIZ, GVD_SGADYNFREE, GVD_SGA, GVD_SGARESIZEOPS, GVD_SESS_IO, GVD_SGASTAT, GVD_SGADYNCOMP, GVD_SEGSTAT, GVD_SPPARAMETER, GVD_SHAR_P_ADV, GVD_SQLAREA, GVD_SQL, GVD_SQLTEXT, GVD_SQL_WA_ACTIV, GVD_SQL_WA_HISTO, GVD_SQL_WORKAREA, GVD_SYSSTAT, GVD_SYSTEM_EVENT, GVD_DATABASE, GVD_CURR_BLKSRV, GVD_DATAGUARD_ST, GVD_DATAFILE, GVD_LOCKED_OBJEC, GVD_LOCK_ACTIVTY, GVD_DB_CACHE_ADV, GVD_LATCHHOLDER, GVD_LATCHCHILDS, GVD_LATCH, GVD_LATCHNAME, GVD_LATCH_PARENT, GVD_LIBRARYCACHE, GVD_LOCK, GVD_MANGD_STANBY, GVD_OBJECT_DEPEN, GVD_PARAMETER, GVD_LOGFILE, GVD_PARAMETER2, GVD_TEMPFILE, GVD_UNDOSTAT, GVD_WAITSTAT, ORA_SNAPSHOT | ABAP | DBACOCKPIT Oracle histories | histories can be truncated as data is also available via native Oracle histories | |
ICFRECORDER | ABAP | internet connection framework |
| transaction SICF, automatic cleanup, manual cleanup with database tools possible |
IDOCREL, SMW0REL, SRRELROLES | ABAP | object links |
| report RSRLDREL |
INDX | ABAP | binary data export | ||
JBDCPHDR2, JBDCPPOS2, VDCHGPTR | ABAP | loan and SEM change pointers | 911392 | transactions FNCP4, JBDCD, reports RFVD_CHGPTR_DELETE, JBD_CHGPTR_DELETE |
JOB_LOG | Lumira | job log | 2117301 | manual deletion |
MDMFDBEVENT, MDMFDBID, MDMFDBPR | MDM | feedback | 1529387 | reports RMDM_CLEAR_FEEDBACK, ZMDM_DELETE_FEEDBACK |
OBJECT_HISTORY | HANA | repository object versions | 2479702 | manual DELETE |
ODQDATA_F | Data services | delta queues | 1836773 | transaction ODQMON, batch job ODQ_CLEANUP |
ORA_SQLC_HEAD, ORA_SQLC_DATA | ABAP | DBACOCKPIT Oracle SQL editor | 1556453 | report RSORASQLCX2 |
QRFCTRACE, QRFCLOG | ABAP | QRFC | 1567007 | transaction SMQE, report QRFC_TRACE_DELETE |
RSBATCHCTRL, RSBATCHCTRL_PAR, RSBATCHDATA, RSBATCHHEADER, RSBATCHPROT, RSBATCHSTACK | BW | batch runtime | transaction RSBATCH, report RSBATCH_DEL_MSG_PARM_DTPTEMP | |
RSBERRORLOG | BW | DTP error logs | 1095924 | report RSBM_ERRORLOG_DELETE |
RSBKDATA, RSBKDATAINFO, RSBKDATAPAKID, RSBKDATAPAKSEL | BW | DTP request details | 2407784 | reports RSBKCHECKBUFFER, RSBKCLEANUPBUFFER |
RSBKSELECT | BW | DTP request selections | 2388357 | report RSBK_DELETE_UNUSED_RSBKSELECT |
RSBMLOGPAR, RSBMLOGPAR_DTP, RSBMNODES, RSBMONMESS, RSBMONMESS_DTP, RSBMREQ_DTP, RSCRTDONE, RSDELDONE, RSHIEDONE, RSLDTDONE, RSMONFACT, RSMONICTAB, RSMONIPTAB, RSMONMESS, RSMONRQTAB, RSREQDONE, RSRULEDONE, RSSELDONE, RSTCPDONE, RSUICDONE | BW | requests | 694895 2069551 | transaction SARA, archiving object BWREQARCH |
RSDDSTATAGGR, RSDDSTATAGGRDEF, RSDDSTATCOND, RSDDSTATDELE, RSDDSTATDM, RSDDSTATEVDATA, RSDDSTATHEADER, RSDDSTATINFO, RSDDSTATLOGGING, RSDDSTATDTP | BW | statistics | 934848 1018114 | transaction RSDDSTAT, report RSDDSTAT_DATA_DELETE |
RSECHIE_CL, RSECSESSION_CL, RSECTXT_CL, RSECUSERAUTH_CL, RSECVAL_CL | BW | authorization change logs | transaction SARA, archiving object RSEC_CHLOG | |
RSECLOG | BW | authorization logs | 1592528 | transaction RSECADMIN |
RSERRORHEAD, RSERRORLOG | BW | PSA error logs | 456150 | report RSSM_ERRORLOG_CLEANUP |
RSICPROT | BW | processed job logs | 2248272 | report RSSM_DELETE_PROCESSED_JOB |
RSIXWWW, RSZWBOOKMARK, RSZWITEM, RSZWOBJ, RSZWVIEW | BW | stateless bookmarks | 589899 1388287 1998391 | reports RSRD_BOOKMARK_REORGANISATION, RSRA_CLUSTER_TABLE_REORG |
RSODSACTUPDTYPE | BW | DSO field aggregation | 1919867 | report RSODSO_CLEANUP_RSODSACTUPDTYPE |
RSOTLOGOHISTORY | BW | metadata object versions | 1943604 | transaction SPRO |
RSPCINSTANCE, RSPCINSTANCET | BW | PSA logs | 1115243 | report RSPC_INSTANCE_CLEANUP |
RSPCPROCESSLOG, RSPCCOMMANDLOG | BW | chain run logs | 1829728 | report RSPC_LOG_DELETE |
RSR_CACHE_DATA_B, RSR_CACHE_DATA_C, RSR_CACHE_FFB, RSR_CACHE_QUERY, RSR_CACHE_STATS, RSR_CACHE_VARSHB, RSR_CACHE_DBS_BL | BW | cache | 1107434 2140135 | transaction RSRCACHE, report RSR_CACHE_RSRV_CHECK_ENTRIES |
RSRWBINDEX, RSRWBSTORE | BW | workbooks | 385219 1968912 | reports RRMX_WORKBOOKS_DELETE, RSR_WORKBOOK_ADMIN, RSR_WORKBOOK_ADMINISTRATION |
RSSTATMANREQMDEL, RSSTATMANREQMAP | BW | status manager request mapping | 1245415 1568379 | reports RSBK_REORG_RSSTATMANREQMAP_DEL, RSSTATMAN_DELETE_OLD_REQMDEL |
RSTT_CALLSTACK | BW | RSTT trace | 1142427 1334342 | report RSTT_TRACE_DELETE |
RSWR_DATA | BW | bookmarks | 1419451 | report RSWR_BOOKMARK_DELETE |
SDBAH, SDBAD, DBMSGORA | Oracle | BR*Tools | 403704 | program brconnect, option "-f cleanup" |
SE16N_CD_DATA, SE16N_CD_KEY | ABAP | SE16N change log | 1360465 | transaction SARA, archiving object CA_SE16NCD |
SMO8FTCFG, SMO8_DLIST, SMO8FTSTP, SMO8_TMDAT, SMO8_TMSG, SMW3_BDOC, SMW3_BDOC1, SMW3_BDOC2, SMW3_BDOC4, SMW3_BDOC5, SMW3_BDOC6, SMW3_BDOC7, SMW3_BDOCQ, SMWT_TRC | CRM | middleware | 206439 536414 | reports SMO6_REORG, SMO6_REORG2 |
SNAP | ABAP | short dumps | 11838 | report RSSNAPDL |
SQLMD, /SDF/ZQLMD | ABAP | SQL monitor | 1885926 | transaction SQLM |
SRT_CDTC, SRT_MMASTER, SRT_MONILOG_DATA, SRTM_SUB, SRT_RTC_DATA, SRT_RTC_DATA_RT, SRT_RTC_DT_RT, SRT_SEQ_HDR_STAT, SRT_SEQ_REORG, SRT_UTIL_ERRLOG | ABAP | SOAP runtime | 2231932 | report RSWSMANAGEMENT |
SSCOOKIE | ABAP | BSP server side cookies | 1080518 | report BSP_CLEAN_UP_SERVER_COOKIES |
SWELOG, SWELTS, SWFREVTLOG | ABAP | workflow event trace | 46358 948831 | reports RSWFEVTLOGDEL, RSWELOGD |
SWFGPROLEINST, SWP_HEADER, SWPNODE, SWPNODELOG, SWP_NODEWI, SWPSTEPLOG, SWW_CONT, SWW_CONTOB, SWWCNTPADD, SWWCNTP0, SWWEI, SWWWIDEADL, SWWWIRET, SWWWIHEAD, SWWLOGHIST, SWWLOGPARA, SWWUSERWI, SWW_WI2OBJ, SWZAI, SWZAIENTRY, SWZAIRET | ABAP | work items | 49545 1552169 | reports RSWWHIDE, RSWWWIDE, RSWWWIDE_DEP |
SWFRXICNT, SWFRXIHDR, SWFRXIPRC | XI | ccBPM | 872388 | transaction SXMB_ADM |
SWNCMONI | ABAP | workload collector | ST03, adjustment of retention times | |
SWN_NOTIF, SWN_NOTIFTSTMP, SWN_SENDLOG | ABAP | workflow notifications | 722840 | report RSWNNOTIFDEL |
SXMSCLUP, SXMSCLUP2, SXMSCLUR, SXMSCLUR2, SXMSPFRAWD, SXMSPFRAWH, SXMSPHIST, SXMSPHIST2, SXMSPMAST, SXMSPMAST2 | XI | integration server | 872388 | transaction SXMB_ADM |
TBTCO, TBTCP, TBTCS | ABAP | jobs | 16083 666290 | reports RSBTCDEL2, RSTS0024 |
TPRI_PAR | ABAP | print parameters | 16083 | report RSBTCPRIDEL |
TRFC_I_DEST, TRFC_I_ERR_STATE, TRFC_I_EXE_STATE, TRFC_I_SDATA, TRFC_I_UNIT, TRFC_I_UNIT_LOCK | ABAP | background RFC | transaction SBGRFCMON, smaller 'unit delete time' values can reduce table sizes | |
TSPEVDEV, TXMILOGRAW | ABAP | XMI interface | 182963 | report RSXMILOGREORG |
TST01, TST03, TSPEVJOB | ABAP | TemSe, spool | 48400 | reports RSPO0041, RSPO1041, RSBTCDEL2, RSBDCREO |
T811E, T811ED, T811ED2 | CO | extracts | 988703 | transaction KSEX |
UJ0_STAT_DTL, UJ0_STAT_HDR | BPC | query statistics | 1934038 | report UJ0_STATISTICS_DELETE |
UJF_DOC, UJF_DOC_CLUSTER | BPC | file service documents | 1705431 1908533 | reports UJF_FILE_SERVICE_CLEAN_LOGS, UJF_FILE_SERVICE_DLT_DM_FILES |
UPC_STATISTIC, UPC_STATISTIC2, UPC_STATISTIC3 | SEM | UPC statistics | function module UPC_STATISTIC_DELETE | |
VBDATA, VBERROR, VBHDR, VBMOD | ABAP | update | 67014 | report RSM13002 |
WRH$_ACTIVE_SESSION_HISTORY | Oracle | active session history | 1916179 | Oracle procedure DBMS_WORKLOAD_REPOSITORY.DROP_SNAPSHOT_RANGE |
WRI$_OPTSTAT_HISTGRM_HISTORY, WRI$_OPTSTAT_HISTHEAD_HISTORY, WRI$_OPTSTAT_IND_HISTORY, WRI$_OPTSTAT_TAB_HISTORY | Oracle | optimizer statistics histories | 1783696 | Oracle procedures DBMS_STATS.PURGE_STATS, DBMS_STATS.ALTER_STATS_HISTORY_RETENTION |
ZARIX* | ABAP | archive information structures | SAP Data Management Guide |
basis tables archiving deletion data management
| Product or Product Version |
|---|