SAP standard components

SAP system landscape may contain according IT Scenarios and IT Practices various different scenarios as described in Master Guides.

• SAP application components (SAP APO, SAP ERP, SAP R/3, SAP R/3 Enterprise,

SAP CRM, SAP SCM, SAP SRM, SAP SEM)

• SAP components for industry solutions (IS) (SAP Banking, SAP Discrete Industries,

SAP High Tech, etc. – around 20 different IS)

• SAP NetWeaver components SAP BI, SAP WAS, SAP Enterprise Portal, SAP

KW, SAP MDM, SAP Exchange Infrastructure, and SAP Mobile Engine.

Since release 2004s of SAP NW there are used within installation and design of architecture so called (SW installable blocks) building blocks so called „usage types“^* and “standalone engine” and “clients” e.g:

• Application Server ABAP (AS ABAP) - [usage type]
• Application Server Java (AS Java) - [usage type]
• Development Infrastructure (DI) - [usage type]
• Enterprise Portal (EP) - [usage type]
• Process Integration (PI) - [usage type]
• Gateway - [standalone engine]
• Search and Classification (TREX) - [standalone engine]
• SAP Content Server 6.30 - [standalone engine]
• SAP GUI 6.40 - [client]
• Mobile Infrastructure Client - [client]
• SAP technological components (SAP Solution Manager, SAP Marketplace Connector)
• SAP XApps (SAP xApps for Mobile Business, SAP XEM, SAP XPD, SAP XRPM)
• SAP Solutions for Electronic Marketplaces (SAP MarketSet)
• add-ons specific solutions for different countries(SAP HR-CEE, CCIS, C-CEE, HR-CIS)

• Support components for different solutions (ABC Connector, BackWeb Infocenter, SAP

PLM Recipe Management, SAP Records Management, SAP Workforce Management)

• SAP front-end components (SAP GUI, SAP ITS, SAP IGS)
• Plug-ins (SAP Plug-Ins, SAP Solution Tools Plug-Ins)
• Other components (SAP Kernel)

^*usage type - An installed and correspondingly configured part of an SAP NW system that provides key capabilities for a system landscape.
- It specifies the intended purpose of a system.
- It is the result of the configuration of the underlying installed software units and the configuration of the underlying functional units.
Examples include business intelligence, process integration, and enterprise portal.

-      2020-Feb-10 Update:

Update regarding a term usage type became is obsolete:

As of Software Provisioning Manager 1.0 SP07 (SL Toolset 1.0 SP12), the term “product instance” replaces the terms “usage type” and “technical usage” for SAP systems based on SAP NetWeaver 7.3 including enhancement package 1 and higher. More information in SAP Note 1970349. There are many occurrences of the now obsolete term usage type whoever as there is no a change terminology all mentioned terms are intended to be as synonyms. However the term “product instance” shall be used from now on.

Future funcionalities in SAP BI

Are you interesting what are next hot functionalities which will be included in SAP BI? Is your most wished feature contained? Are you aware of some enhancement what could make BW life easier and you cannot wait when it will be implemented as a standard functionality? For all those kind of questions SAP is providing a document called Functional Enhancements Schedule BI. Currently it does cover version of SAP NetWeaver BI 7.0 (2004s). Document is available via SDN here and via OSS here. The newest version is no. 15.3 as of April 29, 2008. For updates always check out folder BI Capabilities NW 7.0 of OSS. It does includes all enhancements added to NW BI 7.0 until Enhancement Package (EHP) no. 1; since EHP1 enhancements will be announced via standard future EHP roll-outs.

History of enhancements already delivered (new functionalitities shipped with older SP stacks) is structured according following sections:

1.      Enterprise Query, Reporting

2.      Business Planning

3.      Enterprise Data Warehousing

New enhancements are structured according following sections:

1.      AdHoc Query & Analysis

2.      Query, Reporting & Analysis Design

3.      Modeling the EDW

Other possible sources of SAP BI news are:

1.      OSS notes:

a.      853507 - Release Restr.: Usage Type BI of SAP NetWeaver 2004s

b.      853505 - Release Restr.: Usage Type BI-Java of SAP NetWeaver 2004s

c.      1055581 - Recommendations for Support Package Stacks for BI 7.0

d.      1013369 - SAP NetWeaver 7.0 BI - intermediate Support Packages

2.      OSS BI news page (+Business Information Warehouse News Page Archive)

3.      OSS BI FAQs:

a.      Business Explorer Suite: Platform Questions

b.      Report Design

c.      Web Application Design

d.      Business Explorer Web Printing & Export

4.      SDN BI

5.      SDN BI forums:

