Skip to Content
Product Information
Author's profile photo Ruthvik Chowdary

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

  1. 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

 

  1. Now Check whether BP Is created or not
  2. 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.

 

Assigned Tags

      57 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ramkumar RV
      Ramkumar RV

      Hi Ruthvik

      Nice Document. Thanks for Sharing

      Thanks & Regards,

      Ramkumar RV

       

      Author's profile photo Ruthvik Chowdary Vennamaneni
      Ruthvik Chowdary Vennamaneni
      Blog Post Author

      Thank you very much Ramkumar ?

      Author's profile photo Ashfaq Attar
      Ashfaq Attar

      Hi Ruthvik

      Nice Document. Thanks for Sharing

      Thanks & Regards,

      Ashfaq Ahmad

      Author's profile photo Ruthvik Chowdary Vennamaneni
      Ruthvik Chowdary Vennamaneni
      Blog Post Author

      Thank you Ashfaq

      Author's profile photo Sai Krishna Vallurupalli
      Sai Krishna Vallurupalli

      Excellent explanation, thank you very much for sharing your practical knowledge to S/4HANA world

      Author's profile photo Ruthvik Chowdary Vennamaneni
      Ruthvik Chowdary Vennamaneni
      Blog Post Author

      Thank you Sai Krishna, Its's my pleasure

      Author's profile photo Jai Muripindi
      Jai Muripindi

      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

      Author's profile photo Ruthvik Chowdary Vennamaneni
      Ruthvik Chowdary Vennamaneni
      Blog Post Author

      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

      Author's profile photo Amit Tawale
      Amit Tawale

      i am getting error like "No update is defined for BP role 000000"

      please Help

      Author's profile photo Jai Muripindi
      Jai Muripindi

      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

      Author's profile photo Ruthvik Chowdary Vennamaneni
      Ruthvik Chowdary Vennamaneni
      Blog Post Author

      Sorry no idea

      Author's profile photo Jai Muripindi
      Jai Muripindi

      Thank you so much dear

      Author's profile photo Former Member
      Former Member

      Hello Ruthvik Chowdary Vennamaneni

      Is there a Migration object for Supplier mass change? in order to change some parameters like payment terms & account details.

      Author's profile photo Ruthvik Chowdary Vennamaneni
      Ruthvik Chowdary Vennamaneni
      Blog Post Author

      Yes we do have Migration Object for Supplier change in LTMC, if im not wrong check with Supplier change / customer change

      Author's profile photo Former Member
      Former Member

      Thank you Ruthvik very much it worked

      Author's profile photo value pass
      value pass

      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 ?

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Check with Vendor Change you will find

      Author's profile photo Vijay Kumar
      Vijay Kumar

      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

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      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

      Author's profile photo Racherla Vyomakesh Bharadwaj
      Racherla Vyomakesh Bharadwaj

      Thank you for sharing it's really a good tool  with templates

      BR

      Vyomakesh Bharadwaj Racherla

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Glad you liked Racherla Vyomakesh Bharadwaj

      Follow me to get like this continues Updates

      Author's profile photo Jagadesh Chukka
      Jagadesh Chukka

      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

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      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

      Author's profile photo Carlos Garcia
      Carlos Garcia

      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.

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Hi Carlos Garcia

      Whats the file size you are trying to upload ?

      Author's profile photo Ahmed Ibrahim
      Ahmed Ibrahim

      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

       

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Hi Ahmed Ibrahim

      I'm Logistics side you can reach out to Sai Krishna Vallurupalli for Finance related

      Author's profile photo Kevin Wu
      Kevin Wu

      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

       

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Hi Kevin Wu

      That need to be Done as CVI, not as Migration by using LTMC

      Author's profile photo Kevin Wu
      Kevin Wu

      Dear Ruthvik Chowdary Vennamaneni

      Got it. Thank you very much!

      Author's profile photo Manoj Kumar
      Manoj Kumar

      Hi Ruthvik Chowdary Vennamaneni

      Great Document. thank you for this document

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Thank you Manoj Kumar Glad you like my Article

      Author's profile photo Mirel Monigu
      Mirel Monigu

      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 🙂

       

       

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Thank you Mirel Monigu

      For your comment follow me to get more such useful information

      Author's profile photo Guillermo Rodríguez Sánchez
      Guillermo Rodríguez Sánchez

      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

      Author's profile photo Guillermo Rodríguez Sánchez
      Guillermo Rodríguez Sánchez

      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!

       

       

      Author's profile photo Praveen Kunda
      Praveen Kunda

      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?

      Author's profile photo Praveen Panyam
      Praveen Panyam

      Hi Praveen,

      1. In the Excel,fill the Vendor with any number (Eg - If your BP Internal Number range is 5 digits, enter in Excel as 12345 in all the Tabs - General,Company code, Purchasing, Partner profile).

       

      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.

       

      Author's profile photo Amba Prasad Bonala
      Amba Prasad Bonala

      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

      Author's profile photo Guillermo Rodríguez Sánchez
      Guillermo Rodríguez Sánchez

      Hi Praveen Kunda,

       

      Vendor ID is not the BP code , it just the link between each Excel sheet.

       

      BR,

      Guillermo

      Author's profile photo Jai Muripindi
      Jai Muripindi

      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

       

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      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

      Author's profile photo Jai Muripindi
      Jai Muripindi

      Many thanks for your reply sir,

      I will do the same.

       

      Author's profile photo Prateek Agarwal
      Prateek Agarwal

      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

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Once check what Partner Functions you have selected and also once cross check in convert values step the field mapping

      Author's profile photo Prateek Agarwal
      Prateek Agarwal

      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

      Author's profile photo Soumyadeep Roy
      Soumyadeep Roy

      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?

       

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author
      Soumyadeep Roy by using direct transfer you can move from ECC to S/4HANA
      No idea about Financial data
      Author's profile photo SAP ADMIN
      SAP ADMIN

      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.

       

      Author's profile photo Manuel Robalinho
      Manuel Robalinho

      Excelent. Nice document Ruthvik.

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Thank you Manuel Robalinho

      Author's profile photo Andrew Brookes
      Andrew Brookes

      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.

       

      Author's profile photo Jenny Pezlo
      Jenny Pezlo

      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

      Author's profile photo Mofty Hossain
      Mofty Hossain

      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.

      Author's profile photo Alexander Trofimenko
      Alexander Trofimenko

      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

      Author's profile photo Ashish Shah
      Ashish Shah

      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%20Supplier%20number%20range%20internal%20or%20external%20configuration

      LTMC Supplier number range internal or external configuration

       

      Regards,

      Ashish Shah

      Author's profile photo Ruthvik Chowdary
      Ruthvik Chowdary
      Blog Post Author

      Yes for that internal and external number range you need to maintain 2 projects because number range is an object dependency