Monday, April 28, 2008
Easter eggs in ABAP
SAP consultant needs to debug ABAP source code very often. While digging in it you can reveal sense of humor of ABAPers who programmed it. Current version of SAP’s flagship ECC (former R/3) is quite matured where you can find code from early 90’s till recent days. Of course most of code was probably written in
Wednesday, April 16, 2008
SAP’s the biggest database tables
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*
Friday, April 11, 2008
SAP GUI - where to download it?
Reactions: |
Wednesday, April 9, 2008
SAP’s wiki initiative
History is repeating. As SAP missed an entrance of internet in second half of 90’s last century it is similar with wikis. Wiki is kind of software we can say it is improved CMS system to not only publish something on internet but to allow user’s of your site to cooperate, create their own content, organize it, makes virtual communities, discuss and even sell on the internet, etc. In area of enterprise software we are speaking of enterprise wikis. Software provider are integrating wiki functionality in their portals solutions to allow such a collaboration to communities within a companies they running their ERP systems.
Clearspace’s Jive will be integrated via NW Portal’s iViews with support for portal roles. Final release is not still clearly slated until Q2 2009. For more detail see Wiki in NW Portal presentation.
Reactions: |