2125725, 10:20AM Migrating data from SAP ECC to SAP SAIHANA with th... SAP Community Samm roducsandTectnology Groups Panes Topics Events WhatsNew Get Stared Expioresar QB ‘Ae conmuniy > Products and Teemelogy > Enterpse Resource Planing > ERP Slogs by Members > Migrating dt tom SAP ECC to SAP AANA wih Enterprise Resource Planning Blogs by Members Gain new perspectives and knowledge about enterprise resoute planning in blog poss fem commun members. Share your cam comments and ERP insighs today" Blog What are you looking for today? Migrating data from SAP ECC to SAP S4/HANA with the migration cockpit @ rmarcobuescher ‘Active Contibutor ) | oKudos | ©8,740 ‘SAP Managed Tags: SAP S/4HANA migration cockpit, ° 2024 fot 20 12:15 AM Migrating data from SAP ECC to SAP S/4HANA isa crucial step for companies that want to beneft from the improved functionality and performance of SISHANA. Effective data migration is crucial for a smooth transition and the success of your project. The Migration Cockpit isa powerful tool designed specifically fr this purpose, helping companies to migrate data quickly, easly and reliably. In its simplest terms, data migration involves extacting data fram one system and loading itinto another. In practice, however, this is rarely possible without vansforming the extracted data before loading itinto the target system. The transformation can contain, formatting values tat fit into the target felds. You can also use this phase to ensure the qualty of your data (e.g. to identify and eliminate duplicate master data) © ji B= e272 % 27 © ov sees © —weosrerseencon —_siuae More rmigraton objects sae Jo & design to reflect, aes ‘custom requirements Cloud Legacy ‘ntps:[Link]/Sienterprise-tesource-planning-blogs-by-membersimigrating-dats-rom-sap-ecco-sap-s¢-hanae-with-ihe-migraon-cockp.. 1/122128725, 10:20AM Migrating data from SAP ECC to SAP SAIHANA wit h..- SAP Community ‘The data migration process follows the extrac - transform - load approach. At the stat of a project you define the migration objects ‘that you want to use, Each migration object describes a specific type of data, e.g. bank master record, customer, supplicr, etc. nthe ‘migration cockpit, you can see which migration objects depend on others. For example, to migrate cost centers, you must fist migrate Yyour profit center structure. ‘The data migration process is based on an approach that includes extraction, transformation and loading. At the beginning, the migration objects are defined, whicn describe cifferent types of data, such as bank master records, customers or suppers. The dependencies between the migration objects become visible in the migration cockpit. For example, the migration of cost centers requires the prior migration of the profit centr structure ‘Once the relevant migration objects have been defined, the data is retrieved from the source system, depending on the migration ‘method selected. The data is then assigned to the corresponding fields in SAP S/4HANA, with automatic mapping suggestions providing assistance. Transformations may also be necessary to adapt the data tothe requirements of the SAP S/4HANA system, such 2 converting "GER" to "DE" for country codes. ‘Simulating the data migration makes it possible to identify potential erors without actualy saving the data. After a successful simulation, the actual migration takes place, during which the data is saved inthe system. In the event of errors, these can be Identified, corected and reprocessed in the migration cockpit. ‘App -Miatieren Sie Ihre Dater* ‘App -Miarieren Sie Ihre Daten* oar nisl ce - f : g Ersieit rH Datenbart fs | Daten hochiaden SS Tabelion mit Dateivoriage fallen ‘oder ETL-Too! jenubemahme mit Dateien und Staging-Tabellen ‘The first approach to data migration uses staging tables, which serve as a cache for data, These tables ae filled with data from the source system and the "Migrate data" app collects this data from the staging tables for migration. ‘The source system can either be an SAP system ora third-party system. With this approach, you have the option of downloading an Excel template into which you can load the data from your source system. You can then upload the content ofthe Excel fle tothe staging tables. Aterativly, you can fil he staging tables directly with SAP Data Services, your own SQL programming ora third-party ETL tool, ‘ntps:/[Link]/Sienterprise-tesource-planning-blogs-by-membersimigating-dats-rom-sap-eccto-sap-s¢-hana-with-ihe-migraion-cockp... 2/122125125, 10:20AM Migrating data from SAP ECC to SAP SAIHANA with th... SAP Community ‘The third approach to data transfer is direct wansfer. Here, the SAP S/4HANA system collects the data directly fom the source system. ‘The source system must be eitier an SAP Business Suite system, SAP Apparel and Footwear, SAP CRM or SAP EWM. ‘The advantage ofthis approach is that itis sutable for ary amount of data. As the data is transterred directly trom the source system, there is no intermediate step of storing it in staging tables, This can be particularly advantageous if real-time data vansfer or large volumes of data are required Here | showy you how to perform a migration, Datenmigration Migrieren Sie ihre Daten Migrationscockpit 3 Migrtionsprojete a ‘App Migrate Open your data i Migrate data using staging tables ‘Assign a name forthe migration project ‘ntps:[Link]/Sienterprise-tesource-planning-blogs-by-membersimigrating-dats-rom-sap-ecco-sap-s¢-hanaewith-ihe-migraon-cockp... 3/122125125, 10:20AM Migrating data trom SAP ECC to SAP SHANA with h..- SAP Community 2. Entwicklungspaket snare = =—s3 . ipo you canslethe mization cet Asn ie projection iting package as pot go Neston tet tat you itemust then be checked, Itcan be created by clicking on the “Create Project” ogress can be observed in the monitoring map. Basic mapping tasks must be carried out, ‘ntps:[Link]/Sienterprise-tesource-planning-blogs-by-membersimigrating-dats-rom-sap-eccto-sap-s¢-hanaewith-ihe-migraon-cockp.. 4/122125725, 10:20AM Migrating data trom SAP ECC to SAP SAIHANA wit h..- SAP Community Tene — ae ora enmtraden > [[isseenesmsses >| — st en hoc Download template Upload completed fle - Pesce nto Nett ean an Progress cn be observed under Monitoring args roe Succes cn be ewes ie ‘ntps:[Link]-tesource-planning-blogs-by-membersimigating-dats-rom-sap-eccto-sap-s¢-hana-with-ihe-migraion-cockp.. 5/122125725, 10:20AM Migrating data from SAP ECC to SAP SHANA wit th... SAP Community ‘Any parameters can be mapped and confirmed under Mapping tasks. Prepare staging tables. Click the Prepare staging tables Prepare migration. are migra button here. ‘After completing the preparation, you can view the ‘This point can also be observed under Monitoring errors, warnings, successes and information and correct cerrrs if necessary. ‘ntps:/[Link]/Sienterprise-tesource-planning-blogs-by-membersimigrating-dats-rom-sap-eccto-sap-s¢-hana-wih-ihe-migraion-cockp.. 6/122125725, 10:20AM Migrating data trom SAP ECC to SAP SAIHANA with th... SAP Community ‘You can then perform the mapping tasks again ——s = —=1 Mapping Mapping o j fesse ‘Next point, simulate, For example, you can simulate with 1096 ofthe data, ‘The progress can be observed inthe monitoring Errors can be analyzed with “Show messages” = “Trigger migration process ‘Trigger the migration of data, ‘ntps:[Link]-tesource-planning-blogs-by-membersimigrating-dats-rom-sap-ecco-sap-s¢-hana-with-ihe-migraion-cockp... 7/122125725, 10:20AM Migrating data from SAP ECC to SAP S4IHANA with th... SAP Community Information message Migration started, ‘The progress ofthe migration can also be monitored Unsuccessflly migrated data records can be reprocessed separately in a correction fle. inthis case 10 data records. ‘These ten data records can be reworked and must then bbe migrated again. You must be a registered user to add a comment. you've already registered, sign in. Otherwise, register and sign in. ‘Comment Labels In This Area “Dest Practice" “Data Source Migration” 1 "mm02"2 “SAPSales” SAP Cloud 1 Session InCOS1‘abap' 1 “SAPr1 ‘ntps:/[Link]-tesource-planning-blogs-by-membersimigrating-data-rom-sap-ecco-sap-s¢-hanaewith-ihe-migraion-cockpi.. 8/122125125, 10:20AM Migrating dat from SAP ECC to SAP SA/HANA with th... SAP Community SAP1 2028 Upyrade1@expertiap2@tapcommunity 1 A_PurchaseOrderitem adltonal fields 1 ABAPS — ABAPT.42 ahap cds ABAP CDS VIEW2 —ABAPCDS Views 2 ABAP CDS Views - BW Extraction 1 [ABAP CDS Views - COC (Change Dal capture)? ABAP DDIC COS view 1 ABAP development 2 ABAP Extensibilty 2 [ABAP Programming 1 ABAP Query abapGit1_ACCOSTRATE1 Account Assignment Category 1 ACDOCP 1 ‘Adding your country in SPRO -Project Administration 1 Adobe form binding. Adobe forme Adobe Printing 1 ‘Advance Retuin Management 1 Advanced intercompany Sales (502)1 Advanced Returns Management 2 ‘Advanced SAP Techniques 1 ADVANCED VARIANT CONFIGURATION 2 AgenticAl1 ageless 1 Aland RPAn SAP Upgrades 2 ‘Alvi ALVGRID1 ALVReport1 APL and integration Application Development for SAP HANA Cloud 1 ‘Approval Worktions 1 Ariba ARM1 Ail ntlgence (A). ASN Asset Management 1 Asset under construction 1 ‘Assigned budget 1 Associations in CDS 1 Associations in CDS Views 2 AMtachmentList 1 audit 1 aueltog 1 authorization 1 Auto POtromGR i Avalabllty date 1 Azure Center for SAP Solutions 1 AzureSentnel3BADIZ Bank? |_SALESORDER_CREATEFROMDATZ 2 batch characterises 1 Batch Cassifcation batch Determination 1 Batch Management Best Practice 1 iling BP bpbusiness partner. BRF+ 1 BREPLUS 2 Budgetfor PRs 1 Bundled Cloud Services + business paicipation 1 Business Partner 2__ Business Parner Master Data 3 Business Processes 2 Business Tends 1 usiness Trends 1 Capacity Planning 1 CAPM2 Carbon CDS Annotatons 2 (CDS View wih Parameter2 Cental Finance 1 Centralfnance 1 CFIN2 CHIN Document Spliting 1 Charge aleuaton 2 CLGULALYGRID1 Classical MRP Cloud 2 cloud alm 1 Cloud Integration 1 Related Content Propose IAN in Bank Master Data of Business Partner dur In Emerpse Resource Planning 8A yesterday 1g Data Migration or Mass Change Deactivating Simplified Sourcing in SAP SISHANA in Emerpse Resource Planning Bogs by SAP yesterday How do we migrate Open Accruals into a Condition Contract? in Emerpse Resource Planning Q&A Fay How to migrate DIR attachments (physical files) from one SAP instance to another. In Enerpse Resource Panning Q&A Thursday Migration Cockpit: Archived migrated data should be migrated again. In Emerpse Resource Planning O84 Wednesday Popular Blog Posts rips eommunity [Link]/Slenterprse-resource-planning-blogs-by-membersimigrating-data-trom-sap-ecc-o-sap-sé-hanavaiththe-migraton-cockpl... 942Migrating data from SAP ECC to SAP SATHANA with th... SAP Community Doc Basies For Functional Consultants former_member213836 ‘Acive Patcpant © 1102201] 320 683 {LSMW for Functional Consultants in simple step-by-step way {former_member182098 ‘Acive Contbutor © 652812 295 304 ‘ntps:/[Link]/Sienterprise-tesource-planning-blogs-by-membersimigrating-dats-rom-sap-eccto-sap-s¢-hana-wit-ihe-migraon-cock... 10/12Migrating data from SAP ECC to SAP S4IHANA with th... SAP Community Pricing procedure Steps and Details in SAP MM former membert83424 ‘cive Conteotor @ ra Gis. & 332 ‘Top Kudoed Authors Q verre be [ oatnazanee o7 R vas oe Bremen os Qu o: former embertse 3 | Meka_Maduvandi_K o3 terme memberi0e252 2 ‘ntps:/[Link]-tesource-planning-blogs-by-membersimigrating-dats-rom-sap-ecco-sap-s¢-hana-wit-ihe-migralon-cock... 11/122125125, 10:20AM Migrating data from SAP ECC to SAP SAIHANA with th... SAP Community 8 venkateshe RR Rajecopatan o2 View att Privacy Terms of se copyiet Legal Disclosure “adem suspoe Cookie Preferences Follow fo in ‘ntps:[Link]/Sienterprise-tesource-planning-blogs-by-membersimigating-dats-rom-sap-ecco-sap-s¢-hana-wit-ihe-migralon-cock... 12/12