What Every BW/BI Developer Needs to Know About ABAP in BW

  • by Sam Gassem, Senior Business Consultant/BW Lead, Rural Sourcing, Inc.
  • September 24, 2013
Over time every BW developer needs to write ABAP in SAP NetWeaver BW to be able to meet user requirements. ABAP might be required in a start routine, end routine, expert routine, InfoPackage, Data Transfer Process, Analysis Process Designer, query, or field. Get basic knowledge on how to write ABAP code and the differences between each routine method.
Key Concept

Start routine is a routine in transformation that is executed before transformation is executed. End routine is a routine in transformation that is executed after transformation is executed. Expert routine is a routine in transformation that is itself the transformation. In other words it contains all three: start, end, and actual. SOURCE_PACKAGE is a structure that contains the inbound fields of the routine. RESULT_PACKAGE is a structure that contains the outbound fields of the routine. APD is a workbench with a graphical user interface (UI) for creating, executing, and monitoring analysis processes.

SAP NetWeaver BW provides user exits throughout the system to take advantage of custom coding add-ons and to be able to meet user requirements. After reading this article, BW developers should be able to develop an idea of when to use ABAP code using different routine methods. I show the differences between the major methods for ABAP in the following:

  1. Start routine
  2. End routine
  3. Expert routine
  4. InfoPackage
  5. Data Transfer Process (DTP)
  6. Analysis Process Designer (APD)
  7. Query variable
  8. Transformation fields
  9. Start, end, and expert routines and the differences between them

Sam Gassem

Sam Gassem is senior business consultant and SAP BW lead at Rural Sourcing, Inc. (RSI). He has 13 years of experience on SAP NetWeaver BW. RSI is a leader in domestic sourcing, a cost-effective, on-shore alternative to the traditional model for IT outsourcing. RSI specializes in software development and support and maintenance for critical business applications. Its development centers are located in second- and third-tier cities across the United States. RSI was founded in 2004 by the former CIO of Baxter Healthcare with the intention of bringing jobs to areas of the United States in which historically the job market was dominated by agriculture and manufacturing.

See more by this author


No comments have been submitted on this article. 

Please log in to post a comment.

To learn more about subscription access to premium content, click here.