Introduction |
|
15 | (8) |
1 Business Basics for Migrating Data to SAP |
|
23 | (20) |
|
1.1 Data Migration as a Subproject |
|
|
23 | (2) |
|
1.2 Preliminary Considerations |
|
|
25 | (10) |
|
1.2.1 Defining the Dataset for Migration |
|
|
25 | (1) |
|
1.2.2 Identifying Dormant Data |
|
|
26 | (2) |
|
1.2.3 Measures for Reducing the Data Volume |
|
|
28 | (1) |
|
1.2.4 Preparatory Measures for Extracting the Legacy Data |
|
|
28 | (1) |
|
1.2.5 Addendum: Accounting Considerations |
|
|
29 | (6) |
|
1.3 The Data Migration Process from the Project Perspective |
|
|
35 | (7) |
|
|
35 | (1) |
|
1.3.2 System Presentations in SAP |
|
|
36 | (1) |
|
1.3.3 Business Reengineering |
|
|
36 | (1) |
|
1.3.4 Simulating the Data Migration |
|
|
37 | (1) |
|
1.3.5 Mapping (Field Matching) |
|
|
37 | (2) |
|
1.3.6 Data Extraction from the Legacy System |
|
|
39 | (1) |
|
1.3.7 Manual Postprocessing of the Extracted Data |
|
|
39 | (1) |
|
1.3.8 Selecting a Data Migration Technique |
|
|
39 | (1) |
|
1.3.9 Uploading the Data in SAP |
|
|
40 | (1) |
|
1.3.10 Testing the Business Processes in SAP |
|
|
41 | (1) |
|
|
42 | (1) |
2 Technical Basics for Migrating Data to SAP |
|
43 | (10) |
|
|
43 | (2) |
|
2.2 The Data Migration Process from a Technical Perspective |
|
|
45 | (5) |
|
|
45 | (1) |
|
|
45 | (1) |
|
2.2.3 Converting the Data |
|
|
46 | (2) |
|
|
48 | (2) |
|
|
50 | (1) |
|
2.3 Overview of Technical Procedures for Data Migration |
|
|
50 | (2) |
|
|
50 | (1) |
|
2.3.2 Legacy System Migration Workbench |
|
|
51 | (1) |
|
|
51 | (1) |
|
|
52 | (1) |
3 Plan and Organize Your Data Migration Projects |
|
53 | (44) |
|
3.1 Types of Data Migration Projects |
|
|
53 | (3) |
|
3.1.1 Initial Load (Green Field) |
|
|
53 | (1) |
|
3.1.2 Upgrading an Existing System (Brown Field) |
|
|
54 | (1) |
|
|
54 | (1) |
|
|
54 | (1) |
|
3.1.5 System Optimization |
|
|
54 | (1) |
|
|
55 | (1) |
|
3.2 Phases of Data Migration Projects |
|
|
56 | (6) |
|
|
58 | (1) |
|
|
58 | (1) |
|
|
59 | (1) |
|
3.2.4 Data Migration Tests |
|
|
59 | (1) |
|
|
59 | (1) |
|
|
60 | (1) |
|
3.2.7 Productive Load and Support |
|
|
61 | (1) |
|
3.3 Work Packages in Data Migration Projects |
|
|
62 | (29) |
|
|
64 | (7) |
|
|
71 | (2) |
|
|
73 | (3) |
|
|
76 | (4) |
|
3.3.5 Data Migration Tests |
|
|
80 | (5) |
|
3.3.6 Productive Load and Support |
|
|
85 | (2) |
|
|
87 | (4) |
|
3.4 Planning and Effort Estimation |
|
|
91 | (5) |
|
3.4.1 Determine Business Objects to Migrate |
|
|
91 | (2) |
|
3.4.2 Estimate the Effort |
|
|
93 | (3) |
|
|
96 | (1) |
4 Batch Input |
|
97 | (34) |
|
4.1 How Batch Input Works |
|
|
98 | (7) |
|
4.1.1 A Batch Input Session |
|
|
98 | (3) |
|
4.1.2 Processing a Batch Input Session |
|
|
101 | (3) |
|
4.1.3 Creating a Batch Input Session |
|
|
104 | (1) |
|
4.2 Standard Batch Input Programs |
|
|
105 | (4) |
|
4.2.1 Program RFBIDEOO: Customer Master |
|
|
106 | (1) |
|
4.2.2 Program RFBIKROO: Vendor Master |
|
|
106 | (1) |
|
4.2.3 Program RFBISAOO: General Ledger Account Master |
|
|
107 | (1) |
|
4.2.4 Program RFBIBLOO: Financial Documents |
|
|
107 | (1) |
|
4.2.5 Program RCSBIOIO, RCSBI020, RCSBIO3O, RCSBIO4O: Bill of Materials |
|
|
107 | (1) |
|
4.2.6 Program RMO6BBIO: Purchase Requisitions |
|
|
108 | (1) |
|
4.2.7 Program RMO7MMBL: Material Documents |
|
|
108 | (1) |
|
4.3 Batch Input Recording: General Approach |
|
|
109 | (21) |
|
4.3.1 Creating the Batch Input Recording |
|
|
109 | (5) |
|
4.3.2 Generating an ABAP Program from a Batch Input Recording |
|
|
114 | (4) |
|
4.3.3 Modifying the Generated ABAP Program |
|
|
118 | (8) |
|
4.3.4 Creating and Processing the Batch Input Session |
|
|
126 | (2) |
|
4.3.5 Call Transaction and Batch Input Session in Case of Error |
|
|
128 | (2) |
|
|
130 | (1) |
5 IDoc and ALE Distribution |
|
131 | (18) |
|
|
131 | (11) |
|
5.1.1 IDoc as an Interface |
|
|
132 | (1) |
|
|
132 | (4) |
|
5.1.3 IDoc Customizing in SAP |
|
|
136 | (2) |
|
5.1.4 Optimizing IDoc Performance |
|
|
138 | (4) |
|
5.2 Data Transfer Workbench |
|
|
142 | (5) |
|
|
142 | (2) |
|
5.2.2 Data Migration Using BAPIs |
|
|
144 | (1) |
|
5.2.3 Combining the Data Transfer Workbench and the LSMW |
|
|
145 | (1) |
|
5.2.4 Data Transfer Workbench Tools |
|
|
146 | (1) |
|
|
147 | (2) |
6 Legacy System Migration Workbench |
|
149 | (90) |
|
|
149 | (3) |
|
6.2 Data Migration with the LSMW |
|
|
152 | (63) |
|
6.2.1 Getting Started with the LSMW |
|
|
153 | (5) |
|
6.2.2 User Guide: The Main Steps of Data Migration |
|
|
158 | (1) |
|
6.2.3 Maintaining Object Attributes |
|
|
159 | (4) |
|
6.2.4 Maintaining Source Structures |
|
|
163 | (1) |
|
6.2.5 Maintaining Source Fields |
|
|
164 | (6) |
|
6.2.6 Maintaining Structure Relations |
|
|
170 | (3) |
|
6.2.7 Maintaining Field Mapping and Conversion Rules |
|
|
173 | (12) |
|
6.2.8 Maintaining Fixed Values, Translations, and User-Defined Routines |
|
|
185 | (8) |
|
|
193 | (2) |
|
|
195 | (6) |
|
6.2.11 Using Wildcards in File Names |
|
|
201 | (1) |
|
|
202 | (1) |
|
|
203 | (2) |
|
6.2.14 Displaying Read Data |
|
|
205 | (2) |
|
|
207 | (2) |
|
6.2.16 Displaying Converted Data |
|
|
209 | (1) |
|
|
210 | (3) |
|
|
213 | (2) |
|
|
215 | (11) |
|
6.3.1 Creating and Editing Recordings |
|
|
217 | (6) |
|
|
223 | (3) |
|
|
226 | (6) |
|
6.4.1 Long Texts in the SAP System |
|
|
226 | (1) |
|
6.4.2 Target Structures and Field Mapping |
|
|
227 | (4) |
|
6.4.3 Importing Long Texts |
|
|
231 | (1) |
|
6.5 Transporting Projects |
|
|
232 | (2) |
|
6.5.1 Creating a Change Request |
|
|
232 | (1) |
|
|
233 | (1) |
|
|
234 | (1) |
|
6.6 Preparations for Using IDoc Inbound Processing |
|
|
234 | (3) |
|
|
237 | (2) |
7 Legacy System Migration Workbench for Experts |
|
239 | (50) |
|
|
239 | (6) |
|
7.1.1 Layout and Processing Times |
|
|
240 | (2) |
|
|
242 | (1) |
|
|
243 | (1) |
|
7.1.4 Reusable Rules: Naming Conventions |
|
|
243 | (2) |
|
7.2 Advanced Applications |
|
|
245 | (10) |
|
7.2.1 Determining the Transaction Code at Runtime |
|
|
245 | (1) |
|
|
246 | (1) |
|
7.2.3 Skipping All Records of a Transaction |
|
|
246 | (1) |
|
7.2.4 Duplicating a Record |
|
|
246 | (2) |
|
7.2.5 Assigning Multiple Source Structures to a Target Structure |
|
|
248 | (1) |
|
7.2.6 Assign a Random Number of Records to One Transaction |
|
|
249 | (5) |
|
7.2.7 Error Messages in the Conversion Log |
|
|
254 | (1) |
|
7.3 The LSMW Conversion Program |
|
|
255 | (4) |
|
7.3.1 Activate Additional Process Steps |
|
|
255 | (1) |
|
7.3.2 The Conversion Program's Structure |
|
|
256 | (3) |
|
7.4 User-Defined Routines and Advanced Tips |
|
|
259 | (28) |
|
7.4.1 Initialize IDoc Structures with a Nodata Sign |
|
|
259 | (3) |
|
7.4.2 Directly Modify Table Records Using the LSMW |
|
|
262 | (2) |
|
7.4.3 Adding Selection Parameters to the LSMW Conversion Program |
|
|
264 | (3) |
|
7.4.4 Assign Multiple Source Structures to One Target Structure with Substructures |
|
|
267 | (7) |
|
7.4.5 Extend LSMW with an Advanced Conversion Log |
|
|
274 | (7) |
|
7.4.6 Using Conversion Exits and Routines |
|
|
281 | (6) |
|
|
287 | (2) |
8 Rapid Data Migration with SAP Data Services |
|
289 | (70) |
|
8.1 SAP Data Services Overview |
|
|
290 | (2) |
|
8.2 Rapid Data Migration Architecture |
|
|
292 | (6) |
|
8.3 Rapid Data Migration Process |
|
|
298 | (45) |
|
8.3.1 Data Migration Content |
|
|
299 | (9) |
|
8.3.2 Connecting Source Systems |
|
|
308 | (3) |
|
|
311 | (5) |
|
|
316 | (9) |
|
|
325 | (8) |
|
|
333 | (4) |
|
|
337 | (3) |
|
|
340 | (3) |
|
8.4 Lookups and Validations |
|
|
343 | (3) |
|
|
344 | (1) |
|
|
345 | (1) |
|
8.5 SAP Data Services for Experts |
|
|
346 | (7) |
|
|
346 | (1) |
|
|
346 | (2) |
|
|
348 | (2) |
|
8.5.4 Validation Enhancements |
|
|
350 | (2) |
|
|
352 | (1) |
|
8.6 Data Migration to SAP Cloud Solutions |
|
|
353 | (5) |
|
8.6.1 Rapid Data Migration to the Cloud |
|
|
354 | (2) |
|
8.6.2 Interfaces for SAP Cloud Solutions |
|
|
356 | (2) |
|
|
358 | (1) |
9 Data Migration in SAP Business ByDesign and SAP Cloud for Customer |
|
359 | (124) |
|
|
360 | (13) |
|
9.1.1 Structure and Elements of Migration Templates |
|
|
360 | (3) |
|
|
363 | (2) |
|
|
365 | (3) |
|
9.1.4 Export Data from the Source System |
|
|
368 | (1) |
|
9.1.5 Filling Data into Migration Templates |
|
|
369 | (1) |
|
9.1.6 Alternative Options to Populate Migration Templates |
|
|
370 | (2) |
|
|
372 | (1) |
|
|
373 | (26) |
|
9.2.1 Navigation in SAP Business ByDesign |
|
|
374 | (1) |
|
9.2.2 Navigation in SAP Cloud for Customer |
|
|
375 | (1) |
|
9.2.3 Migration Tasks in the Implementation Project |
|
|
376 | (1) |
|
9.2.4 Prepare for Data Migration |
|
|
377 | (3) |
|
|
380 | (3) |
|
|
383 | (5) |
|
|
388 | (4) |
|
9.2.8 Migration Cockpit: More Features |
|
|
392 | (2) |
|
9.2.9 Integrated Data Editor |
|
|
394 | (5) |
|
9.3 Migration Process Steps |
|
|
399 | (29) |
|
|
400 | (7) |
|
9.3.2 Convert Values (Value Mapping) |
|
|
407 | (8) |
|
|
415 | (9) |
|
|
424 | (4) |
|
9.4 Migration of Accounting Transactional Data |
|
|
428 | (24) |
|
9.4.1 Preparation in SAP Business ByDesign |
|
|
429 | (2) |
|
9.4.2 Preparation in the Source System |
|
|
431 | (3) |
|
|
434 | (5) |
|
9.4.4 Migration Templates in Accounting |
|
|
439 | (3) |
|
9.4.5 Accounting Migration: Main Steps |
|
|
442 | (1) |
|
9.4.6 Simulation of Single Files |
|
|
443 | (1) |
|
|
444 | (2) |
|
9.4.8 Cross-Check of Balances |
|
|
446 | (4) |
|
9.4.9 Acceptance of Imported Data |
|
|
450 | (1) |
|
|
451 | (1) |
|
|
452 | (18) |
|
|
453 | (3) |
|
9.5.2 Enhance Existing Records |
|
|
456 | (4) |
|
9.5.3 Modify Existing Records |
|
|
460 | (2) |
|
9.5.4 Replace Existing Records |
|
|
462 | (2) |
|
9.5.5 Mass Data Maintenance |
|
|
464 | (6) |
|
9.6 Migration as a Subproject |
|
|
470 | (6) |
|
|
470 | (2) |
|
9.6.2 Migration Tasks in Implementation Projects |
|
|
472 | (2) |
|
|
474 | (2) |
|
|
476 | (6) |
|
9.7.1 Volume Performance by Parallelization |
|
|
477 | (2) |
|
9.7.2 Reconciliation of Migration Results |
|
|
479 | (3) |
|
|
482 | (1) |
10 Techniques for Avoiding Programming |
|
483 | (22) |
|
10.1 Problem Area: Data Conversion |
|
|
483 | (1) |
|
10.2 Techniques for Converting Data |
|
|
484 | (19) |
|
10.2.1 Modifying Structures |
|
|
484 | (5) |
|
10.2.2 Modifying Field Contents |
|
|
489 | (10) |
|
10.2.3 Using Microsoft Excel VLOOKUP Instead of Microsoft Access Database Join |
|
|
499 | (4) |
|
|
503 | (2) |
11 Assessment of Data Migration Techniques |
|
505 | (12) |
|
|
505 | (1) |
|
11.2 Advantages and Disadvantages of the Procedures |
|
|
506 | (5) |
|
|
506 | (3) |
|
11.2.2 Legacy System Migration Workbench |
|
|
509 | (1) |
|
|
510 | (1) |
|
11.3 Reasons for Favoring a Certain Procedure |
|
|
511 | (4) |
|
11.3.1 Complexity of the Migration Task |
|
|
511 | (1) |
|
11.3.2 Quality of the Legacy Data |
|
|
512 | (1) |
|
|
512 | (1) |
|
11.3.4 The Importance of Data Security |
|
|
513 | (1) |
|
|
513 | (1) |
|
|
514 | (1) |
|
|
515 | (1) |
|
|
515 | (2) |
12 Advanced Topics and SAP S/4HANA |
|
517 | (32) |
|
12.1 Data Migration between SAP Systems or within an SAP System |
|
|
517 | (10) |
|
12.1.1 SAP Landscape Transformation |
|
|
518 | (5) |
|
12.1.2 Using the Data Browser to Extract Records |
|
|
523 | (4) |
|
|
527 | (6) |
|
|
528 | (1) |
|
12.2.2 Rapid Database Migration |
|
|
528 | (5) |
|
12.3 Migration Paths to SAP S/4HANA |
|
|
533 | (15) |
|
12.3.1 Migrating Data to SAP S/4HANA |
|
|
533 | (4) |
|
|
537 | (3) |
|
12.3.3 SAP S/4HANA Cloud Editions |
|
|
540 | (3) |
|
12.3.4 SAP S/4HANA, On-Premise Edition |
|
|
543 | (2) |
|
12.3.5 Integrating Your Data with SAP S/4HANA, Cloud Marketing Edition |
|
|
545 | (3) |
|
|
548 | (1) |
The Authors |
|
549 | (4) |
Index |
|
553 | |