SAP ABAP View MA61V (Material Master: DB View for MRP)

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	MA61V
Short Description	Material Master: DB View for MRP
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	MTART	MARA	MTART		☐	MTART	☐	Material type
5	MATKL	MARA	MATKL		☐	MATKL	☐	Material Group
6	MEINS	MARA	MEINS		☐	MEINS	☐	Base Unit of Measure
7	DISST	MARA	DISST		☐	DISST	☐	Low-level code
8	PSTAT	MARC	PSTAT		☐	PSTAT_D	☐	Maintenance status
9	LVORM	MARC	LVORM		☐	LVOWK	☐	Flag Material for Deletion at Plant Level
10	MMSTA	MARC	MMSTA		☐	MMSTA	☐	Plant-Specific Material Status
11	DISMM	MARC	DISMM		☐	DISMM	☐	MRP Type
12	BESKZ	MARC	BESKZ		☐	BESKZ	☐	Procurement Type
13	SOBSL	MARC	SOBSL		☐	SOBSL	☐	Special procurement type
14	MISKZ	MARC	MISKZ		☐	MISKZ	☐	Mixed MRP indicator
15	SBDKZ	MARC	SBDKZ		☐	SBDKZ	☐	Dependent requirements ind. for individual and coll. reqmts
16	KZBED	MARC	KZBED		☐	KZBED	☐	Indicator for Requirements Grouping
17	DISPO	MARC	DISPO		☐	DISPO	☐	MRP controller
18	EKGRP	MARC	EKGRP		☐	EKGRP	☐	Purchasing group
19	KZDIE	MARC	KZDIE		☐	KZDIE	☐	Indicator: MRP controller is buyer (deactivated)
20	DZEIT	MARC	DZEIT		☐	DZEIT	☐	In-house production time
21	BEARZ	MARC	BEARZ		☐	BEARZ	☐	Processing time
22	RUEZT	MARC	RUEZT		☐	RUEZT	☐	Setup and teardown time
23	TRANZ	MARC	TRANZ		☐	TRANZ	☐	Interoperation time
24	BASMG	MARC	BASMG		☐	BASMG	☐	Base quantity
25	FHORI	MARC	FHORI		☐	FHORI	☐	Scheduling Margin Key for Floats
26	PLIFZ	MARC	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
27	WEBAZ	MARC	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
28	PFREI	MARC	PFREI		☐	PFREI	☐	Indicator: automatic fixing of planned orders
29	WZEIT	MARC	WZEIT		☐	WZEIT	☐	Total replenishment lead time (in workdays)
30	DISLS	MARC	DISLS		☐	DISLS	☐	Lot size (materials planning)
31	BSTFE	MARC	BSTFE		☐	BSTFE	☐	Fixed lot size
32	BSTMI	MARC	BSTMI		☐	BSTMI	☐	Minimum lot size
33	BSTMA	MARC	BSTMA		☐	BSTMA	☐	Maximum lot size
34	BSTRF	MARC	BSTRF		☐	BSTRF	☐	Rounding value for purchase order quantity
35	MABST	MARC	MABST		☐	MABST	☐	Maximum stock level
36	AUSSS	MARC	AUSSS		☐	AUSSS	☐	Assembly scrap in percent
37	EISBE	MARC	EISBE		☐	EISBE	☐	Safety stock
38	MINBE	MARC	MINBE		☐	MINBE	☐	Reorder point
39	LOSFX	MARC	LOSFX		☐	LOSFX	☐	Ordering costs
40	PERKZ	MARC	PERKZ		☐	PERKZ	☐	Period indicator
41	LAGPR	MARC	LAGPR		☐	LAGPR	☐	Storage costs indicator
42	AUFTL	MARC	AUFTL		☐	AUFTL	☐	Splitting Indicator
43	KZAUS	MARC	KZAUS		☐	KZAUS	☐	Discontinuation indicator
44	AUSDT	MARC	AUSDT		☐	AUSDT	☐	Effective-out date
45	NFMAT	MARC	NFMAT		☐	NFMAT	☐	Follow-up material
46	ALTSL	MARC	ALTSL		☐	ALTSL	☐	Method for Selecting Alternative Bills of Material
47	USEQU	MARC	USEQU		☐	USEQU	☐	Quota arrangement usage
48	PERIV	MARC	PERIV		☐	PERIV	☐	Fiscal Year Variant
49	AUSME	MARC	AUSME		☐	AUSME	☐	Unit of issue
50	MMSTD	MARC	MMSTD		☐	MMSTD	☐	Date from which the plant-specific material status is valid
51	MTVFP	MARC	MTVFP		☐	MTVFP	☐	Checking Group for Availability Check
52	UMLMC	MARC	UMLMC		☐	UMLME	☐	Stock in transfer (plant to plant)
53	MRPPP	MARC	MRPPP		☐	MRPPP	☐	PPC planning calendar
54	SAUFT	MARC	SAUFT		☐	SA_SAUFT	☐	Ind.: Repetitive mfg allowed
55	FXHOR	MARC	FXHOR		☐	FXHOR	☐	Planning time fence
56	VRMOD	MARC	VRMOD		☐	VRMOD	☐	Consumption mode
57	VINT1	MARC	VINT1		☐	VINT1	☐	Consumption period: backward
58	VINT2	MARC	VINT2		☐	VINT2	☐	Consumption period: forward
59	DISGR	MARC	DISGR		☐	DISGR	☐	MRP Group
60	KAUSF	MARC	KAUSF		☐	KAUSF	☐	Component scrap in percent
61	QMATV	MARC	QMATV		☐	QMATV	☐	Inspection Setup Exists for Material/Plant
62	TAKZT	MARC	TAKZT		☐	TAKZT	☐	Takt time
63	FEVOR	MARC	FEVOR		☐	FEVOR	☐	Production Supervisor
64	RWPRO	MARC	RWPRO		☐	RWPRO	☐	Range of coverage profile
65	KZREV	MARA	KZREV		☐	KZREV	☐	Indicator: revision level has been assigned to the material
66	KZKFG	MARA	KZKFG		☐	KZKFG	☐	Configurable Material
67	LGPRO	MARC	LGPRO		☐	LGPRO	☐	Issue storage location
68	CUOBJ	MARC	CUOBJ		☐	CUOBM	☐	Internal object number
69	STDPD	MARC	STDPD		☐	STDPD	☐	Configurable material
70	SFEPR	MARC	SFEPR		☐	SFEPR	☐	Repetitive manufacturing profile
71	STRGR	MARC	STRGR		☐	STRGR	☐	Planning strategy group
72	RDPRF	MARC	RDPRF		☐	RDPRF	☐	Rounding Profile
73	LFRHY	MARC	LFRHY		☐	LFRHY	☐	Planning cycle
74	LGFSB	MARC	LGFSB		☐	LGFSB	☐	Default storage location for external procurement
75	BSTME	MARA	BSTME		☐	BSTME	☐	Order unit
76	EXPME	MARC	EXPME		☐	EXPME	☐	Unit of measure for commodity code (foreign trade)
77	FRTME	MARC	FRTME		☐	FRTME	☐	Production unit
78	SERNP	MARC	SERNP		☐	SERAIL	☐	Serial Number Profile
79	EPRIO	MARC	EPRIO		☐	BF_GROUP	☐	Stock determination group
80	CUOBV	MARC	CUOBV		☐	CUOBV	☐	Internal object number of configurable material for planning
81	INSMK	MARC	INSMK		☐	INSMK_MAT	☐	Post to Inspection Stock
82	RESVP	MARC	RESVP		☐	RESVP	☐	Period of adjustment for planned independent requirements
83	XCHPF	MARC	XCHPF		☐	XCHPF	☐	Batch management requirement indicator
84	TRAME	MARC	TRAME		☐	TRAME	☐	Stock in transit
85	SHFLG	MARC	SHFLG		☐	SHFLG	☐	Safety time indicator (with or without safety time)
86	SHZET	MARC	SHZET		☐	SHZET	☐	Safety time (in workdays)
87	MDACH	MARC	MDACH		☐	MDACH	☐	Action control: planned order processing
88	BWSCL	MARC	BWSCL		☐	BWSCL	☐	Source of Supply
89	SPART	MARA	SPART		☐	SPART	☐	Division
90	ATTYP	MARA	ATTYP		☐	ATTYP	☐	Material Category
91	SATNR	MARA	SATNR		☐	SATNR	☐	Cross-Plant Configurable Material
92	CUOBF	MARA	CUOBF		☐	CUOBM	☐	Internal object number
93	FABKZ	MARC	FABKZ		☐	FABKZ	☐	Indicator: Item Relevant to JIT Delivery Schedules
94	SERLV	MARA	SERLV		☐	SERLV	☐	Level of Explicitness for Serial Number
95	MSTAE	MARA	MSTAE		☐	MSTAE	☐	Cross-Plant Material Status
96	MSTDE	MARA	MSTDE		☐	MSTDE	☐	Date from which the cross-plant material status is valid
97	VSPVB	MARC	VSPVB		☐	VSPVB	☐	Proposed Supply Area in Material Master Record
98	DPLFS	MARC	DPLFS		☐	DPLFS	☐	Fair share rule
99	DPLPU	MARC	DPLPU		☐	DPLPU	☐	Indicator: push distribution
100	DPLHO	MARC	DPLHO		☐	DPLHO	☐	Deployment horizon in days
101	KZWSM	MARA	KZWSM		☐	KZWSO	☐	Units of measure usage
102	SCHGT	MARC	SCHGT		☐	SCHGT	☐	Indicator: bulk material
103	MFRPN	MARA	MFRPN		☐	MFRPN	☐	Manufacturer Part Number
104	MFRNR	MARA	MFRNR		☐	MFRNR	☐	Manufacturer number
105	MPROF	MARA	MPROF		☐	MPROF	☐	Mfr part profile
106	PRCTR	MARC	PRCTR		☐	PRCTR	☐	Profit Center
107	KZEFF	MARA	KZEFF		☐	CC_MTEFF	☐	Assign effectivity parameter values/ override change numbers
108	MAABC	MARC	MAABC		☐	MAABC	☐	ABC indicator
109	SHPRO	MARC	SHPRO		☐	SHPRO	☐	Period profile for safety time
110	AHDIS	MARC	AHDIS		☐	AHDIS	☐	MRP relevancy for dependent requirements
111	DIBER	MARC	DIBER		☐	DIBER	☐	Indicator: MRP area exists
112	APOKZ	MARC	APOKZ		☐	APOKZ	☐	Indicator: Is material relevant for APO
113	KZPSP	MARC	KZPSP		☐	KZPSP	☐	Indicator for cross-project material
114	EISLO	MARC	EISLO		☐	EISLO	☐	Minimum Safety Stock
115	BFLME	MARA	BFLME		☐	BFLME	☐	Generic Material with Logistical Variants
116	BWESB	MARC	BWESB		☐	BWESB	☐	Valuated Goods Receipt Blocked Stock

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