User exits and Business Add-Ins (BAdIs) provide ideal approaches to extend and optimize your standard SAP system with custom developments. This book teaches you to implement these adaptations in ABAP for use in SAP NetWeaver BI. The book is written for BI consultants who have basic knowledge of ABAP as well as ABAP programmers who want to get started with BI development. After a brief overview of high-performance ABAP programming, you’ll learn how to structure the data flow from the source system up to the report and planning level using practical workshops.

Readers learn how to use all of the capabilities of SAP NetWeaver BI, from transformation, including the derivation of characteristics and key figures, to start and end routines and transfer and update rules and benefit from expert instruction and techniques to implement even the most complex requirements with a limited amount of work, simply knowing how to choose the right user exits.

An entirely new chapter in this edition describes how you can enhance the SAP BW-BPS planning components and the BI-Integrated Planning tool. Although this book is based on SAP NetWeaver BI 7.0, it also outlines the essential differences from previous releases as needed. With volumes of commented code examples, this book enables you to quickly and easily implement your own custom developments, step-by-step, in your daily work.

Highlights

• Performance Aspects for BI Programming
• User Exits and BAdIs in the Extraction Process
• Customizing Data Import Processes
• Design Options in Reporting
• User Exits in Planning

About the Author(s)

Dirk Herzog is a Senior Consultant at SAP AG in Berlin, Germany. He has led numerous national and international implementations of Business Intelligence (BI) and Strategic Enterprise Management (SEM), and is an expert in solving complex modeling and implementation problems. Dirk is also the co-author of the course on “User Exits in SAP BW.”

Table of Contents

1 ... Introduction ... 11


2 ... Performance ... 15
... 2.1 ... Table Types in ABAP ... 15
... 2.2 ... Loops and Read Accesses to Tables ... 18
... 2.3 ... Field Symbols ... 20
... 2.4 ... Database Accesses and Cache ... 22


3 ... User Exits and BAdIs in the Extraction Process ... 25
... 3.1 ... Usage Options ... 25
... 3.2 ... Generic Extractors ... 26
... 3.3 ... User Exit RSAP0001 ... 31
... 3.4 ... BAdI RSU5_SAPI_BADI ... 45


4 ... User Exits in Data Import Processes ... 49
... 4.1 ... Transformation ... 49
... 4.2 ... Routines in the Data Transfer Processes ... 76
... 4.3 ... Importing a Hierarchy from an Unstructured Excel Sheet ... 82
... 4.4 ... Transfer Rules in SAP BW 3.x ... 101
... 4.5 ... Update Rules in SAP BW 3.x ... 116


5 ... User Exits and BAdls in Reporting ... 131
... 5.1 ... Variable Exit RSR00001 ... 131
... 5.2 ... Virtual Key Figures and Characteristics ... 153
... 5.3 ... VirtualProviders ... 168
... 5.4 ... BAdI SMOD_RSR00004 ... 177
... 5.5 ... Implementing Own Read Routines for Master Data ... 181


6 ... User Exits in Planning ... 199
... 6.1 ... Variables in Planning ... 199
... 6.2 ... Characteristic Value Derivations ... 211
... 6.3 ... Exit Functions in Planning ... 229
... 6.4 ... Conclusion ... 246


7 ... Summary ... 247


A ... dditional Extension Options ... 251
... A.1 ... Other BAdIs and User Exits in SAP NetWeaver BI ... 251
... A.2 ... Generated Tables and Objects in SAP NetWeaver BI ... 252


B ... The Author ... 257