Getting started with the S/4Hana Migration Cockpit...

JK · ‎02-28-2017

Overview

The S/4HANA Migration Cockpit is available from S/4HANA Release 1610 in the OnPremise Version.

As it is the first Version, i don't have too much expectations, but i am sure we will see very interesting updates in the future.

Basically, it is a Web Based Tools to migrate Legacy Data into S/4HANA. It allows to Download predefined Excel Sheet-Templates, so you can "easily" extract legacy data into this format and upload in S/4HANA by using the Migration Cockpit. Basic Mapping Functionality is provided (e.g. Map Unit of Measure Codes and so on) but don’t expect too much here yet.

Target group seems to be smaller and medium businesses (SMB). The handling of the Import Process and Validations are made very easy ("cloud style")

To Import the Data, the SAP Standard BAPIs are used. There is an error Log provided with information on Warnings or Errors.

As there is already a number of Standard Objects Available (see below)

for the creation of additional Migration Objects see also my Blog

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

Update 28.9.2017: Added 1709 Standard Content Migration Object List

Update 13.3.2018: Working with Staging Tables see Blog https://blogs.sap.com/2018/03/13/working-with-staging-tables-in-s4hana-migration-cockpit-onpremise/

Update 27.9.2018: https://blogs.sap.com/2018/09/27/s4hana-1809-migration-cockpit-release-news-a-few-other-hints/

Update 12.02.2019: 02/2019: Updated Newsletter with best practices on S/4HANA Migration Cockpit

Transaction Codes

LTMC Migration Cockpit

LTMOM Migration Object Modeler

url for migration cockpit:

https://<server>:<port>/sap/bc/webdynpro/sap/dmc_wda?WDCONFIGURATIONID=DMC_WDA_APP&sap-client=<clien...

SAP Notes:

Check CA-GTF-MIG / SV-CLD-MIG for predefined content problem, check CA-LT-MC for tools problem.

use the expert search https://launchpad.support.sap.com/#/mynotes?tab=Search

Existing Documentation

Added 6.7.2017:

Overview Presentation: SAP S/4HANA Migration Cockpit

Interactive Click Demo:

https://cp.hana.ondemand.com/dps/d/preview/76a9ec56a9eb6138e10000000a44147b/1610%20001/en-US/ab24255...

SAP Help

https://help.sap.com/doc/PRODUCTION/bf1d5c82ea1c45ba8f1d7d1f7757f04d/1610%20001/en-US/frameset.htm?8...

https://help.sap.com/doc/PRODUCTION/bf1d5c82ea1c45ba8f1d7d1f7757f04d/1610%20001/en-US/frameset.htm?9...

Best Practice Explorer S/4Hana OnPremise, Data Management:

Data Migration to S/4HANA from File (BH5)

Data Migration to S/4HANA Enhancements (BH4)

https://support.sap.com/content/dam/SAAP/Sol_Pack/BP_OP_ENTPR_S4HANA1611_DEV3/BP_OP_ENTPR_S4HANA1611...

02/2019: Updated Newsletter with best practices on S/4HANA Migration Cockpit:

https://www.sap.com/documents/2019/02/80f57ddb-3a7d-0010-87a3-c30de2ffd8ff.html

Migration Objects

Update 30.1.2018: check out new note 2596400 - Which Migration Object is available in the Migration Cockpit currently https://launchpad.support.sap.com/#/notes/2596400

Business Object Name	Area	Business Object Type	Migration Cockpit Object Name	Technical Object Name
Activity Types	CO	Master data	Migration of Activity types (FILE2S4)	SIF_LSTAR_CREATE
Cost Center	CO	Master data	Migration of Cost centers (FILE2S4)	SIF_KOSTL_MASTER
Activity Price	CO	Master data	Migration of Activity prices (FILE2S4)	SIF_ACT_PRICE
Internal Order	CO	Transactional data	Migration of Activity prices (FILE2S4)	SIF_INTORDER
Profit Center	FI	Master data	Migration of Profit centers (FILE2S4)	SIF_PRCTR_MASTER
Bank Master Data	FI	Master data	Migration of Banks (FILE2S4)	SIF_BANK_MASTER
Customer Master	FI, SD	Master data	Migration of Customer (FILE2S4)	SIF_CUSTOMER
Vendor Master	FI, MM-PUR	Master data	Migration of Vendor (FILE2S4)	SIF_VENDOR
Customer Open Items	FI	Transactional data	Migration of Customer open items (FILE2S4)	SIF_AR_OPEN_ITEM
Vendor Open Items	FI	Transactional data	Migration of Vendor open items (FILE2S4)	SIF_AP_OPEN_ITEM
Fixed Asset incl. Balances	FI-AA	Master data + Transactional data	Migration of Fixed assets (FILE2S4)	SIF_FIXED_ASSET
G/L Account Balances	FI	Transactional data	Migration of G/L balances (FILE2S4)	SIF_GL_OPEN_ITEM
G/L Account Open Items	FI	Transactional data	Migration of G/L open items (FILE2S4)	SIF_GL_OPEN_ITEM
Exchange Rate	FI	Master data	Migration of Exchange rates (FILE2S4)	SIF_EXCH_RATE
Inventory Balances	MM-IM	Transactional data	Migration of Material inventory balances (FILE2S4)	SIF_INVENTORYBAL
Material Master	LO-MD	Master data	Migration of Materials (FILE2S4)	SIF_MATERIAL
Material Long texts	LO-MD	Master data	Migration of Material long texts (FILE2S4)	SIF_MAT_LONGTEXT
Material Consumptions	LO-MD	Master data	Migration of Consumptions (FILE2S4)	SIF_MAT_CONSUMP
Purchasing Info Record	MM-PUR	Master data	Migration of Purchasing info records (FILE2S4)	SIF_PURCH_INFREC
Purchase Order	MM-PUR	Transactional data	Migration of Purchase orders (only open) (FILE2S4)	SIF_PURCH_ORDER
Pricing Conditions	SD, CO, MM-PUR	Master data	Migration of Pricing conditions (FILE2S4) (Currently Cloud Only)	SIF_CONDITIONS
Contracts (Purchasing)	MM-PUR	Transactional data	Migration of Purchasing contracts (FILE2S4)	SIF_CONTRACTS
Source List	MM-PUR	Transactional data	Migration of Source lists (FILE2S4)	SIF_SOURCE_LIST
Sales Order	SD	Transactional data	Migration of sales orders (only open) (FILE2S4)	SIF_SALES_ORDER
Batches	QM, SD, PP-PI	Master data	Migration of Batches (FILE2S4)	SIF_BATCHES
Bill of Material (BOM)	PP	Master data	Migration of Bill of materials (FILE2S4)	SIF_BOM
Work Center	PP, QM	Master data	Migration of Work centers (FILE2S4)	SIF_WORK_CNTR
Equipment	PM	Master data	Migration of Equipment (FILE2S4)	SIF_EQUIPMENT
Equipment Task List	PM	Master data	Migration of Equipment task lists (FILE2S4)	SIF_EAM_TASKLIST
Functional Location	PM	Master data	Migration of Functional locations (FILE2S4)	SIF_FUNC_LOC
Characteristics	CA	Master data	Migration of Characteristics (FILE2S4)	SIF_CHARACT
Classes	CA	Master data	Migration of Classes (FILE2S4)	SIF_CLASS