a.      BI General

b.      Business Content and Extractors

c.      Data Warehousing

d.      BI Suite - Business Explorer

e.      BI Business Planning

f.       BI in SAP NetWeaver 2004s

g.      SAP NetWeaver BI Accelerator

-                     update 20/08/2008 –

“Enhancement package (EHP) 1 for SAP NetWeaver BI 7.0 - Functional Enhancements Schedule” has been released on 18th of August. BI part of it is integrated in Enhancement package for SAP NetWeaver. Major changes included in this EHP is regarding Enterprise Data Warehousing (EDW) and in
"Enterprise Reporting, Query, and Analysis" furthermore in Business Object (BOBJ) integration to SAP BI and "SAP Business Planning and Consolidation". For more details at SDN here.

-                     update 22/11/2008 –

After “EHP - Functional Enhancements Schedule” from August 2008 during November 2008 an Enhancement package 1 for SAP NetWeaver 7.0 has been released. It does include additional modeling capabilities in area of Enterprise Data Warehousing (EDW) which provide better data consistency, enhanced administration features and improved mass data handling. In the area of Enterprise Reporting, Query, and Analysis additional flexibility for Information Broadcasting, Formatted Reporting and BEx Analyzer is supported. For more details at SDN here.

Short history of SAP BW

First version of SAP introduced Business Warehouse Information Systems (BIW later name was changed to BW and afterward in world of NetWeaver to BI) in the first half of year 1997. I was not able to find number of first version of BIW. Most likely it was version BIW 1.2A which went live for first six customers. Release 1.2B is based on the SAP R/3 4.5x version of course without business application modules. Let see to the history what was evaluation of it.

In year 1997 SAP started an initiative to extend the reporting and analysis capabilities of their flagship ERP software - R/3 based on OLTP environment. SAP was listening a customer's voice begging for standalone data warehousing software. Customers were annoyed for a long time of information processing in OLTP software like R/3 is. At that time they started to call this software “Reporting Server” and it rose to the largest development project in the history of SAP after the SAP R/3 development was done. This initiative was led by SAP cofounder Hasso Plattner who mandated that SAP created a reporting server.

In 1998, SAP launched a so called Early Customer Program (ECP, today’s Early Adoption Program (EAP)) with six customers to gather requirements and to do a proof of concept at customer sites. Thusly the SAP BIW was created.

Release 1.2A of BW was made available to the public in September 1998. Five years later, the 3.0B release of the SAP BW software not only provides a mature, end-to-end data warehouse technology, it also serves as a cornerstone of the formerly called mySAP Business Intelligence solution which is now NetWeaver BI.

When SAP BW was designed, it may never have been a consideration to use a third-party OLAP engine. More than likely it was a very quick decision to port the concepts from SAP R/3 to SAP BW and leverage its past development experience. Two examples of tools developed years ago as a core part of SAP R/3 that have found their way into SAP BW (not the code but the concepts) are the Early Warning System and the Report-to-Report Interface (RRI). In highlighting the reuse of R/3 tools, we are not saying that specific code was ported from one product to the next, only that SAP has had many years of experience in business intelligence and OLAP.

Based on the Microsoft multidimensional database access standard OLE DB for OLAP (ODBO) BW was first implemented on Microsoft Windows NT 4.0. There were two main reasons for developing SAP BW on Windows NT 4.0: first, to support SAP BW on the Microsoft platform using MS SQL Server 7; and second, to support Oracle Data Base Management Systems (DBMS) prior to implementing on a UNIX platform. At that time-early to mid-1998-Microsoft SQL Server 7 was still a beta product; therefore, SAP focused most BW development work on Oracle8 under Windows NT 4.0. However, toward midsummer 1998, SAP customers pressed SAP to implement SAP BW 1.2A on the UNIX platform as well. BW 1.2A supported the first UNIX implementation.

There are some common misunderstandings about SAP BW being just another application module comparable to FI, CO, or SD, or about being able to install SAPBW as an add-on to SAP R/3 or SAP R/3-based systems like CRM. While SAP BW may be installed on the same physical server, it always has to be installed as a separate SAP instance and will always use its own separate database and its own separate application servers. SAP started developing the SAP Business Information Warehouse in late 1996 based on an SAP system with just the basis and cross-application components installed and with a completely separate architecture, optimized for reporting and analysis purposes, in mind.

SAP was among the first software development companies to fully adopt a multi-tier client/server model and move away from traditional host-based solutions for business software. This was the beginning of the SAP R/3 success story back in the early 1990s.

