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