Skip to Content
Author's profile photo Jörg Knaus

S/4HANA 1809 Migration Cockpit Release News & a few other Hints

Updated 16.11.2018

Hi all

today i had a chance to look at the new version in S/4HANA 1809, so i want to share this updates with you. if you are completely new to the topic of migration cockpit, please also check the links at the end of this document, as the focus of this blog is on the deltas.

what is the motivation to use migration cockpit?

  • Migrate data from Non-SAP Systems to SAP S/4HANA
  • Migrate data from SAP Systems to SAP S/4HANA
  • Greenfield or Migration from R/3, Rollouts by country or business unit
  • Generate Testdata/SampleData
  • Provide a comprehensive migration solution with no programming required by the customer
  • Map data structures between source and target systems
  • Easily integrate custom objects
  • Reduce test effort
  • Make the migration solution auditable

 

New Features in 1809 FPS0 Migration Cockpit:

New Button in step „convert values“ SKIP SIMULATE IMPORT

so you can imediately starting the Import for a faster process

 

New Button in step „execute import“ BACK TO CONVERT VALUES

(less clicks)

 

New Features in 1809 FPS0 Migration Object Modeler

Now it is possible to Simulate Import/Test the Function Module

New function for Mass Rule Proposal

 

 

Migration Cockpit Standard Content

(with Migration Object Modeler, you can add you own Objects)

 

Migration Cockpit Object Name Business Object Name Area Business Object Type
Activity price (restricted) Activity Price CO Master data
Activity type Activity Type CO-OM-CCA-MD Master data
Bank Bank Master Data FI Master data
Bank account balance Bank Account FIN-FSCM-FQM Transactional data
Batch (if Batch is unique at material level) Batch LO-BM Master data
Batch (if Batch level is at plant level) Batch LO-BM Master data
Cash memo record Bank Account FIN-FSCM-FQM Transactional data
Characteristic Classification Characteristic CA-CL Master data
Class Classification Class CA-CL Master data
Condition contract Condition Contract LO-GT-CHB Master data
Consent Consent Record CA Transactional data
Cost center Cost Center CO Master data
Customer Customer LO-MD-BP-CM Master data
Customer (deprecated) Customer LO-MD-BP-CM Master data
Customer – extend existing record by new org levels Customer LO-MD Master data
Customer -extend exist record by new org levels (deprecated) Customer LO-MD Master data
Customer material Customer Material SD Master data
Equipment Equipment PM Master data
Equipment task list Maintenance Task List PM Master data
Exchange rate Exchange Rate BC-SRV-BSF-CUR Master data
FI – Accounts payable open item Accounting Document FI Transactional data
FI – Accounts receivable open item Accounting Document FI Transactional data
FI – G/L account balance and open/line item Accounting Document FI Transactional data
Fixed asset (incl. balances and transactions) Fixed Asset FI Master data + Transactional data
Functional location Functional Location PM Master data
Functional location task list Maintenance Task List PM Master data
G/L account General Ledger Account FI-GL-IS Master data
General task list Maintenance Task List PM Master data
Inspection method Inspection Method QM-PT-BD Master data
Inspection plan Inspection Plan QM-PT-IP Master data
Internal order (restricted) Internal Order FI-GL-IS Transactional data
Legal transaction Legal Transaction LCM-LT Transactional data
Maintenance item Maintenance Item PM Master data
Maintenance plan Maintenance Plan PM Master data
Master inspection characteristic Inspection Specification QM-PT-BD Master data
Material Material LO-MD-MM Master data
Material BOM Bill of Material LO-MD-BOM Master data
Material classification Classification Valuation/Product CA-CL Master data
Material consumption Product LO-MD Master data
Material – extend existing record by new org levels Product LO-MD Master data
Material inspection setting Product QM Master data
Material inventory balance Material Stock MM-IM Transactional data
Material long text Product LO-MD Master data
Material trade classification Product MM-IM Master data
Pricing condition (general) Price Condition SD-MD-CM, CO, MM-PUR Master data
Pricing condition (purchasing) Price Condition MM Master data
Pricing condition (sales) Price Condition SD Master data
Production version Production Version PP Master data
Profit center Profit Center FI, CO Master data
Purchase order (only open PO) Purchase Order MM-PUR Transactional data
Purchase scheduling agreement Purchase Scheduling Agreement MM-PUR Transactional data
Purchasing contract Purchase Contract MM-PUR Transactional data
Purchasing info record- extend existing record Purchasing Info Record MM-PUR-VM Master data
Purchasing info record with conditions Purchasing Info Record MM-PUR Master data
QM/PM catalog code group/code Inspection Code Group QM-PT-BD Master data
QM selected set Inspection Selected Set QM-PT-BD Master data
QM selected set code Inspection Selected Set QM-PT-BD Master data
Routing Routing PP-BD-RTG Master data
Sales contract Sales Contract SD Transactional data
Sales order (only open SO) Sales Order SD Transactional data
Software/Hardware constraint Software Constraint PLM-ESD-ESC Master data
Source list Source List MM-PUR Master data
Supplier Supplier LO-MD-BP-VM Master data
Supplier (deprecated) Supplier LO-MD-BP-VM Master data
Supplier – extend existing record by new org levels Supplier LO-MD Master data
Supplier- extend exist record by new org levels (deprecated) Supplier LO-MD Master data
VC – Variant configuration profile Variant Configuration Profile LO-VC Master data
Work center Work Center PP-BD-WKC, QM Master data
Xceptional case – Material price chng for global currencies Product CO-PC-ACT Master data

