SAP ABAP Table MC29V (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MC29V	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
3	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	LVORM	☐	LVOWK	XFELD	CHAR	1	0	Flag Material for Deletion at Plant Level
5	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
6	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
7	BLANZ	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
8	BLATT	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
9	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
10	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
12	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
13	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
14	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
15	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
16	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
17	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
18	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
19	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
20	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
21	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
22	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
23	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
24	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
25	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
26	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
27	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	TWSPR
28	ZEIAR	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
29	ZEIFO	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
30	ZEINR	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
31	ZEIVR	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
32	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
33	ALTSL	☐	ALTSL	ALTSL	CHAR	1	0	Method for Selecting Alternative Bills of Material
34	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	T006
35	AUSSS	☐	AUSSS	DEC3_2	DEC	5	2	Assembly scrap in percent
36	KZAUS	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
37	AUSDT	☐	AUSDT	DATUM	DATS	8	0	Effective-out date
38	NFMAT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	MARA
39	SBDKZ	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
40	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	T141
41	MMSTD	☐	MMSTD	DATUM	DATS	8	0	Date from which the plant-specific material status is valid
42	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
43	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
44	SOBSL	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	T460A
45	DZEIT	☐	DZEIT	DEC3	DEC	3	0	In-house production time
46	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
47	RGEKZ	☐	RGEKM	RGEKM	CHAR	1	0	Indicator: Backflush
48	RUEZT	☐	RUEZT	DEC3_2	DEC	5	2	Setup and teardown time
49	TRANZ	☐	TRANZ	DEC3_2	DEC	5	2	Interoperation time
50	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
51	BASMG	☐	BASMG	MENG13	QUAN	13	3	Base quantity
52	BEARZ	☐	BEARZ	DEC3_2	DEC	5	2	Processing time
53	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
54	KAUSF	☐	KAUSF	DEC3_2	DEC	5	2	Component scrap in percent
55	LGPRO	☐	LGPRO	LGORT	CHAR	4	0	Issue storage location	T001L
56	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
57	KZDKZ	☐	KZDKZ	XFELD	CHAR	1	0	Documentation required indicator
58	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
59	STDPD	☐	STDPD	MATNR	CHAR	18	0	Configurable material	MARA
60	CUOBJ	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
61	SOBSK	☐	CK_SOBSL	SOBSL	CHAR	2	0	Special Procurement Type for Costing	T460A
62	KZKUP	☐	KZKUPMAT	FLAG	CHAR	1	0	Indicator: Material can be co-product
63	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
64	EPRIO	☐	BF_GROUP	BF_GROUP	CHAR	4	0	Stock determination group	T434G
65	STAWN	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
66	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
67	PRENE	☐	PRENE	PRENE	CHAR	1	0	Indicator: Vendor declaration exists
68	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
69	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
70	KZECH	☐	KZECH	KZECH	CHAR	1	0	Determination of batch entry in the production/process order
71	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
72	MISKZ	☐	MISKZ	MISKZ	CHAR	1	0	Mixed MRP indicator
73	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	TMVF
74	FRTME	☐	FRTME	MEINS	UNIT	3	0	Production unit	T006
75	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
76	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
77	SERLV	☐	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
78	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
79	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
80	VSPVB	☐	VSPVB	PRVBE	CHAR	10	0	Proposed Supply Area in Material Master Record	PVBE
81	KZBED	☐	KZBED	KZBED	CHAR	1	0	Indicator for Requirements Grouping
82	KZEFF	☐	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
83	FXPRU	☐	CK_FIXPRKU	XFELD	CHAR	1	0	Fixed-Price Co-Product
84	APOKZ	☐	APOKZ	APOKZ	CHAR	1	0	Indicator: Is material relevant for APO
85	AHDIS	☐	AHDIS	AHDIS	CHAR	1	0	MRP relevancy for dependent requirements
86	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	TMQ2
87	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MC29V	AUSME	T006	MSEHI	REF	C	CN
2	MC29V	DISMM	T438A	DISMM	REF	1	CN
3	MC29V	EKGRP	T024	EKGRP	REF	C	CN
4	MC29V	EPRIO	T434G	EPRIO
5	MC29V	FRTME	T006	MSEHI	REF	C	CN
6	MC29V	GEWEI	T006	MSEHI	REF	C	CN
7	MC29V	LABOR	T024L	LABOR	REF	C	CN
8	MC29V	LGPRO	T001L	LGORT	REF	C	CN
9	MC29V	MANDT	T000	MANDT	KEY	1	CN
10	MC29V	MATKL	T023	MATKL	REF	C	CN
11	MC29V	MBRSH	T137	MBRSH	REF	C	CN
12	MC29V	MEINS	T006	MSEHI	REF	1	CN
13	MC29V	MMSTA	T141	MMSTA	REF	C	CN
14	MC29V	MSTAE	T141	MMSTA
15	MC29V	MTART	T134	MTART	REF	1	CN
16	MC29V	MTVFP	TMVF	MTVFP	REF	C	CN
17	MC29V	NFMAT	MARA	MATNR	REF	C	CN
18	MC29V	SERNP	T377P	SERAIL	REF	C	CN
19	MC29V	SOBSK	T460A	SOBSL	REF	C	CN
20	MC29V	SOBSL	T460A	SOBSL	REF	C	CN
21	MC29V	STAWN	T604	STAWN	REF	C	CN
22	MC29V	STDPD	MARA	MATNR	REF	C	CN
23	MC29V	USEQU	TMQ2	USEQU	REF	C	CN
24	MC29V	VOLEH	T006	MSEHI	REF	C	CN
25	MC29V	VSPVB	PVBE	PRVBE
26	MC29V	WERKS	T001W	WERKS	KEY	1	CN
27	MC29V	WRKST	TWSPR	WRKST

History

Last changed by/on	SAP	20140121
SAP Release Created in