SAP Table MA61V

Generated Table for View

MA61V (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MA61V to other SAP tables.

MA61V table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR CHAR 18 0
WERKS Plant WERKS_D T001W CHAR 4 0
MTART Material Type MTART T134 CHAR 4 0
MATKL Material Group MATKL T023 CHAR 9 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
DISST Low-Level Code DISST CHAR 3 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
LVORM Flag Material for Deletion at Plant Level LVOWK CHAR 1 0
X Yes
NULL No
MMSTA Plant-Specific Material Status MMSTA T141 CHAR 2 0
DISMM MRP Type DISMM T438A CHAR 2 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBSL Special procurement type SOBSL T460A CHAR 2 0
MISKZ Mixed MRP indicator MISKZ CHAR 1 0
1 Subassembly planning with final assembly
2 Gross requirements planning
3 Subassembly planning without final assembly
SBDKZ Dependent requirements ind. for individual and coll. reqmts SBDKZ CHAR 1 0
NULL Individual and collective requirements
1 Individual requirements only
2 Collective requirements only
KZBED Indicator for Requirements Grouping KZBED CHAR 1 0
T Display of dependent requirements as a daily total
0 In rep. mfg, individual record in addn to total requirements
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
EKGRP Purchasing Group EKGRP T024 CHAR 3 0
KZDIE Indicator: MRP controller is buyer (deactivated) KZDIE CHAR 1 0
X Yes
NULL No
DZEIT In-house production time DZEIT DEC 3 0
BEARZ Processing time BEARZ DEC 5 2
RUEZT Setup and teardown time RUEZT DEC 5 2
TRANZ Interoperation time TRANZ DEC 5 2
BASMG Base quantity BASMG QUAN 13 3
FHORI Scheduling Margin Key for Floats FHORI T436A CHAR 3 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
PFREI Indicator: automatic fixing of planned orders PFREI CHAR 1 0
X Yes
NULL No
WZEIT Total replenishment lead time (in workdays) WZEIT DEC 3 0
DISLS Lot size (materials planning) DISLS T439A CHAR 2 0
BSTFE Fixed lot size BSTFE QUAN 13 3
BSTMI Minimum Lot Size BSTMI QUAN 13 3
BSTMA Maximum Lot Size BSTMA QUAN 13 3
BSTRF Rounding value for purchase order quantity BSTRF QUAN 13 3
MABST Maximum stock level MABST QUAN 13 3
AUSSS Assembly scrap in percent AUSSS DEC 5 2
EISBE Safety Stock EISBE QUAN 13 3
MINBE Reorder Point MINBE QUAN 13 3
LOSFX Ordering costs LOSFX CURR 11 2
PERKZ Period Indicator PERKZ CHAR 1 0
P Period according to fiscal year variant
M Monthly
W Weekly
T Daily
NULL Initial value
LAGPR Storage costs indicator LAGPR T439L CHAR 1 0
AUFTL Splitting Indicator AUFTL T439P CHAR 1 0
KZAUS Discontinuation indicator KZAUS CHAR 1 0
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
AUSDT Effective-Out Date AUSDT DATS 8 0
NFMAT Follow-Up Material NFMAT MARA CHAR 18 0
ALTSL Method for Selecting Alternative Bills of Material ALTSL CHAR 1 0
NULL Selection by order quant.
1 Selection by explosion date
2 Selection by production version
3 Selection only by production version
USEQU Quota arrangement usage USEQU TMQ2 CHAR 1 0
PERIV Fiscal Year Variant PERIV T009 CHAR 2 0
AUSME Unit of issue AUSME T006 UNIT 3 0
MMSTD Date from which the plant-specific material status is valid MMSTD DATS 8 0
MTVFP Checking Group for Availability Check MTVFP TMVF CHAR 2 0
UMLMC Stock in Transfer (Plant to Plant) UMLME QUAN 13 3
MRPPP PPC planning calendar MRPPP T439G CHAR 3 0
SAUFT Ind.: Repetitive mfg allowed SA_SAUFT CHAR 1 0
X Yes
NULL No
FXHOR Planning time fence FXHOR NUMC 3 0
VRMOD Consumption mode VRMOD CHAR 1 0
1 Backward consumption only
2 Backward/forward consumption
3 Forward consumption only
4 Forward/backward consumption
VINT1 Consumption period: backward VINT1 NUMC 3 0
VINT2 Consumption period: forward VINT2 NUMC 3 0
DISGR MRP Group DISGR T438M CHAR 4 0
KAUSF Component scrap in percent KAUSF DEC 5 2
QMATV Inspection Setup Exists for Material/Plant QMATV CHAR 1 0
X Yes
NULL No
TAKZT Takt time TAKZT DEC 3 0
FEVOR Production Supervisor FEVOR T024F CHAR 3 0
RWPRO Range of coverage profile RWPRO T438R CHAR 3 0
KZREV Revision Level Has Been Assigned to the Material KZREV CHAR 1 0
X Yes
NULL No
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
LGPRO Issue Storage Location LGPRO T001L CHAR 4 0
CUOBJ Internal object number CUOBM NUMC 18 0
STDPD Configurable material STDPD MARA CHAR 18 0
SFEPR Repetitive manufacturing profile SFEPR T437S CHAR 4 0
STRGR Planning strategy group STRGR T461P CHAR 2 0
RDPRF Rounding Profile RDPRF RDPR CHAR 4 0
LFRHY Planning cycle LFRHY CHAR 3 0
LGFSB Default storage location for external procurement LGFSB T001L CHAR 4 0
BSTME Purchase Order Unit of Measure BSTME T006 UNIT 3 0
EXPME Unit of measure for commodity code (foreign trade) EXPME T006 UNIT 3 0
FRTME Production unit FRTME T006 UNIT 3 0
SERNP Serial Number Profile SERAIL T377P CHAR 4 0
EPRIO Stock determination group BF_GROUP T434G CHAR 4 0
CUOBV Internal object number of configurable material for planning CUOBV NUMC 18 0
INSMK Post to Inspection Stock INSMK_MAT CHAR 1 0
NULL Indicator is not set
X Indicator is set
RESVP Period of adjustment for planned independent requirements RESVP DEC 3 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
TRAME Stock in Transit TRAME QUAN 13 3
SHFLG Safety time indicator (with or without safety time) SHFLG CHAR 1 0
NULL Ignore safety time
1 Safety time for independent reqmts
2 Safety time for all requirements
SHZET Safety time (in workdays) SHZET NUMC 2 0
MDACH Action control: planned order processing MDACH T46AC CHAR 2 0
BWSCL Source of Supply BWSCL TMBW1 CHAR 1 0
SPART Division SPART TSPA CHAR 2 0
ATTYP Material Category ATTYP CHAR 2 0
NULL Single material (industry)
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 SATNR MARA CHAR 18 0
CUOBF Internal object number CUOBM NUMC 18 0
FABKZ Indicator: Item Relevant to JIT Delivery Schedules FABKZ CHAR 1 0
NULL No JIT
1 Automatically
SERLV Level of Explicitness for Serial Number SERLV CHAR 1 0
NULL Serialization within the stock material number
1 Keep equipment number and serial number synchronous
MSTAE Cross-Plant Material Status MSTAE T141 CHAR 2 0
MSTDE Date from which the cross-plant material status is valid MSTDE DATS 8 0
VSPVB Proposed Supply Area in Material Master Record VSPVB PVBE CHAR 10 0
DPLFS Fair share rule DPLFS CHAR 2 0
A Percentage breakdown
B Percentage fulfilment of target
X User exit
DPLPU Indicator: push distribution DPLPU CHAR 1 0
NULL Pull
P Pull/Push
X Push
DPLHO Deployment horizon in days DPLHO DEC 3 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit
SCHGT Indicator: Bulk Material SCHGT CHAR 1 0
X Yes
NULL No
MFRPN Manufacturer Part Number MFRPN CHAR 40 0
MFRNR Number of a Manufacturer MFRNR LFA1 CHAR 10 0
MPROF Manufacturer Part Profile MPROF TMPPF CHAR 4 0
PRCTR Profit Center PRCTR CHAR 10 0
KZEFF Assign effectivity parameter values/ override change numbers CC_MTEFF CHAR 1 0
X Yes
NULL No
MAABC ABC Indicator MAABC TMABC CHAR 1 0
SHPRO Period Profile for Safety Time SHPRO T438V CHAR 3 0
AHDIS MRP relevancy for dependent requirements AHDIS CHAR 1 0
NULL Materials for dependent requirements are planned
1 Materials for dependent requirements are not planned
DIBER Indicator: MRP area exists DIBER CHAR 1 0
X Yes
NULL No
APOKZ Indicator: Is material relevant for APO APOKZ CHAR 1 0
NULL 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)
KZPSP Indicator for cross-project material KZPSP CHAR 1 0
NULL Check individual segments of project only
1 Check plant segment and all segments of projects
EISLO Minimum Safety Stock EISLO QUAN 13 3
BFLME Generic Material with Logistical Variants BFLME CHAR 1 0
NULL Material is not a logistical variant
1 Generic material with logistical variants
2 Sales variant
3 Procurement variant
BWESB Valuated Goods Receipt Blocked Stock BWESB QUAN 13 3

