/SCWM/AQUA EWM Available Quantity
Holds aggregated available quantities in SAP EWM for stock removal and availability checks per product, batch, stock type, party entitled to dispose, storage type and storage bin. Stock removal strategies and the warehouse monitor use these quantities next to the physical stock (/SCWM/QUAN). GUID_PARENT points to the location and GUID_STOCK to the stock attributes; the table is maintained by the system and must not be changed directly.
S/4HANA status
SAP EWM object; it exists in embedded EWM on S/4HANA and in decentralized EWM systems, not in ECC LE-WM.
Main fields
| Field | Description | Key |
|---|---|---|
| GUID_PARENT | Parent GUID | Yes |
| GUID_STOCK | Stock GUID | Yes |
| LGNUM | Warehouse number | — |
| MATID | Product | — |
| QUAN | Available quantity | — |
| UNIT | Base unit of measure | — |
| CHARG | Batch | — |
| CAT | Stock type | — |
| ENTITLED | Party entitled to dispose | — |
| LGPLA | Storage bin | — |
Transactions working with this table
Reports using this table
Mass Stock Transfer Upload Between Storage Locations, Bins and Materials
A program that posts storage location to storage location, bin to bin and material to material stock transfers in bulk from one Excel template. Every …
Barcode Mobile Goods Issue App for Cost Center and Project (WBS) Consumption
A Fiori app that records material issues from the warehouse to a cost center or a project WBS element by scanning barcodes on a handheld or phone. …
Mobile Warehouse Count App with Bin and Barcode Scanning: Bin Checks, Difference Approval and Posting
A Fiori app in which warehouse staff enter counts from a phone, tablet or handheld by scanning the bin and the product barcode. The app checks that …
Automatic Consumption Posting on EWM Production Staging, Partial Consumption and Consumption Reversal from Handhelds
An EWM enhancement that consumes staged or picked materials to the production order by rule as soon as staging is complete. Partial consumptions such …
EWM Production Staging Cockpit with Pick Lists and Handover Tracking
A custom cockpit that manages picking and staging the components of production and subcontracting orders to the production supply area (PSA) in EWM …
EWM–QM Integration: Rule-Based Inspection Lots and Automatic Stock Routing After the Usage Decision
An EWM enhancement that decides with company rules when an inspection lot is opened for incoming material and, after the usage decision, routes the …
EWM Stock Packing, Transfer into Handling Units and Carton Label Printing
A custom program that packs free stock from a bin into cartons or pallets by quantity per carton, moves the resulting handling units to the …
EWM to ERP Production Consumption and Stock Type Reconciliation Report
A custom report that compares ERP consumption per production order with the quantity staged to the production supply area in EWM and the quantity left …
Can't find the report you need?
We also build anything that is not in the catalog. Describe it briefly and we will suggest the right solution.