Product Information
Migration of Location and Logistics Area using Migration Template
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.
Note:
The Site is not created by migration; it is created when an Org. Entity of type Business Residence is created. When the site is marked as Logistics Relevant, a SPA is created for it.Once these settings are maintained the materials can be migrated. If the material information is being used in LoA migration, the migration of materials with the above steps becomes a pre requisite.
Regards,
Sandeep
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
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
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
Dear Adriel,
Please ensure you have maintained field value "Management of Logistics Unit" and "Blocked for Putaway" in the migration template.
Regards,
Sandeep
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
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
Hi Sandeep,
I was able to resolve the last issue. Thank you for your help!
Best regards,
Adriel Negrete
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
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
This helps! It’s a clear cut with images and neatly deafted. These kinda blogs helps! Good one Sandeep!