SAP table MT61D (Material Master: MRP)

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
LVORM Deletion Indicator CHAR 1 0 LVORM
MAKTX Material Description CHAR 40 0 MAKTX
MTART Material type CHAR 4 0 T134 MTART
MATKL Material Group CHAR 9 0 T023 MATKL
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MMSTA Plant-Specific Material Status CHAR 2 0 T141 MMSTA
DISMM MRP Type CHAR 2 0 T438A DISMM
BESKZ Procurement Type CHAR 1 0 BESKZ
No Procurement
E In-House Production
F External Procurement
X Both Procurement Types
SOBSL Special procurement type CHAR 2 0 T460A SOBSL
MISKZ Mixed MRP indicator CHAR 1 0 MISKZ
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
DISST Low-Level Code CHAR 3 0 DISST
SBDKZ Dependent requirements ind. for individual and coll. reqmts CHAR 1 0 SBDKZ
Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
KZBED Indicator for Requirements Grouping CHAR 1 0 KZBED
0 In rep. mfg, individual record in addn to total requirements
T Display of dependent requirements as a daily total
DISPO MRP Controller CHAR 3 0 T024D DISPO
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
KZDIE Indicator: MRP controller is buyer (deactivated) CHAR 1 0 KZDIE
DZEIT In-house production time DEC 3 0 DZEIT
BEARZ Processing time DEC 5 2 BEARZ
RUEZT Setup and teardown time DEC 5 2 RUEZT
TRANZ Interoperation time DEC 5 2 TRANZ
BASMG Base quantity QUAN 13 3 BASMG
FHORI Scheduling Margin Key for Floats CHAR 3 0 T436A FHORI
PLIFZ Planned Delivery Time in Days DEC 3 0 PLIFZ
WEBAZ Goods receipt processing time in days DEC 3 0 WEBAZ
WZEIT Total replenishment lead time (in workdays) DEC 3 0 WZEIT
PFREI Indicator: automatic fixing of planned orders CHAR 1 0 PFREI
DISLS Lot Sizing Procedure within Materials Planning CHAR 2 0 T439A DISLS
BSTFE Fixed lot size QUAN 13 3 BSTFE
BSTMI Minimum Lot Size QUAN 13 3 BSTMI
BSTMA Maximum Lot Size QUAN 13 3 BSTMA
BSTRF Rounding value for purchase order quantity QUAN 13 3 BSTRF
MABST Maximum Stock Level QUAN 13 3 MABST
AUSSS Assembly scrap in percent DEC 5 2 AUSSS
EISBE Safety Stock QUAN 13 3 EISBE
MINBE Reorder Point QUAN 13 3 MINBE
LOSFX Lot-Size-Independent Costs CURR 11 2 LOSFX
LAGPR Storage Costs Percentage Code CHAR 1 0 T439L LAGPR
PROKZ Forecast indicator CHAR 1 0 PROKZ
No forecast
* Optional forecast
+ Obligatory forecast
PERKZ Period Indicator CHAR 1 0 PERKZ
Initial value
M Monthly
P Period according to fiscal year variant
T Daily
W Weekly
AUFTL Splitting Indicator CHAR 1 0 T439P AUFTL
KZAUS Discontinuation indicator CHAR 1 0 KZAUS
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
AUSDT Effective-Out Date DATS 8 0 AUSDT
NFMAT Follow-Up Material CHAR 40 0 MARA NFMAT
ALTSL Method for Selecting Alternative Bills of Material CHAR 1 0 ALTSL
Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
BKLAS Valuation Class CHAR 4 0 T025 BKLAS
VPRSV Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
VERPR Moving Average Price/Periodic Unit Price CURR 11 2 VERPR
STPRS Standard price CURR 11 2 STPRS
PEINH Price unit DEC 5 0 PEINH
UMLMC Stock in transfer (plant to plant) QUAN 13 3 UMLME
USEQU Quota arrangement usage CHAR 1 0 TMQ2 USEQU
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
MTVFP Checking Group for Availability Check CHAR 2 0 TMVF MTVFP
WERTU Value Updating in Material Master Record CHAR 1 0 WERTU
MENGU Quantity Updating in Material Master Record CHAR 1 0 MENGU
SAUFT Indicator: Repetitive Manufacturing Allowed CHAR 1 0 SA_SAUFT
MRPPP PPC Planning Calendar CHAR 3 0 T439G MRPPP
LFRHY Planning Cycle CHAR 3 0 T439G LFRHY
DISGR MRP Group CHAR 4 0 T438M DISGR
PSTAT Maintenance status CHAR 15 0 PSTAT_D
VRMOD Consumption mode CHAR 1 0 VRMOD
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
5 Period-specific consumption
VINT1 Consumption period: backward NUMC 3 0 VINT1
VINT2 Consumption period: forward NUMC 3 0 VINT2
FXHOR Planning time fence NUMC 3 0 FXHOR
QMATV Inspection Setup Exists for Material/Plant CHAR 1 0 QMATV
PRGRP Planning material CHAR 40 0 MARA VPMAT
PRWRK Planning plant CHAR 4 0 T001W VPWRK
UMREF Conversion factor: quantities FLTP 16 16 UMREFF
PRBME Base unit of measure for product group UNIT 3 0 T006 PRBME
TAKZT Takt time DEC 3 0 TAKZT
FEVOR Production Supervisor CHAR 3 0 T024F FEVOR
RWPRO Range of coverage profile CHAR 3 0 T438R RWPRO
KZREV Revision Level Has Been Assigned to the Material CHAR 1 0 KZREV
KZKFG Configurable Material CHAR 1 0 KZKFG
STDPD Configurable material CHAR 40 0 MARA STDPD
CUOBJ Internal object number NUMC 18 0 CUOBM
CUOBF Internal object number NUMC 18 0 CUOBM
LGPRO Issue Storage Location CHAR 4 0 T001L LGPRO
SFEPR Repetitive Manufacturing Profile CHAR 4 0 T437S SFEPR
RDPRF Rounding Profile CHAR 4 0 RDPRF
STRGR Planning Strategy Group CHAR 2 0 T461P STRGR
LGFSB Default storage location for external procurement CHAR 4 0 T001L LGFSB
BSTME Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
AUSME Unit of issue UNIT 3 0 T006 AUSME
EXPME Unit of measure for commodity code (foreign trade) UNIT 3 0 T006 EXPME
FRTME Production unit UNIT 3 0 T006 FRTME
SERNP Serial Number Profile CHAR 4 0 T377P SERAIL
EPRIO Withdrawal Sequence Group for Stocks CHAR 4 0 EPRIO
CUOBV Internal object number of configurable material for planning NUMC 18 0 CUOBV
BSEXT External Purchase Orders Allowed CHAR 1 0 BSEXT
0 No external purchase orders allowed
1 External purchase orders allowed, but warning issued
2 External purchase orders allowed
BSINT Internal purchase orders allowed CHAR 1 0 BSINT
0 No internal purchase orders allowed
1 Internal purchase orders allowed, but warning issued
2 Internal purchase orders allowed
KZGRP Grouping indicator CHAR 1 0 KZGRP
1 Product group
2 Free grouping
INSMK Stock Type CHAR 1 0 INSMK
Unrestricted use
S Blocked stock
X Quality inspection
RESVP Period of adjustment for planned independent requirements DEC 3 0 RESVP
XCHPF Batch Management Requirement Indicator CHAR 1 0 XCHPF
TRAME Stock in Transit QUAN 13 3 TRAME
SHFLG Safety time indicator (with or without safety time) CHAR 1 0 SHFLG
Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety Time (in Workdays) NUMC 2 0 SHZET
MDACH Action Control: Planned Order Processing CHAR 2 0 T46AC MDACH
BWSCL Source of Supply CHAR 1 0 BWSCL
SPART Division CHAR 2 0 SPART
ATTYP Material Category CHAR 2 0 ATTYP
Product
00 Single material
01 Generic material
02 Variant
10 Sales set
11 Prepack
12 Display
20 Material group material
21 Hierarchy material
22 Group material
30 Material group reference material
SATNR Cross-Plant Configurable Material CHAR 40 0 SATNR
KZWSM Units of measure usage CHAR 1 0 KZWSO
Alternative unit of measure
A Proportion unit
B Product unit
FABKZ Indicator: Item Relevant to JIT Delivery Schedules CHAR 1 0 FABKZ
No JIT
1 Automatically
SERLV Level of Explicitness for Serial Number CHAR 1 0 SERLV
Serialization within the stock material number
1 Keep equipment number and serial number synchronous
VSPVB Proposed Supply Area in Material Master Record CHAR 10 0 PVBE VSPVB
DPLFS Fair share rule CHAR 2 0 DPLFS
A Percentage breakdown
B Percentage fulfilment of target
X User exit
DPLPU Indicator: push distribution CHAR 1 0 DPLPU
Pull
P Pull/Push
X Push
DPLHO Deployment horizon in days DEC 3 0 DPLHO
MMSTD Date from Which the Plant-Specific Material Status Is Valid DATS 8 0 MMSTD
MSTAE Cross-Plant Material Status CHAR 2 0 T141 MSTAE
MSTDE Date from which the cross-plant material status is valid DATS 8 0 MSTDE
MFRPN Manufacturer Part Number CHAR 40 0 MFRPN
MFRNR Manufacturer number CHAR 10 0 MFRNR
MPROF Mfr part profile CHAR 4 0 MPROF
PRCTR Profit Center CHAR 10 0 PRCTR
KZEFF Assign effectivity parameter values/ override change numbers CHAR 1 0 CC_MTEFF
MAABC ABC Indicator CHAR 1 0 TMABC MAABC
SHPRO Period Profile for Safety Time CHAR 3 0 SHPRO
DIBER Indicator: MRP area exists CHAR 1 0 DIBER
AHDIS MRP relevancy for dependent requirements CHAR 1 0 AHDIS
Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
APOKZ Indicator: Is material relevant for APO CHAR 1 0 APOKZ
Material is not relevant to APO
1 ATP check will be carried out in APO for material
2 ATP check and planning will be carried out in APO
3 Is active in APO integration model (set automatically)
SCHGT Indicator: bulk material CHAR 1 0 SCHGT
BERID MRP Area CHAR 10 0 BERID
KZPSP Indicator for cross-project material CHAR 1 0 KZPSP
Check individual segments of project only
1 Check plant segment and all segments of projects
EISLO Minimum Safety Stock QUAN 13 3 EISLO
BFLME Generic Material with Logistical Variants CHAR 1 0 BFLME
Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
BWESB Valuated Goods Receipt Blocked Stock QUAN 13 3 BWESB
SGT_REL Segmentation Relevant CHAR 1 0 SGT_REL
SGT_COVS Segmentation Strategy CHAR 8 0 SGT_COVS
SGT_STATC Segmentation Status CHAR 1 0 SGT_STATC
SGT_PRCM Consumption Priority [Obsolete] CHAR 1 0 SGT_PRCM
1 Based on Consumption Mode and then Segmentation
2 Only if Requirement Segments Match
3 Based on Segmentation and then Consumption Mode
SGT_SCOPE Segmentation Strategy Scope CHAR 1 0 SGT_SCOPE
1 Requirement and Stock Segments maintained
2 Only Requirement Segments maintained
SGT_STK_PRT Stock Protection Indicator [Obsolete] CHAR 1 0 SGT_STK_PRT
Stock Protection Off
X Stock Protection On
SGT_MRPSI Sort Stock based on Segment CHAR 1 0 SGT_MRPSI
PPSKZ Indicator for Advanced Planning CHAR 1 0 PPSKZ
SFTY_STK_METH MRP Safety Stock Method CHAR 2 0 MRP_SSTOCK_METHOD
MB Time-dependent Safety Stock
FSH_MG_ARUN_REQ Supply Assignment (ARun) CHAR 1 0 FSH_MG_ARUN_REQ
ARun Non-Relevant
1 ARun Relevant
FPRFM Distribution profile of material in plant CHAR 3 0 * FPRFM
ARUN_FIX_BATCH Assign Batches in Supply Assignment (ARun) CHAR 1 0 ARUN_FIX_BATCH
Do not Assign Batches
1 Assign Batches
FSH_SEALV Indicator: Use of Season CHAR 1 0 FSH_SEALV
Do not use Season Year / Season
C Season Year / Season / Collection
S Use Season Year / Season
T Season Year / Season / Collection / Theme
IMATN FFF class CHAR 40 0 * IMATN
PICNUM Supersession chain number CHAR 40 0 PIC_PICNUM_SUS

