SAP EWM Physical Inventory for individual quants

[rahulsharma_iitr]

Hello gurus,

I have a bin where the 'available stock' is 1000 pieces. However, for the 'physical stock' there are two quants with 600 and 400 pieces respectively. The reason why I have two quants for physical stock is because of two goods receipts posted against two different Inbound Deliveries.

Now, when I create a Physical Inventory for this bin and then try to post the count (RFUI and also in desktop PC), system expects the user to enter - not the total count in the bin - but the count for individual 'quants'. So, if 2 pieces in the bin are missing, we cannot enter 998 pieces as the count- rather we have to enter lets say 600 for the first quant and then 398 (=400-2) for the second quant.

Is there a way to do the physical inventory stock 'count' at the 'bin level' and not really at the 'quant' level.

For a user perspective, it might be very cumbersome to break the total qty and enter the count for individual quants. Especially, if there are lets say 10 quants for a product in a bin (as they might have received on 10 different dates). I know its possible to mark the quants with 'zero stock' but still- its an extra work for them - especially if they really do not physically separate' these quantities received on different dates.

I am aware there is a relevant note 2726057 from SAP that talks about how entering the total count per quant is required. But it does not say if there is a setting somewhere to allow users to enter the total count per bin, and not per quant.

Is there any other way to make it more efficient?

Thanks in advance for your input.

[rahulsharma_iitr · Accepted solution]

I found the root cause of the issue I was facing.

I was under the impression that the checkbox 'Stor.Ctrl/Put.Compl.' in the Storage Type settings is relevant only for POSC (as is indicated in the F1 text for this field).

And as I am not using POSC, I had not marked this field for my Storage Types. The result of this was that I was getting a new quant created for the putaway of every new Inbound Delivery. And hence, the question from the Physical Inventory perspective.

I have now marked my Storage Types (even though I dont use POSC) with this field. The effect is that the system removes the link of the Inbound Delivery with the quant and hence, instead of creating a new quant each time, it keeps adding quantity to the existing quant - which was the expected behavior.

[JuergenPitz · Accepted solution]

Ah... I wanted to ask already what type of storage type and putaway rule you have. Because what you described sounded not right in general - that you have different quants, mixed storage, but without HU or anything else.

The flag: yes, this one is necessary for every final storage type. Doesn't matter if you use POSC or not. It is also relevant for LOSC!

Brgds

Juergen

[JuergenPitz]

Hi,

"Is there any other way to make it more efficient?"

More efficient? Maybe if you can figure out a way how the system should know from which quant a quantity is missing in your scenarios if you only enter the total quantity per bin. How is that supposed to work?

Brgds

Juergen

---

All the above is no official SAP statement.

Want to learn EWM?

Check for EWM courses: https://training.sap.com/trainingpath/Applications-Extended+Warehouse+Management-EWM+in+S4HANA

Get a SAP Learning Hub Subscription: https://training.sap.com/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!

[rahulsharma_iitr]

Hello Juergen,

Thanks for your input!

However, if I do a /SCWM/ADPROD to lets say move 20 pieces from the very same bin (from the same example) to another bin, system allows me to just enter the quantity = 20. It does not ask me from what 'quant' I want to remove it from. And then, when I post ADPROD, it just removes the quantity from one of the quants - if my observation is correct - by just 'alphabetically' sorting the quants - as the quant from which it removed the quantity was not even the oldest quant in the bin. The stock removal rule for the Storage Type is 'FIFO'.

I was wondering can we not somehow have the same behavior for the Physical Inventory - system allocating the 'counted quantity' to all the quants (sorting them).. and then the quantity in the last quant gets adjusted if the quantity 'counted' is any less than the 'system quantity'.