Object List in 1709:

Business Object Name	Area	Business Object Type	Migration Cockpit Object Name	Technical Object Name
Activity Type	CO	Master data	Activity type	SIF_LSTAR_CREATE
Cost Center	CO	Master data	Cost center	SIF_KOSTL_MASTER
Activity Price	CO	Master data	Activity price	SIF_ACT_PRICE
Internal Order	CO	Transactional data	Internal order	SIF_INTORDER
Profit Center	FI	Master data	Activity price	SIF_PRCTR_MASTER
Bank Master Data	FI	Master data	Bank	SIF_BANK_MASTER
Customer	FI, SD	Master data	Customer	SIF_CUSTOMER
Customer	FI, SD	Master data	Customer – extend existing record by new organizational levels	SIF_CUST_EXTEND
Supplier	FI, MM-PUR	Master data	Supplier	SIF_VENDOR
Supplier	FI, MM-PUR	Master data	Supplier – extend existing record by new organizational levels	SIF_VEND_EXTEND
Accounts Receivable (Customer) Open Item	FI	Transactional data	Accounts receivable (Customer) open item	SIF_AR_OPEN_ITEM
Accounts Payable (Vendor) Open Item	FI	Transactional data	Accounts payable (Vendor) open item	SIF_AP_OPEN_ITEM
Fixed Asset	FI-AA	Master data + Transactional data	Fixed asset incl. balances	SIF_FIXED_ASSET
G/L Account Balance	FI	Transactional data	G/L balance	SIF_GL_BALANCES
G/L Account Open/Line Item	FI	Transactional data	G/L open/line item	SIF_GL_OPEN_ITEM
Exchange Rate	FI	Master data	Exchange rate	SIF_EXCH_RATE
Inventory Balance	MM-IM	Transactional data	Material inventory balance	SIF_INVENTORYBAL
Material Master	LO-MD	Master data	Material	SIF_MATERIAL
Material Master	LO-MD	Master data	Material long text	SIF_MAT_LONGTEXT
Material Master	LO-MD	Master data	Material consumption	SIF_MAT_CONSUMP
Material Master	CO	Master data	Exceptional case: Material Price Chng for global currencies	SIF_MATPRICE_CHG
Material Master	MD	Master data	Material – extend existing record by new organizational levels	SIF_MAT_EXTEND
Material Master	CA-CLF	Master data	Material classification	SIF_CLF_MAT
Material Master	QM	Master data	Material inspection type *	SIF_INSP_TYPE
Material Master	SLL-LEG	Master data	Material – Commodity code	SIF_MAT_COMMCODE
Purchasing Info Record	MM-PUR	Master data	Purchasing info record with conditions	SIF_PURCH_INF_V2
Purchasing Info Record	MM-PUR	Master data	Purchasing info record	SIF_PURCH_INFREC
Purchase Order	MM-PUR	Transactional data	Purchase order (only open PO)	SIF_PURCH_ORDER
Pricing Condition	SD, CO, MM-PUR	Master data	Pricing condition	SIF_CONDITIONS
Contracts (Purchasing)	MM-PUR	Transactional data	Purchasing contract	SIF_CONTRACTS
Scheduling Agreement	MM-PUR	Transactional data	Scheduling Agreement	SIF_SCHED_AGRMNT
Source List	MM-PUR	Transactional data	Source list	SIF_SOURCE_LIST
Sales Order	SD	Transactional data	Sales order (only open SO)	SIF_SALES_ORDER
Sales Contract	SD	Transactional data	Sales contract	SIF_SD_CONTRACT
Batch	QM, SD, PP-PI	Master data	Batch (if Batch is unique at material level)	SIF_BATCHES
Bill of Material (BOM)	PP	Master data	Bill of material	SIF_BOM
Work Center	PP, QM	Master data	Work center	SIF_WORK_CNTR
Routing	PP	Master data	Routing	SIF_ROUTING
Equipment	PM	Master data	Equipment	SIF_EQUIPMENT
Functional Location	PM	Master data	Functional location	SIF_FUNC_LOC
Maintenance Task List	PM	Master data	Equipment task list	SIF_EQUI_TL
Maintenance Task List	PM	Master data	Functional location task list	SIF_FLOC_TL
Maintenance Task List	PM	Master data	General task list	SIF_GENMT_TL
Maintenance Plan	PM	Master data	Maintenance plan	SIF_MAINT_PLAN_2
Characteristic	CA	Master data	Characteristic	SIF_CHARACT
Class	CA	Master data	Class	SIF_CLASS
Commercial Project Management (CPM)	CA-CPD	Master data	CPM project	SIF_PROJECT
Inspection method	QM	Master data	Inspection method	SIF_INSP_METHOD
Master inspection characteristic	QM	Master data	Master inspection characteristic	SIF_MSTR_CHAR
QM catalog code group/code	QM	Master data	QM catalog code group/code	SIF_QM_CATALOG
Inspection Plan	QM	Master data	Inspection plan	SIF_INSP_PLAN
QM selected set	QM	Master data	QM selected set	SIF_SELECTED_SET
QM selected set code	QM	Master data	QM selected set code	SIF_SELSET_CODE
TRM – Financial Transaction	FI-FSCM-TRM-TM	Transactional data	TRM – Foreign exchange spot/forward transaction – contract	SIF_TR_FX_TR
TRM – Financial Transaction	FI-FSCM-TRM-TM	Transactional data	TRM – Foreign exchange swap – contract	SIF_TR_FX_SWAP
TRM – Financial Transaction	FI-FSCM-TRM-TM	Transactional data	TRM – Interest rate instrument	SIF_TR_IR_INSTR
TRM – Financial Transaction	FI-FSCM-TRM-TM	Transactional data	TRM – Interest rate swap	SIF_TR_IRDE_SWAP