Like all software releases, the BW faced the classic time-to-market, scope-of functionality, quality-of-software dilemma. Despite that it play now central role in SAP NetWeaver technology platform; a lot of customers is using it for strategic analyzing of its information; for optimizing of business operations etc. What is future of SAP BI? After acquisition of Business Objects in Oct 2007 there is a new SAP BI roadmap as of 02.2008. Some of tools originally developed by SAP will be replaced by BOBJ tools.

According to SAP, there are more than 12,000 installations of SAP's BI solution exist these days.

SAP BIW/BW/BI major releases:

Versions in detail:

Information fro this post was gathered from several internet sources; plus following books:

BIW for SAP by Naeem Hashmi

Mastering the SAP BIW: Leveraging the BI Capabilities of SAP NetWeaver by Kevin McDonald

For further reference see:

gleez.com/sap/bw/biw_and_bw

wikipedia.org/wiki/SAP_Business_Information_Warehouse

- update 23/12/2009 -

For information about the newest SAP BW 7.20 see this post.

Transaction SAPBWNEWS

Have you ever try to run transaction SAPBWNEWS in some SAP BW systems? For me it never works; it just displays empty screen. TA is linked with ABAP program called SAPBWNEWS_PRINT which is suppose to displays a SAP note with description about available Support Packages (SP) for your SAP BW system. Similar usage of this; is to give you an access to a readme file with the latest news about the BW patch. Usually we are suppose to see same text which contains the information in *SAPBWNEWS* SAP notes after implementing any Support Package (SP) or Patch. The SAPBWNEWS notes used to provide the latest news on BW maintenance strategy like availability of new SPs, new functionality available etc. Since SAP introduced Support Package Stack (SPS) within SAP NetWeaver (from SAP BW point of view versions of BW 3.5 and onwards are part of SAP NetWeaver 04.) those *SAPBWNEWS* notes are not maintained anymore.

Customizing of logon screens for BW web reporting

Since SAP BW 3.0 and higher there are many option how to customize logon screen while user access BW reports through web. E.g. by default you can log on to BW via web using HTTP authentication but it doesn‘t allow you to enter logon language or change your password from logon screen like it is possible via standard SAP GUI logon screen.

To customize this behavior you can create a newly defined response to HTTP requests generated during execution of the BW URL HTTP – a BSP application is called which provides the customizable login screen.

• Via TA SE80 a copy of SAP standard BSP application called ‘SYSTEM’ will be created (copied application e.g.: ‘ZSYSTEM’).

• Definition of publicly available alias to new BSP application will be maintain in TA SICF; stored in path: /sap/public/bsp/sap as reference to existing service ‘ZEHSSYSTEM’ in path: /sap/bc/bsp/sap.

• Standard SAP BW service for accessing BW reports via web; called ‘/sap/BW’ will be enhanced for following parameter:

‘/sap/public/bsp/sap/zsystem/login.htm?sap-url=

<%=PATHTRANS%>

&BspChangePassWordVisible=X

&BspDontShowHttpsWarning=X

&BspSysIdVisible=X

&BspClient=100’.

• All involved services needs to be restarted and activated again.

Afterwards whenever user access BW web reports by URL link like:

http://macine:8000/sap/bw/BEx?CMD=LDOC

&TEMPLATE_ID=ZMY_BW_REPORT_01

Logon screen looks like:

All parameters on logon screen:

BspApplication

BspHandlerClass

BspPrivacyStatement

BspTermsOfUse

BspForgotPass

BspPasswordHint

BspPasswordViaEmail

BspSignUpHere

BspClient

BspClientVisible

BspLanguage

BspLanguageVisible

BspSysIdVisible

BspAccessibility

BspAccessibilityCheckboxVisible

BspChangePassword

BspChangePasswordVisible

BspDontShowHttpsWarning

BspDontForceHttps

BspUserLongNames

BspDumpFields

BspSAPGUILayout

For detailed documentation see help.sap.com.

ABAP dump ASSIGN_TYPE_CONFLICT while data loading via DTP

This dump is very common with data load based on DTP (Data Transform Process). You can observe you failed load in DTP Monitor as follows:

If you clink on ABAP dump icon as above you go to TA ST22 (ABAP Runtime Error) to see dump.

It is caused by changed meta data of objects involved in this data loads. A process (mode) used for the runtime of BI objects has a certain and determined lifetime. Generated program (GP) which is serving for transformation (TRAN) between source and target objects of your load no longer match the metadata because the metadata changes during this lifetime. It means that you have recently changed something within your source and target objects (e.g. via TA RSA1) then you transported just some part of your changes recently but not whole data flow. Therefore your GP* program is referencing to „old“ runtime version of objects and they are already changed to „new“ version. As dumps says:

