Muutke küpsiste eelistusi

Data Migration with SAP Third Edition [Kõva köide]

  • Formaat: Hardback, 563 pages, kõrgus x laius: 229x175 mm
  • Ilmumisaeg: 28-Mar-2016
  • Kirjastus: SAP Press
  • ISBN-10: 1493213385
  • ISBN-13: 9781493213382
  • Formaat: Hardback, 563 pages, kõrgus x laius: 229x175 mm
  • Ilmumisaeg: 28-Mar-2016
  • Kirjastus: SAP Press
  • ISBN-10: 1493213385
  • ISBN-13: 9781493213382
When it comes to data migration, choosing the right approach for your organization can be overwhelming. This comprehensive guide not only leads you through project planning, but also gives you step-by-step instructions for executing your migration with LSMW, SAP Data Services, the batch input technique, and more. Whether you’re moving to the cloud, migrating to SAP S/4HANA, or replacing a legacy system, let us smooth the way.Planning and Selection CriteriaGet the tools you need to plan your data migration, from project management to terminology and procedure, to criteria for selecting the best migration tool for the job.Migration MethodsUnderstand the tools and methods for data migration without programming: batch input, IDocs, ALE, the LSMW, SAP Data Services, and SAP Activate.Cloud Migration and SAP S/4HANAExplore options for migration to the cloud with SAP Business ByDesign and SAP Cloud for Customer. Then, discover pathways for data migration to SAP S/4HANA.Highlights:

  • Legacy data
  • Migration planning
  • Batch input
  • IDocs and ALE
  • Legacy System Migration Workbench (LSMW)
  • SAP Data Services
  • Rapid Data Migration
  • Cloud migration
  • SAP S/4HANA
  • SAP Activate

Muu info

