ABAP Development for SAP NetWeaver BI: User Exits and BAdIs

After graduating with a degree in business mathematics from Technische Universitat Berlin, Germany, Dirk Herzog started his career in 1996 in the CO-OM development department at SAP in Walldorf, Germany. His work focused on cost-center planning and the CO planning processor. Four years later, he moved back to Berlin to join the BW consulting team at SAP Deutschland. Since then, he has led numerous national and international implementations of Business Intelligence (BI) and Strategic Enterprise Management (SEM). These included the world's first SAP BW 3.0 project, one of the first cube-based SEM-BCS implementations, and a large International Accounting Standards (IAS) project in the banking sector. Dirk also has developed solutions and solution concepts for complex modeling and implementation. He is co-author of the PDEBWB course on "User Exits in SAP BW," and has taught the course several times. Whenever he has the time, Dirk writes Web logs in the SAP Developer Network (SDN) and answers forum questions.

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 ... Additional 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