SAP EWM - tables unavailable stock

[sappallet]

Hello ladies and gentlemen,

everyone knows the list with the typical EWM tables which stock is kept where datawise.

But there is no Information about physical stock being unavailable e.g. due to open WTs but still on a bin waiting to be moved. Or other way round the delta between physical stock and available stock not yet on ressources.

Does the /SCWM/AQUA contain all stock on bin data until it leaves the bin and moves on a ressource? Just with the reduced quantity or in case you want to pick the whole quantity it shows field SCHWM/AQUA-QUAN = 0? Where does /LIME/NQUAN = physical stock e.g. in the monitor gets it's link to a bin from?

Thanks

C

[MarekKaminski · Accepted solution]

Hello,

I think that the standard warehouse management monitor give you enough information about stock (also with stock reserved for warehouse task).

Please look at screenshot from warehouse management monitor:

You see how many pieces we have physically and how many is reserved, e. g. for bin M718-718-043-06 the 108 pcs is incoming quantity but for bin 7003-253-071-03 the same quantities are as outgoing quantity.

If you want to display also the stock in resource you have to check relevant options in selection screen:

These are the stock tables:

/SCWM/AQUA - Available Quantity

/SCWM/QUAN - Quant Attributes

/LIME/NQUANLIME – Stock Quantities (EDIT: should be /LIME/NQUAN)

/SCWM/STOCK_IW01 Stock GUID from table

/SCWM/STOCK_IW02 Stock GUID from Batch managed stock

/SCWM/STOCK_IW03 Stock GUID from refernce stock PDI and PDO

/SCWM/STOCK_IW04 Stock GUID from Special stock

Best Regards,

Marek

[former_member753543 · Accepted solution]

good afternoon, how can i check these tables that you mentioned earlier in transaction SE16N? I didn't find it by the names of AQUA, QUAN etc ...

[MarekKaminski · Accepted solution]

Hi there,

prrr It works, I checked it in SE16:

And here is the result:

And there is a mistake in my previous answer. I mean the table: /LIME/NQUANLIME - it should be /LIME/NQUAN

Best Regards,

Marek