SAP table V_MMIM_LN (Generated Table for View)

SAP table V_MMIM_LN has 4 primary key fields being MANDT,MATNR,WERKS,LGORT.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 MARC WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
LVORM Flag Material for Deletion at Storage Location Level CHAR 1 0 LVOLG
LGPBE Storage Bin CHAR 10 0 LGPBE
LFGJA Fiscal Year of Current Period NUMC 4 0 LFGJA
LFMON Current period (posting period) NUMC 2 0 LFMON
KZILL Physical inventory indicator for whse stock in current year CHAR 3 0 KZILL
KZILQ Phys. inventory ind. f. stock in qual. insp. in current year CHAR 3 0 KZILQ
KZILS Physical inventory indicator for blocked stock CHAR 3 0 KZILS
KZVLL Physical inventory indicator for stock in previous year CHAR 3 0 KZVLL
KZVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period CHAR 3 0 KZVLQ
KZVLS Phys. inventory indicator for blocked stock in prev. period CHAR 3 0 KZVLS
DLINL Date of Last Posted Count DATS 8 0 DLINL
MTART Material type CHAR 4 0 T134 MTART
MATKL Material Group CHAR 9 0 T023 MATKL
ABCIN Physical Inventory Indicator for Cycle Counting CHAR 1 0 T159C ABCIN
LABST Valuated Unrestricted-Use Stock QUAN 13 3 LABST
INSME Stock in Quality Inspection QUAN 13 3 INSME
SPEME Blocked Stock QUAN 13 3 SPEME
EINME Total Stock of All Restricted Batches QUAN 13 3 EINME
ATTYP Material Category CHAR 2 0 ATTYP
Product
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 CURR 13 2 VKLAB
MDJIN Fiscal year of current physical inventory indicator NUMC 4 0 GJINV

V_MMIM_LN foreign key relationships

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