SAP ABAP View MC29V (Data Base View from MARA and MARC on Bills of Materials)

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

View Type	D	Database View
Database View	MC29V
Short Description	Data Base View from MARA and MARC on Bills of Materials
Root table	MARA	General Material Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	MARA	MARA
2	MARC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	MARA	MANDT	JL	EQ				0	0
2	MARC	MANDT	JR	EQ			AND	0	0
3	MARA	MATNR	JL	EQ				0	0
4	MARC	MATNR	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20140121
SAP Release Created in