Legacy data; Migration planning; Batch input; IDocs and ALE; Legacy System Migration Workbench (LSMW); SAP Data Services; Rapid Data Migration; Cloud migration; SAP S/4HANA.
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)
1.3.1 Basic Customizing
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)
1.4 Summary
42(1)
2 Technical Basics for Migrating Data to SAP 43(10)
2.1 Basic Terminology
43(2)
2.2 The Data Migration Process from a Technical Perspective
45(5)
2.2.1 Exporting the Data
45(1)
2.2.2 Reading the Data
45(1)
2.2.3 Converting the Data
46(2)
2.2.4 Importing the Data
48(2)
2.2.5 Verifying the Data
50(1)
2.3 Overview of Technical Procedures for Data Migration
50(2)
2.3.1 Batch Input
50(1)
2.3.2 Legacy System Migration Workbench
51(1)
2.3.3 SAP Data Services
51(1)
2.4 Summary
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)
3.1.3 Phased Roll-Out
54(1)
3.1.4 Big Bang
54(1)
3.1.5 System Optimization
54(1)
3.1.6 Cloud Migration
55(1)
3.2 Phases of Data Migration Projects
56(6)
3.2.1 Data Analysis
58(1)
3.2.2 Mapping
58(1)
3.2.3 Implementation
59(1)
3.2.4 Data Migration Tests
59(1)
3.2.5 Data Validation
59(1)
3.2.6 Data Cleansing
60(1)
3.2.7 Productive Load and Support
61(1)
3.3 Work Packages in Data Migration Projects
62(29)
3.3.1 Data Analysis
64(7)
3.3.2 Data Cleansing
71(2)
3.3.3 Mapping
73(3)
3.3.4 Implementation
76(4)
3.3.5 Data Migration Tests
80(5)
3.3.6 Productive Load and Support
85(2)
3.3.7 Data Validation
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)
3.5 Summary
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)
4.4 Summary
130(1)
5 IDoc and ALE Distribution 131(18)
5.1 IDoc Basics
131(11)
5.1.1 IDoc as an Interface
132(1)
5.1.2 Using I Docs
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)
5.2.1 Basics
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)
5.3 Summary
147(2)
6 Legacy System Migration Workbench 149(90)
6.1 Overview of the LSMW
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)
6.2.9 Addendum: Files
193(2)
6.2.10 Specifying Files
195(6)
6.2.11 Using Wildcards in File Names
201(1)
6.2.12 Assigning Files
202(1)
6.2.13 Reading Data
203(2)
6.2.14 Displaying Read Data
205(2)
6.2.15 Converting Data
207(2)
6.2.16 Displaying Converted Data
209(1)
6.2.17 Importing Data
210(3)
6.2.18 Object Overview
213(2)
6.3 Recordings
215(11)
6.3.1 Creating and Editing Recordings
217(6)
6.3.2 Using a Recording
223(3)
6.4 Long Texts
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)
6.5.2 Exporting Projects
233(1)
6.5.3 Importing Projects
234(1)
6.6 Preparations for Using IDoc Inbound Processing
234(3)
6.7 Summary
237(2)
7 Legacy System Migration Workbench for Experts 239(50)
7.1 Advanced Functions
239(6)
7.1.1 Layout and Processing Times
240(2)
7.1.2 Global Variables
242(1)
7.1.3 Global Functions
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)
7.2.2 Skipping a Record
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)
7.5 Summary
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)
8.3.3 Data Profiling
311(5)
8.3.4 Field Mapping
316(9)
8.3.5 Value Mapping
325(8)
8.3.6 Data Validation
333(4)
8.3.7 Data Load
337(3)
8.3.8 Monitoring
340(3)
8.4 Lookups and Validations
343(3)
8.4.1 SAP Lookup Tables
344(1)
8.4.2 Translation Tables
345(1)
8.5 SAP Data Services for Experts
346(7)
8.5.1 Scripting Language
346(1)
8.5.2 System Functions
346(2)
8.5.3 Custom Functions
348(2)
8.5.4 Validation Enhancements
350(2)
8.5.5 Data Quality
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)
8.7 Summary
358(1)
9 Data Migration in SAP Business ByDesign and SAP Cloud for Customer 359(124)
9.1 Migration Templates
360(13)
9.1.1 Structure and Elements of Migration Templates
360(3)
9.1.2 User Tips
363(2)
9.1.3 Field Formats
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)
9.1.7 Data Cleansing
372(1)
9.2 Migration Tool
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)
9.2.5 Migration Objects
380(3)
9.2.6 Migration Cockpit
383(5)
9.2.7 Upload CSV Files
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)
9.3.1 Validate File
400(7)
9.3.2 Convert Values (Value Mapping)
407(8)
9.3.3 Simulate Import
415(9)
9.3.4 Import Data
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)
9.4.3 Migration Unit
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)
9.4.7 Posting Preview
444(2)
9.4.8 Cross-Check of Balances
446(4)
9.4.9 Acceptance of Imported Data
450(1)
9.4.10 Postprocessing
451(1)
9.5 Change Migration
452(18)
9.5.1 Add New Records
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)
9.6.1 Project Management
470(2)
9.6.2 Migration Tasks in Implementation Projects
472(2)
9.6.3 Test Strategy
474(2)
9.7 Tips and Tricks
476(6)
9.7.1 Volume Performance by Parallelization
477(2)
9.7.2 Reconciliation of Migration Results
479(3)
9.8 Summary
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)
10.3 Summary
503(2)
11 Assessment of Data Migration Techniques 505(12)
11.1 Use Cases
505(1)
11.2 Advantages and Disadvantages of the Procedures
506(5)
11.2.1 Batch Input
506(3)
11.2.2 Legacy System Migration Workbench
509(1)
11.2.3 SAP Data Services
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)
11.3.3 Data Volume
512(1)
11.3.4 The Importance of Data Security
513(1)
11.3.5 Reusability
513(1)
11.3.6 Restrictions
514(1)
11.3.7 User-Friendliness
515(1)
11.4 Summary
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)
12.2 Database Migration
527(6)
12.2.1 Basics
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)
12.3.2 SAP Activate
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)
12.4 Summary
548(1)
The Authors 549(4)
Index 553
Frank Densborn is a product manager for SAP Rapid Deployment solutions in the technology area, focusing on data migration and cloud integration. Frank is the package owner of SAP's Rapid Data Migration rapid-deployment solution packages and is also working on integrating SAP's cloud solutions with the on premise world. He joined SAP in 2004 holding various roles in development, education, support, and product management.

Johann Gradl was born in 1961. He studied mathematics and computer science at the Technische Universität München (Munich Polytechnic University) from 1980 to 1986 and after a hiatus during which he performed his civil service duty; he completed his doctorate in mathematics from 1988 to 1990. Johann Gradl joined SAP in 1993. He initially worked in the R/2 Services department, and then turned his attention to the area of data migration. He was a driving force behind the development o f the Legacy Sy stem Migration Workbench described in this book. He subsequently performed various tasks related to the development of Customer Relationship Management (CRM). In his current position of Vice President for Installed Base Maintenance & Support, he is responsible for the products CRM and BW, among others.

Michael Willinger was born in 1971 in Heidelberg, Germany. He studied business administration at the University of Mannheim from 1990 to 1996, focusing on bank management, financing, auditing, fiduciary structures, and statistics. He first encountered SAP R/3 during his graduate studies in business data processing; it has had a major impact on his career path ever since. From 1998 to 2001, Michael Willinger worked as an SAP consultant (focus: Financial Accounting) at Bilfinger & Berger AG, a construction firm, before he moved to Tarkett Sommer Holding, an internationally active manufacturer of flooring. At present, he is the project manager for the global implementation of the R/3 Financial Accounting and Controlling modules.