Sorting of locations -> /scwm/sbst

[michael_fallenbchel]

Experts,

need some hints regarding sorting:

My location is like that:

2IB02A1

2 is the hall

IB is the aisle

02 could be seen as the stack

A1 is the level

At the moment I'm sorting like that:

Sequence 1 (Stack, level, bin subdivision)

Sort Aisle Desc

Sort Stack Desc (not alternating)

Sort Level Asc (not descending)

Sort Subdivision Desc (not alternating)

No specific Division by stack

My location master data:

Level 1

Stack I (we have 4 areas in warehouse, this is area I)

Aisle IB

Subdivision empty

Depth always 1775 (as depth is 1775 cm)

Now when I create sort sequence, something "abnormal" happens, first 6 locations:

2IB02A1

2IB36A1

2IB04A1

2IB06A1

2IB38A1

2IB08A1

Question now - why first 02, then 36, then 04, 06, 38, 08

Does not make any sense for me?

Thanks

Michael

[JuergenPitz]

Hi Michael,

I agree, it should be working correct, can't really see right now why not.

Could you post a screenshot of one of your bins? And the structure definition?

Brgds

Juergen

---

Want to learn EWM?

Check for EWM courses @ https://training.sap.com/curriculum/scm_ewm

Get a SAP Learning Hub Subscription: https://training.sap.com/shop/learninghub

And it is EWM. NOT eWM - Duh!

[michael_fallenbchel]

Hi Jürgen,

see a bin:

And my structure definition is not used, should be copy of standard warehouse number 0001:

Regards

Michael

[JuergenPitz]

Hi,

sorry, but this does not fit. Shouldn't A3 be the stack? But it says F.

Brgds

Juergen

BTW: these are NOT locations, these are bins.

[michael_fallenbchel]

Already changed to stack 03, this causes correct sorting 😉

But still - as all bins have stack "I" in my example, the sorting makes no sense to me...

[Ajit_Routray]

Hi Michael,

Stack behave different in cases as number and character values If I understood correct.

which version are you using ?

Did you check with SAP ?

Many Thanks,

Ajit

[michael_fallenbchel]

Hi Ajit,

I'm on EWM 9.1, SP 0008
.

No, did not check with SAP until now - first I tried to solve here...

Regards

Michael

[Ajit_Routray]

Hi Michael,

Thank you for providing information.

There are 2 two type of sorting

Assign a sort sequence to a storage bin assignment for an activity area, using one of the following options:

• Explicitly enter the sorting
• Enter the criteria (sorting, path direction, pick mode) for your storage bin parts.
• Implicitly enter the sorting
• Enter only the storage type. You can leave all remaining fields blank. The system sorts by storage bin name in ascending order.

I guess it may be external sorting or AA bin sequence.

Assign the storage bins to activity areas using one of the following options:

• Explicitly enter all parts of the storage bins

To do this, enter the intervals for your individual

storage bin parts

(such as

Aisle Start

or

Aisle End

). Make these entries for all storage bin parts in the relevant storage bins, including the storage bin subdivisions. You have defined the storage bins in the storage bin structure. The system only assigns the relevant storage bins to the activity area if they are completely specified.

If you want to define your storage bins as a consolidation group, set the

Cons.Grp

• indicator.
• Implicitly enter the storage type
• Enter only the storage type. You can leave all the remaining fields empty. The system specifies the storage bins using the storage type, and assigns all storage bins within this storage type to the activity area.

Assign the storage bins to activity areas using one of the following options:

• Explicitly enter all parts of the storage bins

To do this, enter the intervals for your individual

storage bin parts

(such as

Aisle Start

or

Aisle End

). Make these entries for all storage bin parts in the relevant storage bins, including the storage bin subdivisions. You have defined the storage bins in the storage bin structure. The system only assigns the relevant storage bins to the activity area if they are completely specified.

If you want to define your storage bins as a consolidation group, set the

Cons.Grp

• indicator.
• Implicitly enter the storage type
• Enter only the storage type. You can leave all the remaining fields empty. The system specifies the storage bins using the storage type, and assigns all storage bins within this storage type to the activity area.

I guess Bin sequence also influence parameter.

Extended Warehouse Management->Master Data->Activity Areas->Assign Storage Bins to Activity Areas

Please check.

Thank you,

Ajit

[Ajit_Routray]

Hi Michael,

Please check Table: /SCWM/LAGPS ( check Sort Seq field )

Alternative,

Please check another Tcode  to upload the file /SCWM/SRTUP - Load Storage Bin Sorting

( Upload File )

Please let us know if you have further queries.

Best Regards,

Ajit

[michael_fallenbchel]

Hi Ajit,

that's exactly what I have done - check table for the sequence.

My example locations are numbered from 1 to 6 (first in sequence).

So the question is why EWM sorts a location with 36 before one with 04...

Upload could be possible, but I want to do it automatically if working

[Sandip_S]

Hi Michael,

Just tried the same scenario in my system however in sort sequence nothing is maintained.

System is sorting as below:

I guess, you just need to edit your sort sequence settings to get the correct sort sequence.

hope you have created the bins using /SCWM/LS10 instead of direct upload using bin upload transaction.

Thanks,

Sandip

[michael_fallenbchel]

Hi Sandip,

first, thank you very very much for testing!

That's exactly what I expect.

Strange thing is - in another storage type (instead of 2101 1101), everything's working...(same customizing behind)

If I check coding, looks like that:

So sorting by aisle, stack, level, bin sorting then depth.

What happens is that my real stack (02/03/04/...) is not used for sorting, as I use "I" for example as stack...

Still strange

What I have done now - instead of using the are as stack (I), I have changed the stack to the 02/03/04/.. - now sorting is working fine.

Not sure if I can go on like that, need to do some checks...but could be a solution.

And - I have uploaded bins, not generated

[Former Member]

Hi sandip,

I am having the issue .

Where we can edit the sort sequence setting for sorting bin.

Thanks in advance.

regards

Srini