SAP ABAP Table ENT5117 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	ENT5117	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	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
32	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
33	LFGJAMSKA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
34	LFMONMSKA	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
35	KASPR	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
36	KALAB	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
37	KAINS	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
38	KASPE	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock
39	KAVLA	☐	VMLAB	MENG13V	QUAN	13	3	Valuated unrestricted-use stock in previous period
40	KAVIN	☐	VMINS	MENG13V	QUAN	13	3	Stock in quality inspection from previous period
41	KAVSP	☐	VMSPE	MENG13V	QUAN	13	3	Blocked stock of previous period
42	KAILL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
43	KAILQ	☐	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
44	KAILS	☐	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
45	KAVLL	☐	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
46	KAVLQ	☐	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
47	KAVLS	☐	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
48	KAFLL	☐	KZFLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in following year
49	KAFLQ	☐	KZFLQ	INVKZ	CHAR	3	0	Physical inventory indicator, quality insp.stck, follow.yr.
50	KAFLS	☐	KZFLS	INVKZ	CHAR	3	0	Phys. inventory ind. for blocked stock in following period

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ENT5117	CHARG	MCHA	CHARG	KEY	1	CN
2	ENT5117	LGORT	T001L	LGORT	KEY	1	CN
3	ENT5117	MANDT	T000	MANDT	KEY	1	CN
4	ENT5117	MATNR	MARA	MATNR	KEY	1	CN
5	ENT5117	POSNR	VBUP	POSNR	KEY	1	CN
6	ENT5117	SOBKZ	T148	SOBKZ	KEY	1	CN
7	ENT5117	VBELN	VBUK	VBELN	KEY	1	CN
8	ENT5117	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in