this list comes from:

https://rapid.sap.com/bp/#/browse/scopeitemversions/BH5/S4HANA/1809/XX

Login with s-user and click on test script:

 

 

Obsolete function module for Business Partner Migration

2506041 – S4TWL – API RFC_CVI_EI_INBOUND_MAIN is not supported from the release S/4 HANA OP 1709 FPS2 and in Cloud Edition 1805 onwards

(Use new Migration Object with new API, the old migration object is still available but ‘deprecated’)

 

 

Planned for 1809 FPS1:

New Fiori Application (not a webdynpro any more!) to extract Data directly from R/3 and transfer by RFC and Migration Cockpit into S/4HANA

there is a Filter Condition (Like Company Code), it should be possible to adapt the criteria for the Data Selection.

New Features from older Releases:

1709 FPS2:

New Report DMC_MC_SIMULATE_IMPORT_FILE

with this report you can upload Migration-Files (or staging tables) directly from sapgui without using the browser (faster process for simulations/tests iterations)

also check:

Note 6301833 Run an import simulation for a file migration object

Note 2665339 S/4HANA 1709 FPS01 / FPS02 – Migration – Run an import simulation for a staging migration object

 

There are new functions for Debugging and create Test-Data in the Simulate Import Report.

 

Large Files:

Upload Large Files: From 1709 FPS2 its also possible to upload ZIP Files

with Parameter icm/HTTP/max_request_size_KB you can increase the Size Limit to 160MB, this is also the maximum size Limit for the ZIP File.

 

Staging Tables

It is now possible to use Staging Tables instead of Files as input source for migration cockpit:

so the source-staging-tables are on a different database/schema and can be filled by any tool (abap/sql/etc)

also check this blog:

https://blogs.sap.com/2018/03/13/working-with-staging-tables-in-s4hana-migration-cockpit-onpremise/

be sure you also check the note mentionned in blog as some restrictions are with staging tables compared to file.

it is now also possible to use more than one data Transfer Job in parallel when working with staging tables.

 

 

Mandatory Fields

if you want to change fields to be optional, you can do this in /NLTMOM by changing the view:

Goto Detail View / change from ‚Expected‘ to ‚enabled‘

like this you can avoid error message on uploading the files.

(of Course if the function or Customizing requires this field it will produce an error message)

 

SAP Notes:

Use Report DMC_NOTE_ANALYZER to list all Migration cockpit related notes which have not been implemented.

 

 

Further Documentation

https://blogs.sap.com/2017/02/28/getting-started-with-the-s4hana-migration-cockpit-onpremise/

https://blogs.sap.com/2017/06/20/discover-the-s4hana-migration-cockpit-migration-object-modeler-onpremise-nltmom/

