SAP Table LINV_VB

Transfer structure LINV + LINV1 for update task

LINV_VB (Transfer structure LINV + LINV1 for update task) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LINV_VB to other SAP tables.

Source: LINV_VB (Transfer structure LINV + LINV1 for update task)

LINV_VB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 CHAR 3 0
IVNUM Number of system inventory record LVS_IVNUM CHAR 10 0
IVPOS Item number in inventory document LVS_IVPOS NUMC 4 0
LQNUM Quant LVS_LQNUM NUMC 10 0
NANUM Inventory recount number LINV_NANUM NUMC 2 0
ISTAT Item status of inventory at quant level LINV_ISTAT CHAR 1 0
A Partially counted
L Cleared
N Not counted
Z Counted
S canceled
D Dynamic Cycle Count
NVERS Inventory recount version LINV_NVERS NUMC 2 0
ISEIT Inventory page LVS_ISEIT NUMC 4 0
LGTYP Storage Type LGTYP T301 CHAR 3 0
LGPLA Storage Bin LGPLA LAGP CHAR 10 0
PLPOS Position in storage bin LVS_PLPOS CHAR 2 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
LETYP Storage Unit Type LVS_LETYP T307 CHAR 3 0
ANZLE Number of storage units corresponding to counted quantity LINV_ANZLE DEC 9 3
MENGE Counted quantity in stockkeeping unit LINV_MENGE QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MENGA Counted quantity in alternative unit of measure LINV_MENGA QUAN 13 3
ALTME Alternative Unit of Measure for Stockkeeping Unit LRMEI T006 UNIT 3 0
UMREZ Numerator for Conversion to Base Units of Measure UMREZ DEC 5 0
UMREN Denominator for conversion to base units of measure UMREN DEC 5 0
BESTQ Stock Category in the Warehouse Management System BESTQ CHAR 1 0
NULL Available Stock
Q Stock in Quality Control
R Returns Stock
S Blocked Stock
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
SONUM Special Stock Number LVS_SONUM CHAR 16 0
WDATU Date of Goods Receipt LVS_WDATU DATS 8 0
GESME Total Quantity LQUA_GESME QUAN 13 3
IDATU Date of inventory LVS_IDATU DATS 8 0
KZINV Inventory method LVS_KZINV CHAR 2 0
NULL No inventory
PE Continuous inventory upon placement into stock
PN Continuous inventory based on zero stock check
PZ Continuous inventory
ST Annual inventory
MA Manual inventory
CC Cycle counting
DC Dynamic Cycle Count
IRNUM Inventory reference number LVS_IRNUM CHAR 10 0
TANUM Transfer order number of continuous inventory procedure LINV_TANUM NUMC 10 0
TAPOS Transfer order item of continuous inventory procedure LINV_TAPOS NUMC 4 0
LENUM Storage Unit Number LENUM LEIN CHAR 20 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
UNAME Name of counter for system inventory record LINV_UNAME CHAR 25 0
QUINV Indicator for quant inventory LINK_QUINV CHAR 1 0
X Yes
NULL No
IDQUA Indicator: identical quant LINV1IDQUA CHAR 1 0
X Yes
NULL No
DBGEZ Indicator: quant in data base counted LINV1DBGEZ CHAR 1 0
X Yes
NULL No
KEY Internal key for scrolling LINV1_KEY DEC 5 0
LVORM Deletion flag LINV1LVORM CHAR 1 0
X Yes
NULL No
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
KREUZ Indicator: record selected LINV1KREUZ CHAR 1 0
X Yes
NULL No
PAGNO Page number in ABAP list LVS_PAGNO DEC 3 0
LINNO Line number in ABAP list LVS_LINNO DEC 5 0
BEMER Additional remarks on line issued LINV1BEMER CHAR 14 0
ABWEI Relative difference between amount counted and book amount LINV1ABWEI DEC 12 2
VZCHN +/- sign LINV1VZCHN CHAR 1 0
+ Plus
- Minus
AUSBU Indicator: to be cleared LINV1AUSBU CHAR 1 0
X Yes
NULL No
BWKEY Valuation Area BWKEY CHAR 4 0
BUKRS Company Code BUKRS CHAR 4 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
WAERS Currency Key WAERS CUKY 5 0
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price VERPR CURR 11 2
STPRS Standard price STPRS CURR 11 2
PEINH Price Unit PEINH DEC 5 0
CWERT Value difference (with comment) LVS_CWERT CHAR 18 0
DWERT Value difference (can be added up) LVS_DWERT CURR 13 2
NOVAL Value cannot be determined LVS_NOVAL CHAR 1 0
X Yes
NULL No

LINV_VB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LINV_VB ALTME LINV_VB ALTME T006 Units of Measurement MSEHI
LINV_VB ALTME LINV_VB MANDT T006 Units of Measurement MANDT
LINV_VB LENUM LINV_VB LENUM LEIN Storage unit header records LENUM
LINV_VB LENUM LINV_VB MANDT LEIN Storage unit header records MANDT
LINV_VB LETYP LINV_VB LETYP T307 Storage Unit Types LETYP
LINV_VB LETYP LINV_VB LGNUM T307 Storage Unit Types LGNUM
LINV_VB LETYP LINV_VB MANDT T307 Storage Unit Types MANDT
LINV_VB LGNUM LINV_VB MANDT T300 WM Warehouse Numbers MANDT
LINV_VB LGNUM LINV_VB LGNUM T300 WM Warehouse Numbers LGNUM
LINV_VB LGORT LINV_VB WERKS T001L Storage Locations WERKS
LINV_VB LGORT LINV_VB MANDT T001L Storage Locations MANDT
LINV_VB LGORT LINV_VB LGORT T001L Storage Locations LGORT
LINV_VB LGPLA LINV_VB MANDT LAGP Storage bins MANDT
LINV_VB LGPLA LINV_VB LGNUM LAGP Storage bins LGNUM
LINV_VB LGPLA LINV_VB LGTYP LAGP Storage bins LGTYP
LINV_VB LGPLA LINV_VB LGPLA LAGP Storage bins LGPLA
LINV_VB LGTYP LINV_VB LGTYP T301 WM Storage Types LGTYP
LINV_VB LGTYP LINV_VB MANDT T301 WM Storage Types MANDT
LINV_VB LGTYP LINV_VB LGNUM T301 WM Storage Types LGNUM
LINV_VB MATNR LINV_VB MANDT MARA General Material Data MANDT
LINV_VB MATNR LINV_VB MATNR MARA General Material Data MATNR
LINV_VB MEINS LINV_VB MANDT T006 Units of Measurement MANDT
LINV_VB MEINS LINV_VB MEINS T006 Units of Measurement MSEHI
LINV_VB SOBKZ LINV_VB MANDT T148 Special Stock Indicator MANDT
LINV_VB SOBKZ LINV_VB SOBKZ T148 Special Stock Indicator SOBKZ
LINV_VB WERKS LINV_VB MANDT T001W Plants/Branches MANDT
LINV_VB WERKS LINV_VB WERKS T001W Plants/Branches WERKS