SAP ABAP Table ENT5111 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT5111	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	MARC
4	LGORT	☑	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
5	LVORM	☑	LVOLG	XFELD	CHAR	1	0	Flag Material for Deletion at Storage Location Level
6	LFGJA	☑	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
7	LFMON	☑	LFMON	MONAT	NUMC	2	0	Current period (posting period)
8	SPERR	☑	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
9	LABST	☑	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
10	UMLME	☑	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)
11	INSME	☑	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
12	EINME	☑	EINME	MENG13V	QUAN	13	3	Total Stock of All Restricted Batches
13	SPEME	☑	SPEME	MENG13V	QUAN	13	3	Blocked stock
14	RETME	☑	RETME	MENG13V	QUAN	13	3	Blocked Stock Returns
15	VMLAB	☑	VMLAB	MENG13V	QUAN	13	3	Valuated unrestricted-use stock in previous period
16	VMUML	☑	VMUML	MENG13V	QUAN	13	3	Stock in transfer, previous period
17	VMINS	☑	VMINS	MENG13V	QUAN	13	3	Stock in quality inspection from previous period
18	VMEIN	☑	VMEIN	MENG13V	QUAN	13	3	Restricted-use stock in previous period
19	VMSPE	☑	VMSPE	MENG13V	QUAN	13	3	Blocked stock of previous period
20	VMRET	☑	VMRET	MENG13V	QUAN	13	3	Blocked stock returns, previous period
21	KZILL	☑	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
22	KZILQ	☑	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
23	KZILE	☑	KZILE	INVKZ	CHAR	3	0	Physical inventory indicator for restricted-use stock
24	KZILS	☑	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
25	KZVLL	☑	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
26	KZVLQ	☑	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
27	KZVLE	☑	KZVLE	INVKZ	CHAR	3	0	Physical inventory ind. for restricted-use stock, prev.pd
28	KZVLS	☑	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
29	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
30	SOBKZ	☑	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
31	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
32	LVORMMKOL	☐	LVOKL	XFELD	CHAR	1	0	Deletion Flag for All Data on a Consignment Stock
33	LFGJAMKOL	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
34	LFMONMKOL	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
35	SPERS	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
36	SLABS	☐	KLABS	MENG13V	QUAN	13	3	Unrestricted-use consignment stock
37	SINSM	☐	KINSM	MENG13V	QUAN	13	3	Consignment stock in quality inspection
38	SEINM	☐	KEINM	MENG13V	QUAN	13	3	Restricted-use consignment stock
39	SSPEM	☐	KSPEM	MENG13V	QUAN	13	3	Blocked consignment stock
40	SVMLA	☐	KVLAB	MENG13V	QUAN	13	3	Unrestricted-use consignment stock, previous period
41	SVMIN	☐	KVINS	MENG13V	QUAN	13	3	Consignment stock in quality inspection, previous period
42	SVMEI	☐	KVEIN	MENG13V	QUAN	13	3	Restricted-use consignment stock in the previous period
43	SVMSP	☐	KVSPE	MENG13V	QUAN	13	3	Blocked consignment stock, previous period
44	KZISL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
45	KZISQ	☐	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
46	KZISE	☐	KZILE	INVKZ	CHAR	3	0	Physical inventory indicator for restricted-use stock
47	KZISS	☐	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
48	KZVSL	☐	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
49	KZVSQ	☐	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
50	KZVSE	☐	KZVLE	INVKZ	CHAR	3	0	Physical inventory ind. for restricted-use stock, prev.pd
51	KZVSS	☐	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
52	MMENG	☐	MMENG	MENG13	QUAN	13	3	Minimum order quantity
53	AMENG	☐	AMENG	MENG13	QUAN	13	3	Replenishment quantity
54	KODLL	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5111	CHARG	MCHA	CHARG	KEY	1	CN
2	ENT5111	LGORT	T001L	LGORT	KEY	1	CN
3	ENT5111	LIFNR	LFA1	LIFNR	KEY	1	CN
4	ENT5111	MANDT	T000	MANDT	KEY	1	CN
5	ENT5111	MATNR	MARA	MATNR	KEY	1	CN
6	ENT5111	SOBKZ	T148	SOBKZ	KEY	1	CN
7	ENT5111	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in