/SCWM/AQUA - Available Quantity
Available Quantity information is stored in SAP table /SCWM/AQUA.
It is part of development package /SCWM/CORE in software component SCM-EWM-WOP. This development package consists of objects that can be grouped under "Core Functions of WME".
It is part of development package /SCWM/CORE in software component SCM-EWM-WOP. This development package consists of objects that can be grouped under "Core Functions of WME".
Fields for table /SCWM/AQUA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| GUID_PARENT | Parent GUID | X | /LIME/GUID_PARENT | RAW | 16 | |
| GUID_STOCK | GUID Stock Item | X | /LIME/GUID_STOCK | RAW | 16 | |
| LGNUM | Warehouse Number/Warehouse Complex | /SCWM/LGNUM | CHAR | 8 | /SCWM/T300 | |
| LGTYP | Storage Type | /SCWM/LGTYP | CHAR | 8 | ||
| LGPLA | Storage Bin | /SCWM/LGPLA | CHAR | 36 | ||
| RSRC | Resource (Means of Transportation or User) | /SCWM/DE_RSRC | CHAR | 36 | ||
| HUIDENT | Handling Unit Identification | /SCWM/DE_HUIDENT | CHAR | 40 | ||
| TU_NUM | Internal Number of Transportation Unit | /SCWM/DE_TU_NUM | CHAR | 36 | ||
| FLGMOVE | Indicator: Handling Unit is Being Moved (Open HU WT) | /SCWM/FLGMOVE | CHAR | 2 | ||
| .INCLUDE | /SCWM/S_STOCK | 0 | ||||
| MATID | Product | /SCWM/DE_MATID | RAW | 16 | ||
| BATCHID | Batch | /SCWM/DE_BATCHID | RAW | 16 | ||
| CAT | Stock Type | /LIME/STOCK_CATEGORY | CHAR | 4 | ||
| STOCK_DOCCAT | Type: Sales Order Stock or Project Stock | /SCWM/DE_STOCK_DOCCAT | CHAR | 6 | ||
| STOCK_DOCNO | Number of the Sales Order or Project for Special Stock | /SCWM/DE_STOCK_DOCNO | CHAR | 70 | ||
| STOCK_ITMNO | Sales Order Item for Sales Order Stock | /SCWM/DE_STOCK_ITMNO | NUMC | 20 | ||
| DOCCAT | Doc. Category for Doc. Reference and Doc.-Related Stock | /SCWM/DE_DOCCAT | CHAR | 6 | ||
| STOCK_USAGE | Stock Usage | /LIME/STOCK_USAGE | CHAR | 2 | ||
| OWNER | Owner | /SCWM/DE_OWNER | CHAR | 20 | ||
| OWNER_ROLE | Partner Role of Owner | /LIME/OWNER_ROLE | CHAR | 4 | ||
| ENTITLED | Party Entitled to Dispose | /SCWM/DE_ENTITLED | CHAR | 20 | ||
| ENTITLED_ROLE | Partner Role of Party Entitled to Dispose | /SCWM/DE_ENTITLED_ROLE | CHAR | 4 | ||
| STOCK_CNT | Counter for Stock Separation | /SCWM/DE_STOCK_CNT | NUMC | 12 | ||
| CHARG | Batch | /SCWM/DE_CHARG | CHAR | 20 | ||
| QUAN | Available Quantity | /SCWM/DE_AVLQUAN | QUAN | 16 | ||
| UNIT | Base Unit of Measure | /SCWM/DE_BASE_UOM | UNIT | 6 | ||
| ALTME | Alternative Unit of Measure for Stockkeeping Unit | /SCWM/DE_AUNIT | UNIT | 6 | ||
| VFDAT | Shelf Life Expiration Date | /SCWM/SLED | DATS | 16 | ||
| WDATU | Date and Time of Goods Receipt | /SCWM/LVS_WDATU | DEC | 8 | ||
| INSPTYP | Inspection ID Type | /SCWM/DE_INSPIDTYP | CHAR | 2 | ||
| INSPID | Identification of a Quality Object | /SCWM/DE_INSPID | RAW | 16 | ||
| COO | Country/Region of Origin | /SCWM/DE_COO | CHAR | 6 | ||
| OUTCON | Storage Bin Improvable | /SCWM/DE_OUTCON | CHAR | 2 | ||
| SKZSI | Blocking Indicator: Current Inventory (System) | /SCWM/LQUA_SKZSI | CHAR | 2 | ||
| READ_QUANTS | Read Quants for Stock Removal | /SCWM/DE_READ_QUANTS | CHAR | 2 | ||
| BRESTR | Batch in Restricted-Use Stock | /SCMB/MDL_DZUSTD | CHAR | 2 | ||
| LOGPOS | Logical Position of Handling Unit | /SCWM/DE_LOGPOS | CHAR | 4 | ||
| .INCLUDE | /SCWM/INCL_EEW_AQUA | 0 | ||||
| DUMMY_FIELD | Dummy function in length 1 | DUMMY | CHAR | 2 |