LQUA is a standard Warehouse Management Transparent Table in SAP Logistics Execution application, which stores Quants data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for LQUA. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.

LQUA — Meta Data

Description: Quants
Main Category: Logistics Execution
Sub Category: Warehouse Management
Table type: Transparent Table (TRANSP)

LQUA — Table Structure, Fields(Columns) and Definitions

    Position Column Name Description Primary Key Data Type Length Check Table
    1 MANDT Client X CLNT 3
    2 LGNUM Warehouse No. X CHAR 3 T300
    3 LQNUM Quant number X NUMC 10
    4 MATNR Material CHAR 40 MARA
    5 WERKS Plant CHAR 4 T001W
    6 CHARG Batch CHAR 10
    7 BESTQ Stock Category in the Warehouse Management System CHAR 1
    8 SOBKZ Special Stock CHAR 1 T148
    9 SONUM Special Stock Number CHAR 16
    10 LGTYP Storage Type CHAR 3 T301
    11 LGPLA Storage Bin CHAR 10 LAGP
    12 PLPOS Position in Storage Bin CHAR 2
    13 SKZUE Block Indicator: For Putaways CHAR 1
    14 SKZUA Block Indicator: For Stock Removals CHAR 1
    15 SKZSE Blocking indicator: current placement into stock (system) CHAR 1
    16 SKZSA Blocking Indicator: Current Stock Removal (System) CHAR 1
    17 SKZSI Blocking Indicator: Current Inventory (System) CHAR 1
    18 SPGRU Blocking reason CHAR 1 T330
    19 ZEUGN Certificate Number CHAR 10
    20 BDATU Valid-To Date of Production Version DATS 8
    21 BZEIT Time TIMS 6
    22 BTANR Warehouse Task Number of Last Movement NUMC 10
    23 BTAPS Item in transfer order of last stock transfer NUMC 4
    24 EDATU Delivery Date DATS 8
    25 EZEIT Release order time TIMS 6
    26 ADATU Valid-From Date of Production Version DATS 8
    27 AZEIT Time TIMS 6
    28 ZDATU Date of last addition to existing stock DATS 8
    29 WDATU Date of Goods Receipt DATS 8
    30 WENUM Number of workdays in the year CHAR 10
    31 WEPOS Goods Receipt NUMC 4
    32 LETYP Storage Unit Type CHAR 3 T307
    33 MEINS Base Unit UNIT 3
    34 GESME Total Quantity QUAN 13
    35 VERME Sales unit QUAN 13
    36 EINME Char 15 QUAN 13
    37 AUSME Unit of issue QUAN 13
    38 MGEWI Weight of material DEC 11
    39 GEWEI Weight unit UNIT 3
    40 TBNUM Transfer Requirement Number NUMC 10
    41 IVNUM Number of Physical Inventory Document CHAR 10
    42 IVPOS Item NUMC 4
    43 BETYP Availability type CHAR 1
    44 BENUM Area number for pension insurance CHAR 10
    45 LENUM Handling Unit Identification CHAR 20 LEIN
    46 QPLOS Inspection Lot Number NUMC 12
    47 VFDAT Shelf Life Expiration or Best-Before Date DATS 8
    48 QKAPV Capacity usage of quant DEC 11
    49 KOBER Checkbox CHAR 3
    50 LGORT Stor. Location CHAR 4 T001L
    51 VIRGO Quant does not contain GR data CHAR 1
    52 TRAME Char 15 QUAN 13
    53 KZHUQ Indicator: Quant is on a handling unit CHAR 1
    54 VBELN Sales Document CHAR 10
    55 POSNR Item NUMC 6
    56 IDATU Entered Date of Physical Inventory Count (Time Stamp) DATS 8
    57 MSR_INSP_GUID Inspection GUID RAW 16
    58 .INCLU--AP 0
    59 SGT_SCAT Stock Segment CHAR 40

SAP Help, Wiki Resources, and Forum Discussions on LQUA

Click the above link for the full list of resources and help pages, only the first few are posted below


Related Tables

