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

Discover the S/4HANA Migration Cockpit Migration Object Modeler (OnPremise) /NLTMOM

 

This Blog describes how it is possible to add custom fields to standard migration objects or even create new migration objects.

Description and Screenshots are created with S/4HANA 1610 FPS2. Some options might not be available before and there will be more features available in 1709.

Be aware the Migration Cockpit and Object Modeler are new Solutions, so at some points there are still bugs and there will be a lot of additional features in the future.

 

before starting LTMOM, you have to create a migration project using /NLTMC

Link to getting started with the S/4HANA migration cockpit (onpremise) 

 

Update 6.7.2017: Click-Demo/Training of LTMOM

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

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/

 

SAP Notes

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

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

 

 

Start Migration Object Modeler

Call Transaction code /NLTMOM

Select the Migration Object from the value-list (F4)

 

in most of the cases, it is the easiest solution to use an existing Migration Object and just add some Fields to an existing Source Structure. But it is also possible to create new Migration Objects or Source Structures.

 

Create a new Migration Object

To Create a new Migration Object select ‘create Migration Object’ from the Menu.

you can eater copy from an existing SAP Migration Object/Template or create a user defined Migration object.

 

User-defined Migration Object

give an Object id(No Z_ required, example MYOBJ) and description. Currently only the option Migration from File by calling Function Module is supported. (see Outlook)

 

Enter the Name of the Function Module (Example BAPI_MATERIAL_SAVEREPLICA)

Parameter for the Return is the Table-Parameter which contains the BAPIRET2-Error Messages (see /NSE37)

Parameter for Simulation see Function Module Description, usually there is an option like TESTRUN, where ‘X’ means no Update.

 

Define Source Structure / Add Fields to Source/Excel Spreadsheet

in the Section ‘Source Structure’ it is possible to add new Fields to existing structure and add new Structures.

choose ‘Add Field’ to add fields at the end of the structure. choose ‘insert Field’ to insert the field at the cursor position.

 

add new Source Structures (Optional)

in future it will be possible to choose the Structure Definition from DDIC or Remote Databases:

 

Foreign Key Relationship: You can maintain foreign Keys for Keyfields like MATNR or KUNNR. (See also Standard Objects Assignment)

 

for example, i want to add custom fields to the Material BAPI. The BAPI has an Input Parameter for Customer Fields which matches the Structure BAPIE1PAREX:

Enter Field name, Datatype and Length and Description (Description is shown in generated Excel Template). i usually use CHAR Fields for the Excel/Input Structure and they also can be longer than the target SAP Field.

Press on Button ‘Generate Runtime Object’.

next Time you Generate an Excel Template in LTMC, you will also see the new fields.

 

Target Structure

currently this comes from the assigned Function Module so there is nothing to be changed here.

 

Structure Mapping

each target structure you want to use/fill needs to be assigned to at least one source structure (can also be more than one). this is done by drag and drop.

best thing is to look at the standard assignments first.

the assignment triggers the loop, you can only assign fields of an assigned structure in the field mapping.

 

Field Mapping

when choosing field mapping, the current mapping is displayed.

i usually choose ‘more/settings/technical names on’.

there might be complex hierarchies with a lot of structures and fields, so i ‘collapse’ the target structure first and then drill down to the relevant structure. you can also use the ‘search’ function to find you target field.

then drag and drop the source field to your target field.

some BAPIs have ‘X’ Field Structures, where you have to Mark the Used Fields with an ‘X’:

double click the target field to see the mapping-rule:

 

here you can select from a list of existing mapping rules, or create a new mapping rule. For each Value-Mapping in LTMC, there is a Rule available:

Create new Mapping Rule

if you click on Create you can create a new Rule:

Define Input/Output Parameters

Create a Default Variant

Create Documentation

Edit Code (ABAP)

 

 

Use Mapping Templates:

 

 

Troubleshooting

 

seems to be a bug, but i could not yet find a note for it. Solution: just start LTMOM again

 

use display generated function group to see the generated ABAP Code:

 

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.

 

Update Custom-Specific/Additional Fields to BAPIs

you need to add these to the BAPI, see https://help.sap.com/doc/saphelp_ehsext40/4.0/en-US/3e/0e1089c24611d1ad09080009b0fb56/frameset.htm

 

Additional Ideas

Create a Batchinput Recording, Generate a Function Module and create a Migration Object for this Function Module. (/NSM35)

Example Material Master, Field Commodity Code MARC-STAWN currently not updated by BAPI_MATERIAL_SAVEREPLICA. I usually do a Z-Report to save it with function /SAPSLL/API_COMCO_CLS_DISTR, but it should be possible also to create a new migration object for this function module.

https://launchpad.support.sap.com/#/notes/2432527/E

 

Transport DEV/QAS/PRD

in LTMC there is an option to export and import migration Projects.

 

Outlook

it looks as it will be possible to create Migration Objects from IDOC and Direct DB Access to Source R/3 System.

 

 

Assigned Tags

      81 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo SAPer Yang
      SAPer Yang

      Wow..thanks,Jorg...I am the first one to comment on it..

      Can you give me some tips on below issue  when executing LTMOM... I checked with the BASIS guy but he also has no idea..

       

      Looks like some configuration or application is required to use LTMOM...

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

      i think there is nothing special to be installed for LTMOM from SAP Basis. Do you have a Migration Project in LTMC?

      what sap release/patch are you on? are you using webgui or local sapgui installation?

      did you try log in in english? ( i see asian characters in your screenshot ), try in english first.

      (webgui can be called from browser with /sap/bc/gui/sap/its/webgui?~transaction=LTMOM

      (i do not recommend webgui here, but just to find out whats going on)

       

       

       

      Author's profile photo Frank Finkbohner
      Frank Finkbohner

      Hi Jörg

      starting SAP S/4HANA Cloud 1705 there is a new object (Material - Commodity code) available to  classify products. It is using the new FM /SAPSLL/COMCO_CLS_MIGR_BAPI. Probably not available before 1709 OP.

      Best,

      Frank

       

       

      Author's profile photo Atul Khavenekar
      Atul Khavenekar

      Hi Jorg,

      This blog is very helpful. We have followed same process to migrate the data.

      Tried to insert  Employee address details (PA20) with custom function module, where we are not getting any errors while uploading the source template.and able to proceed with  Star Transfer

      Issue here is , we are not able to see the Simulate step in the road map, only three steps are available for custom migration object. And also data is not migrating in to PA20 transaction through the source template, where as we are able to migrate through Function module.

       

      Can you give some helpful tips on the issue.

       

      Thanks,

      Kishore

       

       

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

      i think if Simulation is active or not depends on the Settings here: (Parameter for Simulation)

       

      what function are you using? some functions require also a post processing function (like save_adress_data), so a combination of multiple functions

      if you set a breakpoint at the beginning of function module, you should be able to see the difference between template and your migrate through function module.

      Author's profile photo Monika Blauth
      Monika Blauth

      Dear Joerg,

      Thank you very much for this blog, it is very valuable. I tried to follow your instructions.

       

      In the transaction LTMOM I try to extend Material migration object by adding (activating) S_MARA-NORMT field.

      I mapped rules

      T02_CLIENTDATA-STD_DESCR MOVE (S_MARA-NORMT)

      T03_CLIENTDATAX - STD_DESCR SET_X_IF_NOT_INIT (S_MARA-NORMT)

      and activated changes.

      Then, in Migration Cokpit, when I download template, I can see that the file structure has been adjusted automatically - new field S_MARA-NORMT appears on "Field List" and "Basic data" sheets.

      However, when I try to upload data from the migration file (filled with data, of course), I receive message "No data available".

       

      Could you please suggest possible solution?

      Thank you,

      Monika

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

      hi monica

      glad to hear you like this

      for me this works as described, your description looks ok to me

      what is the field type/lenght of your Field?

      sometimes i had problems with fields filled with space instead of 'null' (maybe somewhere in your structure), so when uploading the columns got confused, see also my other blog for LTMC

      to find out where the problem comes from:

      download a new template, enter values (only one line) material number, language key, text, industry sector, material type, material group, base unit of measure and your NORMT Field while you always go to next column with Tab (no copy paste of ranges etc)

      if you upload this it should work

       

       

      Author's profile photo Federica Quaranta
      Federica Quaranta

      Hi Monika,

      I am facing the same problem.

      Could you solve it?

      Thank you,

      Federica

      Author's profile photo adarsha Yellenki
      adarsha Yellenki

      Hi Jorg,

      We are facing issue while enhancing the Migration of Vendors object using LTMOM with S/4HANA 1610 package 2, by adding new structure for VAT at source structure, fields added are Country and VAT registration number and mapped structures.

      In target structure _R_IT_SUP_GENERAL_VAT-CVI field, assigned rule using defined SET_RUN_ID for increment. after creating rule, tried generate the Object, which is ending with 3 errors as below

      checked the FM ‘/1LT/LM16300000000000157FI4’ which has error at Perform statement _RULE_SET_RUN_ID_S has only with 4 parameters passed with missing returning parameter.

      tried edit and add the returning parameter at 5191 in above FM is removing the syntax error, but actual object is giving error, hence we are not able to upload data using LTMC for Vendors.

      Could you please help us in finding, why Generate Runtime Object is replacing the code without Exporting parameter as RUN_ID at perform statment in above FM.

      Regards,

      Adarsha Yellenki

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

      SAP has started to deliver correction for LTMC and LTMOM

      Komponente CA-LT-MC

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

      maybe this one helps:

      2453118           2          S/4 HANA OP 1610 FPS02 - Creation of Rules within LTMOM fails

       

      other interesting notes:

      2376533 - Migration Cockpit & SLT on S/4 HANA On-Premise Edition 1610

      2486472 - S/4HANA 1610 FPS02 - Syntax error during generation of runtime modules

      2498738   Migration - RABAX_STATE Termination in Migration Cockpit

      2489225 - How to handle same data from different clients in the migration object

      2487822 - How to manually activate a migration object

       

      Author's profile photo Former Member
      Former Member

      Thanks  Jorg.

      Author's profile photo Former Member
      Former Member

      Hi Adarsha.

       

      Any of the Notes above fixed your issue?

      I'm facing the your same scenario, applied note 2453118 but the code doesn't seem to compile.

       

      Thanks in advance.

      Sergio

      Author's profile photo Former Member
      Former Member

      Hi Jorg

       

      Firstly many thanks for this blog, it is really helpful.

       

      So I tried getting my hands dirty on using this new tool. I didn’t see any out of the box template for GL Account creation, so started with it as it’s one of the simplest conversion object. I used function module GL_ACCT_MASTER_SAVE. Went through my learning curve, got stuck with hardcoding fixed values, read through the comments and learned that it’s a bug. Then implemented the relevant note and tried to generate the runtime object again.

       

      I am getting a new kind of error now –

      Would you know why this would be happening ?

       

      Thanks

      Nitish

      Author's profile photo Former Member
      Former Member

       

      I figured out the error, it was due to not defining the foreign keys.

      Now struggling to generate a view of the source structure as I cannot download the template from LTMC.

       

      Thanks

      Nitish

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

      thats great, i like your approach. what is the problem when downloading template?

      Author's profile photo Former Member
      Former Member

      I get the following error when I try to download the template using LTMC -

       

      Despite having generated "Customer 1" View in LTMOM. Don't know if its a system thing or I am missing something.

      Author's profile photo Sandra Kirsch
      Sandra Kirsch

      Hi,

      Have you been able to generate the GL Account Upload, I've created a upload based on FM

      GL_ACCT_MASTER_SAVE, but once I'm trying to upload my new GL accounts, I'm getting an error (see screenshot) - Import to table SKA1 not possible.

      I've checked out OSS Note:

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

      But that doesn't make much sense. Does that mean I have to load the GL Account General data first, prior to loading the Company Code data?

      Any help would be greatly appreciated.

      Sandra

      Author's profile photo Former Member
      Former Member

      Jörg Former Member

      Hi!

      Trying to solve same problem for GL accounts Master. I was able to download template, but I faced with an issue that I don`t get any result when trying to load my data through LTMC.

      Is it enough to use @"move" rule in fields mapping? (created by simple drag and drop)

      Thanks,

      Alexey

      Author's profile photo Li Ying Khoo
      Li Ying Khoo

      I am facing the same problem for the GL account master data creation too where I am able to download template but I don't get any result when upload my data through LTMC.

      Any Solutions?

      Thanks.

      Author's profile photo Sandeep Gowda
      Sandeep Gowda

      Hello Li Ying Khoo,

      were you able to solve the problem? I have same issue with GL account master data upload via migration cockpit.

      it shows no results and file still remains "not started" state.

      Author's profile photo Peter Muschick
      Peter Muschick

      I assume you guys did not find a solution to the load issue with FM GL_ACCT_MASTER_SAVE? We are also stuck with that as we get no results. We traced also the error in debugging to DMC_MT_STARTER_BATCH line 608 where there is an exception probably - but there is no log entry or something else anywhere. And the FM is never actually executed at least once and manual execution of it works flawlessly.

      Thanks a lot for your feedback!

      Author's profile photo Nihad Catak
      Nihad Catak

      Hi Jörg,

      thank you for the blog. It’s great!

      The ‘new’ LTMOM with FPS2 is great and after all the corrections it’s working fine.

      The only problem is that the LTMC is not working with own objects and it is not giving me any errors when migrating own objects.

      Same problem as Monica described in her post – ‘No data available’.

       

      But my main question is: can I use transaction MWB instead of LTMC?

      To me, MWB looks more detailed and is a combnation of LTMOM and LTMC.

      When I download the tepmplate file via MWB, edit the file with my data and go through the migration steps, it works.

       

      Can you please help.

       

      Thanks

      Nihad

       

       

      Author's profile photo Jeff Yong
      Jeff Yong

      The transport option is not found in LTMC, any settings required?

      Author's profile photo Former Member
      Former Member

      Hi Jeff

       

      The option to import/export is available in 1610 FPS02. You seem to be on a previous 1610 stack. Once you upgrade, you will have the option on the same screen as follows -

       

      Author's profile photo Former Member
      Former Member

      Hi Jorg,

      I'm creating a custom LTMOM object to create Sales Contracts using BAPI_CONTRACT_CREATEFROMDATA . I have mapped the 3 main structures (Header, Item, and Partners) and the FM is generated successfully:

      My issue is when I run the object via LTMC, the FM does not seem to get called.  I have put break points in the generated FM as well as the BAPI, and none of the breakpoints are hit.  I do not get any messaging in LTMC:

       

      Any suggestions?

       

      Thanks,

      C.Curtis

       

      Author's profile photo Former Member
      Former Member

      Hi Christopher.

      I had the same issue and my best guess at the moment is that there are some issues within LTMOM when creating a new object from scratch.

      One problem you might have noticed was a missing function when you generate (there should be at least four):

      • SS4ACS (this one was missing)
      • SS4IL
      • SS4OLC
      • SS4OLO

      To get the missing function I had to manual update tables in the background for given MO:

      • Table DMC_COBJ field SOURCE = M
      • Table DMC_CNTN field READING_TYPE = 6
      • Table DMC_MT_TABLES field TABCLASS = TRANSP

      Afterwards regenerate the function group. And try again via LTMC.

      Also keep an eye out for messages in the application log SLG1. I've found messages there that are not in LTMC web site.

      I hope that helps.
      Juergen

       

      Author's profile photo Former Member
      Former Member

      Hi Juergen,

       

      Thank you very much for the information.  I did notice that the ...SS4ACS include program/function was missing in the generated code. In searching for information on LTMC/LTMOM - I had found info regarding tables DMC_COBJ and DMC_MT_TABLES and had made those updates to the entries.  I did not know about DMC_CNTN - and now that I've updated that info - it seems to have worked!! Thanks you very much.....appreciate the help.

      One thing I will mention - is after re-generating the function group, be sure to exit out completely of LTMC....then call LTMC again to ensure you are accessing the latest version.

      Thanks again for the help.  🙂

       

      Chris Curtis

      Author's profile photo Former Member
      Former Member

      Hi Juergen.

       

      When manually updating the fields in background, you mean when generating the function group? or editing the tables content in SE16N + sap_edit?

       

      I tried the second option and didn't work.

       

      Thanks in advance!

      Regads,

      Sergio

       

      Author's profile photo Andrés Galeano
      Andrés Galeano

       

      I have the same issue, and SAP answer me with this NOTE 2452772 – S/4 HANA OP 1610 FPS02 – User-Defined Migration Object is created with wrong reading type

      But seems that this is not enough yet, with this note it generate the 4 funcion modules, but the problem persist because tables Table DMC_COBJ field SOURCE = M and Table DMC_MT_TABLES field TABCLASS = TRANSP don't have the correct values yet, updating this it will work.

      Author's profile photo Diego Jauregui
      Diego Jauregui

      Just a question, not sure if this is the correct blog, there is any standard object for Chart of Account upload?

      Author's profile photo Nitish Dhingra
      Nitish Dhingra

       

      Hi Diego

       

      No, there isn't one.

       

      Thanks

      Nitish

      Author's profile photo Diego Jauregui
      Diego Jauregui

      Thanks, we will use LSMW as in the past

      Author's profile photo Diego Jauregui
      Diego Jauregui

      Hi all, I have another question, we try to create a BP as vendor and also as customer, for this scenario we use external number, the verdor is created and the BP, but when we tried to create the customer, the message displayed is the BP A000000003 already exist, the idea of this proyecto is to create the BP with the customer and vendor role, Does anybody knows how to proceed?

      Author's profile photo Nitish Dhingra
      Nitish Dhingra

       

      Hi Diego

       

      The standard objects first creates a BP then adds relevant BP roles and then adds customer sales area and company code details. Since in your case the BP is already created, the system is giving an error. You can create a custom object by copying the standard customer object and remove the BP creation blocks in the used function module(RFC_CVI_EI_INBOUND_MAIN). Also ensure that you add a column for the BP number in your source gathering template and supply the BP number which got created with vendor creation. Also ensure that your program add's the relevant roles to BP when creating customer master.

       

      Thanks

      Nitish

      Author's profile photo Atul Khavenekar
      Atul Khavenekar

       

      Hi Jorg,

      I’m creating a custom LTMOM object to create Asset Master using BAPI_FIXEDASSET_CREATE1 . I have mapped the main structures (Header, Item, and its fieldds) and the FM is generated successfully:

      issue here when we run the object via LTMC, the FM does not seem to get called.  I have put break points in the generated FM as well as the BAPI, and none of the breakpoints are hit.  I do not get any messaging in LTMC:

       

      And also we have an error in migration object Notifications tab that Migration object Z_ASSET_UPLOAD_00T is not assigned to mass transfer 00T, though it was assigned while creating the project itself.

       

      Please suggest.

       

      Thanks,

      Kishore

       

       

       

       

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

      there is a standard migration object for assets which is using BAPI_FIXEDASSET_OVRTAKE_CREATE maybe this helps you?

      Author's profile photo Delon Ndlovu
      Delon Ndlovu

      Hello Jörg

      I have created an custom object using LTMOM (Migration Cockpit Modeller) for Projects. I am using Bapi BAPI_PROJECTDEF_CREATE.

      I have done all the required mapping on the Modeller, but when activate the object on LTMC (Migration Cockpit) it goes through all the steps but when I click finish on the final step. It goes back to the object initial page with status Not started (Active).

      Am I missing something?

       

       

       

      Author's profile photo Diego Jauregui
      Diego Jauregui

       

      Hi all,

      There is a size limit on the XML File? we are trying to upload 45000 vendors and the LTMC said that Wrong File type or file to big (the file type is OK, I download the template before upload)

       

      Thanks

      Diego

      Author's profile photo Anthony Collober
      Anthony Collober

      Hi Diego,

      Did anyone give you an answer regarding your post ? Because I'am having the same issue with another template. I'm trying to upload Material template, it's more than 200Mo however, LTMC error message says "file is too big".

      Thanks in advance for your answer

      Anthony

       

      Author's profile photo Diego Jauregui
      Diego Jauregui

       

      Another question, someone knows if the is a way to download a DELTA XLM file I'd looing into the options and didn't saw it

      Author's profile photo Manish Shandilya
      Manish Shandilya

      Hi Diego,

      It will automatically generated for the failed records after you finish Data import and click on finish button.

      then you can select and download the delta records file.

       

      Best Regards,

      Manish

      Author's profile photo Adolfo Medina Molina
      Adolfo Medina Molina

      Good Afternoon Jörg:

      Actually I´m having a problem with the transaction LTMOM in our SAP 1610 SP2.

      I was trying to add a new field to the template of customers (field FDGRV) but I can´t see the Source Structure:

      Any advice?

      Regards

      Author's profile photo Ce Li
      Ce Li

      Good Morning Jörg:

      How can I cancel a File with status “started (in process)”? It waste too much time,and I can not upload the next one.

      Thanks,

      Ce

      Author's profile photo Former Member
      Former Member

      If you're having the same issues we're having, you're probably still running the fixed asset load.

      RE performance issues please check :-

       

      2554160 - SAP S/4HANA Migration Cockpit: Fixed Asset : Less performance during simulation run

      Author's profile photo Ce Li
      Ce Li

      Thanks a lot for the information !

      Author's profile photo Jit-Wei Tan
      Jit-Wei Tan

      Hi,

      I have received error msg "Maintain data path for the relationship of structure R_POSTEDVALUES" when I trying to save after structure mapping for Fixed Asset.

      Also how to change the Access Type from 'READ TABLE' to 'LOOP AT TABLE'?

       

      Author's profile photo Emmanuel Stefano Guidote
      Emmanuel Stefano Guidote

      hi. is it possible to use Function modules which require initialize and commit?

      Author's profile photo Former Member
      Former Member

      Hi dear,

      do you know if SAP released an OSS NOTE to avoid the procedure of Former Member

      "To get the missing function I had to manual update tables in the background for given MO:

      • Table DMC_COBJ field SOURCE = M
      • Table DMC_CNTN field READING_TYPE = 6
      • Table DMC_MT_TABLES field TABCLASS = TRANSP"

       

      Anyway it works!!

      Thank you in advance.

      Author's profile photo Andrés Galeano
      Andrés Galeano

      NOTE 2452772 – S/4 HANA OP 1610 FPS02 – User-Defined Migration Object is created with wrong reading type

      But seems that this is not enough yet, with this note it generate the 4 funcion modules, but the problem persist because tables Table DMC_COBJ field SOURCE = M and Table DMC_MT_TABLES field TABCLASS = TRANSP don't have the correct values yet, updating this it will work.

      Author's profile photo Former Member
      Former Member

      Hi All,

       

      We are trying to integrate the customer master in ECC to S/4 HANA wherein ECC is the source of customer master data. In S/4 HANA, does it have any download functionality like the transaction R3AR2/R3AR4/R3AR3 using object CUSTOMER_MAIN in SAP CRM to PULL the customer master data in ECC? Or is there any existing IDoc ALEs/BAPIs that can be used to PUSH the customer master data from ECC to S/4 HANA or vise versa?

      What process would you suggest to establish the integration of customer master:

      A) working in S/4HANA to pull the data from ECC or

      B) working in ECC to push the data to S/4HANA.

      Any suggestions will be greatly appreciated. Hope you can enlighten us on this matter.

       

      Thank you so much!

       

      Regards,

      Mike

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

      There will be a functionality for LTMC, which allows instead of file uploads a transfer from r/3 to s/4 by rfc. it was anounced for 1709 and I expect this to be available with FPS1 in Q1/2018, at the moment you can request the functionality for betatest together with sap consulting (try oss message?).

      for LTMC so far there are to options before this feature is available:

      a) download data from an abap report

      you can use the structure definitions from the top include of the generated functions and use move-corresponding

      FUNCTION-POOL /1LT/SIDCLNT00000000XXX.

      *--- source types ---*
      TYPES: BEGIN OF _TS_IO_S_MARA ,
      MATNR(000080) TYPE C,
      SPRAS(000080) TYPE C,
      MAKTX(000040) TYPE C,
      MBRSH(000080) TYPE C,
      MTART(000080) TYPE C,
      GROUP(000080) TYPE C,
      XCHPF(000001) TYPE C,
      ...

       

      b) you use SQL to select from source database and insert into excel (sql can insert data into the excel)

       

      c) copy paste (value only to keep the xml structure of the excel)

      regards

      joerg

       

      Author's profile photo Suresh Babu
      Suresh Babu

      Dear All,

      Can you please provide me SAP Course Details for S/4 Hana Migration Cockpit.

      Thanks

      Suresh

      Author's profile photo Former Member
      Former Member

      Hi all,

       

      If i had create a account group z001 , and i can use migration to create customer bp number , and my fi customer assignment is also z001 , but in the field display in bp rule it still show FLCU01 Customer not z001 . Is there any way that i can make the field show z001 not FLCU01 Customer?

      Best Regards.

      Galen

      Author's profile photo Former Member
      Former Member

      Hello Jörg

      Very interesting blog.

      Is there any documentation that details which Migration Objects are currently delivered within S/4HANA Migration Cockpit for the latest On Premise and cloud versions?

      Thanks

       

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

      yes see my blog here:

      Link to getting started with the S/4HANA migration cockpit (onpremise) 

       

       

      Author's profile photo Former Member
      Former Member

      Thank you.

       

      What's the difference between between the 2 lists - Migration Objects and Objects in 1709.

      Is the Objects in 1709 in the latest release and the previous list in the older release?

       

      Are all the Objects in 1709 list also available in the cloud?

       

      Thanks

       

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

      yes first list ist 1610, second 1709

      for cloud you will find the list in the bestpractice documentation:

      https://rapid.sap.com/bp/assetsdownload/?publishedUrl=https%3A%2F%2Fsupport.sap.com%2Fcontent%2Fdam%2FSAAP%2FSol_Pack%2FLibrary%2FTestScripts%2FBH5_S4CLD1711_BPD_EN_XX.docx&bomId=609c9265caf5d78c02b1fb5de4d6db7c&pvId=11df4e22b642444dafedfcc82e5a21de&sivId=eda2110ab1414523abc5566896363eab&bbId=

       

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

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

       

       

      Author's profile photo Anand Sirgapuram
      Anand Sirgapuram

      Hi Jörg,

      Greetings. This is a useful blog for the starters on LTMOM.

      I have a question related to creating source structures. I wanted to have a hierarchy structure for the source wherein I have to have multiple structures at the same level. But the option of "Insert structure at same level" is greyed out. Am I missing something here?

      Could you please help me on this.

      Thank you.

      Anand Sirgapuram. 

      Author's profile photo Marcelo García
      Marcelo García

      Hi Anand,

      You need to insert a higher level structure first

       

      Regards

      Author's profile photo ACN Appli
      ACN Appli

      Hi all .

      This may not be directly related to this topic.

      We are using Cockpit to migrate vendor data. Since each vendor has multiple bank accounts (more than 4 sometimes) we do not know how to insert it in the cockpit template. Does anyone have a clue on this?

      Author's profile photo Mohamed Ahmed
      Mohamed Ahmed

      i guess you enter 4 lines for each vendor each one with one bank account number.... not sure though

      Author's profile photo Mohamed Ahmed
      Mohamed Ahmed

      Hi All,
      Anyone tried to create a rule or use transaction object in Cockpit Modeler?
      I have a requirement to get a field form source field and select with it anther field from a table and  then pass the table field  to the FM (target Field) in my customized migration object but i am not sure where to write this code and what is the syntax of the source field in that code,  Also to take a source field (entered by the user in excel template ) and Add on it a constant number than pass it to the target field.
      Can anyone help me ?

      Author's profile photo Luz Mery Hernández Torres
      Luz Mery Hernández Torres

       

      Thanks for this blog.
      
      I am working with S/4HANA 1709.
      
      I have the same problem already explained in this blog:
      
      I create an own object by LTMOM, the 4 function modules are generated correctly.
      
      LTMC does not work with own objects. I download the template but when loading the data I do
      not get any results, it does not give any error in any of the steps but it does not load.
      
      I put break points in the generated functions and in the bapi and they are not reached.
      Does anyone have the solution?
      
      
      Thanks for your help.

       

      Author's profile photo Austin Steyn
      Austin Steyn

      Hi, this is my first time to learn about LTMC and LTMOM... so thanks for the information that you have shared.

      Question (apologies if this is stupid). But is this functionality only to load data / extend data? Or can I use the same to make changes to existing data?

      Previously we used LSMW but now we have issues with LSMW where we have to set certain logical file paths using SFILE.

       

      Your advice is appreciated.

       

       

       

       

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

      the focus is on creating new data, in theory you could add a custom function with update functionalities similar to lsmw. the lsmw SFILE problem can be solved (there are sap notes on this) so lsmw basically is still running but no more strategic.

      for changes also have a look at the mass data maintenance tools (like /NMASS)

      Author's profile photo Austin Steyn
      Austin Steyn

      Hi Jorg,

      Thanks for your response.

      Transaction MASS (BUS1006) doesn't allow update to the object I need to update (Recon account for Customers).

      I've seen the note for LSMW but the change affects other areas and its a risk.

      So theres no reliable method to make changes to master data in Hana??

      Austin

      Author's profile photo Ramazan Islamoglu
      Ramazan Islamoglu

      Hi,

      I also have question about formatting.Did you try to upload any negative values like “-5” , “-10” ?

      In help document its given as “For negative numbers, ensure that a minus sign (‘-‘) directly precedes the number, for example ‘-100’. ”

      But whenever i upload data like this LTMC gives error BF020 – ‘value can’t be interp. as floating-point number or longer than 22 charac’. I tried different formatting but it didn’t do any good, even tried giving it like “10-” but it didn’t work.

      How should be formatting for negative values any recommends ?

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

      yes we use - sign before the number, example -0.2

      this might be a problem of your sap release (what s/4hana release/patchlevel, also check for sap-notes) or migration object content (which migration object is it?)

      another idea I had was this could be language/country specific number settings in windows/excel?

       

      Author's profile photo Rakesh Ramakrishnan
      Rakesh Ramakrishnan

      Thank you Jorg for this!

      However, I have a query for you. I understand that the Function Modules used in the Migration Object Modeler must not execute COMMIT work commands as they are implicitly handled by the Migration Cockpit. Does that mean that even ROLLBACK commands will handled implicitly by the cockpit and explicit rollback commands will not have to be written in the Function module/custom BAPI for a custom migration object.

       

      Please revert.

      Author's profile photo Mayur Satish Ubale
      Mayur Satish Ubale

      Hello Jorg,

      Nice blog, I'm running into one issue while uploading fields for Source Structure in LTMOM through Upload Structure Field List functionality. The issue is, even though the fields are uploaded successfully, Data Type & Length are taken default as CHAR & 80 respectively. The values in the file are not used, any idea about this?

       

      Thanks!

      Author's profile photo Somraj Roy
      Somraj Roy

      Dear Jörg Knaus :

      As per SAP documentation below where can I get a complete list of migration objects available along with mapping information

       

      Author's profile photo Jörg Knaus
      Jörg Knaus
      Blog Post Author
      Available migration objects SAP S/4HANA http://help.sap.com/S4_OP_MO
      Available migration objects SAP S/4HANA Cloud http://help.sap.com/S4_CE_MO
      Author's profile photo Somraj Roy
      Somraj Roy

      Jörg Knaus : Kindly can you let me know in little details where can i get the mapping rules as mentioned in the image taken from SAP documentation. I need for a direct transfer approach.

      Author's profile photo Heike Jensen
      Heike Jensen

      Hello Roy,

      you can only see the mapping/transformation rule information when you are in a SAP S/4HANA system.

      In the migration cockpit (in the Fiori app), go to your project and there to the mapping task. You find the button "Show" documentation.

      Detail:

      You can also go to the modelling environment (transaction LTMOM in the SAP S/4HANA backend system). There, you see the technical definition for the rule/mapping. In this place, you can also change the rule or create own rules.

      If you want to access a preconfigured system to educate yourself or to test/play, you can use a so-called SAP fully activated system.

      Pls. find here more information:

      How to access

      1. General information on what Fully-Activated Appliance is and how to use: https://blogs.sap.com/2018/12/12/sap-s4hana-fully-activated-appliance-create-your-sap-s4hana-1809-system-in-a-fraction-of-the-usual-setup-time/
      2. The SAP S/4HANA trial homepage contains step-by-step guides how to create a system and how to walk through the pre-configured sample processes.
      3. Check the Demo Guide Blog to access the Demo Scripts

      Best regards,

      Heike

      Author's profile photo Somraj Roy
      Somraj Roy

      Dear  Heike Jensen :  Hope you are having a fun filled & memorable Easter.

      I have a small query – I need to create data migration strategy for ECC -> S/4HANA on-premise migration (with all available tools & options).

      Does SAP recommends DMC or something else ?

      Secondly, can you kindly share a blog for this migration which mentions the SAP recommended tools & scenarios for data migration from ECC -> S/4HANA for all 3 ETL processes (extract, transform & load). I don’t need much of you time. Kindly share a blog/article/whitepaper with SAP recommendations which could be my starting point and rest I will create.

      In the below link it is mentioned that The SAP S/4HANA migration cockpit is designed for an initial load of data, specifically for the SAP S/4HANA new implementation scenario.  Does this mean that we have restrictions on using DMC for ECC -> S/4HANA transition.

       

      https://help.sap.com/viewer/29193bf0ebdd4583930b2176cb993268/2020.001/en-US/7a62b59726ce42e7a10770b06940f934.html

      Author's profile photo Heike Jensen
      Heike Jensen

      Hello Somraj Roy,

      I am not really sure what you mean with DMC. Do you mean the SAP S/4HANA Migration Cockpit, approach "Direct Transfer"?

      Basically, there is the so-called manifesto LINK – a practical guide for senior IT leadership which outlines the 3 different ways to SAP S/4HANA => system conversion, selective data transition and new implementation (greenfield approach).

      There is a second paper which describes and compares the migration tools offered by SAP that can be used for a new implementation (greenfield approach) of SAP S/4HANA => Migration Cockpit, Rapid Data Migration with Data Services, LSMW (=> is on the simplification list, no SAP support for LSMW anymore!): LINK.

      For the move to the cloud, the SAP S/4HANA Migration Cockpit is the tool of choice. For onprem targets, you have the possibilities described in the comparison paper above. In an onprem system, you have the full control so of course you can also think about any alternative.

      Pls. find here the complete slide deck for the SAP S/4HANA Migration Cockpit.

      If you refer to the Migration Cockpit – approach Direct Transfer: SAP ships about 150 migration objects. If you need other/more objects, you can create them by yourself by using the modelling environment (which comes for free with the Migration Cockpit) => transaction LTMOM.

      Pls. keep in mind that a New Implementation means: we do NOT transfer historical data such as closed processes nor data of former years. Only the data which is necessary for a new start is transferred: master data, open items, balances and so on. Neither does the Migration Cockpit offer possibilities for updates respectively it is not designed to keep systems in sync.

      Best regards,

      Heike

      Author's profile photo Somraj Roy
      Somraj Roy

      Dear Heike Jensen  :

      By DMC I meant SAP S/4HANA Data Migration Cockpit. I went through the documents shared by you and below is my understanding.

       

      Can you kindly confirm on this approach.

       

      • DMC is applicable for greenfield implementations only. We can have ECC as source (legacy) but the implementation should be greenfield (i.e. no transition by SUM/DMO).
      • For ECC -> S/4HANA conversion (i.e. SUM/DMO) the tools do the conversion and data migration. No need of DMC. We need to do pre-projects (e.g. CVI) and some post conversion tasks.
      Author's profile photo Heike Jensen
      Heike Jensen

      Dear Somraj Roy,

      I would appreciate to use the correct name: SAP S/4HANA Migration Cockpit, in short: MC. DMC does not exist in the SAP branding.

      1. Yes, the SAP S/4HANA Migration Cockpit is only meant to be used if you want to do a greenfield approach.
      2. In a conversion, the whole system is transferred to SAP S/4HANA including all history, all data. This is technically done in a completely different way and has nothing to do with the SAP S/4HANA Migration Cockpit => pls. see the manifesto mentioned above. Unfortunately, I cannot provide more details here as I am not an expert in this area. On help.sap.com there should be more detailed material when searching with "conversion to SAP S/4HANA".

      Best regards,

      Heike

      Author's profile photo Somraj Roy
      Somraj Roy

      Dear Heike Jensen : Can you kindly share some leads about SAP recommendations for DVM (data volume mgmt or data mgmt). Normally in ERP we used to do archiving. But with HANA we had data aging and ILM. But are they valid ? Kindly refer the below blog from 2019 which said SAP will come up with something in place of data aging. Also what are the recommendations fro archiving ?

      https://blogs.sap.com/2019/11/11/case-study-data-aging-in-sap-hana-and-s-4hana/

      Author's profile photo Heike Jensen
      Heike Jensen

      Hello Somraj Roy,

      sorry, this does not belong in our area, so I can unfortunately not give any advice here.

      Best, Heike