SAP ABAP View MA06V (Material Master: DB View for Purchasing)

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	MA06V
Short Description	Material Master: DB View for Purchasing
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	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
5	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
6	BSTME	MARA	BSTME		☐	BSTME	☐	Order unit
7	MLGUT	MARA	MLGUT		☐	W_MITLEERG	☐	Empties Bill of Material
8	CUOBJ	MARC	CUOBJ		☐	CUOBM	☐	Internal object number
9	DISST	MARA	DISST		☐	DISST	☐	Low-level code
10	VABME	MARA	VABME		☐	VABME	☐	Variable Purchase Order Unit Active
11	PSTAT	MARC	PSTAT		☐	PSTAT_D	☐	Maintenance status
12	LVORM	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
13	BWTTY	MARC	BWTTY		☐	BWTTY_D	☐	Valuation Category
14	AUSME	MARC	AUSME		☐	AUSME	☐	Unit of issue
15	MMSTA	MARC	MMSTA		☐	MMSTA	☐	Plant-Specific Material Status
16	MMSTD	MARC	MMSTD		☐	MMSTD	☐	Date from which the plant-specific material status is valid
17	EKGRP	MARC	EKGRP		☐	EKGRP	☐	Purchasing group
18	DISPO	MARC	DISPO		☐	DISPO	☐	MRP controller
19	WEBAZ	MARC	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
20	INSMK	MARC	INSMK		☐	INSMK_MAT	☐	Post to Inspection Stock
21	PLIFZ	MARC	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
22	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
23	USEQU	MARC	USEQU		☐	USEQU	☐	Quota arrangement usage
24	MTART	MARA	MTART		☐	MTART	☐	Material type
25	EKWSL	MARA	EKWSL		☐	EKWSL	☐	Purchasing Value Key
26	BWSCL	MARC	BWSCL		☐	BWSCL	☐	Source of Supply
27	NTGEW	MARA	NTGEW		☐	NTGEW	☐	Net weight
28	GEWEI	MARA	GEWEI		☐	GEWEI	☐	Weight Unit
29	KORDB	MARC	KORDB		☐	KORDB	☐	Indicator: Source list requirement
30	STAWN	MARC	STAWN		☐	STAWN	☐	Commodity Code/Import Code Number for Foreign Trade
31	KAUTB	MARC	KAUTB		☐	KAUTB	☐	Indicator: "automatic purchase order allowed"
32	HERKL	MARC	HERKL		☐	HERKL	☐	Country of origin of the material
33	HERKR	MARC	HERKR		☐	HERKR	☐	Region of origin of material (non-preferential origin)
34	QMPUR	MARA	QMPUR		☐	QMPUR	☐	QM in procurement is active
35	SSQSS	MARC	SSQSS		☐	QSSPUR	☐	Control Key for Quality Management in Procurement
36	QZGTP	MARC	QZGTP		☐	QZGTYP	☐	Certificate Type
37	QMATV	MARC	QMATV		☐	QMATV	☐	Inspection Setup Exists for Material/Plant
38	EAN11	MARA	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
39	KZREV	MARA	KZREV		☐	KZREV	☐	Indicator: revision level has been assigned to the material
40	BRGEW	MARA	BRGEW		☐	BRGEW	☐	Gross weight
41	VOLUM	MARA	VOLUM		☐	VOLUM	☐	Volume
42	VOLEH	MARA	VOLEH		☐	VOLEH	☐	Volume unit
43	QSSYS	MARC	QSSYS		☐	QSSYS_SOLL	☐	Required QM system for vendor
44	KZKFG	MARA	KZKFG		☐	KZKFG	☐	Configurable Material
45	SATNR	MARA	SATNR		☐	SATNR	☐	Cross-Plant Configurable Material
46	ATTYP	MARA	ATTYP		☐	ATTYP	☐	Material Category
47	BESKZ	MARC	BESKZ		☐	BESKZ	☐	Procurement Type
48	SOBSL	MARC	SOBSL		☐	SOBSL	☐	Special procurement type
49	PRDHA	MARA	PRDHA		☐	PRODH_D	☐	Product Hierarchy
50	PLGTP	MARA	PLGTP		☐	PLGTP	☐	Price band category
51	SAISO	MARA	SAISO		☐	SAISO	☐	Season Category
52	SAISJ	MARA	SAISJ		☐	SAISJ	☐	Season Year
53	ETIAR	MARA	ETIAR		☐	ETIAR	☐	Label type
54	ETIFO	MARA	ETIFO		☐	ETIFO	☐	Label form
55	BWVOR	MARA	BWVOR		☐	BWVOR	☐	Procurement rule
56	MHDRZ	MARA	MHDRZ		☐	MHDRZ	☐	Minimum Remaining Shelf Life
57	MHDHB	MARA	MHDHB		☐	MHDHB	☐	Total shelf life
58	SERVG	MARC	SERVG		☐	W_SERVGRD	☐	IS-R service level
59	PRCTR	MARC	PRCTR		☐	PRCTR	☐	Profit Center
60	SBDKZ	MARC	SBDKZ		☐	SBDKZ	☐	Dependent requirements ind. for individual and coll. reqmts
61	ALTSL	MARC	ALTSL		☐	ALTSL	☐	Method for Selecting Alternative Bills of Material
62	STDPD	MARC	STDPD		☐	STDPD	☐	Configurable material
63	CUOBF	MARA	CUOBF		☐	CUOBM	☐	Internal object number
64	LGFSB	MARC	LGFSB		☐	LGFSB	☐	Default storage location for external procurement
65	DATAB	MARA	DATAB		☐	DATAB	☐	Valid-From Date
66	LIQDT	MARA	LIQDT		☐	LIQDT	☐	Deletion date
67	MSTAE	MARA	MSTAE		☐	MSTAE	☐	Cross-Plant Material Status
68	MSTDE	MARA	MSTDE		☐	MSTDE	☐	Date from which the cross-plant material status is valid
69	MRPPP	MARC	MRPPP		☐	MRPPP	☐	PPC planning calendar
70	NRFHG	MARA	NRFHG		☐	NRFHG	☐	Material qualifies for discount in kind
71	MFRGR	MARC	MFRGR		☐	MFRGR	☐	Material freight group
72	STEUC	MARC	STEUC		☐	STEUC	☐	Control code for consumption taxes in foreign trade
73	INDUS	MARC	INDUS		☐	J_1BINDUS3	☐	Material CFOP category
74	MFRPN	MARA	MFRPN		☐	MFRPN	☐	Manufacturer Part Number
75	MFRNR	MARA	MFRNR		☐	MFRNR	☐	Manufacturer number
76	BMATN	MARA	BMATN		☐	MPMAT	☐	Number of firm's own (internal) inventory-managed material
77	MPROF	MARA	MPROF		☐	MPROF	☐	Mfr part profile
78	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
79	FABKZ	MARC	FABKZ		☐	FABKZ	☐	Indicator: Item Relevant to JIT Delivery Schedules
80	XCHPF	MARC	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
81	XCHAR	MARC	XCHAR		☐	XCHAR	☐	Batch management indicator (internal)
82	IPRKZ	MARA	IPRKZ		☐	DATTP	☐	Period Indicator for Shelf Life Expiration Date
83	TRAGR	MARA	TRAGR		☐	TRAGR	☐	Transportation Group
84	SERNP	MARC	SERNP		☐	SERAIL	☐	Serial Number Profile
85	BFLME	MARA	BFLME		☐	BFLME	☐	Generic Material with Logistical Variants
86	LADGR	MARC	LADGR		☐	LADGR	☐	Loading Group
87	LFRHY	MARC	LFRHY		☐	LFRHY	☐	Planning cycle
88	PERKZ	MARC	PERKZ		☐	PERKZ	☐	Period indicator
89	PERIV	MARC	PERIV		☐	PERIV	☐	Fiscal Year Variant
90	RDPRF	MARC	RDPRF		☐	RDPRF	☐	Rounding Profile
91	BSTRF	MARC	BSTRF		☐	BSTRF	☐	Rounding value for purchase order quantity
92	BSTMA	MARC	BSTMA		☐	BSTMA	☐	Maximum lot size
93	BSTMI	MARC	BSTMI		☐	BSTMI	☐	Minimum lot size
94	MEGRU	MARC	MEGRU		☐	MEGRU	☐	Unit of Measure Group
95	PRENC	MARC	PRENC		☐	PRENC	☐	Exemption certificate: Indicator for legal control
96	.APPEND	WRF_MARC_MA06V			☐		☐
97	CONS_PROCG	MARC	CONS_PROCG		☐	WRF_CONS_PROCG	☐	Consignment Control
98	GI_PR_TIME	MARC	GI_PR_TIME		☐	WRF_PSCD_WABAZ	☐	Goods Issue Processing Time in Days
99	MULTIPLE_EKGRP	MARC	MULTIPLE_EKGRP		☐	WRF_POHF_OTHER_EKGRP_ALLOW	☐	Purchasing Across Purchasing Group

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	20140122
SAP Release Created in