Wednesday, April 16, 2008

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.

No comments: