Product Information
LTMC for Master Data Step by Step Process
Dear All,
When We are Implementing SAP S/4HANA solution, We can migrate our master data and business data from SAP systems or non-SAP systems to SAP S/4HANA. By using SAP S/4HANA migration cockpit.
The SAP S/4HANA migration cockpit uses migration objects to identify and transfer the relevant data. A migration object describes how to migrate data for a specific business object to SAP S/4HANA. It contains information about the relevant source and target structures, as well as the relationships between these structures. It also contains mapping information for the relevant fields, as well as any rules used to convert values that are migrated from source fields to target fields. SAP provides predefined migration objects that you can use to transfer your data.
The Tool used to perform Migration is LTMC – (Legacy Transfer Migration Cockpit)
You can access the SAP S/4HANA migration cockpit by using transaction LTMC.
Note the following considerations when deciding on the most suitable approach for your project:
Consideration | Files | Staging Tables |
Size Limit | 160MB limit for SAP S/4HANA Migration Cockpit .* | No Limit. |
System Considerations | None. | Staging system uses an SAP HANA database. |
Data Provisioning | Enter data manually in each Microsoft Excel XML file. | Fill tables manually or by using preferred tools (for example SAP Agile Data Preparation). |
* For on-premise systems, parameter icm/HTTP/max_request_size_KB controls the size of the http request. The value of this parameter is the maximum size (in KB) of an HTTP request. This parameter has the standard value 102400 kb (100MB) but can be changed if required. For more information, see
Steps to Use LTMC
- Enter LTMC T.Code
2. LTMC Web page / Fiori App will get opened
3. Click on Create for Starting New Migration Project
4. Provide Project Title & Data Retention Time and hit Create
5. In the Search bar, we can look for an object which we want to use and upload data
6. Select Required Object and click open
It’s just an information and press ok
7. Click on Download Template so XML file will be downloaded
8. A pre-filled Template with detailed of each field and business is available
9. In Field, List Sheet will find each sheet which and all are mandatory based on that we will fill data and upload
10. In Basic Data Sheet highlighted column is mandatory and fill the remaining fields and sheets as per requirement.
11. In the last Sheet, “Maintenance Status Settings” Sheet will be activating which screens are required as per business.
12. Once the template is ready with all required data need to follow below Steps
A. Upload File
B. Activate
C. Start Transfer
D. Data Validate
E. Convert values
F. Simulate
G. Execute Import
13. Click Activate
14. Click Start Transfer
15. Data will get Transferred once its done Close button will get enabled
16. If any error or data is missing will get error hear if all data in templet is good we can proceed further
17. Click next
18. When we are executing for the first time particular object in a project we need to Map fields.
19. Click each line item and do Mapping of Values
20. Select Line Item and Click check once status turns in to Green Light click save so next time system will do the mapping automatically
21. Once all the mapping is completed and no open items click next to simulate Import
22. Similar to upload once its completed click close to proceeding further
23. Backed Program will execute and data gets simulated if any missing data of mandatory fields and fields Mapping is wrong
24. If any error go back and fix and repeat same if no error click Next
25. If all the steps are completed without any error will get above message then click finish.
Migration Status is now Finish
- Now Check whether Material is created or not
2. Go to Display Material Fiori App and Search with the Material Number which you created
3. Select required Fields
4. Material with all the fields got updated with Screens.
For uploading data without any error try with one material and will get a lot of errors when doing initially do trial and error so will get masters in LTMC.
Hi Ruthvik Chowdary ,
Can you help me to suggest some tool like LSMW / LTMC for the below details.
I have a huge data which need to be loaded on the system at one go. Kindly help me to provide the tool for the below details.
Create Equipment BOM
Functional Location BOM
Create Equipment Task List
Functional Location task List
Thanks
Sambit Sahoo
Mob- 8886051114
Very Nice informative good explanation about the steps for data migration in blogs keep it up
Thank you RAJESH SHARMA
Hi Ruthvik
I need a way to create QM views for a bunch of materials in mass.
Is there a standard template available for the same?
Under the older LSMW, I would have created a recording of MM01, where I select the QM view for the required plant and proceed with maintaining the fields which I wish to update for my materials.
In fact, I need to update only these four fields for my material-plant combinations:
Can you guide me as how to go about it? is there a standard way to extend a particular view in MMR , in my case , the QM view?
Any inputs will be appreciated.
Hi , could you please let me know which migration data object to use for " conversation - tax depreciation " I could see there is no migration data separately available for tax depreciation
I think its not there till 1909 version
Hi Ruthvik,
Excellent document.
I have a small doubt in Material Load. My question is if we are loading different material types then we have the different views( Raw Material - No Sales views required, FERT - required all views). How to handle this in a single file?
Thanks in advance.
Regards,
Venkat.
LTMC will automatically detect views based on material type no need to maintain manually based on information we maintain views will get selected
Hi Ruthwik
LTMC is out good old friend. Quite innovative one is it, indeed.
I just looked at CVT_MATNR, starts with statics: ... well, I am prepared to find go to as well.
We still have a bad clue that 65% and 83% are somehow hardwired...
Regards
Janos
Hi Ruthvik,
This is is awesome & excellent information.
Thank you.
Best Regards
Mahi
Hi Padmanabha Rao Mahisarla
Glad you liked
Thank you 🙂 very helpful
Thanks.. Very Nice n very informative...
Excellent content, it was help full Thanks .
Hi Ruthvik,
Thanks for the detailed steps...
Question: Do have any blogs/YouTube Videos to build an LTMC object to update a specific filed??
For example we have list of Materials that are already exist in S4 that we need to update Purchasing Group.. how can I build a LTMC Object to update Purchasing Group on given materials??
Thanks in advance...
How to Customize LTMC | SAP Blogs
https://youtu.be/CIwOeYg6SV8
Hi Ruthvik
when I run LTMC and it fires up webdynpro.... There is a message that says
You can use the app Migrate Your Data – Migration Cockpit to migrate data to SAP S/4HANA. You can access this app in the Fiori launchpad.
Hi Jonny Wellard
the Blog I wrote with SAP S/4HANA 1909 from 2020 version LTMC is replaced with Migrate your data app
reffer
LTMC replaced with Migrate Your Data | SAP Blogs
LTMC replaced with Migrate Your Data (2/2) | SAP Blogs
Hi Ruthvik,
Can you please help this guy? i dont have system to check and respond him.
Thanks for this very useful article. First time I read this, and I find it useful.
I have a query, you mentioned for now you haven't attempted 'changing existing objects' via LTMC.
We are in 1709 version, and I need to modify Internal Order settlement rules specially adding additional rows with revised validity, having modified Profit Segment and COPA derivation based on customer specific attributes. Is there any predefined template as a mass change available?
I tried using our custom-developed mass change program, however, I observed we can add new rows with new From/To Year/Period only, without any changes to Profit Segment at each IO level.
After uploading the new row, we are obliged to manually edit the profit segment for fresh derivation, where not all key fields are derived, certain fields are left out.
Any clue how to go about it? I thought of enhancing the existing custom-program, but meanwhile, trying to see if there is an alternate workaround.
Please advise from your experience.
Regards, Sivasankaran S
@SIVASANKARAN SUNDARESAN
Hi Ruthvik,
Very helpful & excellent content. Thanks