New 04/12/2017:

Nice: Sample Migration Templates (Excel Examples)

https://launchpad.support.sap.com/#/notes/2470789

(currently for S/4HANA Cloud only but still helpful)

FAQ Note on Migration Cockpit

https://launchpad.support.sap.com/#/notes/2537549

Migration Process

In the first Screen you can create or open a Migration Project.

then you can activate one or multiple migration objects

Now Open the Migration Object

you can look at the documentation of the migration object

you can Download an Excel Template.

Now fill the Excel with you data

and Upload into the Migration Cockpit

select and activate the File

now start Transfer (migrate to S/4 Hana):

First the Data is validated

when finished 100 %, click on close

now you can see the notifications (warnings/error messages):

Choose next to perform the Value Mappings (Convert Values)

if a value from the excel sheet is found for the first time, you have to confirm or add a value mapping:

enter a new Value (EV_xxx) and/or click on confirm

now click on next for the simulation and then next for the import (same procedure as validation)

all actions are performed in background (as a batch-job/SM37), but you can wait until process is finished 100 % and then immediately see the results or let it run in background and come back later.

Excel Format

The Excel Templates are in XML Format

it looks like this

<?xml version="1.0"?>

<?mso-application progid="Excel.Sheet"?>

<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:o="urn:schemas-microsoft-com:office:office"

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"

xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"

xmlns:html="http://www.w3.org/TR/REC-html40">

<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

<Title>MATERIAL</Title>

<Author>HHE</Author>

<LastAuthor>Heiko Herrmann</LastAuthor>

<Created>2017-01-03T00:00:00Z</Created>

<LastSaved>2017-02-08T14:11:35Z</LastSaved>

<Company>HHE</Company>

<Version>16.00</Version>

</DocumentProperties>

<CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">

<APPLICATION dt:dt="string">SLO</APPLICATION>

<OBJECT_NAME dt:dt="string">MATERIAL</OBJECT_NAME>

<VERSION dt:dt="string">S4CORE 101 - 06.01.2017</VERSION>

<SYSTEM dt:dt="string">EAD / 700</SYSTEM>

<LANGUAGE dt:dt="string">D</LANGUAGE>

</CustomDocumentProperties>

<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">

<AllowPNG/>

<Colors>

…

<Row ss:AutoFitHeight="0">

<Cell ss:StyleID="s79"><Data ss:Type="String">D1-100011-02</Data></Cell>

<Cell ss:StyleID="s79"><Data ss:Type="String">EN</Data></Cell>

<Cell ss:StyleID="s79"><Data ss:Type="String">ASF1400</Data></Cell>

<Cell ss:StyleID="s79"><Data ss:Type="String">E</Data></Cell>

<Cell ss:StyleID="s79"><Data ss:Type="String">9999</Data></Cell>

<Cell ss:Index="7" ss:StyleID="s79"><Data ss:Type="String">X</Data></Cell>

<Cell ss:Index="9" ss:StyleID="s79"><Data ss:Type="String">98</Data></Cell>

<Cell ss:Index="11"><Data ss:Type="String">01</Data></Cell>

<Cell ss:StyleID="s79"><Data ss:Type="String">PCE</Data></Cell>

<Cell ss:Index="14" ss:StyleID="s79"><Data ss:Type="String">10</Data></Cell>

you can find several documentations in the internet:

https://msdn.microsoft.com/en-us/library/aa140066(v=office.10).aspx

https://wiki.scn.sap.com/wiki/display/Snippets/XML+TAGS+simplifies+Excel+Download

i faced problems with 'SPACE' for empty columns, they should be <null> otherwise the ss:Index gets confused and the Values are linked to the wrong columns when importing into the migration cockpit, even if they are in correct order

Import Processing

It helps if you are familiar with the Standard BAPI Structures and SAP Input Data (for example how to create a material master)

