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 Germany by Germans but you can feel a mix of different cultures in involved in this code. Here in ABAP we cannot talk about real Easter eggs like we know them from other software but still some ABAP style eggs are really funny. Either it is comment from frustrated OSS development support guy who was trying to fix program according customer needs or from development angel who’s got assignment for some implementation project or any other buffoons; you can find forgotten break points statements (BREAK SH!T.) for really funny user names; some of comments are provided in different languages etc. One blog which is collecting such an Easter eggs in ABAP is here; huge collection has sapfans.com site.

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.

Friday, April 11, 2008

SAP GUI - where to download it?

As there is still repeating same demand about SAP GUI – where to download it. I’m continuing focus on this topic. This will be addition post to previous one about overview of SAP GUI for Windows 7.10. The newest version of SAP GUI is always available on official SAP’s FTP server ftp://ftp.sap.com/ in folder ftp://ftp.sap.com/pub/sapgui/win/. You can user anonymous user to connect to this ftp site. The newest patches; add-on (like BI) and JAVA version of GUI are available here as well. 

Other official source of SAP GUI can be service market place (OSS). Here use shortcut “swdc” (stands for SoftWare Download Center) and navigate your self like following: Download -> Installations and Upgrades -> Entry by Application Group -> SAP Frontend Components -> SAP GUI FOR WINDOWS -> SAP GUI FOR WINDOWS 7.10 CORE etc…

- update 10/18/2008 -
By the end of September 2008 SAP has removed SAP GUI installation files from its FTP server: ftp.sap.com. It is not possible to download it from this location any more. Please kindly use SAP service market place (OSS) for downloading it. Here’s extract from official file placed on FTP:

SAP GUI 7.10 for Windows downloads – no more directly available
-----------------------------

SAP GUI for Windows CDs and patches are no longer available on this server.
Please use the official download sites on SAP Service Marketplace (User-ID required).

SAP GUI for Windows 7.10 CDs (Compilations) can be found here:

SAP GUI for Windows 7.10 Patches can be found here:

- update 04/26/2010 -
SAP GUI 7.20 for Windows downloads
-----------------------------

SAP GUI for Windows 7.20 CDs (Compilations) can be found here:
https://service.sap.com/sap/bc/bsp/spn/download_basket/download.htm?objid=012002523100004876912010E&userid=S0007111409&action=DL_DIRECT


- update 03/15/2013 -
SAP GUI 7.30 for Windows downloads, available as of 26.06.2012
-----------------------------
NW7.0 Presentation - 7.30 Compilation 1 Present. 2/2


- update 08/10/2014 -
SAP GUI 7.40 for Windows downloads, available as of 8.10.2014
-----------------------------

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. Enterprise wiki is bundled with security, access to any information across a company etc. SAP was not presented in this field so far. This is being changed by announcement of roadmap for “Wikis in SAP NetWeaver Portal”. It will be based on the Jive enterprise collaboration software Clearspace Jive and its wiki application - as a standard component of SAP NetWeaver Portal. For me it is quite surprising that SAP will use Clearspace since I have always thought that SDN’s wiki section is running on Atlasian’s Confluence wiki.

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.