TABLE Description Functional Area
MARA General Material Data Logistics - Material Master
LTAP Transfer order item Logistics Execution - Warehouse Management
LAGP Storage bins Logistics Execution - Warehouse Management
MAKT Material Descriptions Logistics - Material Master
MARD Storage Location Data for Material Logistics - Material Master
LTAK WM transfer order header Logistics Execution - Warehouse Management
VERME Assignment of CAPP methods to CAPP processes PP - Computer Aided Process Planning

Transaction Codes for SAP Table LQUA

TCODE Description Functional Area
SPRO Customizing - Edit Project Basis - Customizing Project Management (IMG)
SE16 Data Browser Basis - Workbench Utilities
MCHA RIS: Till Receipt/Matl - Selection Logistics - Retail Information System (RIS)
MCHB RIS: Till Receipt - Selection Logistics - Retail Information System (RIS)
LS26 Warehouse stocks per material LE - Warehouse Management
LT01 Create Transfer Order Logistics Execution - Warehouse Management
MIGO Goods Movement MM - Inventory Management
LS24 Display Quants for Material LE - Warehouse Management

FMs for SAP Table LQUA

FM Description Functional Area
L_TO_CREATE_SINGLE Create a transfer order with one item Logistics Execution - Warehouse Management
EXIT_SAPLL03A_005 Internal Stock Removal Strategy: Determine and Sort Stocks Logistics Execution - Warehouse Management
REUSE_ALV_LIST_DISPLAY Output a simple list (single line or several lines) BC - SAP List Viewer
BAPI_GOODSMVT_CREATE Post goods movements with MB_CREATE_GOODS_MOVEMENT MM - Inventory Management
REUSE_ALV_GRID_DISPLAY Output of a simple list (single-line) Basis - SAP List Viewer
REUSE_ALV_COMMENTARY_WRITE List body comment block output BC - SAP List Viewer
REUSE_ALV_VARIANT_EXISTENCE Checks whether a display variant exists BC - SAP List Viewer
REUSE_ALV_VARIANT_F4 Display variant selection dialog box BC - SAP List Viewer

ABAP Reports for SAP Table LQUA

ABAP REPORT Description Functional Area
RLTREORG2 Storage Bins / Storage Units analysis Logistics Execution - Warehouse Management
SPRSL TEXT 630 - Workbench Tools: Editors
RLREOLPQ Reset Inventory Data in Storage Bins and Quants Logistics Execution - Warehouse Management
SAPLBARM Function Pool - Confirmation in Repetitive Manufacturing
SAPLCOWB Function Group for Goods Movement
RLVSDR10 Initiate Printing of Transf.Order Logistics Execution - Warehouse Management
RLQCHECK Check Program for Determining Inconsistencies Between LQUA and LTAP Logistics Execution - Warehouse Management
LL03AF8T AUSLAGERSTRATEGIE_H

BW Datasources for SAP Table LQUA

BW DATASOURCE Description Functional Area
2LIS_03_S091 WM: Quantity flows MM - Materials Management
0CO_PC_ACT_06 Material Valuation: Prices - Sales Order Stocks MM - Materials Management
0ID_BR_NF_1 Nota Fiscal Header -
2LIS_03_BX Stock Initialization for Inventory Management MM - Materials Management
2LIS_03_S198 Periodic plant stock MM - Materials Management
2LIS_11_VASCL Sales Document Schedule Line SD - Sales and Distribution
0CO_PC_ACT_03 Material Valuation: Per. Ending Inventory Sales Order Stocks MM - Materials Management
0CO_PC_ACT_02 Material Valuation: Per. Ending Inventory MM - Materials Management

Authorization Objects for SAP Table LQUA

AUTHORIZATION OBJECT Description Functional Area
I_FCODE WCM: Function Codes (e.g. Operational Cycle)
J_1IRG23D Authorisation object for Depo Transactions
FDT_WORKB BRFplus: Authorization Check for BRFplus Workbench
L_LGNUM Warehouse Number / Storage Type
ECM_REQ Change Management: Change Request
ECM_ORD Change Management: Change Order
J_1IEWT_HC health check for Migration to EWT
L_BWLVS Movement Type in the Warehouse Management System