Abap Skills are not required, but ABAP Debugging skills are useful for the Root Cause Analysis in cases where the Error Log isn't enough.

The BAPI used for the Data Inport can be found in Transaction LTMOM

you can also see how the input fields are mapped.

currently i was not able to change the standard mappings, i can only add customer fields.

you can set an external Breakpoint (external as the import is always performed by a batch job)

here you can also save the data (after mapping/conversion) as testdata for SE37 (right click on toolbox) if you need to do some troubleshooting

in some cases i added an 'implicit enhancement' at begin of function (ABAP Enhancement Concept) in the importing BAPI to change the conversion.

(quick and dirty?)

Generated ABAP Objects

The Migration Cockpit generates ABAP Function Modules for the Conversion and the Import.

These can be Debugged (or maybe even "enhanced"?)

if you come from LSMW or other ABAP Migration Tools you will find yourself familiar shortly.

Fugr /1LT/S4H500000000000003

INCLUDE /1LT/LS4H500000000000003U01.
"/1LT/S4HIL_500000000000003
INCLUDE /1LT/LS4H500000000000003U02.
"/1LT/S4HOLC_500000000000003
INCLUDE /1LT/LS4H500000000000003U03.
"/1LT/S4HOLO_500000000000003
INCLUDE /1LT/LS4H500000000000003U04.
"/1LT/S4HACS_500000000000003

FUNCTION /1LT/S4HIL_500000000000003.
*"--------------------------------------------------------------------
*"*"Lokale Schnittstelle:
*"  IMPORTING
*"     VALUE(IM_ALLOG) TYPE  DMC_ALLOG OPTIONAL
*"     VALUE(IM_DEBUG) TYPE  BOOLEAN OPTIONAL
*"     VALUE(IM_DEBUG_LEVEL) TYPE  CHAR1 OPTIONAL
*"     VALUE(IM_TEST_MODE) TYPE  BOOLEAN OPTIONAL
*"     VALUE(IM_ROLLBACK) TYPE  BOOLEAN OPTIONAL
*"     VALUE(IM_VALIDATE) TYPE  BOOLEAN OPTIONAL
*"  EXCEPTIONS
*"      INSERT_IT_ERROR
*"      LOG_ERROR
*"      STOPPED_BY_RULE
*"--------------------------------------------------------------------
* Project          : ZSIN_MIG_001
* Subproject       : ZSIN_MIG_001
* Migration Object : Z_MATERIAL_001
* Layer            : Conversion layer
* Generated        : 13.02.2017 07:53:07 by SENS_MM
*
* Generate time related processing   = X
* Generate interlinkage processing   = -
* Generate IMPORT FROM MEMORY        = -
* Generate EXPORT TO MEMORY          = -
* Generate LDU initialize            = X
* Generate Call next function module = -

...
*
*** <__UNIT_0001__> ************************************
*** Targetstructure           : HEADER
*** Primary relation source   : S_MARA
*** Primary relation type     : 1:1
*** Primary relation number   : 0001
********************************************************
* CONVERSION: call BEGIN OF LOOP routine
* CONVERSION: Primary relation read
" init receiver work area
CLEAR _WA_HEADER.
LOOP AT _IT_S_MARA
  INTO _WA_S_MARA
.
CLEAR _actual.
_actual-sstruct1 = 'S_MARA'.
_actual-sddicname = ''.
* CONVERSION: Init receiver work area
CLEAR _WA_HEADER .
CLEAR l_mapping_error.
* CONVERSION: Init SKIP_TRANSACTION
_FLG_SKIP_TNX_ = FALSE.
* CONVERSION: Increment transaction count
<TNX_COUNT> = <TNX_COUNT> + 1.
* CONVERSION: init SKIP_RECORD flag
_FLG_SKIP_REC_ = FALSE.

...

ENDIF.
* CONVERSION: call BEGIN OF RECORD routine
PERFORM _BEGIN_OF_RECORD_0001_.
* CONVERSION: call field processing routine
IF _FLG_SKIP_REC_ = FALSE.
PERFORM _CONVERT_0001_.
ENDIF.
* BWP: Increment record count
HEADER_NO = HEADER_NO + 1.

IF _FLG_SKIP_REC_ = FALSE.

...

FORM _CONVERT_0002_.
*--- RECEIVER: NOAPPLLOG
PERFORM _RULE_MOVE_OP
USING
_WA_VI0001_NOAPPLLOG-NOAPPLLOG
'X'.
ENDFORM.
FORM _CONVERT_0003_.
*--- RECEIVER: FUNCTION
PERFORM _RULE_MOVE_OP
USING
_WA_T01_HEADDATA-FUNCTION
'INS'.
*--- RECEIVER: IND_SECTOR
PERFORM _RULE_CVT_MBRSH_S
USING
_WA_T01_HEADDATA-IND_SECTOR
_WA_S_MARA-MBRSH.
*--- RECEIVER: MATL_TYPE
PERFORM _RULE_CVT_MTART_S
USING
_WA_T01_HEADDATA-MATL_TYPE
_WA_S_MARA-MTART.
*--- RECEIVER: BASIC_VIEW
PERFORM _RULE_SET_X_IF_NOT_INIT_S
USING
_WA_T01_HEADDATA-BASIC_VIEW
_WA_S_MARA_CUST-INDICATOR_K.
*--- RECEIVER: SALES_VIEW
PERFORM _RULE_SET_X_IF_NOT_INIT_S
USING
_WA_T01_HEADDATA-SALES_VIEW
_WA_S_MARA_CUST-INDICATOR_V.
*--- RECEIVER: PURCHASE_VIEW
PERFORM _RULE_SET_X_IF_NOT_INIT_S
USING
_WA_T01_HEADDATA-PURCHASE_VIEW
_WA_S_MARA_CUST-INDICATOR_E.
*--- RECEIVER: MRP_VIEW
PERFORM _RULE_SET_X_IF_NOT_INIT_S
USING
_WA_T01_HEADDATA-MRP_VIEW
_WA_S_MARA_CUST-INDICATOR_D.
*--- RECEIVER: FORECAST_VIEW
PERFORM _RULE_SET_X_IF_NOT_INIT_S
USING
_WA_T01_HEADDATA-FORECAST_VIEW
_WA_S_MARA_CUST-INDICATOR_P.
*--- RECEIVER: WORK_SCHED_VIEW
PERFORM _RULE_SET_X_IF_NOT_INIT_S
USING
_WA_T01_HEADDATA-WORK_SCHED_VIEW
_WA_S_MARA_CUST-INDICATOR_A.
*--- RECEIVER: PRT_VIEW
PERFORM _RULE_SET_X_IF_NOT_INIT_S

