SAP ABAP Table MT61D (Material Master: 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

Table Category	INTTAB	Structure
Structure	MT61D	Table Relationship Diagram
Short Description	Material Master: MRP

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	MARA
2	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
3	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
4	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
5	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
6	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
7	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
8	MMSTA	☐	MMSTA	MMSTA	CHAR	2	0	Plant-Specific Material Status	T141
9	DISMM	☐	DISMM	DISMM	CHAR	2	0	MRP Type	T438A
10	BESKZ	☐	BESKZ	BESKZ	CHAR	1	0	Procurement Type
11	SOBSL	☐	SOBSL	SOBSL	CHAR	2	0	Special procurement type	T460A
12	MISKZ	☐	MISKZ	MISKZ	CHAR	1	0	Mixed MRP indicator
13	DISST	☐	DISST	DISST	CHAR	3	0	Low-level code
14	SBDKZ	☐	SBDKZ	SBDKZ	CHAR	1	0	Dependent requirements ind. for individual and coll. reqmts
15	KZBED	☐	KZBED	KZBED	CHAR	1	0	Indicator for Requirements Grouping
16	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
17	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
18	KZDIE	☐	KZDIE	XFELD	CHAR	1	0	Indicator: MRP controller is buyer (deactivated)
19	DZEIT	☐	DZEIT	DEC3	DEC	3	0	In-house production time
20	BEARZ	☐	BEARZ	DEC3_2	DEC	5	2	Processing time
21	RUEZT	☐	RUEZT	DEC3_2	DEC	5	2	Setup and teardown time
22	TRANZ	☐	TRANZ	DEC3_2	DEC	5	2	Interoperation time
23	BASMG	☐	BASMG	MENG13	QUAN	13	3	Base quantity
24	FHORI	☐	FHORI	FHORI	CHAR	3	0	Scheduling Margin Key for Floats	T436A
25	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
26	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
27	WZEIT	☐	WZEIT	DEC3	DEC	3	0	Total replenishment lead time (in workdays)
28	PFREI	☐	PFREI	XFELD	CHAR	1	0	Indicator: automatic fixing of planned orders
29	DISLS	☐	DISLS	DISLS	CHAR	2	0	Lot size (materials planning)	T439A
30	BSTFE	☐	BSTFE	MENG13	QUAN	13	3	Fixed lot size
31	BSTMI	☐	BSTMI	MENG13	QUAN	13	3	Minimum lot size
32	BSTMA	☐	BSTMA	MENG13	QUAN	13	3	Maximum lot size
33	BSTRF	☐	BSTRF	MENG13	QUAN	13	3	Rounding value for purchase order quantity
34	MABST	☐	MABST	MENG13	QUAN	13	3	Maximum stock level
35	AUSSS	☐	AUSSS	DEC3_2	DEC	5	2	Assembly scrap in percent
36	EISBE	☐	EISBE	MENG13	QUAN	13	3	Safety stock
37	MINBE	☐	MINBE	MENG13	QUAN	13	3	Reorder point
38	LOSFX	☐	LOSFX	WERT11	CURR	11	2	Ordering costs
39	LAGPR	☐	LAGPR	LAGPR	CHAR	1	0	Storage costs indicator	T439L
40	PROKZ	☐	PROKZ	PROKZ	CHAR	1	0	Forecast indicator
41	PERKZ	☐	PERKZ	PERKZ	CHAR	1	0	Period indicator
42	AUFTL	☐	AUFTL	AUFTL	CHAR	1	0	Splitting Indicator	T439P
43	KZAUS	☐	KZAUS	KZAUS	CHAR	1	0	Discontinuation indicator
44	AUSDT	☐	AUSDT	DATUM	DATS	8	0	Effective-out date
45	NFMAT	☐	NFMAT	MATNR	CHAR	18	0	Follow-up material	MARA
46	ALTSL	☐	ALTSL	ALTSL	CHAR	1	0	Method for Selecting Alternative Bills of Material
47	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
48	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
49	VERPR	☐	VERPR	WERT11V	CURR	11	2	Moving Average Price/Periodic Unit Price
50	STPRS	☐	STPRS	WERT11V	CURR	11	2	Standard price
51	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
52	UMLMC	☐	UMLME	MENG13V	QUAN	13	3	Stock in transfer (plant to plant)
53	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	TMQ2
54	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
55	MTVFP	☐	MTVFP	MTVFP	CHAR	2	0	Checking Group for Availability Check	TMVF
56	WERTU	☐	WERTU	XFELD	CHAR	1	0	Value Updating in Material Master Record
57	MENGU	☐	MENGU	XFELD	CHAR	1	0	Quantity Updating in Material Master Record
58	SAUFT	☐	SA_SAUFT	XFELD	CHAR	1	0	Ind.: Repetitive mfg allowed
59	MRPPP	☐	MRPPP	MRPPP	CHAR	3	0	PPC planning calendar	T439G
60	LFRHY	☐	LFRHY	MRPPP	CHAR	3	0	Planning cycle	T439G
61	DISGR	☐	DISGR	DISGR	CHAR	4	0	MRP Group	T438M
62	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
63	VRMOD	☐	VRMOD	VRMOD	CHAR	1	0	Consumption mode
64	VINT1	☐	VINT1	VRINT	NUMC	3	0	Consumption period: backward
65	VINT2	☐	VINT2	VRINT	NUMC	3	0	Consumption period: forward
66	FXHOR	☐	FXHOR	FXHOR	NUMC	3	0	Planning time fence
67	QMATV	☐	QMATV	XFELD	CHAR	1	0	Inspection Setup Exists for Material/Plant
68	PRGRP	☐	VPMAT	MATNR	CHAR	18	0	Planning material	MARA
69	PRWRK	☐	VPWRK	WERKS	CHAR	4	0	Planning plant	T001W
70	UMREF	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
71	PRBME	☐	PRBME	MEINS	UNIT	3	0	Base unit of measure for product group	T006
72	TAKZT	☐	TAKZT	DEC3	DEC	3	0	Takt time
73	FEVOR	☐	FEVOR	FEVOR	CHAR	3	0	Production Supervisor	T024F
74	RWPRO	☐	RWPRO	RWPRO	CHAR	3	0	Range of coverage profile	T438R
75	KZREV	☐	KZREV	XFELD	CHAR	1	0	Indicator: revision level has been assigned to the material
76	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
77	STDPD	☐	STDPD	MATNR	CHAR	18	0	Configurable material	MARA
78	CUOBJ	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
79	CUOBF	☐	CUOBM	CUOBJ	NUMC	18	0	Internal object number
80	LGPRO	☐	LGPRO	LGORT	CHAR	4	0	Issue storage location	T001L
81	SFEPR	☐	SFEPR	SFEPR	CHAR	4	0	Repetitive manufacturing profile	T437S
82	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	*
83	STRGR	☐	STRGR	STRGR	CHAR	2	0	Planning strategy group	T461P
84	LGFSB	☐	LGFSB	LGORT	CHAR	4	0	Default storage location for external procurement	T001L
85	BSTME	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
86	AUSME	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	T006
87	EXPME	☐	EXPME	MEINS	UNIT	3	0	Unit of measure for commodity code (foreign trade)	T006
88	FRTME	☐	FRTME	MEINS	UNIT	3	0	Production unit	T006
89	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	T377P
90	EPRIO	☐	EPRIO	EPRIO	CHAR	4	0	Withdrawal sequence group for stocks	*
91	CUOBV	☐	CUOBV	CUOBJ	NUMC	18	0	Internal object number of configurable material for planning
92	BSEXT	☐	BSEXT	BSEXT	CHAR	1	0	External Purchase Orders Allowed
93	BSINT	☐	BSINT	BSINT	CHAR	1	0	Internal purchase orders allowed
94	KZGRP	☐	KZGRP	KZGRP	CHAR	1	0	Grouping indicator
95	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
96	RESVP	☐	RESVP	RESVP	DEC	3	0	Period of adjustment for planned independent requirements
97	XCHPF	☐	XCHPF	XFELD	CHAR	1	0	Batch management requirement indicator
98	TRAME	☐	TRAME	MENG13V	QUAN	13	3	Stock in transit
99	SHFLG	☐	SHFLG	SHFLG	CHAR	1	0	Safety time indicator (with or without safety time)
100	SHZET	☐	SHZET	NUMC2	NUMC	2	0	Safety time (in workdays)
101	MDACH	☐	MDACH	MDACH	CHAR	2	0	Action control: planned order processing	T46AC
102	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	*
103	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
104	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
105	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
106	KZWSM	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
107	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
108	SERLV	☐	SERLV	SERLV	CHAR	1	0	Level of Explicitness for Serial Number
109	VSPVB	☐	VSPVB	PRVBE	CHAR	10	0	Proposed Supply Area in Material Master Record	PVBE
110	DPLFS	☐	DPLFS	DPLFS	CHAR	2	0	Fair share rule
111	DPLPU	☐	DPLPU	DPLPU	CHAR	1	0	Indicator: push distribution
112	DPLHO	☐	DPLHO	DEC3	DEC	3	0	Deployment horizon in days
113	MMSTD	☐	MMSTD	DATUM	DATS	8	0	Date from which the plant-specific material status is valid
114	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
115	MSTDE	☐	MSTDE	DATUM	DATS	8	0	Date from which the cross-plant material status is valid
116	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
117	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
118	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
119	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
120	KZEFF	☐	CC_MTEFF	XFELD	CHAR	1	0	Assign effectivity parameter values/ override change numbers
121	MAABC	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	TMABC
122	SHPRO	☐	SHPRO	SHPRO	CHAR	3	0	Period profile for safety time	*
123	DIBER	☐	DIBER	XFELD	CHAR	1	0	Indicator: MRP area exists
124	AHDIS	☐	AHDIS	AHDIS	CHAR	1	0	MRP relevancy for dependent requirements
125	APOKZ	☐	APOKZ	APOKZ	CHAR	1	0	Indicator: Is material relevant for APO
126	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
127	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
128	KZPSP	☐	KZPSP	KZPSP	CHAR	1	0	Indicator for cross-project material
129	EISLO	☐	EISLO	MENG13	QUAN	13	3	Minimum Safety Stock
130	BFLME	☐	BFLME	BFLME	CHAR	1	0	Generic Material with Logistical Variants
131	BWESB	☐	BWESB	MENG13V	QUAN	13	3	Valuated Goods Receipt Blocked Stock

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MT61D	AUFTL	T439P	AUFTL
2	MT61D	AUSME	T006	MSEHI
3	MT61D	BKLAS	T025	BKLAS
4	MT61D	BSTME	T006	MSEHI
5	MT61D	DISGR	T438M	MTART
6	MT61D	DISLS	T439A	DISLS
7	MT61D	DISMM	T438A	DISMM
8	MT61D	DISPO	T024D	DISPO
9	MT61D	EKGRP	T024	EKGRP
10	MT61D	EXPME	T006	MSEHI
11	MT61D	FEVOR	T024F	FEVOR
12	MT61D	FHORI	T436A	FHORI
13	MT61D	FRTME	T006	MSEHI
14	MT61D	LAGPR	T439L	LAGPR
15	MT61D	LFRHY	T439G	MRPPP
16	MT61D	LGFSB	T001L	LGORT
17	MT61D	LGPRO	T001L	LGORT
18	MT61D	MAABC	TMABC	MAABC
19	MT61D	MATKL	T023	MATKL
20	MT61D	MATNR	MARA	MATNR
21	MT61D	MDACH	T46AC	MDACH
22	MT61D	MEINS	T006	MSEHI
23	MT61D	MMSTA	T141	MMSTA
24	MT61D	MRPPP	T439G	MRPPP
25	MT61D	MSTAE	T141	MMSTA
26	MT61D	MTART	T134	MTART
27	MT61D	MTVFP	TMVF	MTVFP
28	MT61D	NFMAT	MARA	MATNR
29	MT61D	PERIV	T009	PERIV
30	MT61D	PRBME	T006	MSEHI
31	MT61D	PRGRP	MARA	MATNR
32	MT61D	PRWRK	T001W	WERKS
33	MT61D	RWPRO	T438R	RWPRO
34	MT61D	SERNP	T377P	SERAIL
35	MT61D	SFEPR	T437S	SFPRO
36	MT61D	SOBSL	T460A	SOBSL
37	MT61D	STDPD	MARA	MATNR
38	MT61D	STRGR	T461P	STRGR
39	MT61D	USEQU	TMQ2	USEQU
40	MT61D	VSPVB	PVBE	PRVBE
41	MT61D	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in