SAP table LINV_VB (Transfer structure LINV + LINV1 for update task)

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

LINV_VB foreign key relationships

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