Table of Contents

Open all
Close all
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