...

FUNCTION /1LT/S4HOLO_500000000000003.
*"--------------------------------------------------------------------
*"*"Lokale Schnittstelle:
*"  IMPORTING
*"     VALUE(IM_TEST_MODE) LIKE  EDITSTRUC-CHANGED OPTIONAL
*"     VALUE(IM_BEHAVIOUR) TYPE  NUM1 DEFAULT                    1
*"  EXPORTING
*"     VALUE(ET_MESSAGES) TYPE  DMC_FM_MESSAGES_T
*"  CHANGING
*"     VALUE(CT_PAYLOAD) TYPE  DMC_PAYLOAD_TAB
*"     VALUE(XT_RUN_STAT) TYPE  DMC_T_RUN_STAT OPTIONAL
*"  EXCEPTIONS
*"      COMMUNICATION_FAILURE
*"      SYSTEM_FAILURE
*"      NO_AUTHORIZATION
*"--------------------------------------------------------------------
* Project          : ZSIN_MIG_001
* Subproject       : ZSIN_MIG_001
* Migration Object : Z_MATERIAL_001
* Layer            : Outer layer out (Function Module)
* Generated        : 13.02.2017 07:53:34 by SENS_MM
*
Job-Controller Functions: (for Debugging purposes)

FORM    EXECUTE_LOAD SAPLDMC_DTL                 LDMC_DTLU25

METHOD             START_ACTIVITY              CL_DMC_WDA_MIG_JOBS===========CP                          CL_DMC_WDA_MIG_JOBS===========CM003

further Tips

Structure XXXX: Number of recipient records generated 0000000000 (or less than in input file)

reason:

the Migration Cockpit is storing all created objects in Table DMC_FM_RESTART, so if your object number, for example material number, is in this table, it will be skipped and not imported again.

you can delete the entry with transaction code se16

also if a job with the name /1LT/LOAD... is scheduled or already running, the import will not start

(but shows no error message)

verify with SE37

Check from ABAP Coding