Assigned Tags

      14 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Atul Saxena
      Atul Saxena

      Thanks for sharing this Jorg

      I am working in 1610 little behind and have a requirement to keep the same BP for Vendor/Customer during data migration, We are using the standard DMC with some extra fields. Can you please share your comments or guidance for the same. Thanks.

      Regards,

      Atul Saxena

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author

      there will be a new solution for 1809 (knowledge base article/new api)

       

      for 1709em you can something like this:

      load customers

      then load vendors with the link to the customer

      do enhancement of the api (or solve same in mapping)

       

      function rfc_cvi_ei_inbound_main.
      """""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""$"$:(1) Funktionsbaustein RFC_CVI_EI_INBOUND_MAIN, Anfang                                                                                                 A
      *$*$-Start: (1)---------------------------------------------------------------------------------$*$*
      ENHANCEMENT 1  Z_RFC_CVI_EI_INBOUND_MAIN_MIG.    "active version
      if not it_sup_general[] is initial.
      data: ls_sup_general like line of it_sup_general.
      field-symbols: <ls_bp_general> type  CVIS_BP_GENERAL.
      clear ls_sup_general.
      read table it_sup_general into ls_sup_general index 1.

      if not ls_SUP_GENERAL-KUNNR is initial.
      loop at it_bp_general assigning <ls_bp_general>.
      <ls_bp_GENERAL>-BPARTNER = ls_SUP_GENERAL-KUNNR .
      clear  <ls_BP_GENERAL>-BPARTNERGUID.
      <ls_bp_general>-object_task = 'U'.
      exit.
      endloop.

      endif.

       

      if the address is not the same for customer and vendor, the vendor will overwite the values

      endif.
      ENDENHANCEMENT.

      Author's profile photo atul saxena
      atul saxena

      Thanks Jorg !! Appreciate it

      Author's profile photo Pawan Kalyan K
      Pawan Kalyan K

      Hello Jörg Knaus,

       

      Thanks a lot for explaining these ..!!! In 1809, When I am using the app "Migrate your Data" , and option --> Migrate Data Directly from SAP System ,

       

      I am not getting anything in the Combo Box/Drop Down - Connection to Source System and It is a mandatory field as well.  Please let me know where I should add this information to see list of Source Systems

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author

      The feature of direct read is in beta Phase and not public available yet. ( i think it will be in 1909)

      Author's profile photo Peter Murphy
      Peter Murphy

      Hi Jorg, thanks for the blog.

       

      At the moment in general there seems to be 2 main recommended options for data migration to S/4 – the Migration Cockpit and SAP Data Services. Data Services has the advantage of the extract functionality.

      In terms of recommended Best Practices roadmap for future Data Migrations, does the addition of the direct extract feature from SAP source systems (potentially in 1909) indicate a phasing out of the use of SAP Data Services – at least with respect to SAP Source -> S/4 data migrations?

      Thanks

      Peter

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author

      i can't speak for sap product management

      my opinion: the tool depends on the use case

      a) migration of master data and open items / small volume:

      migrate from one r3 to one s4 withouth much data harmonization i like migration cockpit and direct read

      if you have one small legacy system you can use migration cockpit and excel or staging tables

      if you have multiple sources, maybe also non-sap sources, and lots of data cleansing etc, maybe you look at data services

       

      b)

      for the migration of large data volumes and document data (even historic documents) we use slo tools like snp

       

       

       

      Author's profile photo Peter Murphy
      Peter Murphy

      Thanks for the quick response Jorg. I'm not familiar with snp. Are you referring to http://www.snpgroup.com/ ?

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author

      Yes

      Author's profile photo Claudia Jost
      Claudia Jost

      Hi Jörg,

      thanks for the explanation. We are now preparing the migration from a ECC system. We made several tests with  the migration cockpit and it´s working well. The only handicap is, that we need a lot of time to harmonize the data from the ECC system, that it fits to the S/4 template structure. Do you have any hint, or experience from other projects to reduce these efforts?

       

      Thanks for you support

      Claudia

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author

      If you create customizing only client and convert this to s4, you wouldn't have much efforts for value mappings

      Or what is meant by harmonize (like duplicates?)

       

      Author's profile photo Claudia Jost
      Claudia Jost

      Hi Jörg,

      our problem is that the order of the fields you download from an LFA1 is different from the order in the XML template. So we tried several ways of harmonizing these tables, but it´s still a lot of manual work. When you think about more than 200 fields in the material master data.

      Thanks Claudia

      Author's profile photo Kritesh Shah
      Kritesh Shah

      Hello Jorg,

       

      Do you know if we can migrate multiple suppliers under 1 BP using migration cockpit. I have internal number range for both BP and suppliers.

       

      Thanks in advance for your response.

      Kritesh

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author

      the feature with 1:n is new with 1809 in sap standard, in sapgui it is not possible only in fiori, before it was only 1 Vendor for one BP.

      not sure if this works already in migration cockpit, you have to test it, but use the newest migration cockpit object for vendor not the obsolete version with the old bapi

      for internal number you will have the problem to identify which vendors should go to the same vendor...