LQUA - Quants
Quants information is stored in SAP table LQUA.
It is part of development package LVS in software component LE-WM. This development package consists of objects that can be grouped under "Application development Warehouse Management (WM)".
It is part of development package LVS in software component LE-WM. This development package consists of objects that can be grouped under "Application development Warehouse Management (WM)".
Fields for table LQUA
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| LGNUM | Warehouse Number / Warehouse Complex | X | LGNUM | CHAR | 6 | T300 |
| LQNUM | Quant | X | LVS_LQNUM | NUMC | 20 | |
| MATNR | Material Number | MATNR | CHAR | 80 | MARA | |
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| CHARG | Batch Number | CHARG_D | CHAR | 20 | ||
| BESTQ | Stock Category in the Warehouse Management System | BESTQ | CHAR | 2 | ||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 2 | T148 | |
| SONUM | Special Stock Number | LVS_SONUM | CHAR | 32 | ||
| LGTYP | Storage Type | LGTYP | CHAR | 6 | T301 | |
| LGPLA | Storage Bin | LGPLA | CHAR | 20 | LAGP | |
| PLPOS | Position in storage bin | LVS_PLPOS | CHAR | 4 | ||
| SKZUE | Blocking indicator: for putaways (user) | LQUA_SKZUE | CHAR | 2 | ||
| SKZUA | Blocking Indicator: For Stock Removals (User) | LQUA_SKZUA | CHAR | 2 | ||
| SKZSE | Blocking indicator: current placement into stock (system) | LQUA_SKZSE | CHAR | 2 | ||
| SKZSA | Blocking Indicator: Current Stock Removal (System) | LQUA_SKZSA | CHAR | 2 | ||
| SKZSI | Blocking Indicator: Current Inventory (System) | LQUA_SKZSI | CHAR | 2 | ||
| SPGRU | Blocking reason | LVS_SPGRU | CHAR | 2 | T330 | |
| BDATU | Date of last movement | LQUA_BDATU | DATS | 16 | ||
| BZEIT | Time of last movement | LQUA_BZEIT | TIMS | 12 | ||
| BTANR | Document Number of Last Stock Change in Quant | LQUA_BTANR | NUMC | 20 | ||
| BTAPS | Item in transfer order of last stock transfer | LQUA_BTAPS | NUMC | 8 | ||
| EDATU | Date of last placement into stock | LQUA_EDATU | DATS | 16 | ||
| EZEIT | Time of last placement into stock | LQUA_EZEIT | TIMS | 12 | ||
| ADATU | Date of last stock removal | LQUA_ADATU | DATS | 16 | ||
| AZEIT | Time of last stock removal | LQUA_AZEIT | TIMS | 12 | ||
| WDATU | Date of Goods Receipt | LVS_WDATU | DATS | 16 | ||
| WENUM | Goods Receipt Number | LVS_WENUM | CHAR | 20 | ||
| WEPOS | Goods receipt item | LVS_WEPOS | NUMC | 8 | ||
| LETYP | Storage Unit Type | LVS_LETYP | CHAR | 6 | T307 | |
| MEINS | Base Unit of Measure | MEINS | UNIT | 6 | ||
| GESME | Total Quantity | LQUA_GESME | QUAN | 7 | ||
| VERME | Available stock | LQUA_VERME | QUAN | 7 | ||
| EINME | Stock for putaway | LQUA_EINME | QUAN | 7 | ||
| AUSME | Quantity to remove | LQUA_AUSME | QUAN | 7 | ||
| MGEWI | Weight of material | LQUA_MGEWI | DEC | 6 | ||
| GEWEI | Weight Unit | GEWEI | UNIT | 6 | ||
| TBNUM | Transfer Requirement Number | TBNUM | NUMC | 20 | ||
| IVNUM | Number of system inventory record | LVS_IVNUM | CHAR | 20 | ||
| IVPOS | Item number in inventory document | LVS_IVPOS | NUMC | 8 | ||
| BETYP | Requirement Type | LVS_BETYP | CHAR | 2 | ||
| BENUM | Requirement Number | LVS_BENUM | CHAR | 20 | ||
| LENUM | Storage Unit Number | LENUM | CHAR | 40 | LEIN | |
| QPLOS | Inspection Lot Number | QPLOS | NUMC | 24 | ||
| VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 16 | ||
| QKAPV | Capacity usage of quant | LQUA_QKAPV | DEC | 6 | ||
| KOBER | Picking Area | KOBER | CHAR | 6 | ||
| LGORT | Storage location | LGORT_D | CHAR | 8 | T001L | |
| VIRGO | Quant does not contain GR data | LQUA_VIRGO | CHAR | 2 | ||
| TRAME | Open Transfer Quantity | LQUA_TRAME | QUAN | 7 | ||
| KZHUQ | Indicator: Quant is on a handling unit | LQUA_KZHUQ | CHAR | 2 | ||
| VBELN | Delivery | VBELN_VL | CHAR | 20 | ||
| POSNR | Delivery Item | POSNR_VL | NUMC | 12 | ||
| IDATU | Date of last inventory of quant | LQUA_IDATU | DATS | 16 | ||
| MSR_INSP_GUID | Inspection GUID | MSR_INSP_GUID | RAW | 16 | ||
| .INCLU--AP | SGT_LQUA | 0 | ||||
| SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 80 |