START_DATA_LOAD (CL_DMC_WDA_MIG_CONTR) CHECK cl_dmc_act_rec=>get_active_and_scheduled_jobs( iv_ext_id = lv_ext_id
iv_activity_type = cl_dmc_act_rec=>...

for Material Views Check Note

2145027 - FAQ: Maintenance status in data transfer

Open Items

Export Data from R/3 Source System? in the online help there is a remark: In the ABAP-based SAP source system, you have installed the DMIS add-on. You can download the add-on from the SAP Software Download Center at http://support.sap.com/swdc using the following path: Installations and Upgrades A - Z Index L SAP LT Replication Server SAP LT Replication Server 2.0 .

how can i export the data for the Migration Cockpit?

Best-Practice how to fill the Excel/XML Files with legacy data

The Excel-Templates are very nice, Examples with Best-Practice Data would help understanding how to fill the values.

how to create Additional Mapping Rules like we know this from LSMW?

Create Additional Migration Objects

Create Contact Persons for Customers (i could assign them to the Customer, but i had to to a workaround to create the Contact Person's Business Partner Number)

Mass/Data, Performance, parallel Processing, memory consumption, limitations...

strangely i could not find any oss notes, nor any blogs, is nobody using the tool yet?

so maybe i will write another Blog...

patsu · ‎03-01-2017

Hi Jörg,

Thank you for sharing your knowledge. I´m also trying to figure out this tool, so it is nice to verify some of my own findings and also catch some of yours.

An issue I´m now facing is how to add a new "TAB" of data to an object. For example, If you look at the Customer Master Object you will see that none of the fields within "TAB" Customer Loading is pre mapped. To map the regular fields with in this TAB I see no problem with, but how do you map "CVI Run ID..."?

For other pre mapped TABs it look like this:

Any Idea how to perform the assignment?

Br Patrik

JK · ‎03-02-2017

hi Patrik

the node 'Customer Loading' also has no mapping to an Input structure, so you can't even assign fields to unloading Point etc, currently it looks like you can only Display the structure mapping and not Change it, i expect this will be a Feature for the future, we're currently patching to fps1 i will check if something changes there

i think at the Moment you will have to find a Workaround (modfiy generated mapping function or enhancement of the function RFC_CVI_EI_INBOUND_MAIN or separate program to load the Customer Loading

regards

Jörg

patsu · ‎03-06-2017

Thank you Jörg for your answer.

I suspected that, lets hope it´s included in the coming releases.

Br Patrik

Former Member · ‎03-07-2017

Hi Jörg,

Great post and thank you for sharing the information. Like Patrik, I am also trying to figure out this tool.

Were you able to find out if there is a standard available way to export the data for the migration cockpit so far ?

Best regards,

Sergiu

former_member371933 · ‎03-08-2017

Hi Jörg,

Thanks for your blog, it was most helpful. I noticed on the list of objects that you have Pricing Conditions (SIF_CONDITIONS). On our version of S/4HANA 1610 we don't have this one. Was this list from FPS1?

Thanks

James

JK · ‎03-09-2017

the list is from https://support.sap.com/content/dam/SAAP/Sol_Pack/Library/FactSheets/BH5_S4HANA1611_EN_XX.htm click on test-script

but i can't see the object conditions on FPS1 as well 😞 seems to be only in the docu or Cloud...

there are other improvements like taxes on the customer master in fps1 and also the field lenght of mapping-values was increased (there have been dumps in FPS0 when using la large number of objects)

JK · ‎03-09-2017

not yet, anyone?

S0008389499 · ‎03-16-2017

Hi Jörg,

Does migration cockpit also support Business Partner migration? I mean to migrate multiple BP views accordingly? Thank you.

JK · ‎03-19-2017

the customer and vendor object are creating Business Partners, i think you also can add additional roles. the used function module RFC_CVI_EI_INBOUND_MAIN can do all Kind of Business Partners, but the mapping for customer/vendor object seems kind of hardcoded (so far) and don't provide all fields available. we used enhancements in the function RFC_CVI_EI_INBOUND_MAIN to perform additional mappings, or you better create an individual abap Report or lsmw object if.

former_member182673 · ‎03-20-2017

Thx Jorg Knaus for this informative blog.

As you obviously pointed out this new tool is infancy and will get developed as further versions come out. Particularly the presence of excel templates was a good addition.

Now for customers who already use migration tools which takes care of all the mapping, validation and other migration requirements and load ready data is made available. Can LTMC be used only as an upload tool? Looks like it is possible.

Also in a typical migration project we have lot of data changes as well as loading of data in multiple steps. Are those supported in this tool?

ruta_londhe · ‎03-21-2017

Hello Jörg,

First of all, thanks a lot for such an informative article..!

Question - Could you please guide us through the steps to modify/enhance existing Migration Objects using LTMOM?

Client Requirement - In Functional Location migration object (Migration of Functional locations (FILE2S4)), we don't have 'Functional Location Description (IFLOTX-PLTXT)' field and client has requested to add this field in the Migration Object.

I have added this field in Source Structure, however, I am not able to modify Target Structure.

Request you to please let me know how should I proceed.

Thanking in advance,

Ruta

ruta_londhe · ‎03-21-2017

Hello Jörg,

First of all, thanks a lot for such an informative article..!

Question – Could you please guide us through the steps to modify/enhance existing Migration Objects using LTMOM?

Client Requirement – In Functional Location migration object (Migration of Functional locations (FILE2S4)), we don’t have ‘Functional Location Description (IFLOTX-PLTXT)’ field and client has requested to add this field in the Migration Object.

I have added this field in Source Structure, however, I am not able to modify Target Structure.

Request you to please let me know how should I proceed.

Thanking in advance,

Ruta

former_member106494 · ‎03-28-2017

Hello Jörg,

I am trying to load GL_Open_Item to S4H system. After finishing migration project, I get the following error for object Migration of G/L open items (FILE2S4):

Error while generating runtime objects for Z_GL_OPEN_ITEM_03I

Function group S4J910000000000058 could not be created

Can you please help me out?

Thanking in advance.

Chirag

Former Member · ‎03-29-2017

Hi Jorg

The blog is very informative. Thanks for this !

I can see an open item already regarding "Create Additional Migration Objects". I had couple of questions around this.

- Is it possible in current version or will it be possible in future version to configure and migrate your own object ?

- If not , then more information about which additional objects are being planned by SAP in next release and approximate timeline ?

Thanks

Best regards

Nilesh

former_member193437 · ‎03-30-2017

Hi Jorg,

Does it need additional license to use Migration Cockpit(on-premisse)?

Thanks

Fabio

JK · ‎03-30-2017

as far as i know this is part of the s4hana license

JK · ‎03-30-2017

hi chirag

what Release/FPS are you on?

i tried with 1610 FPS1 and i could generate it without error.

you can go to LTMOM, select your Migration Object, there you will find a generate button. press it and you should see the error message

JK · ‎03-30-2017

in the current Version i could not create own objects, but there already might be functions or Reports which are not shown yet on the webdynpro screen

i have no further info on planned functions, i will post an update if i find something

JK · ‎03-30-2017

what release/fps are you on? i haven't used functional Location object so far, but i see the field

S_FUN_LOCATION-KTX01 Description of technical object in 1610 FPS1 . In FPS1 you can also add mapping rules on field Level in LTMOM see screenshot:

but i still could not create new structure assignements in case no source structure is mapped.

Kirstin · ‎04-06-2017

Hello Nilesh,

it will be possible to create own migration objects with the upcoming 1610 FPS02.

Best regards

Kirstin

former_member324965 · ‎04-07-2017

Hi Jorg,

I am new to S/4 HANA, and I am trying to upload Customer Master details through Migration Cockpit, I have followed All the steps as described, and solved the Errors one by one at the end the progress says 100 % and no errors are there, but I could not see any records in the System being created ,when I am trying to Search with Cust names etc...and the Number of records are still same ( I mean the records are not created, )

could you please help me, where exactly the problem is, looking forward to your Reply

Thanks in Advance

Ashok Yekbote.

JK · ‎04-07-2017

please look at the protocol of the import (informations, not only Errors), maybe all your records have been skipped? (number of records transfered ok?)

you can verify Table DMC_FM_RESTART, so if your customer number ist in this table, it will not be imported again, you can delete the entries with transaction code se16

double check if a job with the name /1LT/LOAD… is scheduled or already running, in this case the import will not start (but shows no error message)

former_member324965 · ‎04-10-2017

Hi Jorg

Thanks for the reply , Can you elaborate the Solution.

Awaiting your reply

Thanks

Ashok Yekbote

PhemmyPayne · ‎04-24-2017

Hi jrg.knaus,

I would like to ask your advise, I would like to Update BP. I did an upload of Business Partners and Suppliers this worked fine.

However, I have a requirement to extend these suppliers to a different company code. From the Documentation of the FM (RFC_CVI_EI_INBOUND_MAIN) it was mentioned that the FM only supports insert only. Hence I would like to know how best to resolve this issue.

Thanks,

Femi.

former_member428844 · ‎04-26-2017

Hi Jorg,

I'm using for the first time the new cockpit, creating customers.

I'm facing two problems:

transaction LTMOM is not working since I have no activites available: I select my migration object and corresponding project but I can't see any activities

in the web migration tool, I managed to create the business partner with only general data, but if I try to upload a file with more than one sheet, e.g. company data or sales data, I get the error:

former_member428844 · ‎04-26-2017

Hi Jorg,

thank you for your clear explanation.

I'm using for the first time the kigration cockpit but I am facing two errors:

LTMOM transaction seems not to be working; I select the migration object and the project but no activities appear

2. I managed to create a new business partner from the web tool, but only in general data; if I try to upload a file with two sheets, e.g. general data and company data, it doesn't recognize the key field and give me the error:

In the sheets the key is the same customer number, so I cannot understand what is the problem.

Thank you for your kind answer.

JK · ‎05-01-2017

i always hat all the activities listed by Default in ltmom so i did not perform any specific Actions here. do you have all authorizations? maybe just try another object, and generate/activate it using ltmc then check again in ltmom. what FPS1 patchlevel are you on?

IN THE COMPANY DATA, DID YOU REPEAT/FILL THE KEY FIELDS (Customer Number? and Company Code)?

KUNNR	BUKRS
ETE;80;0;C;80;0	ETE;80;0;C;80;0
Key
Customer Number* Typ: Text Länge: 80	Company Code* Typ: Text Länge: 80
22334	1000

former_member428844 · ‎05-08-2017

Thank you, Jorg.

The only authorization roles I set in my user are:

SAP_CA_DMC_MC_DEVELOPER
SAP_CA_DMC_MC_USER

Do I need something more?

I tried with other object and I fill the correct data in the file, so I cannot really understand.

My pathc level is FPS01.

Thank you again.

JK · ‎05-16-2017

i think you have to prepare and upgrade you Migration object before you can select the activities

so just click on the advaned activity Tasks on the right side

FrankFinkbohner · ‎05-19-2017

Hello Ruta,

with 1610 OP FSP2 you should be able to do this via the transaction LTMOM.

regards,

Frank

FrankFinkbohner · ‎05-19-2017

Hi James,

The API used for conditions is only available in cloud, the migration object is therefore not available in on-premise. it seems that someone just forgot to remove the entry in the table.

To get a more valid list you can refer to the test script for Cloud 1705

https://support.sap.com/content/dam/SAAP/Sol_Pack/Library/FactSheets/BH5_S4CLD1705_EN_XX.htm

This document contains both the cloud and the OP objects that are delivered 2nd(!) table in chapter 3 end of page 10.

Best,

Frank

FrankFinkbohner · ‎05-19-2017

Hello Federica,

I hope you had a look at the latest test script before filling the templates.

https://support.sap.com/content/dam/SAAP/Sol_Pack/Library/FactSheets/BH5_S4CLD1705_EN_XX.htm

The error above is only thrown if the keys are different in both sheet The template is an XML file and not an Excel file and it is therefore very sensitive. In most of the cases the cell format of the cell value is different. This means they look the same but may be in the general sheet it is formatted as a number and it the company code it is formatted as text.

This normally happens if you copy & paste values into the sheet from another Excel including cell formatting or formulas. If you copy values into the template you must use the paste option "Value only". Otherwise the integration of the XML gets corrupted and this will exactly cause such errors.

The best is to download a new fresh template and then to copy only the values into this new sheet.

And also try to avoid copying empty lines into the sheet.

It could also be that you have addtional empty lines in your company code sheet. This you can check in the file staging of the LTMC if you "Open" the file and check if you can see empty lines.

Best,

Frank

Former Member · ‎05-23-2017

Hi jrg.knaus

I´m Trying to dowload the template of object migration but I have two problem.

1. Template excel don't download, I have done this for two days but the progress bar don’t change. always appears in 10%

2. I can't see the documentation of migration object.

I have followed the steps as you describe them, but I don't know which is problem.

Could you give me your opinion about this?

Thanking in advance,

Jonathan

former_member183783 · ‎05-24-2017

Hi,jrg.knaus:

I am excited to see this blog .

But when i execute LTMC ,i get some error as below. Seems some configuration is required. Can you give me some tips on the configuration ?

Appreciated it very much.

JK · ‎05-24-2017

the webdynpro is not active or sso is not active, you can activate these services in /NSICF (myssocntl and dmc_wda)

this are typical Basis Settings

the URL generated by LTMC is

https://<host>:<port>/sap/bc/webdynpro/sap/dmc_wda?WDCONFIGURATIONID=DMC_WDA_APP&sap-language=DE#

JK · ‎05-24-2017

can you try to log in in english maybe you find the documentation there.

if you click on download Excel template the browser should immediately download the template, theres no Progress bar here, maybe this is a browser or popup blocker Problem?

former_member341319 · ‎05-30-2017

Hi Jorg, Thank you for sharing the information. Could you please help me understand the sequence of loading the data objects for FICO.

S0008389499 · ‎06-05-2017

Hi federica.quaranta,

Have you solve the problem in LTMOM? Please share your solution. thanks a lot.

FrankFinkbohner · ‎06-13-2017

Hi Jörg,

The object for pricing conditions is not available for SAP S/4HANA on-premise it is only available for SAP S/4HANA Cloud. The API used to load Conditions is only made for cloud it cannot be used for on-premise. That's why the conditions object is not delivered for OP. The mistake in the table might come because it is accidentially listed in the test script which seems to be an error by the automatic generation of that script. Can you please remove it from the list?

Thx and Best,

Frank

former_member183783 · ‎06-14-2017

thanks very much for your information, Jorg..

I fix it by adding the linkage to my host file..

But i am a bit confused with the data migration on cloud VS on premise.

Here is an example in YOUTUBE for data migration on premise, and it seems it is in a client instead of a web tool,like LTMC.

https://www.youtube.com/watch?v=PEPDh4bwGLs

so it seems LTMC is more like a tool for data migration on cloud version.. as i checked anther video in YOUTUBE for cloud and it is almost the same as LTMC.

Can you help to clear my concerns?

JK · ‎06-14-2017

hello

the Video Shows another tool called Business objects data services, for which sap provides RDS Content for s/4hana. the Tools helps you to extract, transform and load (ETL).

in this Blog is about the Migration Cockpit/LTMC is another Tool/Option, which is available on Premise and in Cloud.

former_member428844 · ‎06-14-2017

Hello Frank,

finally I corrected the format and I could upload the record.

Thank you,

Federica

former_member428844 · ‎06-14-2017

Hi Yuan-te,

I have not solved my problem. We upgrade the system to version 1611 and something appears in LTMOM, but now I can see some rules, that I cannot understand, but I still don't see the available acitivities.

Former Member · ‎06-14-2017

I would like to suggest you GS Richcopy 360 that I have been using for the past one year. I am using it to solve my problems related to data migration. It provides me long path name support, its easy to use and lets me automate my file transfers. Give it a try!

former_member183783 · ‎06-15-2017

thanks,Jorg..

I finally got it..Now i know ETL is on database level and LTMC is on application level and have better validation for data quality.. 🙂

Former Member · ‎06-15-2017

We are using 1610 S/4 HANA for our greenfield implementation and We are planning to import/install FSP2 in couple of weeks. I am facing couple of issues in current system.I would really appreciate if you share some suggestion in order to solve it.

Issue 1: Material Master creation .

I tried to create 1 material (by population Basic data view and Material description tab ) using LTMC template and tried to load. Program has been hanging for five minutes in Validation data step.

I can see Job name “/1LT/CTRL_Z_MATERIAL_001” is active and still running in SM35.

Same issue had appended when I tried to load Material Master long text ..

I was able to load Vendor template successfully without any issue.

Could you please provide some guidance?

Issue 2: I have successfully loaded 1 Vendor into SAP (In Sandbox) but It took 3 minutes to load a Vendor. I am little concern about the performance. Can we use LTMC to load 20K customer /Vendor ? . Will there be any issue ? . Will this issue be resolved when We import /Install FSP2?

Help Needed: Could you provide me some guidance/steps on how to add additional fields to Source /Target structures in LTMOM. We need to add few fields in Customer/ Vendor template.

Former Member · ‎06-15-2017

I found an OSS note : to solve the Issue1. I have implemented OSS note.

2453318 - S/4HANA 1610 FPS01 – Long runtime of controller job /1LT/CTRL*

I am able to move to Simulation Import stage. When I tried to run one material (by population Basic data view and Material description tab ) in simulation mode. It ran successfully but it didn't show any log . Even I tried in "Excute Import" , It didn't show any log . I checked the table "DMC_FM_RESTART" entries .There is no entry related to material.

I have populated below fields in Material master template.

Tab:General Data:

Material Number
Language Key*
Material description*
Industry sector*
Material type*
Gross Weight
Net Weight
Unit of Weight
Volume
Volume Unit

Tab: Material Description

Material Number
Language Key
Material description*

Any suggestion on this issue.

Former Member · ‎06-19-2017

Hi Guru's

We are using 1611 S/4 Hana. The issue:

In second step "Convert values" , where LTMC shows some feasible values(after clicking on mapping shown above fig) with field names EV_DWERKS, etc. Even though I delete some lines as there are not valid one, they are not deleting. Showing again if we revalidate. For which I can't create the material. And where does these values are took from?

Note: I am trying to create to material.

Thank you for your response.

And thank you jrg.knaus for posting such good note.

JK · ‎06-19-2017

typically, MATKL(Material Group) and MEINS(Base Unit of Measure) are obligatory, try to create Material manually with SAPGUI to find out all necessary fields. make sure the weight Unit is available in the system (you can leave volume and weight for a first test, then add later if it works)

Former Member · ‎06-19-2017

Helo jrg.knaus, first of all thank you for sharing this information is really usefull.

I´m trying to create vendors using migration cockpit on a S4/HANA 1610 environment,

this is the list of steps I making:

1.- Dowload the excel template for vendors object.

2.- Populate the tabs: GENERAL DATA, COMPANY DATA, PURCH. ORG DATA,

3.- Ulpload the file.

4.- Activate the file

5.- Start transfer

6.- Making the mapping of fields to have all them in green.

the problem I´m facing is every time I tried, the tool cycles and create a file called VENDOR_DELTA_0000#.XML and not create any record after I pass for the 4 steps.

The File I´m trying to process contains only one record but every time I process it I only get a new VENDOR_DELTA_0000 (#+1) Created, is like the tool is on an infinitive loop.