Dynamic BIN Determination Based on Specific Requirement

[Arjun_Mukherjee]

Hello All,

I have seen lot of question's on the Bin Determination and concept of fixed versus dynamic bin determination but didn't find any example with Working Solution explaining the EWM standard functionality . So i have tried to put my understanding in words for the community who want's to understand EWM functionality through working example. 

Dynamic Bin Determination is a crucial requirement in Extended Warehouse Management systems. It allows for efficient utilization of storage space and improved inventory management by automatically determining the appropriate bin for  goods based on various factors.

Suppose Business have a scenario where Products are stored in Multiple Storage Location and multiple BIN but Picking need to happen based

• Available Quantity
• Goods Receipts Date and Time

Use Case 1: Product need to Picked from Storage Type and Bin which have Less Available Quantity with Good Receipt Data and Time

User Case 2: Product need to Picked from Storage Type and Bin which have More Available Quantity with Good Receipt Data and Time

Firstly the Picking rule need to be created based on the requirement i.e.

• Available Quantity in the Storage Bin
• Goods Receipts Date and Time

                                                                               Fig :1

                                                                                  Fig:2

Now as per the EWM Outbound Process perform below steps as per configuration :

• Step 1: Map Document Types from ERP System to EWM
• Step 2: Map Item Types from ERP System to EWM
• Step 3: Define Storage Type
• Step 4: Define Warehouse Process Type
• Step 5: Determination of Warehouse Process Type
• Step 6:  Determination of Storage Type Search Sequence
• Step 7: Assign Storage Bin to Activity Area
• Step 8: Define sort Sequence for Activity Area
• Step 9: Create Sorting Bin via TCode  /n/SCWM/SBST

Now as per the Scenario we will create the Transaction Data

Create Sales Order >> Create Outbound Delivery>>Display Outbound Delivery Request >> Create Warehouse Task>> Confirm Warehouse Task>>Perform Loading>> Perform Goods Issue

Current Stock Position in EWM :

In the Warehouse Order we can see the Source Bin determined in EEW1-03-20 reason being the Stock Removal rule is Performing check on below parameter:

1. System is checking the Bin in which Stock is Less as the Descending Checkbox is unchecked (Check Fig:1)
2. System is checking the Goods Receipts Date and Time

In the Warehouse Order we can see the Source Bin determined in EEW1-03-18 reason being the Stock Removal rule is Performing check on below parameter:

1. System is checking the Bin in which Stock is More as the Descending Checkbox is checked (Check Fig:2)
2. System is checking the Goods Receipts Date and Time

Conclusion :

• For Use Case 1:

Even though the Material is present in 2 Separate Bin but system preferred Bin EEW1-03-20 over EEW1-03-18 reason being

1. Our Stock Removal Rule is based on Available Quantity and Goods Receipts Date where Bin EEW1-03-20 have less quantity even though the Goods Receipts date is Higher

• For Use Case 2

Even though the Material is present in 2 Separate Bin but system preferred Bin EEW1-03-18 over EEW1-03-20 reason being

1. Our Stock Removal Rule is based on Available Quantity where is it less and Goods Receipts Date ,where Bin EEW1-03-20 have more quantity and the Goods Receipts date is earlier then Bin EEW1-03-20.

Let me know if this helps i will try to bring more working example from experience.