assign _rdt_TG_1_dp->* to <_yt_tg_1>.

To solve such a failed upload you need to regenerate your GP* program – this involves re-activate transformation. This can be a 1st step. If this doesn’t help you need to go deeper and re-activate and re-transport other objects involved in data flow like 1. source object of the DTP (DSO/DS/IS for example; depending in your particular flow); 2. target object of the DTP (e.g. InfoCube/DSO/InfoProvider IO); 3. transformation; 4. the DTP as it self.

SAP Business ByDesign (BBD) delayed

Information coming from SAP is saying that SAP Business ByDesign (BBD) as a Service (SaaS) is going to be delayed for minimum one year or more according German economic newspaper Handelsblatt. Software is offered already to limited number of customer since second half of 2007. There are a lot of rumors and investigations done on this delay in web’s blogospehere. See Dennis Howlett’s post. Other blogger Joshua Greenbaum is revealing possible reasons of this delay as it is:

- Operationalizing the on-demand model in a cost-effective way – Today they have just around 150 customers; a future roll out to ten thousands of customers can’t be scaled up for such an amount of customers on cost effective way.

- Design flaws - fundamental design flaw in the system, seems to be a misunderstanding of building large scale applications.

- Performance issues - Current release has a performance issues which can cause that response time will not be acceptable for large amount of customers.

On other hand it can be just a reason coming from nature of SAP as a company. As they are traditionally Germany’s very conservative company they are too much worrying about potential lost of their reputation in case of trouble with BBD. Other let say “soft” factor can be level of the maturity of the on-demand market. Traditional SaaS vendors (e.g. salesforce.com) used to have similar problems with performance and down times. As SAP is entering this market late that means it could have a software which has no these kind of kids illnesses and be more bullet proof than others.

SAP has spent a huge effort to develop this SME solution already. In terms of money till year 2007 it was according Dave Rosenberg it was over $1 billion. So see what happen next if SAP will be able to full fill a plans related to gain of customers and market share in this area.

SAP message I like the most

After posting funniest SAP notes and Ester eggs in ABAP I’m coming with few screenshot from SAP BW that I like a most:

Yes, as first must come famous ABAP MESSAGE_TYPE_X dump which always will be in SAP ABAP stack based applications.

Second one is pure BW error “Client out of Memory” within reporting occurred in cased you run query which retries too much data and you chock up all memory in BW server:

Third one is TA RSA1 error saying ”Internal error: - contact SAP”, very often error in BW 7.0 running on old Patch Level.

SAP BI and EURO conversion

Conversion to euro is very hot topic especially on middle European countries markets. Currently Slovakia is very close to euro accession and it seems that Slovak Crown as a Slovak national currency will be replaced by euro by 1^st of January 2009. Hence there is a large demand for SAP consulting services to get SAP software be ready for euro conversion. Main focus is on ECC (former R/3) applications but BI/BW solution from SAP is not standing beyond. What does mean such a euro adoption from BW point of view? It should not be a big deal because a lot of customers had implemented BW in a way to be able switch currency on the flight while running BW reports. It might be a case that you want to convert all data in your cubes to euro only; then it is useful to use standard BW’s ABAP report called RSEURO. Here you choose cubes for conversion; you do specify which key figures from this cube will be converted, conversion as it self is done as background job (RS_EURO_CONVERTER). You proceed in a similar way for fixed currencies. In case of fixed currency InfoObjects cubes with such a IO must be converted in one shot. You do this by using RSEURO as well. This tool has some limitation with regards of Key figures that have currencies as master data attributes. These cannot be converted by this toll. It is limited to key figures in cubes and PSAs. Notice that using of this tool may lead to performance issues in case of large sets of data. Always check OSS. 

Refer to SAP note 327741 - Euro conversion for BW for further details. Other useful notes:

327741 - Euro conversion for BW

376976 - Euro conversion in the BW System

390359 - Euro conversion for SEM

369170 - Euro conversion: Poor performance during cube conversion

379026 - Euro conversion: poor performance w/ PSA conversion

446683 - Euro conversion: poor performance for cube conversion

-       Update 15.12.2012 – 

For projects converting of euro from Slovak Crown (Slovenska Koruna, SKK) see following note:

1273778 - Currency conversion from SSK into Euro in SAP BW

DDIC table types for BI objects

