SAP Table V_MMIM_LN

Generated Table for View

V_MMIM_LN (Generated Table for View) 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 V_MMIM_LN to other SAP tables.

V_MMIM_LN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
LVORM Flag Material for Deletion at Storage Location Level LVOLG CHAR 1 0
X Yes
NULL No
LGPBE Storage Bin LGPBE CHAR 10 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
KZILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
KZILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
KZILS Physical inventory indicator for blocked stock KZILS CHAR 3 0
KZVLL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
KZVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
KZVLS Phys. inventory indicator for blocked stock in prev. period KZVLS CHAR 3 0
DLINL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
MTART Material Type MTART T134 CHAR 4 0
MATKL Material Group MATKL T023 CHAR 9 0
ABCIN Physical inventory indicator for cycle counting ABCIN T159C CHAR 1 0
LABST Valuated Unrestricted-Use Stock LABST QUAN 13 3
INSME Stock in Quality Inspection INSME QUAN 13 3
SPEME Blocked Stock SPEME QUAN 13 3
EINME Total Stock of All Restricted Batches EINME QUAN 13 3
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
VKLAB Stock value of a value-only material at sales price VKLAB CURR 13 2
MDJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0

V_MMIM_LN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_MMIM_LN ABCIN V_MMIM_LN ABCIN T159C Value table for counting cycles in cycle counting ABCIN
V_MMIM_LN ABCIN V_MMIM_LN MANDT T159C Value table for counting cycles in cycle counting MANDT
V_MMIM_LN ABCIN V_MMIM_LN WERKS T159C Value table for counting cycles in cycle counting WERKS
V_MMIM_LN LGORT V_MMIM_LN MANDT T001L Storage Locations MANDT
V_MMIM_LN LGORT V_MMIM_LN WERKS T001L Storage Locations WERKS
V_MMIM_LN LGORT V_MMIM_LN LGORT T001L Storage Locations LGORT
V_MMIM_LN MANDT V_MMIM_LN MANDT T000 Clients MANDT
V_MMIM_LN MATKL V_MMIM_LN MATKL T023 Material Groups MATKL
V_MMIM_LN MATKL V_MMIM_LN MANDT T023 Material Groups MANDT
V_MMIM_LN MATNR V_MMIM_LN MANDT MARA General Material Data MANDT
V_MMIM_LN MATNR V_MMIM_LN MATNR MARA General Material Data MATNR
V_MMIM_LN MTART V_MMIM_LN MANDT T134 Material Types MANDT
V_MMIM_LN MTART V_MMIM_LN MTART T134 Material Types MTART
V_MMIM_LN WERKS V_MMIM_LN WERKS MARC Plant Data for Material WERKS
V_MMIM_LN WERKS V_MMIM_LN MANDT MARC Plant Data for Material MANDT
V_MMIM_LN WERKS V_MMIM_LN MATNR MARC Plant Data for Material MATNR