Skip to Content

This blog helps you to understand step by step process in order to migrate Location and Logistics Areas in Business by Design system.

When you have to create multiple Locations and Logistics area manually in Business By Design system , it is time consuming and tedious to do so. The best way to create Location and Logistics area is through importing data via Migration of Location and Logistics Area by filling the legacy data in  migration template.

The location and location layout concept enables you to design a detailed model of your company’s supply chain. The location represents an external view of your company that helps you to communicate with your business partner. The location layout on the other hand represents an internal view of your company’s structure. It allows for an integrated material flow for warehousing and production through a common layout. You can centrally maintain the layouts of the different sites and locations within your company.

Note: Location should be unique and records to be imported to be limited 5000

Tasks

1)Fill the Migration template , Refer to Documentation sheet and Field List sheet to view the explanation of Fields and Field value in the Migration template.

2)After filling the data in migration template, Change the Excel file format to XML Format

2) Migrate Data Using the Migration Tool

Navigate to Business Configuration Work Center and Overview View , search for Migration of Location and Logistics Area, Select the activity as highlighted below.

 

 Further select “Migrate Location and Logistics Area using the migration tool”

 

After filling the Migration Template convert the excel file format to xml type and upload the migration file

 

 Select Browse to select the Migration file path.

 

File is ready for Migration , as it is successfully uploaded.

 

Now select Execute Migration under which select Execute Migration Step by Step

 

Step1:Validate File is completed

 

Click on Next to initiate Step2

 

Step 2: Convert Values, Click on Next to initiate step 3

 

Step3 :Simulate Import initiated

 

Imported Successfully

 

Imported Successfully without any errors, Click on Next to initiate Step 4

 

Step 4: Execute Import, Click on Yes to continue.

 

Data Import successful

 

 

Click on Finish to initiate Step 5: Confirmation

 

We observe below  data imported successfully.

Verify the migrated Location and Logistics area in Supply Chain Design Master Data Work Center , Locations View. Compare the data in your legacy system with the data that has been migrated to the SAP solution. Check a certain number of records to ensure that the values in both systems match.

 

This completes the Migration of Location and Logistics areas process.

 

Regards,

Sandeep

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Sandeep,

    Is there a limitation for the number of logistic areas that can be created in one location? You mentioned that the migration tool is limited to 5000 records, but, could I create 10,000 logistic areas in one location in two uploads?

    Thanks

    Fernando

    (0) 
  2. Sandeep Y R Post author

    Dear Fernando,

    This Limitation for the number of logistic areas that can be created in one location mentioned above is only with respect to Migration perspective as it might cause performance issues at the time of uploading. Yes you can create 10,000 logistic areas in one location in two uploads.

    Regards,

    Sandeep

    (0) 
  3. Former Member

    Hello Sandeep,

    Do you have experience migrating logistics areas with Storage Control Profiles?

    There doesn’t seem to be any documentation regarding this and it could make the process quicker of filling out the migration template.

    I am currently trying to do this but I am receiving the following error message saying, “Logistics area XXXXX StorageControlProfile should be empty if Inv Managed Ind is unchkd”

    This of course doesn’t make sense to me since the profile already has the inventory managed indicator. I added the inventory managed indicator to the template and tried to simulate it again. However I then received the following error message,”Logistics area XXXX Mgmt of Logi Units should not be empty if Inv Managed Ind is chkd”.

    Its pretty much telling me that I need to add all the other columns to the template. However, the storage control profile already has this information.

    Any help of this would be appreciated.

     

    Best regards,

     

    Adriel Negrete

    (0) 
  4. Sandeep Y R Post author

    Dear Adriel,

    Please ensure you have maintained field value “Management of Logistics Unit” and “Blocked for Putaway”  in the migration template.

     

    Regards,

    Sandeep

     

    (0) 
  5. Former Member

    Hello Sandeep,

     

    Thank you for you response as this helped clear up those error messages!

     

    However, I am receiving one last error message, “Inventory-managed logistics area above already exists in the location layout”

    The migration tool doesn’t let me know what area is giving me the issue.

    I have looked through the template and I don’t have any parent logistics areas as inventory managed.

    Any idea of what this error could be for?

     

    Best regards,

     

    Adriel Negrete

    (0) 
  6. Sandeep Y R Post author

     

    Dear Adriel,

     

    Looks like you are trying to create nested locations with hierarchy,  I will have to check this further in your migration excel , Could you please attach the same, will check further and let you know.

     

    Regards,

    Sandeep

    (0) 
  7. Former Member

    Hi Sandeep,

     

    Can you migrate additional logistics areas below and already existing logistics area?

     

    I am trying to split up the layout into two migration templates in order to accommodate the 5000 max logistics area rule.

     

    I just want to make sure I can add additional child logistics areas via migration once the parent logistics area is already migrated.

     

    Best regards,

     

    Adriel Negrete

    (0) 
  8. Former Member

    Hi Sandeep,

    Thanks for the blog.

    Am trying to migrate the logistics area with material flow rules, am getting the error as “The Sequence ID of advanced material flow should be unique every time”. I checked in the system as well as template there is no repeat on the sequence ID. Could you please help us on this. Thanks

    BR, Ram

     

     

    (0) 

Leave a Reply