LINV

Inventory data per quant | #transactional | Component: Warehouse Management
Column Name Description
MANDT Client
LGNUM FK Warehouse Number / Warehouse Complex
IVNUM Number of system inventory record
IVPOS Item number in inventory document
LQNUM Quant
NANUM Inventory recount number
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Counted quantity in stockkeeping unit
GESME Total Quantity
📏 Alternative Unit of Measure for Stockkeeping Unit (ALTME):
MENGA Counted quantity in alternative unit of measure
Column Name Description
WDATU Date of Goods Receipt
IDATU Date of inventory
VFDAT Shelf Life Expiration or Best-Before Date
Column Name Description
ISTAT Item status of inventory at quant level Show values
BESTQ Stock Category in the Warehouse Management System Show values
KZINV Inventory method Show values
QUINV Indicator for quant inventory Show values
Column Name Description Domain name
NVERS Inventory recount version LVS_NANUM
ISEIT Inventory page LVS_ISEIT
PLPOS Position in storage bin LVS_PLPOS
CHARG Batch Number CHARG
ANZLE Number of storage units corresponding to counted quantity LAGP_ANZLE
UMREZ Numerator for Conversion to Base Units of Measure UMBSZ
UMREN Denominator for conversion to base units of measure UMBSN
SONUM Special Stock Number LVS_SONUM
IRNUM Inventory reference number LVS_IRNUM
TANUM Transfer order number of continuous inventory procedure TANUM
TAPOS Transfer order item of continuous inventory procedure TAPOS
UNAME Name of counter for system inventory record CHAR25
SGT_SCAT Stock Segment SGT_SRCA
Master Data Relations Join Conditions
Alternative Unit of Measure for Stockkeeping Unit
  • LINV.MANDT == T006.MANDT
  • LINV.ALTME == T006.MSEHI
Storage Unit Number
  • LINV.MANDT == LEIN.MANDT
  • LINV.LENUM == LEIN.LENUM
Storage Unit Type
  • Storage Unit Type
  • Warehouse Number / Warehouse Complex
  • LINV.MANDT == T307.MANDT
  • LINV.LETYP == T307.LETYP
  • LINV.LGNUM == T307.LGNUM
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • LINV.LGNUM == T300.LGNUM
  • LINV.MANDT == T300.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • LINV.LGORT == T001L.LGORT
  • LINV.MANDT == T001L.MANDT
  • LINV.WERKS == T001L.WERKS
Storage Bin
  • Storage Bin
  • Warehouse Number / Warehouse Complex
  • Storage Type
  • LINV.MANDT == LAGP.MANDT
  • LINV.LGPLA == LAGP.LGPLA
  • LINV.LGNUM == LAGP.LGNUM
  • LINV.LGTYP == LAGP.LGTYP
Storage Type
  • Warehouse Number / Warehouse Complex
  • Client
  • Storage Type
  • LINV.LGNUM == T301.LGNUM
  • LINV.MANDT == T301.MANDT
  • LINV.LGTYP == T301.LGTYP
Material Number
  • Material Number
  • Client
  • LINV.MATNR == MARA.MATNR
  • LINV.MANDT == MARA.MANDT
Base Unit of Measure
  • LINV.MANDT == T006.MANDT
  • LINV.MEINS == T006.MSEHI
Special Stock Indicator
  • LINV.MANDT == T148.MANDT
  • LINV.SOBKZ == T148.SOBKZ
Plant
  • LINV.MANDT == T001W.MANDT
  • LINV.WERKS == T001W.WERKS