ABAP Development for SAP NetWeaver BW: Exits, BAdIs, and Enhancements (3rd Edition)

ABAP Development for SAP NetWeaver BW: Exits, BAdIs, and Enhancements (3rd Edition)

2012
978-1-59229-424-4
279

Product Details

  • Customize extraction and loading processes, reporting, and planning
  • Optimize your system by learning from detailed examples and commented code
  • Reference a new appendix that outlines exits and enhancements in SAP NetWeaver BW 7.3
  • 3rd Edition Updated for SAP NetWeaver BW 7.3

Steer your BW-specific programming and push your implementation beyond standard BI business requirements! This book is your trusted guide to the most often-used and helpful custom enhancements in SAP NetWeaver BW. Dive into user exits and BAdls for data extracting, importing, reporting, and planning. You'll develop an understanding of why these custom enhancements are necessary, when to apply them, and how to perform them. Up to date for SAP NetWeaver BW 7.3, this edition will kick your implementation up a notch.

System Performance

Understand the impact that well-chosen ABAP developments can have on the performance of the SAP NetWeaver BW system.

Data Record Modification

Differentiate between user exits and BAdIs and learn when to apply each technique in your own custom development.

 Customer Exits

A completely new appendix highlights important customer exits in administrator workbench, extraction, reporting, and planning.

 New Transformation Options

Understand how the updated transformation options have been extended and which new features they provide, such as graphical display of rules.

Practical Application

Helpful icons flag tips that will make your work easier, caution you about frequent errors made by developers, and offer practical examples.

Highlights

  • Data staging
  • Reporting
  • Extraction process
  • Data import process
  • Transformation
  • Extension options
  • SAP Business Planning and Simulation (SAP BW-BPS)
  • ABAP Dictionary naming conventions
  • VirtualProvider
  • Generated tables and objects

The Author

Dirk Herzog works on the SAP NetWeaver BW consulting team at SAP AG, and has led national and international BW and SEM projects. He has developed solutions for complex modeling and implementation issues, and has been a course instructor for "User Exits in SAP BW.”

