Technical Articles
Getting started with the S/4Hana Migration Cockpit (OnPremise)
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
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:
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:
SAP Help
Best Practice Explorer S/4Hana OnPremise, Data Management:
Data Migration to S/4HANA from File (BH5)
Data Migration to S/4HANA Enhancements (BH4)
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…
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
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
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
Hello Ruta,
with 1610 OP FSP2 you should be able to do this via the transaction LTMOM.
regards,
Frank
Thank you Jörg for your answer.
I suspected that, lets hope it´s included in the coming releases.
Br Patrik
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
not yet, anyone?
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
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)
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
Hi Jörg,
Does migration cockpit also support Business Partner migration? I mean to migrate multiple BP views accordingly? Thank you.
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.
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?
Ramesh
Data mapping is quite good. (Rules based for the whole project). It would be nice to see a validations option as we used to manually program in LSMW though. However, lets see what FSP01 & 2 bring.
Derrick
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
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.
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):
Can you please help me out?
Thanking in advance.
Chirag
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
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
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
Hello Nilesh,
it will be possible to create own migration objects with the upcoming 1610 FPS02.
Best regards
Kirstin
Hi Jorg,
Does it need additional license to use Migration Cockpit(on-premisse)?
Thanks
Fabio
as far as i know this is part of the s4hana license
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.
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)
Hi Jorg
Thanks for the reply , Can you elaborate the Solution.
Awaiting your reply
Thanks
Ashok Yekbote
Hi Jörg,
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.
Hi Jorg,
I'm using for the first time the new cockpit, creating customers.
I'm facing two problems:
Hi Jorg,
thank you for your clear explanation.
I'm using for the first time the kigration cockpit but I am facing two errors:
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.
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)?
Typ: Text
Länge: 80
Typ: Text
Länge: 80
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
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
Hello Frank,
finally I corrected the format and I could upload the record.
Thank you,
Federica
Hi Federica,
Have you solve the problem in LTMOM? Please share your solution. thanks a lot.
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.
SAP solved this problem with note 2511974 and 2503250
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.
Hi Jörg
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
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?
Hi,Jörg:
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.
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#
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?
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.
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.. 🙂
Hi Jorg, Thank you for sharing the information. Could you please help me understand the sequence of loading the data objects for FICO.
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
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!
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.
I found an OSS note : to solve the Issue1. I have implemented OSS note.
Language Key*
Material description*
Industry sector*
Material type*
Gross Weight
Net Weight
Unit of Weight
Volume
Volume Unit
Language Key
Material description*
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)
Hi,
you should also check if you have implemented the following SAP Notes:
2428432 – Missing error messages in the return structure.
Some errors were not returned into the return strcuture of the BAPI_MATERIAL_SAVEREPLICA. Those errors are therefore not caught by the LTMC and cause exactly the errors you explained. No log. No FMRESTART entry. As Jörg already said the missing MATKL and missing UOM is probably causing these errors. Implement the SAP Note and try it again.
And you should always enter a correct maintenance status in field “Material Views” that will be defined on the sheet “Settings maintenance status”. If you don’t fill a maintenance status, the system will detect it automatically. The problem with the automatic determination is that it will probably determine additional views where you don’t have provided any value for their mandatory fields. To prevent this fill the field “Material Views”.
for example:
Tab “Settings maintenance status”
Material views = BASIC
Basic data = X
Tab “General Data”
Material views = BASIC
the maintenance status is then set by the BAPI to “K”.
Best,
Frank
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 Jörg for posting such good note.
Helo Jörg, 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.
hi, i've never seen the Delta files, vendor works normal on my System. i expect there is a Problem with the Input Excel/XML, maybe try to create a complete new one with an absolute Minimum of data and try again?
or, if you looking at the Delta.xml can you see something that explains the Delta?
Hi
a delta file normally only contains the delta of records that could not be uploaded because of errors.
Regards,
Frank
Hi Frank,
Just a quick query, Do you know how to download the Delta File?, I need to send the error to the business in order to fix it.
Thanks s in advance.
Hi Diego,
just mark the delta file row and choose "Download" button.
Best,
Frank
Yes, but sometimes I can download the XML but most of the times only an empty html file is generated,
Hello Diego,
there is dome browser dependent behaviour using the Web-Dynpro of the cockpit.
For example, if you use Firefox, Chrome or Edge the templates and the delta files are stored without extension XML. Then you have to add the extension in a file explorer. With Internet Explorer it is stored with the correct XML extension. Have you tried to use a different browser? If the issue still appears it might be good to open a ticket on component CA-LT-MC.
Best,
Frank
i just added another blog
https://blogs.sap.com/2017/06/20/discover-the-s4hana-migration-cockpit-migration-object-modeler-onpremise-nltmom/
Hello Jörg you´re right I had an error on the File, I was able to process the 4 steps and the object shows a 100% progress but the record was not created.... I received now an error telling me the following:
Test migration Z_VENDOR_001: no extended validations, no updates in receiver system
Message no. DMC_RT_MSG042
And for that reason I was not able to see the record created on transaction BP. What I note is the vendor object has a yellow triangle, as well as the migration project, not sure where I need to activate this. Or if I need to check something on the BAPI to not run on test mode.
CVI Interface Needs to be set up, especially the Account Group of the Vendors Needs to be mapped to a Business Partner Group.
if you set an external breakpoint in function module RFC_CVI_EI_INBOUND_MAIN, it should stop during Simulation and Transformation and you can verify the TESTFLAGS
sometimes the records are ignored as there is already an entry in DMC_FM_RESTART, so delete here or give another vendor number in the excel
Hello Jörg,
Thank you for sharing your knowledge.
When I try to execute transaction LTMC, I get an error on the webpage - "The page cannot be displayed". Is there any prerequisite to run the transaction?
Thanks,
Rahul Sinha
LTMC is called from browser
see also comments from other users above, services Needs to be active in /NSICF and Full-Qualified Hostname Needs to be available for your browser (DNS Entry)
if you can reach fiori or other Webpages from your s4hana System, this should be given
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#
Hi,
Even the services are activated, we are getting 500 internal server error.
Thanks,
Mohan
Hello Jörg, I was able to create the vendor, thks a lot, now I´m trying to create Material Masters but I´m facing a problem with field VALUATION TYPE (BWTAR) is mandatory on tab Valuation Data and I don´t need split valuation so which Character I need to use in the Field to indicate Blank. I tried " " but it didn´t work. Any Idea?
it should be possible to leave BWTAR empty
Hello Jörg,
we observed the table “DMC_FM_RESTART” growing anything with millions of entries, could you help what would be the reasons and possible solution to stop.
I see below report us available is system DMC_FM_RESTART_COPY_DELETE", do we need to schedule it to delete old entries.
Thanks
Sree
DMC_FM_RESTART should only have all keys of migrated objects (example if migrated 20000 material masters, you get 20000 entries), when the migration is finished, you can delete the table but you don't need to reorganize it during the migration project.
can you see with se16n where the must entries come from (which migration objects/keys)?
Hello Jorg:
We are doing greenfield implementation of S/4 HANA. Can you please guide us how to use LTMC Migration cockpit for uploading customer master from legacy system to S/4. In my case, Legacy system is a 3rd party system and not ECC.
What we have done so far:
Our Functional guys have done some mandatory configuration to set up the system. we are only implementing inventory solution in first phase of our project with SD as back-end integration.
I logged into S/4 Sandbox system and launched LTMC T-code to do Customer migration.
we used standard template provided by SAP . On LTMC cockpit, SAP says, for customer Master , Bank information is prerequisite and also on documentation it says Dunning area is required . This is Finance part which functional guys believe should not be mandatory to create a BP Customer as we can create a BP- Customer manually without any Bank or Dunning area configuration.
also,using LSMW , we can create BP Customer without Bank / Dunning area configuration.
As you see screen shot below, every time we try, we get "finished" status but when we go to KNA1 or BUT000 we dont see any customer created.
Please note. we have NOT done any configuration in /NLTMOM. we are using standard template out of the box. This is how our LTMOM looks for "Migration of Customers (FILE2S4)" . I am not aware whether any configuration is required in LTMOM before doing going in LTMC
i checked table DMC_FM_RESTART, but we don't see any entry of customer we are planning to create.
Definitely, we have not given all mandatory information but then LTMC Should give us error also, hwo do we debugg this process. i placed an external break-point in Funtion RFC_CVI_EI_INBOUND_MAIN but it didn;t stop while processing.
General Data Tab
General Tex tab
Sales Data
Kept Sales Partner tab as Blank
Sales Org text - Tab
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: unrestricted
Company Code Tab
Type: Text
Length: 80
Type: Text
Length: 80
Dunning Area - tab
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 2
Company Text - Tab
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: unrestricted
Bank Data - Tab ---- we gave some arbitrary numbers
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 15
Type: Text
Length: 18
Type: Text
Length: 34
industry tab
Type: Text
Length: 80
Type: Text
Length: 80
Tax Classification
Type: Text
Length: 80
Type: Text
Length: 80
Type: Text
Length: 80
Hello Mayank,
mandatory fields are only mandatory on Tab/structures that are marked "mandatory" or on sheets where you provide records for.
This is a common mistake done by most of the on-premise users. The BH5 test script for the cloud solution is a bit more detailed and contains some more tips and notes about the Migration template usage.
I guess you have 1610 FPS01 or less. Starting FPS02 mandatory structures are marked yellow/orange in the template. But you can also check the "Field List" in the template.
"General Data" is the only sheet marked as "(mandatory)".
If you only want to provide data for "General data" General Text" and "Sales Data", just leave the other sheets empty and only provide data records for the sheets you need.
There you then have to care for the mandatory fields.
Hope this helps...
regards,
Frank
I am using LTMC to upload Material Master data and run into an error on Step 3 Simulate Import:
The applied combination of translation values has status AUTO
Message no. DMC_RT_MSG091
Does anyone know how to correct this error to complete the Import?
please check https://blogs.sap.com/2017/07/05/starter-blog-for-sap-s4hana-migration-cockpit/comment-page-1/#comment-382170
Hi all,
Been having some issues using hana migration cockpit and don't seem to be able to do much via LTMOM, found the transaction MWB which allows me to do a bit more. Would suggest checking that out.
regards,
Sow
Hi Jorg,
We are facing issue while Uploading Migration of Characteristics (FILE2S4) file with values as attached for S4HANA ON PREMISE 1610 02 (05/2017) FP.
at Step 1 : Validate Data :
Giving error for validation of new creation of Characteristic is not exist in system table CABN (field ATNAM) (Which does not exist in system).
Error : Parameter Target Value: LEAD_CABLE_10 is not a valid value of table CABN (field ATNAM)
Name: Mapping of Characteristic Name
ID: MAP_ATNAM
Please help us in understanding Characteristics template as we have less information in documentation.
Regards,
Adarsha Yellenki
Great Job! Thank you so much Jörg
On the question of downloading the data from legacy system into the templates offered by LTMC, do we need to build ABAP programs in the source ECC system? Are there any utilities available to similarly generate downloads in the source system?
Also, excel based download and upload will mean these are for small volumes only (typically for master data) - Any suggestions on the approach for large transnational data sets have to be moved?
Thanks
Sudarshan
Hi Jorg,
We have an issue with 'Migration of Fixed assets (FILE2S4)', not able to upload file.
Below is the error in Validation step:
file details as follows :
Could you please suggest us on this.
Regards,
Adarsha Yellenki
Hi All,
Anyone who had experience with Fixed Assets object, Please guide me on above issue.
help would be much appreciated.
Regards,
Adarsha Yellenki
Hi Jörg
I have got the same problem like Chirag Gupta
But I’m trying to load Material Records.
Version:
Could you please help us?
Could you provide example of filled template for material record?
Best regards.
please also check oss
Check CA-GTF-MIG / SV-CLD-MIG for predefined content problem, check CA-LT-MC for tools problem.
example
Jörg,
Thank you!!!
Resolved this problem in 2 steps:
But i don’t see any created object.
Problem described above Former Member:
Tool says me that is 100% done.
I deleted record in DMC_FM_RESTART and checked it after. No result…
Best regards.
see frank's answer above for MATERIAL: https://blogs.sap.com/2017/02/28/getting-started-with-the-s4hana-migration-cockpit-onpremise/comment-page-1/#comment-379482
Hi!
All is fine
Thank you.
BR.
Hi Jorg,
Could you please help us with Material Master LO-MD Master data Migration of Materials (FILE2S4) SIF_MATERIAL object using LTMC.
Issue:
When uploading Material with multiple PLANT Data and SALES Data, we are missing BASIC Data 1 and BASIC Data 2 view details after creation of Material with LTMC.
Whereas when we are loading with single PLANT and SALES data there is no issue, Basic data1 and data2 are getting created properly.
Could you please help us to solve the issue.
Regards,
Adarsha Yellenki
see frank's answer above regarding maintenance-views:
https://blogs.sap.com/2017/02/28/getting-started-with-the-s4hana-migration-cockpit-onpremise/comment-page-1/#comment-379482
Hi Jörg,
thank you very much for your explanations.
How about updating an existing BP with LTMC? Is it possible to update the data of an already existing BP? In LSMW you have the chance, for example by changing the transaction code. Or can data only be inserted with the LTMC?
Regards,
Marco Albrecht
Hi Marco
basically, the LTMC is able to do updates as well. it basically depends on the functionality of the assigned function module, if the function can also do updates its ok, otherwise you have to identify another bapi/function module. the standard delivered mappings/content is currently focused on creation of new objects.
Hi
Thanks for such an informative blog.
As per the client requirement we need to migrate Article Master Data from Legacy System to S4 HANA?
Is it similar to material master migration, as Article master has different set of views?
Hi,
Article master is currently not in-scope for the SAP S/4HANA Cloud and therefore also not available as pre-delivered object for SAP S/4HANA (neither cloud nor on-premise). The pre-delivered objects are initially build for the Cloud version based on the best practices scope and then delivered as a template object for on-premise once in a year to the main release. But you can use LTMOM in SAP S/4HANA (on-premise) to build your own migration object using a function module that loads article master.
Best,
Frank
I Created a project in LTMC and i got 33 Migration objects by default. I wanted to migrate Project Definition and other objects but sap has not delivered the migration objects for PS Module.
In LTMOM i created a new migration object by selectiong the initially created project in LTMC. Our Technical team created a BAPI for project definition creation and i tested it in SE37 and it is working fine.
I used that bapi in the target structure, created source structure and mapped them along with field mapping as well.
I generated the object and saved it. Now that Migration Object "ZCreate Project Definition" started to appear in the LTMC Project. I downloaded the template, filled the sheet with data and uploaded it. Followed the process till the end without any error.
Status of the file is "Not Started (active)" with green status.
In the LTMC Project notification i am getting following error message.
Migration object Z_PROJDEF_001 is not assigned to mass transfer 001
The point is this mass transfer id was already assigned to the migration object at the time of its creation in LTMOM, and as it was assigned that is why it is appearing in the respective project in LTMC. If it is not assigned than why it is appearing in the Project of Mass transfer id 001?
The data was also not migrated.
*I successfully Migrated Profit centre data through LTMC which sap has delived by default in S/4 HANA.
Hi there Usman.
I'm exactly in the same spot where you were. Trying to create and run a homemade Migration Object for Project Definition ( for this using the FM: BAPI_BUS2001_CREATE ).
I'm not getting the error message that you got, but my records are not created when I execute the import. I even debugged the FM in back-end and doesn't seem to be called at all.
Question, did you manage to create Project Definitions via Migration Cockpit finally?
Any of you guys managed to create tailor-made Migration Objects based on BAPIs or FMs not used already by Migration Cockpit?
Thanks a lot in advance for your answer 🙂
Regards
Hi Usman, Sergio.
When copying a migration object, there transfer does not start – this is an issued beeing solved for 1709 FPS01.
Theses SAP notes will help:
2475034 - 1709 FPS00
2546103 - 1610 FPS02
regards, sybille
Regards
Creating the materials
The following error is generated, indicating that you try later.
CNV_DMC_WDA051
How can I solve that.
Another warning message tells me that I am in test mode. I do not know where to remove it.
URGENT
Jose, hi.
Did you resolve this issue?
Can you explain how?
Regards
Hello Jose
I'm having the same error message no matter which object type I try with. Have you figured out what's wrong? Thanks.
klif
Many thanks for this excellent blog. Something I discovered today, which I wasn't expecting (S4HANA 1610 on-premise).
Table DMC_FM_RESTART is cross-client therefore when we refreshed a data load client it was not possible to use the same migration project to re-load the same data. Records in the RESTART table were still being present with the same "mass transfer ID". I overcame this by using a new migration project but I see reorganising the table as probably a better option.
For the same reason care needs to be taken if trying to load the same data to multiple clients. For this I think an individual migration project per client is the best way.
Regards,
Dan Glover
Hi Dan
that's definitely a very important point, and most unexpected for all sap experts. i haven't found the reason for all the missing client fields in the tables and i think it would be easy to add this in standard. there are a lot of problems with different clients and ltmc, usually on dev (qa and prod maybe only one client is possible, public cloud usually also is only one client)
for the moment, you are save with different migration projects (but also additional effort to copy/keep activities in sync), or sometimes just deleting the logs and restart tables, but you cannot run migrations in different clients at the same time.
i am currently testing the ltmc/ltmom on 1709, there are a lot of new standard migration objects (content), and i think ltmom is now starting work more stable, otherwise i didn't find to much new features, the client problem is still there and i haven't found the proposed R3-RFC-S4 solution so far (maybe FPS1? havent given up completely yet, someone found this?)
regards
joerg
Hello Joerg, Dan,
Restart Table
Due to data security reasons, an uploaded file can only be used in client where it’s uploaded. In addition, we store information which records have been successfully migrated to avoid that the same record is migrated twice. This information currently doesn’t store the target client. Therefore no record will be migrated if you try to upload the data again (even in another client). We will check required changes in order to support load in different clients in future.
As of now, you can reset the restart information via program DMC_FM_RESTART_HANDLE (or DMC_FM_RESTART_COPY_DELETE for mass reset) . That’s currently not part of the standard process as you need to be aware that when resetting the restart information also allows to migrate in the same client (which might result in errors or duplicate records).
New Features in 1709
e.g. you check the possibility to view on project basis
Regards,
Sybille
Hi Sybille -
Thanks very much for your response. Yes, I understand the reasoning and when we get to production the protection given by this mechanism will be very useful!
Regards,
Dan Glover
Hi Jörg,
Trying to upload purchase orders excel, I have the same issue than Adarsha Yellenki and Jose Gregorio Sira, error CNV_DMC_WDA051 "Error during preparation of data transfer, try again later".
Any suggestion about this?
Thanks in advance,
Alejandro.
Former Member
Hi Alejandro.
Did you manage to fix this issue? I'm having it right now..
Regards,
Sergio
Hi Jörg
I want to thank you for sharing this information. it is actually really usefull. great job!
I have already created all my objects and tested ok in DEV, and now I will appreciate if you let me know, how to transport my project and objects from Dev to Qas.
Thank you for your kind answer.
Best Regards
Linda
Hi Linda
from 1610FPS2 on, you have an export/import button in LTMC if you open the migration-project. i think these are the reports DMC_EXPORT_CONTENT, DMC_IMPORT_CONTENT .
regards
joerg
Hi Jörg
Thank you for you previous response. Now when i run the DMC_IMPORT_CONTENT report, I get the following message fff
How can i unlock SLO for workbench processing?
Thank you for your kind answer.
Best Regards
Linda
Hi Linda,
in your DEV system you use the button EXPORT button
Then in QAS you create a new migration project with the same Mass Transfer ID - this is prerequisite)!!
Next use the Button IMPORT CONTENT in this new project.
best regards, sybille
I tried this, but obtain an http 500 error, the only solution was re-create each migration object on QAS y PRD manually using LTMOM (in our implementation we need to add several fields and addition logic for vendor and customers)
Hi Linda,
Were you able to solve this problem? When I try to import the zip file I get the same error message.
Regards,
Ramesh-
Hi Jorg,
We are doing Open PO migration and in validation step of migration process in cockpit, it throws below error.
"Exception raised in application module " DMC_GENERAL233
There is no detail of how and what causing the this exception. Can you please help me here and tell where we can find details of the issue and fix.
I checked in SLg1 also for DMC* object and there also it shows the same error.
Hello Manish,
the message is raised by the BAPI. Please open an SAP Incident on component CA-GT-MIG.
best regards, sybille
CA-GTF-MIG
Hi Jörg
Thanks for the detail steps here. I am trying to upload Business Partners (suppliers) through LTMC and I notice the grouping used below is 0001. I assume this is business partner grouping as there are no grouping field in the template. The grouping is expecting external numbering and I do have the number in the vendor upload file but it is not reading it. Where can I troubleshoot this problem or how can I change the grouping used in LTMC?
thanks.
Hi Jörg and other LTMC enthusiasts. We've found a new problem...will refer it to SAP, but wanted to share here in case I'm doing something wrong, or it helps anyone else in the future. 1610 on-premise.
We have a requirement to migrate purchase orders with account assignment to a WBS - not included in the standard template but the field is available in the BAPI. So I added a source field, mapped it, and even remembered the matching "X structure". There is a rule SET_X_IF_NOT_INIT which seems exactly what we want, but...
After entering the name of the source field (OK, it should really have chosen the name POSID not PSPNR) and saving, generating the function group fails with the error "Different number of parameters in FORM and PERFORM..." for my rule. The generated code looks like this:
So there is a blank line where the first parameter (_wa_t09-poaccountx-wbs_element) should appear. I can fix this manually for now, but this doesn't seem right!
Has anyone encountered this issue, please?
Regards,
Dan Glover
OK, so I now see you have another, excellent, blog at https://blogs.sap.com/2017/06/20/discover-the-s4hana-migration-cockpit-migration-object-modeler-onpremise-nltmom/
Reading through there perhaps Note 2453118 may be relevant (S/4 HANA OP 1610 FPS02 - Creation of Rules within LTMOM fails) though we're not at FPS02. Why could I not find it yesterday?
Regards,
Dan Glover
i faced the same Problem, see
https://blogs.sap.com/2017/06/20/discover-the-s4hana-migration-cockpit-migration-object-modeler-onpremise-nltmom/
i could solve it by
Error: Different number of parameters in FORM and PERFORM
i did not really see an error as it is a standard MOVE Mapping with a Constant Value. After i changed the Constant to ‘X’, then ok, then change to ‘MYVALUE’ again, the error disappeared.
but i expect this is solved in 1709
Hi Jörg,
We are implementing 1610 version for a customer (With no option to upgrade to 1709). 1610 version does not contain any of the QM objects as a standard. However we have a demo system system for 1709. Is it possible to export these objects from 1709 and import in to 1610? I tried doing it and got this error "
Any interesting hack will highly appreciated to do this import.. It will save us in a time pressed project.
Regards,
Ramesh-
hi ramesh, i haven't tried myself.
first thing you should check is, if the assigned funtion modules are available in 1610. the migration object only contains the mappings to the standard function.
if the function module is available in both releases you can try to
create a new migration project in 1709, include only one QM Migration Object, export this migration project in 1709 and import in 1610, and check if it can be generated here
otherwise create migration object manually in 1610 (manual typing based on the template from 1709)
Hi all,
I have some doubts about loading Materials if you could solve the followings:
Thanks
Amaia
You can view the note SAP Note 2470789 - SAP S/4HANA Migration Cockpit - Cloud data migration template samples, for examples on how to fill this templates, for your case there is an example:
The views (worksheet Maintenance Status Setting) are like possible combination for use in the first Worksheet Basic Data.
Hi,
excellent work on the blogs!
I am getting a 500 error as the guys above but even the functions are activated I still can't resolve why this is happening.
Many thanks for your help in advance.
Best regards
Dears,
Kindly share the link / pointers to have a quick snapshot of list of migration objects that comes from each SAP S/4 HANA Release for each module rather than checking inside the Migration tool(s). Thanks in advance.
Kind Regards,