Connect batch and HU

[former_member738707]

Good day.

I have situation - there are data from /scwm/aqua and some how i need to find what batches exist on available stock for futhar working (in ausp table i need to find correct batch for FEFO method when i creating warehouse task, it seems badi /SCWM/EX_CORE_RMS_DETERMINE can give me all data from /scwm/aqua). Search starts only from data /scwm/aqua (MATID, LGPLA etc) and i really don't know how can i connect my search steps to find what batches are exists in available cell (cell already founded due to badi execution). All tables lime, hu*, stock_iw*, hu_iw01, loc_iw*, quan doesn't give any idea to find batches.

Please, descibe how can i find list of batches wich are availeble at the moment of Wht creation.

Thanks a lot!

[Daniil]

Hi Dmitriy, it is little bit unclear what you want to do.

Do you want to implement special logic for the batch determination during wt creation?

available cell (cell already founded due to badi execution). not cell, but bin (storage bin). In General you can read physical stock for this bin, you will get all available batches, but if you want to use it for WT creation you maybe need to consider what Levent wrote.

If you need to decide if it is FIFO/LIFO/Whatewer you can do it with standard for example with different warehouse process types. You can as well implement on/off switch and use it in the badi for strategy determination. Strategy will determine FIFO/LIFO and so on. You can contact me if you need some more help.

[former_member738707]

Hell Daniil.

Let me explain what needs to be done.

Business requirment - due to picking Wht creation (for some warehouses customize due to STVARV or SM30)

we need to find relevant batches for method FEFO and make hard propose in Wht for this batch:

1) if client has SLED requirment in outbond request (for example mor then 80% of SLED and it comes from

AUSP-OBJEK= SCDL/DB_REQI-/SCWM/CUOBJ_BT) first we look this (this is alredy exist in stanard logic)

2) then we have to find necessary batch due to point 1 and method FEFO and add this data in Wht. So picker will see in RFUI what batch he needs to pick.

Thats why my question was - how can i faind data where batches and material connected or lay nearby or using GUID to connect data or etc to describe this logic to abaper then he can enhance logic of picking Wht creation due to badi /SCWM/EX_CORE_RMS_DETERMINE executing.

[Daniil]

Hi Dmitry,

So you have FEFO and additionally you have (not always) SLED requirement (Batch selection criteria).

You said that selection criteria already works by you, it means you only have to do FEFO customizing.

If as Levent said you set available quantity "Available Quantity: Batch-Specific" you get batch direct in your WT. No development needed. If you want to keep the available quantity as Batch neutral it be really complicated with a development, and it is probably enhancement would required, and it is relatively dangerous to violate standard availability level.

[Daniil]

and regarding batches, as I said you can read physical stock to get batches. If you have batch specific available stock, you should have batch info in Quat table (which you have in the Badi)

[lcaglar]

Hi Dmitriy,

The picking strategies not only depended on storage type setting. I have tried to give a specific answer to your question and answer is not about whole picking strategy.

So the question that you asked was, being not able to see any batch data on BAdI /SCWM/EX_CORE_RMS_DETERMINE and on table /SCWM/AQUA.

Business may require FEFO FIFO LIFO... on their picking process. If you want to use a batch specific "picking strategy" with standard way of working or with a custom development, system needs the "batch data" to determine the correct batch/quant.

When does the system try to determine the batch, based on the strategy? Answer is --> When system is creating the picking warehouse task.

In your case you dont have any batch data on BaDI or /SCWM/AQUA, There might be two options;

1. The stock that you are dealing with is not batch relevant. --> I assume your stock is batch relevant!

2. The storage type customizing for the available quantity. --> It effects your picking strategy, System does not know your business requirement. It only looks for the settings and if you set "batches will not be determined" during picking warehouse task creation, it does not determine the batch, it is so simple, therefore you can not see any batch data on BaDI or on available stock table AQUA. So you can not design your FEFO strategy for whole stock in your storage type.

[former_member738707]

Hello Levent.

Please, describe the second point "The storage type customizing for the available quantity" - how can i customize Wht creation on picking request that batch could be appear in data (may be in AQUA table or some where else)?

[lcaglar]

Hi Dimitriy,

Can you please check the storage type customizing. SPRO --> SCM Extended Warehouse Management --> Extended Warehouse Management --> Master Data --> Define Storage Type

If the Avail. Qty: Batches is set to "1 - Available Quantity: Batch-Neutral" --> you should change it to "Available Quantity: Batch-Specific".

[former_member738707]

Present setting:

[Daniil]

so it means you have Aqua on Matnr level (batch neutral), not on the bath level.

Your WT is created without batch, and batch is specified during picking. If you need batch specific WTs you need to change this setting.

[lcaglar]

Hi Dimitriy,

It depends on your "storage type" customizing. If the "Avail. Qty: Batches" indicator set to 1 - Available Quantity: Batch-Neutral, It is normal not to see any batch data on both objects, the badi RMS_DETERMINE and the table /SCWM/AQUA.

If the setting of the storage type is as I mentioned above, system does not propose any batch while the source quant is being determined when you are trying to create warehouse task. It means that you can not use the strategy FEFO. System waits to enter the withdrawn batch information when you are confirming the task, not when creating.

I hope it helps...

[former_member738707]

Hello Levent.

For only the whole storage type i can customize FEFO or LIFO, or etc am i right? I mean i can't customize batch determine FEFO when Wht creating??? How can i otherwise customize picking process with FEFO if it possible? There is technical condition from business to add FEFO process for some warehouses due to using STVARV or SM30 (so they wants to on\off instrument, and if i shall to change main setting of storage type it can injure system at all) table and only when Wht creates.

Thanks a lot for your answer!!!