Picking according to remaining shelf life

[former_member1182023]

Dear SAP experts,

I have a requirement to create a dynamic picking strategy according to shelf life; i have 2 types of orders Export and domistic.

for Export orders minimum remaining shelf life should be >= 80%

For Domistic Orders minimum remaining shelf life should be >= 50%

and this is how we calculate remaining shelf life percentage (( Expiration Date - Today Date)/(Expiration Date - Production Date)) %.

Curently we achived this through a user exit "Hardcode" the question is do we have a standard way to do it?

thanks in advance

[Andreas_Mergler]

Hi all,

I know I am commenting on an older discussion, but looking at this post by shailesh.mishra5 may help here:

https://blogs.sap.com/2020/03/18/batch-determination-with-object-dependencies.-picking-batches-with-...

BR Andreas

[former_member543347]

Hi Mohamed,

There is a way to do it in standard, but it will only be practical if you have very few products.

• You define two ERP storage locations (and therefore two EWM availability groups). Let's say that your stock type 8F is free stock with >80% SLED and 5F is free stock with >50% SLED. For stock with under 50% you probably want a different availability group, or you just block it.
• You plan the standard report /SCWM/R_STOCK_TYPE_CHANGE as a background job to periodically post from 8F to 5F everything that is under 80% SLED (and possibly from 5F to some other stock type for whatever is under 50%). This is the difficult part of this setup; as the percentage of remaining shelf life is not a criteria in this report, you will need to create many variants, maybe up to one per product. High maintenance.
• Then you need to make sure that your export orders request stock type 8F and your domestic ones, stock type 5F. Working with standard stock determination, you will allow 8F when the requested stock is 5F, but not the other way around.

So theoretically it is possible in standard, but due to high maintencance, you probably prefer the BAdI.

[katrin_kraemer]

Hello Mohamed,

Maybe you can use the following elements to set up a process:

In /SCWM/MON there is the node Stock and Bin -> BBD/SLED Overview. There you can select stocks that you cannot use any more and change the stock type. For example 80% left is F2, 50% left is F3 and <50% is F4 (or a blocked stock).

You could also use different stock types for export/ domestic and create stock removal strategies to let export outbound delivery orders (via their warehouse process type) search for stock with the 80% SLED/BBD in F2 only and domestic in the stock types for 50% and 80% in F2 and F3. Stock that has less shelf life left is in F4 and will not be found.

Alternative: Batch selection criteria (entered in VL01N). But to have them in mass processing will probably need some code as well. And having batch selection criteria is performance consuming during stock determination.

Regards,
Katrin

[former_member1182023]

Hello Katrin,

Thank you for the comment, i can understand from the descryption that its more like a manual way to set stock type. im not sure if understood correct or no but im looking for more automatic way and im trying to get red of the code as its baking my standard process that work for all my processes without codes.

Best Regards,

[JuergenPitz]

Hi,

how should there be a standard way for such a requirement?

In EWM: There is a BAdI "Filtering and/or Sorting of Quants", there you can define your filter. But there is no way to solve this without your own coding.

Brgds

Juergen

---
Want to influence SAP software development decisions for EWM?
https://influence.sap.com/ewm2019

Want to learn EWM?
Check for EWM courses @ https://training.sap.com/trainingpath/Applications-Logistics+Execution+%26+Warehouse+Management-SAP+...
Get a SAP Learning Hub Subscription: https://training.sap.com/shop/learninghub

And it is EWM. NOT eWM - Duh!
And if your question includes the word "transfer order" - do NOT tag the question with Extended Warehouse Management!