SAP ABAP Table QM_EPR_01C1_01 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	QM_EPR_01C1_01	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	MARD
5	CHARG	☑	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCHA
6	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
7	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
8	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
9	KZILL	☐	KZILL	INVKZ	CHAR	3	0	Physical inventory indicator for whse stock in current year
10	KZILQ	☐	KZILQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in current year
11	KZILS	☐	KZILS	INVKZ	CHAR	3	0	Physical inventory indicator for blocked stock
12	KZVLL	☐	KZVLL	INVKZ	CHAR	3	0	Physical inventory indicator for stock in previous year
13	KZVLQ	☐	KZVLQ	INVKZ	CHAR	3	0	Phys. inventory ind. f. stock in qual. insp. in prev. period
14	KZVLS	☐	KZVLS	INVKZ	CHAR	3	0	Phys. inventory indicator for blocked stock in prev. period
15	DLINL	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
16	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
17	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
18	ABCIN	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	T159C
19	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
20	LGPBE	☐	LGPBE	CHAR10	CHAR	10	0	Storage Bin
21	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	MBEW
22	LVORM	☐	LVOCA	XFELD	CHAR	1	0	Deletion Flag for All Data on a Batch at a Plant
23	VFDAT	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
24	MHDLP	☐	MHDLP	DEC3	DEC	3	0	Storage percentage
25	MHDHB	☐	MHDHB	DEC4	DEC	4	0	Total shelf life
26	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
27	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
28	LVORM_B	☐	LVOCB	XFELD	CHAR	1	0	Deletion Flag for All Data on a Batch Stock
29	LVORM_1	☐	LVOC1	XFELD	CHAR	1	0	Deletion Flag for All Data in a Batch
30	LABST	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
31	INSME	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
32	SPEME	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock
33	EINME	☐	EINME	MENG13V	QUAN	13	3	Total Stock of All Restricted Batches
34	VFDAT_1	☐	VFDAT	DATUM	DATS	8	0	Shelf Life Expiration or Best-Before Date
35	RDMHD	☐	RDMHD	RDMHD	CHAR	1	0	Rounding rule for calculation of SLED
36	MDJIN	☐	GJINV	GJAHR	NUMC	4	0	Fiscal year of current physical inventory indicator
37	RETME	☐	RETME	MENG13V	QUAN	13	3	Blocked Stock Returns
38	UMLME	☐	UMLMD	MENG13V	QUAN	13	3	Stock in transfer (from one storage location to another)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QM_EPR_01C1_01	ABCIN	T159C	ABCIN	REF	C	CN
2	QM_EPR_01C1_01	BWTAR	MBEW	BWTAR
3	QM_EPR_01C1_01	CHARG	MCHA	CHARG	KEY	1	CN
4	QM_EPR_01C1_01	LGORT	MARD	LGORT	KEY	1	CN
5	QM_EPR_01C1_01	MANDT	T000	MANDT	KEY	1	CN
6	QM_EPR_01C1_01	MATKL	T023	MATKL	REF	C	CN
7	QM_EPR_01C1_01	MATNR	MARA	MATNR	KEY	1	CN
8	QM_EPR_01C1_01	MEINS	T006	MSEHI	REF	1	CN
9	QM_EPR_01C1_01	MTART	T134	MTART	REF	1	CN
10	QM_EPR_01C1_01	WERKS	MARC	WERKS	KEY	1	CN

History

Last changed by/on	DDIC	20141106
SAP Release Created in