How to update all bin location to System-Bin-Location via DTW?

[former_member908495]

Hello, I am in the process of learning and testing SAP before implementation.

I would like to remove all bin location currently registered using GRPO in SAP. (Pre-scanner/barcode printer)

I would like to update all stock to the default System-Bin-Location, Warehouse 01 so 01-SYSTEM-BIN-LOCATION.
And then re-assign the items to specific bin-location using the scanner.

I know how to do it manually using Bin Location Master Data but it is done 1 by 1.
Is it possible to do it via DTW?

Thank you!

[Former Member]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with: https://community.sap.com/resources/questions-and-answers, as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your profile you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html

Questions on how to draw responses from members? Check out this discussion on how to improve questions. https://groups.community.sap.com/t5/welcome-corner-discussions/advice-from-sap-champions-questions-a...

[nikunjmehta2290]

Hi aceytseng ,

Default bin to assign the item master is possible via DTW. You can use the template

Kind regards,

Nikunj Mehta

[former_member908495]

Dear Nikunj,

Thank you so much for noticing my newbie inquiry.

I'm trying the template now using Data Transfer Workbench (DTW).

Master Data > Update Existing Data

> Inventory > Item Master Data

But only the ParentKey is matching.

I removed Line Number because we are not using it.

1. Also, the template only calls Item Code but under Item Code we have Serial Numbers.

Item Code: ABC

Qty: 5

Serial Number under Item Code ABC are: A111, A222.. to A555

We need to change the bin location of the Serial Numbers to default SYSTEM BIN LOCATION, not the Item Code. Or is changing bin of Item Code affect all Serial Numbers under it as well?

2. For DefaultBin, I put 01-SYSTEM-BIN-LOCATION

3. For DeafultBinEnforced, I put "Y"