New Installation of SAP S/4HANA 2020FPS0 – Part 5 – Direct Data Transfer using Migration Cockpit
There is lots of content out there – blogs, notes, ppts, guides, videos, eLearning Hub, and the key to fast tracking this is to find out all the notes that apply. This blog will take you there in a structured way for current release and you can use same logic for future releases to find out all the details easily.
Basic understanding of the types of notes makes it easy to crack the process. This way you know which notes you have to read, which notes you have to read and apply as corrections using SNOTE.
Please find other blogs as follows at S/4HANA SQUARE ONE
SAP S/4HANA SQUARE ONE
|NEW INSTALLATION||PART1 – MP||PART2 – Installation
||PART3 – BP Activation
||PART4 – Fiori Activation||PART5 – DATA MIGRATION|
|S/4HANA 2020||fps1 fps0||fps1 fps0||fps1 fps0||fps1 fps0||fps0|
|S/4HANA 1909||fps2 fps1 fps0||fps2 fps1 fps0||fps2 fps1 fps0||fps2 fps1 fps0||fps0|
|S/4HANA 1809||fps2 fps1 fps0||fps2 fps1 fps0||fps2 fps1 fps0||fps2 fps1 fps0|
||fps2 fps1 fps0||fps2 fps1 fps0||fps2 fps1 fps0|
|SYSTEM CONVERSION||t2 – RC||t3 – MP||t4 – SIC
||t5 – CCM||t6 – SUM|
|SAP S/4HANA ON-PREM APPLIANCE||INSTALL USING MEDIA||ACTIVATE FROM CAL|
|S/4HANA 1909+||link custom link standard||link|
|SAP S/4HANA CERTIFICATION|
|S/4HANA Certification Exams through SAP Certification Hub||link|
This blog is for SAP S/4HANA 2020 FPS0. After installation of SAP S/4HANA please ensure that Fiori apps are activated as per blog Part 4 – Fiori Activation and you may like to uncheck option for demo data as mentioned in Part 3 – Best practices activation.
The sequence in which you migrate data from ERP to S/4HANA is as follows in this order:
(1) Organization data – configure Company Code, Sales Org, Purchasing Org, Plant, etc
(2) Master Data – Customer, Vendor, Material, General Ledger, Customer Material InfoRecord, Pricing conditions, Source List, Planned Independent Requirements, etc
(3a) Open Balances – General Ledger balance, Inventory balance, Accounts Receivable balance, Accounts Payable balance, etc
(3b) Open Transactions – Open Sales Orders, Open Purchase Orders, Open Contract, etc.
We will first prepare the Source ECC System. Then create RFC connection to ECC system, then prepare target S/4HANA System (prepared based on blogs Part 1 – 4 above) and then Start data migration using Fiori App.
STEP 1: SELECT THE NOTES APPLICABLE
Let’s first find out the note applicable. It’s good to know the difference between Composite Note – which is a note that includes Installation information of all releases like 1909, 2020, etc You have to first go to SAP Note 2780378 Composite SAP Note for SAP S/4HANA Migration Cockpit (all releases) to find out which notes are applicable to the release and then for more details in SAP Note 2747566 – SAP S/4HANA Migration Cockpit: Composite Note for Transfer Data Directly from SAP System.
There is an Analyzer Note 2596411 to be applied in the S/4HANA system to run program DMC_NOTE_ANALYSER to find out if any more correction notes are required. Also in ERP system we have to refer to Note 2974017 for DMIS installation and correction notes included.
There is a FAQ Composite Note which we will use for the step sequence SAP Note 2747566 – SAP S/4HANA Migration Cockpit: Composite Note for Transfer Data Directly from SAP System
There is a Collective FAQ Note 2537549 that has KBAs for migration objects, like for example the Consulting Note 2663293 – Migration Cockpit: Analyze Fixed Asset data migration errors This note says the error could be a configuration/customizing issue and may be due to inconsistencies/incorrect values.
There is also a KBA Note 2778320 – Release Comparison of Migration Objects which contains information about the changed structures and fields between the different releases.
STEP 2: PREPARE SOURCE SYSTEM
(B) Follow Note 2974017 – Installation and delta upgrade of DMIS 2011_1
Install the latest SPAM update to latest version. Upgrade/Install DMIS 2011_731 SP19 on source system. For fresh installation, go to Software Download – DMIS Choose DMIS and then DMIS 2011_1_731 to download K-116AGINDMIS.SARIf the source system already has DMIS then on the Right-Top, Click on Support Packages and Patches and select from needed files K-11601INDMIS.SAR to K-11619INDMIS.SAR and apply.After all the files have been uploaded/extracted, login to client 000 and apply DMIS Add-on using SAINT and password for DMIS 2011_731 fresh install is 51055C245A
Then apply the Correction Notes in source EWP system as below from SAP Note 2974017 – Central Note for DMIS 2011 SP19 – Migration Cockpit: Transfer Data Directly from SAP System – SAP ERP or SAP AFS to SAP S/4HANA
|2955026||Corrections in MM – Purchase order migration object||No|
|2964450||Correction in Pricing condition (purchasing and sales) migration object||No|
|2965677||Corrections in MM – Purchase order migration object||No|
|2967124||Error while generation of objects for TRM – Fixed term deposit||No|
|2969989||Error in currency amount in material inventory balance||No|
|2970716||Missing Tax Number Categories in Customer and Supplier Migration Objects||No|
|2971508||Corrections in FI-GL Account balance – new GL migration object||No|
|2977211||Error in migration object Customer material: “Error message: Type “ATWRT30” is unknown||No|
|2979048||Corrections in MM – Purchase order migration object||No|
|2979236||Corrections in MM – Purchase order migration order||No|
Correction in SD – Sales order migration object
Corrections in MM – Purchase order migration object
Correction in SD – Sales order migration object
Correction in SD – Sales order migration object
(C) Create User in Source System for Data Transfer.
Login to Source System Client from where you want the data transferred. Use tCode SU01 and Create User ECC_RFC_USER, User Type = Communications Data, User Role = SAP_DMIS_OBT_REMOTE.
TIP1: The user ECC_RFC_USER allows access to data in ECC system and SAP has further tightened the security in S/4HANA 2020 to reduce the authorizations for a standard role from SAP_DMIS_OBT_REMOTE. When testing through SM59 the RFC connection for authorization you will get error – No RFC authorization for function module RFCPING. This is normal in view of reducing authorization to bare minimum, but data migration will work. If you want to test, temporarily assign SAP_ALL for testing.
TIP2: For assigning role SAP_DMIS_OBT_REMOTE, it is recommended to use copy of the role. Please ensure that the assigned role is “Generated” after going into tCode PFCG and clicking on change, Authorizations tab, Change Authorization Data button, Generate. If you don’t do this you may get errors due to authorization issue.
TIP3: In case you do not have ERP system and want to try the example, please use IDES ERP 6 EHP8 system. Copy from CAL (60 mins) or Install from media. You will have to upgrade DMIS add-on to the latest as above.
STEP 3: CREATE RFC CONNECTION IN S/4HANA SYSTEM
Login to Target S/4HANA System, tCode SM59 and Create RFC Destination as per graphic:
(1) ECC_S4H_XFER, Connection Type 3
(2) Specify Language = EN, Client = 100, User = ECC_RFC_USER, Password.
(4) Menu -> Utilities, => Test => Authorization Test
TIP: Authorization test you will get error – No RFC authorization for function module RFCPING. This is normal as explained in previous step.
STEP 4: PREPARE TARGET – S/4HANA SYSTEM
Steps are based on system prepared with Part1 to Part4 of the blog for New Installation. In Part 3 the Best Practices Content Activation would be done without demo data. This requires unchecking the demo data option in the first dialog after starting activation.
(A) Implement SAP Note 2946774 – SAP S/4HANA Migration Cockpit: Central Note for Transfer Data Directly from SAP System – Corrections in migration technology for SAP S/4HANA 2020 Apply Correction Notes as mentioned below. The list is based on ver 5 dtd 27 Oct 2020 and the note is may be updated with more corrections. Please confirm the list for S/4HANA 2020 FPS0.
|2952519||Corrections for SAP S/4 HANA OP 2020 FPS00 Migration Cockpit – Direct Transfer||No|
|2947462||Data selection is running for a long time then terminates with the ‘timeout’ error||No|
|2955938||Selection runs much longer after reducing the number of background jobs
(requires note 2955315)
|2956333||Field ‘CLIENT’ will not be displayed technical selection dialog||No|
|2957720||Selection is aborted with error ‘Invalid workset position XXXX’||No|
|2958306||Selection of multiple objects are running simultaneously and the selection result is less than expected||No|
|2962023||Selection is running endless due to poorly performing access plan calculation||No|
|2966992||Rule in “inactive” state after import via transport request (cannot be implemented)||No|
|2971545||Generated embedded specification (ES) with retention period adjusted||No|
|2977545||Selection fails with error ‘Table XXX not found in mass transfer YYY’||No|
|2978236||Add a manual field to the worklist and assign a transformation rule with parameter structure of the root table||No|
|2978602||Selection does not work after deleting another object in migration object modeler
(requires SAP Note 2957720)
|2986938||Action ends with error “Predecessor tasks are not yet executed”||No|
|2989090||Migration object copy process stops with error “The given object name <object name> already exists”||No|
Read Note for FrontEnd server SAP Note 2967468 – Migrate Your Data Fiori App for SAP S/4HANA On-Premise Edition 2020 and as of now it does not have any corrections.
(B) Apply SAP Note 2596411 Note Analyzer – SLT / NZDT / S/4HANA Migration Cockpit (DMIS2011;DMIS2018;S/4HANA This note has manual step that was already implemented.
Run program using tCode SE38 DMC_NOTE_ANALYZER (1) Click on Update Central Note Number, (2) Select S/4HANA Migration Cockpit and (3) Execute
In the next screen check if any notes are to be applied. As per below, there are no notes required to be applied but may be required in future so its always good to check.
(C) Create a user for Data Migration. Logon to the client 100 and using tCode SU01 create user like for e.g. S4HXFER with role SAP_DMIS_OBT_MASTER and SAP_BR_CONFIG_EXPERT_DATA_MIG
In case you need to use the Migration Object Modeler, add role SAP_CA_DMC_MC_DEVELOPER
(D) Please review Collective FAQ note 2537549 for Migration Object KBAs to check if there are any object specific corrections and issues.
(E) In tCode STMS ensure transport landscape is created with defined transport domain, transport layer and transport route and then in tCode SE80 create a development Package as below: You have the option of defining the transport layer for the package. Alternatively you have the option to define transport package as $tmp which means you will use local transport – not move it to QAS or PRD system.
STEP 5: START DATA TRANSFER TO S/4HANA
Click on Create Project
After some time you find that Running Activities is down to zero and then the Select Data button is then available.
On the screen below you can view the migration object assigned to your project. The Migration Object is (1) CO-Activity type. If you click on CO-Activity type you can see the Technical Table Names which is CSLA(master) and CSLT (text).
You can see that Migration Status is (2) Migration Not Started. You can check status by looking at status of (3) Running Activities. You can see the actual status by clicking on (4) Monitoring and also you can click on (5) Job Management. In the Job management screen you can set the number of jobs for the project as shown or for individual object to increase/decrease by clicking +/-
(B) SELECT DATA: Click on (6) Select Data and then click Start Selection.
After the Running Activities changes to 1 and then after sometime it is down to zero and the Select Data button changes to Mapping Tasks as below.
You can (1) select the other 2 records and click on (2) ConfirmGo back and you will find that the Mapping Tasks status is changed from Open = 3 to Done = 3.
The status changes to be low. Here you find that simulation of 2 records is Successful and one is in Error. Let us find out and resolve this error. Click on 1 next to Errors.
And then click on error again. You will see the error below which states that “Cost element 0000610000 does not exist in controlling area A000“
Let us go back and click on 3 next to done under column Mapping tasks. Click on Value mapping for (1) Cost Element and change Target Cost element to (2) 0094303000. Click on (3) Confirm.
At this point we can go back and change the Migrate button to Simulate and confirm that the Error has bene resolved.
Congratulations ! Data Migration is Successfully completed !
TIP 1 – ADD OBJECTS TO PTROJECT: You can edit the project and add more objects if required
TIP 3 – DURATION OF MIGRATION: You can note the duration of migration process by recording the time taken above for Data Selection, Data Load. This way you can decide if you want to increase the number of background processes for the next run and check the overall reduction in time. It would be helpful to know the time required for each object and focus on performance optimization where it is needed.
TIP 4 – ERROR LOG EXPORT TO EXCEL: Sometimes you have hundreds or thousands of error messages of same type like for e.g. Cost element 0000610000 does not exist in controlling area A000. It is required to click on each error message to find out what is the text. To export the error text into Excel file, follow this procedure.
Login to SAPGUI client. Go to tCode SLG1 and enter user S4HINST and select Log Class as Only important logs. Click on Execute and display only error logs at the bottom.Export to Excel and you can then handle the list very easily.
TIP 5 – DOWNLOAD MAPPING VALUES: We mapped Cost Element 0000610000 to Cost Element 0094303000. How about saving all such values so that they can be used in later runs ? It is possible to click on Download to save all values to xml file and click on upload to upload the values.
Hope you have enjoyed the data migration for the the first few objects and can move others.
Thanks to the Data Migration development team for providing the notes, blogs and KBAs that were useful in putting everything together into this blog.
Login to BackEnd tCode SLG1 and filter for Transaction Code MWB
COMPONENTS FOR INCIDENTS:
Migration Cockpit – Direct Transfer – use component CA-LT-MC
Migration Cockpit – File/Staging – use component CA-GTF-MIG
The notes applied have to be moved across the landscape using transport. Users will have to be manually created in each system.
For a more detailed description of all tasks please refer to
DIRECT TRANSFER ONLY:
SAP Help Portal – Transferring Data Directly from an SAP System
SAP Note 2747566 – S/4HANA Migration Cockpit: Composite Note for Transfer Data Directly from SAP System
SAP Note 2946774 Transfer Data Directly from SAP System – Corrections in migration technology
SAP Note 2967468 Migrate Your Data Fiori App for SAP S/4HANA On-Premise Edition 2020
SAP Note 2780378 Composite SAP Note for SAP S/4HANA Migration Cockpit (all releases)
GENERAL MIGRATION COCKPIT:
Starter Blog for SAP S/4HANA Migration Cockpit
SAP S/4HANA 2020 Installation Guide <==7.1.1 SAP S/4HANA Migration Cockpit
Note 2596411 – Run Note Analyzer <==check if relevant notes are installed in S/4HANA
S/4HANA Migration Cockpit <==pdf with presentation
Migrate Data Using Files / Staging Tables <==pdf Step By Step Guide
Filling Staging Tables with data using SAP HANA Studio <==pdf Step by Step Guide
SAP S/4HANA Migration Object Modeler ,==pdf Step by Step Guide and Video
OpenSAPcourse ”Data Migration to S/4HANA” <==File Xfer, Staging w DS and MOM
STAGING TABLES ONLY:
Part 1: Migrating data using staging tables and methods for populating the staging tables
Part 2: Using SAP Data Services to load data to the staging tables
Part 3: Using SAP HANA Smart Data Integration (SDI) to load data to the staging tables
Part 4: Using SAP HANA Studio to load data to the staging tables
BUSINESS PROCESS EXPLORER:
BPX General: Rapid Data Migration Best practice in Best Practice Explorer
BPX Test Script: Data Migration to SAP S/4HANA from File (BH5) <=pdf
BPX Test Script: Data Migration to SAP S/4HANA from Staging (2Q2) <=pdf
Thank you. Hope you enjoyed the blog !
Product Expert – SAP S/4HANA Solutions
Brought to you by the SAP S/4HANA Regional Implementation Group