SAP’s the biggest database tables

Here’s list of tables may potentially grow very fast and become causing problem ones.

Basis tables:

• application log tables: BALHDR, BALHDRP, BALM, BALMP, BALDAT, BALC, BAL_INDX;
• IDoc tables: EDIDS, EDIDC, EDIDOC, EDI30C, EDI40;
• tables for linking IDocs: IDOCREL, SRRELROLES;
• Work item tables: SWFGPROLEINST, SWP_HEADER, SWP_NODEWI, SWPNODE, SWPNODELOG, SWPSTEPLOG, SWW_CONT, SWW_CONTOB, SWW_WI2OBJ, SWWCNTP0, SWWCNTPADD, SWWEI, SWWLOGHIST, SWWLOGPARA, SWWWIDEADL, SWWWIHEAD, SWWWIRET, SWZAI, SWZAIENTRY, SWZAIRET, SWWUSERWI
• change pointers tables: BDCPV (ALE Master Data distribution) BDCP, BDCPS
• change logging tables: DBTABLOG, DBTABPRT
• tRFC and qRFC tables: ARFCSSTATE, ARFCSDATA, ARFCRSTATE, TRFCQDATA, TRFCQIN, TRFCQOUT or TRFCQSTATE
• Oracle, BR*TOOLS tables: SDBAH, SDBAD, DBMSGORA
• Buffer synchronization: DDLOG
• Batch input: APQD
• TemSe tables: TST01, TST03, TSPEVJOB
• XMI interface tables: TXMILOGRAW, TSPEVDEV
• Short dump table: SNAP
• Print parameter table: TPRI_PAR
• Update tables: VBDATA, VBMOD, VBHDR, VBERROR
• Change pointers for loans: VDCHGPTR, JBDCPHDR2, JBDCPPOS2
• Workflow event trace: SWELOG, SWELTS, SWFREVTLOG
• Table Analysis: ARDB_STAT0, ARDB_STAT1, ARDB_STAT2
• qRFC analysis data: QRFCTRACE, QRFCLOG
• Dictionary logs: DDPRS
• Job tables: TBTCO, TBTCP

Cross application tables:

• application tables: BSEG (FI module), BSIS (FI module);
• CO information system: COIX_DATA40
• CO extracts: T811E, T811ED, T811ED2

SAP CRM specific:

• CRM middleware tables: SMO8FTCFG, SMO8FTSTP, SMO8_TMSG, SMO8_TMDAT, SMO8_DLIST, SMW3_BDOC, SMW3_BDOC1, SMW3_BDOC2, SMW3_BDOC4, SMW3_BDOC5, SMW3_BDOC6, SMW3_BDOC7, SMW3_BDOCQ, SMWT_TRC
• CRM-CIC logs: CCMLOG, CCMLOGD, CCMSESSION, CCMOBJLST, CCMOBJKEYS
• CRM-BDOC links: SMW0REL, SRRELROLES

SAP MDM specific:

• MDM feedback tables: MDMFDBEVENT, MDMFDBID, MDMFDBPR

SAP APO specific:

• Job logs for Demand Planning: /SAPAPO/LISMAP, /SAPAPO/LISLOG

SAP XI/PI specific:

• XI Integration Server tables: SXMSPMAST, SXMSPMAST2, SXMSPHIST, SXMSPHIST2, SXMSPFRAWH, SXMSPFRAWD, SXMSCLUR, SXMSCLUR2, SXMSCLUP, SXMSCLUP2
• XI ccBPM tables: SWFRXIHDR, SWFRXICNT, SWFRXIPRC
• XI adapter framework: XI_AF_MSG, XI_AF_MSG_AUDIT

SAP BI/BW specific:

• BW statistics data: RSDDSTATAGGR, RSDDSTATAGGRDEF, RSDDSTATCOND, RSDDSTATDELE, RSDDSTATDM, RSDDSTATEVDATA, RSDDSTATHEADER, RSDDSTATINFO, RSDDSTATLOGGING
• PSA error logs: RSERRORHEAD, RSERRORLOG
• BW tables: RSMONMESS, RSSELDONE
• BW workbook tables: RSRWBSTORE
• Temporary BW tables: /BI0/0*

For more details see SAP Note 706478.