SAP BODS: How to use Data Services Reverse Pivot Transformation

The information for this tutorial was collected from following website. The Reverse Pivot transformation combines data from several rows into one row by creating new columns. For each unique value in a pivot axis column and each selected pivot column, Data Services produces a column i
Continue Reading →

Python: installing sqlparse module

The process was a little involved and required the installation of a few sub modules.  Here’s what I needed to get done to complete the entire process: URL: https://github.com/andialbrecht/sqlparse Download package & extract package Open command prompt Navigate to the packag
Continue Reading →

SAP BODS: DATA_BUFFER_EXCEEDED error

After creating a new Datastore I ran in to a problem where the extractor would throw an error Error calling RFC function to get table data: <RFC_ABAP_EXCEPTION-(Exception_Key: DATA_BUFFER_EXCEEDED, SY-MSGTY: E, SY-MSGID: FL, SY-MSGNO: 046)>.  After doing a little bit of research
Continue Reading →

SAP BODS: Data Integrator Supplement for SAP

Attached to the post is a great overview document that identifies custom configurations that are required to facilitate specific functionality required by the BODS extractors from any given SAP system. The Chapters in the document include: Chapter 2: Data Integrator in the SAP R/3 Env
Continue Reading →

SAP Enterprise Portal: setting up self registration

The steps involved in setting up the self registration process are relatively simple.  You need to have administrative access and perform the following steps: Enabling Self Registration Log in with administrative credentials Navigate to System Administration – System Configurati
Continue Reading →

SAP: MaxDB Password re-set procedure [version 7.6, 7.7, 7.8]

The original reference to the procedure can be found at Matt Bartlett’s website [very useful guide]. The Issue I ran in to an issue where the database log has reached the capacity and required a backup. To accomplish this I needed access to the installed MaxDB instance. I was wo
Continue Reading →

SAP: setting up a new Virtual System & Transport Layer in STMS

In this post I would like to tackle the subject of setting up a new Virtual System in an NetWeaver SAP instance.  For the purpose of this discussion I will be using a standard SAP EHP 2 for SAP NetWeaver 7.0 demo system. System Access The first thing we need to do is gain access to th
Continue Reading →

SAP Portal: migrating portal applications 7.3

A good reference guide summarizing steps involved in migrating SAP Enterprise Portal applications to a new version [7.3] can be found here.
Continue Reading →

SAP Portal: Migrate custom themes 7.0 to 7.3

Migrate the custom themes is a relative simple process.  The first step is to export a theme from the 7.0 system then import it in to the 7.3 system. Exporting theme from 7.0 SAP Portal System Choose System Administration – Portal Display – Theme Archive The themes would b
Continue Reading →

SAP Gateway: errors while creating a basic RFC web service

Creating a basic RFC Web Service is a simple process that is outline in the provided hyper-link. Although the process is simple and straight forward problems arise, lets go through them:   Error: <code>/IWFND/CM_COS/064</code> No System Alias found for Service 'S
Continue Reading →