Table of contents

  • ... Preface to the 3rd Edition ... 11
  • ... Introduction ... 13
  • 1 ... Performance ... 17
  • 1.1 ... Table Types in ABAP ... 17
  • 1.2 ... Loops and Read Accesses to Tables ... 20
  • 1.3 ... Field Symbols ... 22
  • 1.4 ... Database Accesses and Cache ... 24
  • 2 ... User Exits and BAdIs in the Extraction Process ... 27
  • 2.1 ... Usage Options ... 27
  • 2.2 ... Generic Extractors ... 28
  • 2.3 ... User Exit RSAP0001 ... 33
  • 2.3.1 ... How to Use the Exit ... 34
  • 2.3.2 ... Structured Composition of the ZXRSAU01 Include ... 36
  • 2.3.3 ... Implementing User Exit EXIT_SAPLRSAP_001 for Currency Extraction ... 41
  • 2.3.4 ... Using the Hierarchy Exit ... 43
  • 2.3.5 ... Surrogate for the Generic Hierarchy Extractor ... 45
  • 2.3.6 ... Transferring Parameters to the User Exit ... 46
  • 2.4 ... BAdI RSU5_SAPI_BADI ... 47
  • 2.4.1 ... Methods ... 47
  • 2.4.2 ... Advantages and Disadvantages ... 48
  • 3 ... User Exits in Data Import Processes ... 51
  • 3.1 ... Transformation ... 51
  • 3.1.1 ... Deriving Characteristics ... 54
  • 3.1.2 ... Deriving Key Figures ... 58
  • 3.1.3 ... Start Routine in the Transformation ... 63
  • 3.1.4 ... End Routine in the Transformation ... 68
  • 3.1.5 ... Expert Routine in the Transformation ... 71
  • 3.2 ... Routines in the Data Transfer Process ... 81
  • 3.2.1 ... Selecting a File Name in the Data Transfer Process ... 81
  • 3.2.2 ... Determining a Characteristic Value Selection in the Data Transfer Process ... 83
  • 3.3 ... Importing a Hierarchy from an Unstructured Microsoft Excel Sheet ... 86
  • 3.3.1 ... Creating the DataStore Object ... 88
  • 3.3.2 ... Creating the DataSource ... 89
  • 3.3.3 ... Creating the Transformation ... 91
  • 3.3.4 ... Creating the Start Routine ... 92
  • 3.3.5 ... Creating the End Routine ... 94
  • 3.3.6 ... Creating a Data Transfer Process ... 103
  • 3.3.7 ... Creating a Query ... 105
  • 3.3.8 ... Implementation in SAP BW 3.x ... 105
  • 3.4 ... Recommendations for SAP NetWeaver 7.3 ... 106
  • 4 ... User Exits and BAdls in Reporting ... 107
  • 4.1 ... Variable Exit RSR00001 ... 107
  • 4.1.1 ... Interface of Function Module EXIT_SAPLRSR0_001 ... 109
  • 4.1.2 ... Implementation for I_STEP = 1 ... 113
  • 4.1.3 ... Implementation for I_STEP = 2 ... 118
  • 4.1.4 ... Implementation for I_STEP = 0 ... 121
  • 4.1.5 ... Implementation for I_STEP = 3 ... 123
  • 4.1.6 ... Validating an Individual Variable ... 125
  • 4.1.7 ... Checking Characteristic Combinations in Step 3 ... 126
  • 4.2 ... Virtual Key Figures and Characteristics ... 130
  • 4.2.1 ... Implementation ... 131
  • 4.2.2 ... Other Useful Information ... 141
  • 4.2.3 ... Transferring Variable Values to the BAdI ... 142
  • 4.3 ... VirtualProvider ... 143
  • 4.3.1 ... Creating a VirtualProvider ... 144
  • 4.3.2 ... Do’s and Don’ts for the Implementation of the Service ... 148
  • 4.4 ... BAdI SMOD_RSR00004 ... 152
  • 4.5 ... Implementing Own Read Routines for Master Data ... 156
  • 4.5.1 ... Creating a Master Data Read Class ... 157
  • 4.5.2 ... Sample Implementation of a Master Data Read Class ... 164
  • 4.5.3 ... Entering the Class in the InfoObject ... 171
  • 5 ... User Exits in Planning ... 173
  • 5.1 ... Variables in Planning ... 173
  • 5.1.1 ... Variables in SAP BW-BPS ... 174
  • 5.1.2 ... Variables in SAP NetWeaver BW Integrated Planning ... 182
  • 5.2 ... Characteristic Value Derivations ... 185
  • 5.2.1 ... Characteristic Value Derivations in SAP BW-BPS ... 185
  • 5.2.2 ... Characteristic Value Derivations in SAP NetWeaver BW Integrated Planning ... 193
  • 5.3 ... Exit Functions in Planning ... 203
  • 5.3.1 ... Exit Functions in SAP BW-BPS ... 203
  • 5.3.2 ... Exit Functions in SAP NetWeaver BW Integrated Planning ... 211
  • 5.4 ... Conclusion ... 218
  • ... Appendices ... 221
  • A ... Overview of Exits and Enhancements in SAP NetWeaver BW 7.3 ... 223
  • A.1 ... Enhancements in the Administrator Workbench ... 223
  • A.2 ... Enhancements in Extraction ... 227
  • A.3 ... Enhancements in Reporting ... 228
  • A.4 ... Enhancements in Planning ... 232
  • A.5 ... Additional Enhancements ... 235
  • B ... Generated Tables and Objects in SAP NetWeaver BW ... 239
  • B.1 ... Tables in InfoCubes ... 239
  • B.2 ... Tables in DataStore Objects ... 240
  • B.3 ... Tables in InfoObjects ... 240
  • B.4 ... Data Structures in the Data Flow ... 241
  • B.5 ... Generated Objects in SAP NetWeaver BW ... 241
  • C ... Using SAP BW 3.x ... 243
  • C.1 ... Transfer Rules in SAP BW 3.x ... 243
  • C.2 ... Update Rules in SAP BW 3.x ... 258
  • D ... The Author ... 271
  • ... Index ... 273