Stock tables in EWM

[sandeep_pv]

Hi All,

I am new to EWM.

I know few stock tables in EWM like

/SCWM/QUAN,

/LIME/NQUAN etc.

But do we have any table like WM LQUA? Similar to that where we get all stock information?

Please let me know.

Thanks

[Former Member]

Hi PV S

I usually use FM: /SCWM/HU_SELECT_GEN for find the stock.

BR

[Former Member]

Hi PV,

Please find the details..

/SCWM/AQUA - Available Quantities

• Updated at Warehouse Task creation;
• Can be negative (it depends on your Customizing);
• Contatins the quantity that is available for Warehouse Task creation;
• Entry is deleted if quantity is zero.

/SCWM/QUAN - Attributes to Physical Stock

• It has the attributes to a physical stock quantity;
• For example: GR date, best before data, country of origin, delivery reference, etc.;
• Entry is deleted when corresponding quantity in /LIME/NQUAN is zero.

/LIME/NQUAN - Physical Stock

• Only needed for open Warehouse Tasks;
• Reserve specific quantity for the Warehouse Task;
• Entry will be set to zero when Warehouse Task is confirmed or cancelled;
• Must NEVER be negative.

Hope it is useful.

Regards,

G.V.Shivakkumar

[former_member190267]

Hi,

Do you mean a table to check the available stock?

There is /SCWM/AQUA.

More information here:

https://wiki.scn.sap.com/wiki/display/SCM/EWM+Main+Tables

Best regards,

Natalia