Product Information
LTMC Master Data (BP – Supplier) 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. The 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 | 200MB 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
Now let’s See Spets to upload Supplier As BP in SAP HANA System
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 General, Sheet Fill All the mandatory fields and also other important fields
- If you want to create an organization: fields 4-7 are relevant;
- If you want to create a person: fields 8-12 are relevant.
11. In BP Roll Sheet maintain BP Supplier Finance Accounting & Supplier Roles As its Supplier Template General Roll will be created automatically as we maintain General Data in General Sheet
12. In Additional Address, Sheet maintain All Mandatory fields along with Address fields
Please make sure in General Sheet and in Additional Address sheets maintain External Address Number differently it’s just for identification purpose
13. in Company Code Sheet Maintain Reconciliation Account Number As per Business
14. In Purchase Organization Sheet maintain All mandatory fields along with other parameters which are important to business
15. In Partner Functions, Sheet maintain Partner Function “LF” if its Supplier and Vendor name Same as Vendor Which is Creation
16. 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
17. Click Activate
18. Click Start Transfer
19. Data will get Transferred once its done Close button will get enabled
20. If any error or data is missing will get error hear if all data in templet is good we can proceed further
21. Click next
22. When we are executing for the first time particular object in a project we need to Map fields.
23. Click each line item and do Mapping of Values
24. Select Line Item and Click check once status turns in to Green Light click save so next time system will do the mapping automatically
25. Once all the mapping is completed and no open items click next to simulate Import
26. Similar to upload once its completed click close to proceeding further
27. Backed Program will execute and data gets simulated if any missing data of mandatory fields and fields Mapping is wrong
28. If any error go back and fix and repeat same if no error click Next
29. If all the steps are completed without any error will get the above message then click finish.
Migration Status is now Finish
- Now Check whether BP Is created or not
- Open Maintain Business Partner App
3. The supplier has been Created As BP with Required Roles
For uploading data without any error try with one Supplier and will get a lot of errors when doing initially do trial and error so will get Expert in LTMC.
Hi Ruthvik
Nice Document. Thanks for Sharing
Thanks & Regards,
Ramkumar RV
Thank you very much Ramkumar ?
Hi Ruthvik
Nice Document. Thanks for Sharing
Thanks & Regards,
Ashfaq Ahmad
Thank you Ashfaq
Excellent explanation, thank you very much for sharing your practical knowledge to S/4HANA world
Thank you Sai Krishna, Its's my pleasure
Dear Ruthvik
You forgot about BP Role 000000 - General address and without BP Role 000000 you can't create vendor completely. Once you check your vendor which you have created, I think you may get an error if you display or change the vendor.
If you have any document of BRF+ then, please mail on jayababu1010@gmail.com
Thanks
Jay
Hi Jay,
I didn't forget anything if you see properly in the first sheet "General Data" If we maintain parameters system will automatically create BP General Role.
once again read Blog fully Vendor is created without any error, check the last screen shoot its created with all roles.
Once you also try the same if you got the chance to upload LTMC in 1809 or latest version
i am getting error like "No update is defined for BP role 000000"
please Help
Dear sir.,
Thank you so much for your blog,
I have a question, how to pay freight charges to the freight vendor in S4hana?
Actually, in ECC, There’s is an option in MIRO (Planning delivery cost) to pay freight charges, But in S4hana there is no option to pay freight charges to the freight vendor?
also ERS?
So, what is the process to pay the freight charges to the freight vendor?
Note: With respect Bill of landing we can pay
Thank you
Jai
Sorry no idea
Thank you so much dear
Hello Ruthvik Chowdary Vennamaneni
Is there a Migration object for Supplier mass change? in order to change some parameters like payment terms & account details.
Yes we do have Migration Object for Supplier change in LTMC, if im not wrong check with Supplier change / customer change
Thank you Ruthvik very much it worked
Hello Ruthvik,
I am using S/4 HANA 1809, can you guide me to where i can find the Migration object for supplier change please ?
Check with Vendor Change you will find
Hi Ruthvik,
Really very good document (LTMC) .
Please can you share new functionality in 1909 sourcing and procurement.
Currently am working on 1909 , need to innovations.
Thanks in Advance.
Vijay
Sure Once I gathered all Changes of 1909 will share
or else refer to https://help.sap.com/doc/b870b6ebcd2e4b5890f16f4b06827064/1909.000/en-US/WN_OP1909_EN.pdf
Thank you for sharing it's really a good tool with templates
BR
Vyomakesh Bharadwaj Racherla
Glad you liked Racherla Vyomakesh Bharadwaj
Follow me to get like this continues Updates
Hi ruthvik,
I would like to know if you can mass update BP(vendors) in S/4 HANA using LSMW or any other way cause i am trying to update the migrated data using an EXCEL file with 500 records.
Thank you,
Manjunath
Hi Jagadesh Chukka
Yes, you can use other workarounds if LTMC is not working in your case you can use Badi to mass upload.
However LTMC should work because in one of my project I uploaded almost 800+ in a single shot, but business to business requirement and fields changes
Hello,
Could you guide me?
For 2021 version what is the migration object that allows you upload changes trought LTMC. I do not see anymore Customer/Supplier Change.
migration object customer master data
There is no Customer/Supplier Change in Migration Cockpit. you need to go for custom program to make change to BP
Hello, thanks for the article, very useful, I have a problem to upload a new project using Customer – extend existing record by new org levels, I Already create a project and use the object, all the task works fine but nothing happened in a ERP, so I deleted the project and try to create a new one. When I try to load de file, the system show me the message “Error al cargar, El nombre del fichero no es valido o el fichero es demasiado grande”. I use the same file, also I download the templante and try again, but the same error.
Please help, I don’t know what else to do.
Hi Carlos Garcia
Whats the file size you are trying to upload ?
Dear Ruthvik Chowdary Vennamaneni
thanks for your valuable steps & notes on LTMC,
just note in ltmc for S4hana ver 1809 FPS2
when try to upload accounts payable open item ( credit balance ) cant find who to upload coz it is only available to load only debit , which is not realistic , hope to find answer with your
thanks
Hi Ahmed Ibrahim
I'm Logistics side you can reach out to Sai Krishna Vallurupalli for Finance related
Hi Ruthvik,
Thanks for the fantastic sharing~
I'm not sure do you have any idea is it possible to migrate the supplier with different numbering against Business Partner number using LTMC cockpit?
for example: Business Partner: ABC Vendor Number: 100
Hi Kevin Wu
That need to be Done as CVI, not as Migration by using LTMC
Dear Ruthvik Chowdary Vennamaneni
Got it. Thank you very much!
Hi Ruthvik Chowdary Vennamaneni
Great Document. thank you for this document
Thank you Manoj Kumar Glad you like my Article
Hello Ruthvik.
This document contains a very clear and thoroughly explanation.
Many thanks Ruthvik.
You are a professional!
You saved me a lot of hours of searching.
5 stars of 5 🙂
Thank you Mirel Monigu
For your comment follow me to get more such useful information
Hello Ruthvik.
Very nice post! Congrats
In my case I am uploading customers, but data from company code (KNA1) and sales area (KNVV) do not get ERP.
Very confuse now, cause template seems to be filled properly.
Any idea?
BR,
Guillermo
Replying myself,
LTMC does not provide some information about mandatory fields in customizing and I do not have filled in migration template. Consequence is just general data was created, not company code data either sales area data, even the mandatory fields belonged to sales area!
I checked in transaction MDS_PPO2 this error, filled these data and everything works!
Thanks for your answer..!! It really helped.
Hi Rutwik
In the file generated by SAP, vendor id is a mandatory , in case when our BP grouping uses internal number range how to make mandatory fields as optional?
Hi Praveen,
2. Just Activate and click on Start Transfer. Ignore the Information messages on the Number range. Click 'Next' .
3. In 'Confirm Mapping' list, take the 1st record, 'Vendor Internal/External assignment'. In the S4 Hana Target, select the Drop Down -> 'Internal Number' and confirm the Mapping.
Proceed with the next steps. BP gets created with the Next Internal Number and Vendor gets created as per your setting. There will be some Skips in the Number due to the Number Buffer loss.
HI Thanks,
In my scenario BP (Business Partner Number)is external... Though I have maintained External number it is giving error as "BP01 is External umber range enter number"
How to resolve? mine is 1909
Thanks in anticipation
Prasad
Hi Praveen Kunda,
Vendor ID is not the BP code , it just the link between each Excel sheet.
BR,
Guillermo
Hello
How are you doing?
Can we create supplier with internal number range after made a changes in LTMOM like visible or not visible.
I am trying to create, and it is possible for only one supplier for internal number . If I want create more than one then it can't.
But, It is possible to create multiple suppliers using external number range.
So, I want know, can we create multiple supplier using internal number range ?
Thanks
Jayababu
Yes we can create with internal number range but that internal number range we need to give manually in template itself by seeing what's last number used in system
Many thanks for your reply sir,
I will do the same.
Hello Ruthvik,
Thanks for sharing the excellent blog.
I am loading the supplier master data through LTMC process, but at the second last step(Simulation Import), I am getting an error stating as "Name LFA1 is invalid".
Could you please help me with this.
Thanks
Prateek
Once check what Partner Functions you have selected and also once cross check in convert values step the field mapping
Hi,
Initially I have not maintained the Partner functions for this load and kept that sheet as blanked.
I think its not mandatory to fill this sheet, as it doesn’t gave any error in the validation step. Please confirm.
But even after maintaining the partner function its still giving the same error
Mapping
Thanks
Hi - We have to transfer all master data from an old ECC system to S4 HANA 1909. Kindly let me know if direct data transfer features can transfer all master data from ECC to S4 HANA.
Client also needs last 2 years financial data. What tool is available in SAP to transfer last 2 years financial data? Through SDI or SLT, can we do so as LTMC does not support historical data?
Hi Ruthvik,
Need to upload supplier master in S/4HANA 1909 using LTMC. But we are using external number ranges for BP as well as vendors. Also we are not using "same no" concept i.e. BP code and its related vendor code will be different due to different external number ranges assigned to relevant BP grouping code and vendor account group.
How to use the supplier template for uploading the same, since template only has vendor code column and not BP code column.
Excelent. Nice document Ruthvik.
Thank you Manuel Robalinho
Hi Ruthvik,
Need to upload supplier master in S/4HANA 1909 using LTMC. But we are using external number ranges for BP as well as vendors. Also we are not using "same no" concept i.e. BP code and its related vendor code will be different due to different external number ranges assigned to relevant BP grouping code and vendor account group.
How to use the supplier template for uploading the same, since template only has vendor code column and not BP code column.
Hi Ruthvik,
The template don't have maximum stock level, availability check and per. unit price (PVPRS_1), do you have any idea how include these fields.
Thanks
https://answers.sap.com/questions/13359558/grouping-zfiv-has-internal-number-assignment-do-no.html#
Hi
Would u like to help me please.
My BP number range is Internal but Vendor number range is External.
When I am uploading through LTMC this message is shown (Grouping ZFIV has internal number assignment; do not enter a number : Message no. R1092)
* I Can't Change BP number range internal to external due to some vendor created.
Hi, Ruthvik Chowdary Vennamaneni
How can I match field in the bp to a template LTMC?
For example, I need to load '01' into LFB1-ZGRUP, but I can't find the matching field in the template Supplier.
Best regards
Hello Ruthvik Chowdary Vennamaneni ,
If i want to load 2 different types of business partner suppliers in S4 HANA using LTMC or "Migrate your data" fiori app & for one of the set of business partner suppliers Number range is internal & other sets of business partner suppliers , number range is external
then is it possible to create 2 different projects in LTMC / "migrate your data" Fiori app & load both these business partner suppliers through these 2 different projects?
I saw this below value mapping only once during first supplier project in LTMC tcode & i selected "internal", in the new project created i couldnt see this value mapping again to change it to "external" number range
LTMC Supplier number range internal or external configuration
Regards,
Ashish Shah
Yes for that internal and external number range you need to maintain 2 projects because number range is an object dependency
Hello Ruthvik,
can purchase orders, invoices etc. also be migrated with LTMC?
Thanks.
Hi Ruthvik Chowdary
I am using the latest 2021 version of Fiori app to upload Supplier data. This template doesn't contain all roles. For example I need to extend Carrier role to the supplier. Existing template doesn't have any fields related to Carrier. How to add a new role to the template. Please share if any documentation available to add a new role for BP.
Thank you in advance.
Regards,
Venkat