Main distinguishing is based on standard object (Business Content) starting with /BI0/* and customs one with /BIC/*.

SID table (traditional): /BI0/S* or /BIC/S*

SID table time dependent attr: /BIO/Y* or /BIC/Y*

SID table non time depended attr: /BI0/X* or /BIC/X*

SID table hierarchy: /BIO/K* or /BIC/K*

SID-structure hierarchy table: /BIO/I* or /BIC/I*

View: /BI0/M* or /BIC/P*

Master data table for non time depend. attr: /BI0/P* or /BIC/P*

Master data table for time dependent attr: /BIO/Q* or /BIC/Q*

Text table: /BI0/T* or /BIC/X*

Hierarchy table: /BIO/H* or /BIC/H*

Dimension tables: /BIO/D* or /BIC/D*

Fact tables: /BIO/F* or /BIC/F*

Compressed Fact tables: /BIO/E* or /BIC/E*

Shadow table of fact tables: /BIO/4F* or /BIC/4F*

Shadow table of compressed fact tables: /BIO/4E* or /BIC/4E*

Open hub generated destination: /BIO/OH* or /BIC/OH*

Partner or customer-specific namespace: /XYZ/

Special SAP namespaces for generated objects:

- prefixes 1*, 2*, 3*, 4*, 6*, 7*, 8* are required in BW for DataSources and InfoSources in special SAP applications.

- prefix 9A* is required for the SAP APO application.

TA DBACOCKPIT for BI

Since SAP Basis 7.0 (SAP NetWeaver 7.0 Support Stack 12) a new basis transaction for database monitoring and administration is available called DBA Cockpit. It does provide a new access point to monitor and administer databases, which integrates all supported database platforms.

You can start the DBA Cockpit by either calling transaction DBACOCKPIT or by calling database administration transactions, for example, ST04, DB02 or DB13. When you call the DBA Cockpit using a specific database administration transaction, this determines the initial entry screen.

In the navigation frame of the DBA Cockpit, you can navigate between main task areas of database administration.

 

Task Area Corresponding TA Codes

· Performance ST04

· Space DB02

· Backup and Recovery DB12

· Jobs DB13, DB13C, DB24

· Configuration

· Alerts

· Diagnostics

 

Functions

· Monitoring of databases for all platforms: You can configure all your SAP-supported database(s) using the remote database connection in the DBA Cockpit. This remote database connection is available independently of the application running on your database.

· Integration with System Landscape Directory (SLD): You can configure the monitored systems and keep them up-to-date using the SLD instead of performing a manual setup

· Integrated Central Planning Calendar: A new central planning calendar is available as part of the DBA Cockpit

 

BI point of view

Via drill down from menu tree: Space -> BW Analysis BI part of DBCockpit is available. Over here basics information like BW objects we got in system, their partitions, sizes, extends, blocks, LOBs. I’ve found this tool very useful for basis resource who is not so deep in BW but can very quickly analyzed what’s going on in systems and inform functional people in advance.

Another feature which might be in some cases quite dangerous is SQL command editor from the DBA Cockpit.

You can write SQL command to underlying DB from in here. Of course not SAP application tables are accessible but you can try :-)

See more information about DBCockpit on SDN.

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.

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.

SAP GUI - where to download it?

- update 05/08/2023 -

SAP GUI 760 for Windows as well as JAVA one for macOS and Linux can be downloaded from below link:

https://developers.sap.com/trials-downloads.html?search=ABAP+Platform+1909+Developer+Edition+on+SAP+HANA+2.0

Notice that SAP user is needed. You can get the user e.g. registering at community.sap.com also if you have any S* user these can be used too.

- update 09/06/2022 -

Notice that you have to have a valid user to access SAP support site to download the SAP GUI. Navigate to the support site as follows: support.sap.com -> Software downloads -> By Category -> SAP Frontend Components -> SAP GUI for Windows or SAP GUI for Java

- update 03/15/2013 -

SAP GUI 7.30 for Windows downloads, available as of 26.06.2012

-----------------------------

NW 7.0 Presentation - 7.30 Compilation 1 Present. 1/2

NW 7.0 Presentation - 7.30 Compilation 1 Present. 2/2

  

- update 04/26/2010 -

SAP GUI 7.20 for Windows downloads

-----------------------------

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

https://websmp230.sap-ag.de/sap/bc/bsp/spn/download_basket/download.htm?objid=012002523100004876912010E&userid=S0007111409&action=DL_DIRECT

 

 - 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:

http://service.sap.com/~form/handler?_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=N&FUNCTIONBAR=N&EVENT=TREE&TMPL=01200615320200007657&V=INST

SAP GUI for Windows 7.10 Patches can be found here:

http://service.sap.com/~form/handler?_APP=00200682500000001943&_EVENT=DISPHIER&HEADER=N&FUNCTIONBAR=N&EVENT=TREE&TMPL=01200615320200007657&V=MAINT

 

- original post -

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…

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.