SAP ABAP Table MCADV (Material Master Record Table: CAD Integration)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	INTTAB	Structure
Structure	MCADV	Table Relationship Diagram
Short Description	Material Master Record Table: CAD Integration

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	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
3	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
4	LAEDA	☐	LAEDA	DATUM	DATS	8	0	Date of Last Change
5	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
6	VPSTA	☐	VPSTA	PSTAT	CHAR	15	0	Maintenance status of complete material
7	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
8	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
9	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
10	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	*
11	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
12	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
13	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
15	ZEINR	☐	DZEINR	CHAR22	CHAR	22	0	Document number (without document management system)
16	ZEIAR	☐	DZEIAR	ZEIAR	CHAR	3	0	Document type (without Document Management system)
17	ZEIVR	☐	DZEIVR	VERSI	CHAR	2	0	Document version (without Document Management system)
18	ZEIFO	☐	DZEIFO	DINFO	CHAR	4	0	Page format of document (without Document Management system)
19	AESZN	☐	AESZN	AENUM	CHAR	6	0	Document change number (without document management system)
20	BLATT	☐	BLATT	BLATT	CHAR	3	0	Page number of document (without Document Management system)
21	BLANZ	☐	BLANZ	NUM3	NUMC	3	0	Number of sheets (without Document Management system)
22	FERTH	☐	FERTH	FERTH	CHAR	18	0	Production/inspection memo
23	FORMT	☐	FORMT	DINFO	CHAR	4	0	Page Format of Production Memo
24	GROES	☐	GROES	CHAR32	CHAR	32	0	Size/dimensions
25	WRKST	☐	WRKST	WRKST	CHAR	48	0	Basic Material	*
26	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
27	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	*
28	EKWSL	☐	EKWSL	EKWSL	CHAR	4	0	Purchasing Value Key	*
29	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
30	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
31	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
32	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
33	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
34	BEHVO	☐	BEHVO	BEHVO	CHAR	2	0	Container requirements	*
35	RAUBE	☐	RAUBE	RAUBE	CHAR	2	0	Storage conditions	*
36	TEMPB	☐	TEMPB	TEMPB	CHAR	2	0	Temperature conditions indicator	*
37	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
38	TRAGR	☐	TRAGR	TRAGR	CHAR	4	0	Transportation Group	*
39	STOFF	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	*
40	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
41	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
42	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
43	MEINH	☐	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	*
44	UMREZ	☐	UMREZ	UMBSZ	DEC	5	0	Numerator for Conversion to Base Units of Measure
45	UMREN	☐	UMREN	UMBSN	DEC	5	0	Denominator for conversion to base units of measure
46	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
47	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
48	XCHAR	☐	XCHAR	XFELD	CHAR	1	0	Batch management indicator (internal)
49	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	*
50	MMSTD	☐	MMSTD	DATUM	DATS	8	0	Date from which the plant-specific material status is valid
51	MAABC	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	TMABC
52	KZKRI	☐	KZKRI	XFELD	CHAR	1	0	Indicator: Critical part
53	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
54	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	*
55	DISPR	☐	DISPR	DISPR	CHAR	4	0	Material: MRP profile	*
56	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	*
57	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
58	KZDIE	☐	KZDIE	XFELD	CHAR	1	0	Indicator: MRP controller is buyer (deactivated)
59	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
60	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
61	PERKZ	☐	PERKZ	PERKZ	CHAR	1	0	Period indicator
62	AUSSS	☐	AUSSS	DEC3_2	DEC	5	2	Assembly scrap in percent
63	DISLS	☐	DISLS	DISLS	CHAR	2	0	Lot size (materials planning)	*
64	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
65	SOBSL	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	*
66	MINBE	☐	MINBE	MENG13	QUAN	13	3	Reorder point
67	EISBE	☐	EISBE	MENG13	QUAN	13	3	Safety stock
68	BSTMI	☐	BSTMI	MENG13	QUAN	13	3	Minimum lot size
69	BSTMA	☐	BSTMA	MENG13	QUAN	13	3	Maximum lot size
70	BSTFE	☐	BSTFE	MENG13	QUAN	13	3	Fixed lot size
71	BSTRF	☐	BSTRF	MENG13	QUAN	13	3	Rounding value for purchase order quantity
72	MABST	☐	MABST	MENG13	QUAN	13	3	Maximum stock level
73	LOSFX	☐	LOSFX	WERT11	CURR	11	2	Ordering costs
74	NFMAT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	*
75	RGEKZ	☐	RGEKZ	XFELD	CHAR	1	0	Indicator: Backflush
76	FEVOR	☐	VAGRP	VAGRP	CHAR	3	0	Responsible planner group/department	*
77	BEARZ	☐	BEARZ	DEC3_2	DEC	5	2	Processing time
78	RUEZT	☐	RUEZT	DEC3_2	DEC	5	2	Setup and teardown time
79	TRANZ	☐	TRANZ	DEC3_2	DEC	5	2	Interoperation time
80	BASMG	☐	BASMG	MENG13	QUAN	13	3	Base quantity
81	DZEIT	☐	DZEIT	DEC3	DEC	3	0	In-house production time
82	MAXLZ	☐	MAXLZ	DEC5	DEC	5	0	Maximum storage period
83	LZEIH	☐	LZEIH	MEINS	UNIT	3	0	Unit for maximum storage period	*
84	KZPRO	☐	KZPRO	XFELD	CHAR	1	0	Indicator: withdrawal of stock from production bin
85	GPMKZ	☐	GPMKZ	XFELD	CHAR	1	0	Indicator: material included in rough-cut planning
86	UEETO	☐	UEETO	DEC2_1	DEC	3	1	Overdelivery tolerance limit
87	UEETK	☐	UEETK	XFELD	CHAR	1	0	Indicator: Unlimited overdelivery allowed
88	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
89	MPDAU	☐	MPDAU	DEC5	DEC	5	0	Mean inspection duration (deactivated)
90	WSTGH	☐	WSTGH	DEC9	DEC	9	0	Active substance content (deactivated)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCADV	MAABC	TMABC	MAABC

History

Last changed by/on	SAP	20130529
SAP Release Created in