MA61V foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MA61V AUFTL MA61V PERKZ T439P Split-up for forecast requirements PERKZ
MA61V AUFTL MA61V AUFTL T439P Split-up for forecast requirements AUFTL
MA61V AUFTL MA61V MANDT T439P Split-up for forecast requirements MANDT
MA61V AUFTL MA61V WERKS T439P Split-up for forecast requirements WERKS
MA61V AUSME MA61V MANDT T006 Units of Measurement MANDT
MA61V AUSME MA61V AUSME T006 Units of Measurement MSEHI
MA61V BSTME MA61V MANDT T006 Units of Measurement MANDT
MA61V BSTME MA61V BSTME T006 Units of Measurement MSEHI
MA61V BWSCL SYST MANDT TMBW1 Source of Supply Keys MANDT
MA61V BWSCL MA61V BWSCL TMBW1 Source of Supply Keys BWSCL
MA61V DISGR MA61V MANDT T438M Control Parameter for MRP -Material Level- MANDT
MA61V DISGR MA61V WERKS T438M Control Parameter for MRP -Material Level- WERKS
MA61V DISGR MA61V DISGR T438M Control Parameter for MRP -Material Level- MTART
MA61V DISLS MA61V MANDT T439A MRP Lot Sizes MANDT
MA61V DISLS MA61V DISLS T439A MRP Lot Sizes DISLS
MA61V DISMM MA61V MANDT T438A MRP Type MANDT
MA61V DISMM MA61V DISMM T438A MRP Type DISMM
MA61V DISPO MA61V MANDT T024D MRP controllers MANDT
MA61V DISPO MA61V WERKS T024D MRP controllers WERKS
MA61V DISPO MA61V DISPO T024D MRP controllers DISPO
MA61V EKGRP MA61V MANDT T024 Purchasing Groups MANDT
MA61V EKGRP MA61V EKGRP T024 Purchasing Groups EKGRP
MA61V EPRIO MA61V EPRIO T434G Stock determination group EPRIO
MA61V EPRIO SYST MANDT T434G Stock determination group MANDT
MA61V EPRIO MA61V WERKS T434G Stock determination group WERKS
MA61V EXPME MA61V MANDT T006 Units of Measurement MANDT
MA61V EXPME MA61V EXPME T006 Units of Measurement MSEHI
MA61V FEVOR SYST MANDT T024F Production scheduler MANDT
MA61V FEVOR MA61V WERKS T024F Production scheduler WERKS
MA61V FEVOR MA61V FEVOR T024F Production scheduler FEVOR
MA61V FHORI MA61V MANDT T436A Floats for scheduling MANDT
MA61V FHORI MA61V WERKS T436A Floats for scheduling WERKS
MA61V FHORI MA61V FHORI T436A Floats for scheduling FHORI
MA61V FRTME MA61V MANDT T006 Units of Measurement MANDT
MA61V FRTME MA61V FRTME T006 Units of Measurement MSEHI
MA61V LAGPR MA61V MANDT T439L Warehouse costs for MRP lot size MANDT
MA61V LAGPR MA61V WERKS T439L Warehouse costs for MRP lot size WERKS
MA61V LAGPR MA61V LAGPR T439L Warehouse costs for MRP lot size LAGPR
MA61V LGFSB SYST MANDT T001L Storage Locations MANDT
MA61V LGFSB MA61V WERKS T001L Storage Locations WERKS
MA61V LGFSB MA61V LGFSB T001L Storage Locations LGORT
MA61V LGPRO MA61V MANDT T001L Storage Locations MANDT
MA61V LGPRO MA61V WERKS T001L Storage Locations WERKS
MA61V LGPRO MA61V LGPRO T001L Storage Locations LGORT
MA61V MAABC SYST MANDT TMABC Values Table for the ABC Indicator for Materials MANDT
MA61V MAABC MA61V MAABC TMABC Values Table for the ABC Indicator for Materials MAABC
MA61V MANDT MA61V MANDT T000 Clients MANDT
MA61V MATKL MA61V MANDT T023 Material Groups MANDT
MA61V MATKL MA61V MATKL T023 Material Groups MATKL
MA61V MDACH SY MANDT T46AC Action control MANDT
MA61V MDACH MA61V MDACH T46AC Action control MDACH
MA61V MDACH * T46AC Action control ACCFM
MA61V MDACH * T46AC Action control ACCTO
MA61V MEINS MA61V MANDT T006 Units of Measurement MANDT
MA61V MEINS MA61V MEINS T006 Units of Measurement MSEHI
MA61V MFRNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
MA61V MFRNR MA61V MFRNR LFA1 Vendor Master (General Section) LIFNR
MA61V MMSTA MA61V MANDT T141 Material Status from Materials Management/PPC View MANDT
MA61V MMSTA MA61V MMSTA T141 Material Status from Materials Management/PPC View MMSTA
MA61V MPROF MA61V MPROF TMPPF Control Profile for Manufacturer Part Number Management MPROF
MA61V MPROF SYST MANDT TMPPF Control Profile for Manufacturer Part Number Management MANDT
MA61V MRPPP MA61V MANDT T439G PPplanning periods: header table MANDT
MA61V MRPPP MA61V WERKS T439G PPplanning periods: header table WERKS
MA61V MRPPP MA61V MRPPP T439G PPplanning periods: header table MRPPP
MA61V MSTAE MA61V MSTAE T141 Material Status from Materials Management/PPC View MMSTA
MA61V MSTAE SY MANDT T141 Material Status from Materials Management/PPC View MANDT
MA61V MTART MA61V MANDT T134 Material Types MANDT
MA61V MTART MA61V MTART T134 Material Types MTART
MA61V MTVFP MA61V MANDT TMVF Availability Check Control MANDT
MA61V MTVFP MA61V MTVFP TMVF Availability Check Control MTVFP
MA61V NFMAT MA61V NFMAT MARA General Material Data MATNR
MA61V NFMAT MA61V MANDT MARA General Material Data MANDT
MA61V PERIV MA61V PERIV T009 Fiscal Year Variants PERIV
MA61V PERIV MA61V MANDT T009 Fiscal Year Variants MANDT
MA61V RDPRF * RDPR Rounding profile RDZAE
MA61V RDPRF SYST MANDT RDPR Rounding profile MANDT
MA61V RDPRF * RDPR Rounding profile WERKS
MA61V RDPRF MA61V RDPRF RDPR Rounding profile RDPRF
MA61V RWPRO MA61V MANDT T438R Range of coverage profile MANDT
MA61V RWPRO MA61V WERKS T438R Range of coverage profile WERKS
MA61V RWPRO MA61V RWPRO T438R Range of coverage profile RWPRO
MA61V SATNR SY MANDT MARA General Material Data MANDT
MA61V SATNR MA61V SATNR MARA General Material Data MATNR
MA61V SERNP MA61V MANDT T377P Serial Number Management Profiles MANDT
MA61V SERNP MA61V SERNP T377P Serial Number Management Profiles SERAIL
MA61V SFEPR MA61V MANDT T437S Repetitive Manufacturing Profile Table MANDT
MA61V SFEPR MA61V SFEPR T437S Repetitive Manufacturing Profile Table SFPRO
MA61V SHPRO MA61V SHPRO T438V Period Profile for Safety Time SHPRO
MA61V SHPRO MA61V MANDT T438V Period Profile for Safety Time MANDT
MA61V SHPRO MA61V WERKS T438V Period Profile for Safety Time WERKS
MA61V SOBSL MA61V MANDT T460A Special procurement key MANDT
MA61V SOBSL MA61V WERKS T460A Special procurement key WERKS
MA61V SOBSL MA61V SOBSL T460A Special procurement key SOBSL
MA61V SPART MA61V MANDT TSPA Organizational Unit: Sales Divisions MANDT
MA61V SPART MA61V SPART TSPA Organizational Unit: Sales Divisions SPART
MA61V STDPD MA61V MANDT MARA General Material Data MANDT
MA61V STDPD MA61V STDPD MARA General Material Data MATNR
MA61V STRGR SY MANDT T461P Planning strategy group MANDT
MA61V STRGR MA61V STRGR T461P Planning strategy group STRGR
MA61V USEQU MA61V MANDT TMQ2 Quota Arrangement Rules MANDT
MA61V USEQU MA61V USEQU TMQ2 Quota Arrangement Rules USEQU
MA61V VSPVB SYST MANDT PVBE Production Supply Area MANDT
MA61V VSPVB MA61V WERKS PVBE Production Supply Area WERKS
MA61V VSPVB MA61V VSPVB PVBE Production Supply Area PRVBE
MA61V WERKS MA61V MANDT T001W Plants/Branches MANDT
MA61V WERKS MA61V WERKS T001W Plants/Branches WERKS