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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
IDQUA | Indicator: identical quant | LINV1IDQUA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
DBGEZ | Indicator: quant in data base counted | LINV1DBGEZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
KEY | Internal key for scrolling | LINV1_KEY | DEC | 5 | 0 | |||||||||||||||||||
LVORM | Deletion flag | LINV1LVORM | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | 0 | |||||||||||||||||||
KREUZ | Indicator: record selected | LINV1KREUZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
AUSBU | Indicator: to be cleared | LINV1AUSBU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
||||||||||||||||||
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 |
Possible values
|
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 |