LQUA

Quants | #transactional | Component: Warehouse Management
Column Name Description
MANDT Client
LGNUM FK Warehouse Number / Warehouse Complex
LQNUM Quant
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
GESME Total Quantity
VERME Available stock
EINME Stock for putaway
AUSME Quantity to remove
TRAME Open Transfer Quantity
Column Name Description
BDATU Date of last movement
BZEIT Time of last movement
EDATU Date of last placement into stock
EZEIT Time of last placement into stock
ADATU Date of last stock removal
AZEIT Time of last stock removal
ZDATU Date of last addition to existing stock
WDATU Date of Goods Receipt
VFDAT Shelf Life Expiration or Best-Before Date
IDATU Date of last inventory of quant
Column Name Description
BESTQ Stock Category in the Warehouse Management System Show values
SKZUE Blocking indicator: for putaways (user) Show values
SKZUA Blocking Indicator: For Stock Removals (User) Show values
SKZSE Blocking indicator: current placement into stock (system) Show values
SKZSA Blocking Indicator: Current Stock Removal (System) Show values
SKZSI Blocking Indicator: Current Inventory (System) Show values
VIRGO Quant does not contain GR data Show values
KZHUQ Indicator: Quant is on a handling unit Show values
Column Name Description Domain name
CHARG Batch Number CHARG
SONUM Special Stock Number LVS_SONUM
PLPOS Position in storage bin LVS_PLPOS
ZEUGN Certificate Number LVS_ZEUGN
BTANR Document Number of Last Stock Change in Quant TANUM
BTAPS Item in transfer order of last stock transfer TAPOS
WENUM Goods Receipt Number BELNR
WEPOS Goods receipt item MBLPO
MGEWI Weight of material DEC8_3
TBNUM Transfer Requirement Number TBNUM
IVNUM Number of system inventory record BELNR
IVPOS Item number in inventory document LVS_IVPOS
BETYP Requirement Type LVS_BETYP
BENUM Requirement Number LVS_BENUM
QPLOS Inspection Lot Number QPLOS
QKAPV Capacity usage of quant DEC8_3
KOBER Picking Area KOBER
VBELN Delivery VBELN
POSNR Delivery Item POSNR
MSR_INSP_GUID Inspection GUID
SGT_SCAT Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Storage Unit Number
  • LQUA.MANDT == LEIN.MANDT
  • LQUA.LENUM == LEIN.LENUM
Storage Unit Type
  • Storage Unit Type
  • Warehouse Number / Warehouse Complex
  • LQUA.MANDT == T307.MANDT
  • LQUA.LETYP == T307.LETYP
  • LQUA.LGNUM == T307.LGNUM
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • LQUA.LGNUM == T300.LGNUM
  • LQUA.MANDT == T300.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • LQUA.LGORT == T001L.LGORT
  • LQUA.MANDT == T001L.MANDT
  • LQUA.WERKS == T001L.WERKS
Storage Bin
  • Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • LQUA.MANDT == LAGP.MANDT
  • LQUA.LGPLA == LAGP.LGPLA
  • LQUA.LGNUM == LAGP.LGNUM
  • LQUA.LGTYP == LAGP.LGTYP
Storage Type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • LQUA.LGNUM == T301.LGNUM
  • LQUA.MANDT == T301.MANDT
  • LQUA.LGTYP == T301.LGTYP
Material Number
  • Material Number
  • Client
  • LQUA.MATNR == MARA.MATNR
  • LQUA.MANDT == MARA.MANDT
Special Stock Indicator
  • LQUA.MANDT == T148.MANDT
  • LQUA.SOBKZ == T148.SOBKZ
Blocking reason
  • Warehouse Number / Warehouse Complex
  • Blocking reason
  • LQUA.MANDT == T330.MANDT
  • LQUA.LGNUM == T330.LGNUM
  • LQUA.SPGRU == T330.SPGRU
Plant
  • LQUA.MANDT == T001W.MANDT
  • LQUA.WERKS == T001W.WERKS