MT61D foreign key relationships

Table Field Check Table Check Field
0 MT61D AUFTL T439P Split-up for forecast requirements MANDT
0 MT61D AUFTL T439P Split-up for forecast requirements PERKZ
0 MT61D AUFTL T439P Split-up for forecast requirements AUFTL
1 MT61D AUSME T006 Units of Measurement MANDT
0 MT61D BKLAS T025 Valuation Classes MANDT
0 MT61D BKLAS T025 Valuation Classes BKLAS
1 MT61D BSTME T006 Units of Measurement MANDT
0 MT61D DISGR T438M Control Parameter for MRP -Material Level- MANDT
0 MT61D DISGR T438M Control Parameter for MRP -Material Level- WERKS
0 MT61D DISGR T438M Control Parameter for MRP -Material Level- MTART
1 MT61D DISLS T439A MRP Lot Sizes MANDT
1 MT61D DISLS T439A MRP Lot Sizes DISLS
0 MT61D DISMM T438A MRP Type MANDT
0 MT61D DISMM T438A MRP Type DISMM
1 MT61D DISPO T024D MRP Controllers MANDT
1 MT61D DISPO T024D MRP Controllers WERKS
1 MT61D DISPO T024D MRP Controllers DISPO
0 MT61D EKGRP T024 Purchasing Groups EKGRP
1 MT61D EXPME T006 Units of Measurement MANDT
1 MT61D EXPME T006 Units of Measurement MSEHI
0 MT61D FEVOR T024F Production scheduler WERKS
1 MT61D FHORI T436A Floats for scheduling MANDT
1 MT61D FHORI T436A Floats for scheduling FHORI
0 MT61D FRTME T006 Units of Measurement MANDT
1 MT61D LAGPR T439L Warehouse costs for MRP lot size MANDT
1 MT61D LAGPR T439L Warehouse costs for MRP lot size LAGPR
0 MT61D LFRHY T439G PP Planning periods: header table MANDT
0 MT61D LFRHY T439G PP Planning periods: header table WERKS
1 MT61D LGFSB T001L Storage Locations MANDT
1 MT61D LGFSB T001L Storage Locations WERKS
0 MT61D LGPRO T001L Storage Locations MANDT
0 MT61D LGPRO T001L Storage Locations WERKS
1 MT61D MAABC TMABC Values Table for the ABC Indicator for Materials MANDT
0 MT61D MATKL T023 Material Groups MATKL
1 MT61D MATNR MARA General Material Data MANDT
1 MT61D MATNR MARA General Material Data MATNR
0 MT61D MDACH T46AC Action control MANDT
0 MT61D MDACH T46AC Action control MDACH
0 MT61D MDACH T46AC Action control ACCFM
0 MT61D MDACH T46AC Action control ACCTO
1 MT61D MEINS T006 Units of Measurement MANDT
1 MT61D MEINS T006 Units of Measurement MSEHI
0 MT61D MMSTA T141 Material Status from Materials Management/PPC View MANDT
0 MT61D MMSTA T141 Material Status from Materials Management/PPC View MMSTA
1 MT61D MRPPP T439G PP Planning periods: header table MANDT
1 MT61D MRPPP T439G PP Planning periods: header table WERKS
0 MT61D MSTAE T141 Material Status from Materials Management/PPC View MANDT
0 MT61D MSTAE T141 Material Status from Materials Management/PPC View MMSTA
1 MT61D MTART T134 Material Types MANDT
1 MT61D MTART T134 Material Types MTART
0 MT61D MTVFP TMVF Availability Check Control MTVFP
1 MT61D NFMAT MARA General Material Data MANDT
1 MT61D NFMAT MARA General Material Data MATNR
0 MT61D PERIV T009 Fiscal Year Variants MANDT
0 MT61D PERIV T009 Fiscal Year Variants PERIV
1 MT61D PRBME T006 Units of Measurement MANDT
0 MT61D PRGRP MARA General Material Data MANDT
0 MT61D PRGRP MARA General Material Data MATNR
1 MT61D PRWRK T001W Plants/Branches MANDT
1 MT61D PRWRK T001W Plants/Branches WERKS
0 MT61D RWPRO T438R Range of coverage profile MANDT
0 MT61D RWPRO T438R Range of coverage profile RWPRO
1 MT61D SERNP T377P Serial Number Management Profiles MANDT
0 MT61D SFEPR T437S Repetitive Manufacturing Profile Table MANDT
1 MT61D SOBSL T460A Special procurement key MANDT
1 MT61D SOBSL T460A Special procurement key WERKS
1 MT61D SOBSL T460A Special procurement key SOBSL
0 MT61D STDPD MARA General Material Data MANDT
0 MT61D STDPD MARA General Material Data MATNR
1 MT61D STRGR T461P Planning strategy group MANDT
1 MT61D STRGR T461P Planning strategy group STRGR
0 MT61D USEQU TMQ2 Quota Arrangement Rules MANDT
0 MT61D USEQU TMQ2 Quota Arrangement Rules USEQU
1 MT61D VSPVB PVBE Production Supply Area MANDT
1 MT61D VSPVB PVBE Production Supply Area WERKS
1 MT61D VSPVB PVBE Production Supply Area PRVBE
0 MT61D WERKS T001W Plants/Branches MANDT
0 MT61D WERKS T001W Plants/Branches WERKS