SAP table MFHM (Production Resource Tool (PRT) Fields in the Material Master)

SAP table MFHM has 3 primary key fields being MANDT,MATNR,WERKS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W WERKS_D
OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
OBJID Object ID of the resource NUMC 8 0 * CR_OBJID
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
OBJTY_V Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
OBJID_V Object ID of the resource NUMC 8 0 * CR_OBJID
KZKBL Indicator: Create load records for prod. resources/tools CHAR 1 0 KZKBL
STEUF Control Profile for Management of Production Resources/Tools CHAR 4 0 TCF10 STEUF
STEUF_REF Control key cannot be changed CHAR 1 0 CF_STKZR
FGRU1 Grouping Key 1 for Production Resources/Tools CHAR 4 0 TCF12 FGRUA
FGRU2 Grouping Key 2 for Production Resources/Tools CHAR 4 0 TCF12 FGRUB
PLANV Production Resource/Tool Usage CHAR 3 0 TC23 FH_PLANV
KTSCH Standard Text Key for Production Resources/Tools CHAR 7 0 T435 CF_KTSCH
KTSCH_REF Reference Key Cannot be Changed CHAR 1 0 CF_KTKZR
BZOFFB Reference Date for Start of Production Resource/Tool Usage CHAR 2 0 TCA54 BZOFFB
BZOFFB_REF Start reference date cannot be changed CHAR 1 0 CF_BBKZR
OFFSTB Offset to start of production resource/tool usage QUAN 5 0 OFFSTB
EHOFFB Offset Unit for Start of Prodn Resource/Tool Usage UNIT 3 0 T006 EHOFFB
OFFSTB_REF Offset to start cannot be changed CHAR 1 0 CF_OBKZR
BZOFFE Reference date for end of production resource/tool usage CHAR 2 0 TCA54 BZOFFE
BZOFFE_REF End reference date cannot be changed CHAR 1 0 CF_BEKZR
OFFSTE Offset to finish of production resource/tool usage QUAN 5 0 OFFSTE
EHOFFE Offset Unit for End of Production Resource/Tool Usage UNIT 3 0 T006 EHOFFE
OFFSTE_REF Offset to end cannot be changed CHAR 1 0 CF_OEKZR
MGFORM Formula for Calculating the Total Quantity of PRT CHAR 6 0 TC25 CF_MGFORM
MGFORM_REF Formula for calculating the total quantity cannot be changed CHAR 1 0 CF_MFKZR
EWFORM Formula for Calculating the Total Usage Value of PRT CHAR 6 0 TC25 CF_EWFORM
EWFORM_REF Formula to calculate entire usage value cannot be changed CHAR 1 0 CF_EFKZR
PAR01 First parameter (for formulas) CHAR 6 0 TC20 CF_PAR01
PAR02 Second parameter (for formulas) CHAR 6 0 TC20 CF_PAR02
PAR03 Third parameter (for formulas) CHAR 6 0 TC20 CF_PAR03
PAR04 Fourth parameter (for formulas) CHAR 6 0 TC20 CF_PAR04
PAR05 Fifth parameter (for formulas) CHAR 6 0 TC20 CF_PAR05
PAR06 Sixth parameter (for formulas) CHAR 6 0 TC20 CF_PAR06
PARU1 Parameter unit UNIT 3 0 T006 CF_PARUNIT
PARU2 Parameter unit UNIT 3 0 T006 CF_PARUNIT
PARU3 Parameter unit UNIT 3 0 T006 CF_PARUNIT
PARU4 Parameter unit UNIT 3 0 T006 CF_PARUNIT
PARU5 Parameter unit UNIT 3 0 T006 CF_PARUNIT
PARU6 Parameter unit UNIT 3 0 T006 CF_PARUNIT
PARV1 Parameter value QUAN 9 3 CF_PARVAL
PARV2 Parameter value QUAN 9 3 CF_PARVAL
PARV3 Parameter value QUAN 9 3 CF_PARVAL
PARV4 Parameter value QUAN 9 3 CF_PARVAL
PARV5 Parameter value QUAN 9 3 CF_PARVAL
PARV6 Parameter value QUAN 9 3 CF_PARVAL
REGISTRABLE Specifies that the PRT can be Registered in Execution CHAR 1 0 MPE_PRT_REGISTRABLE

MFHM foreign key relationships

Table Field Check Table Check Field
0 MFHM BZOFFB TCA54 Key for reference dates used in offset scheduling BZOFF
1 MFHM BZOFFE TCA54 Key for reference dates used in offset scheduling BZOFF
0 MFHM EHOFFB T006 Units of Measurement MANDT
1 MFHM EHOFFE T006 Units of Measurement MANDT
0 MFHM EWFORM TC25 Work center formulas MANDT
1 MFHM FGRU1 TCF12 Key for grouping production resources/tools MANDT
0 MFHM FGRU2 TCF12 Key for grouping production resources/tools MANDT
1 MFHM KTSCH T435 Standard texts for routing/ref. op set items MANDT
0 MFHM MATNR MARA General Material Data MANDT
0 MFHM MATNR MARA General Material Data MATNR
1 MFHM MGFORM TC25 Work center formulas MANDT
0 MFHM PAR01 TC20 "Formula Parameters" MANDT
0 MFHM PAR01 TC20 "Formula Parameters" PARID
1 MFHM PAR02 TC20 "Formula Parameters" MANDT
1 MFHM PAR02 TC20 "Formula Parameters" PARID
0 MFHM PAR03 TC20 "Formula Parameters" MANDT
0 MFHM PAR03 TC20 "Formula Parameters" PARID
1 MFHM PAR04 TC20 "Formula Parameters" MANDT
1 MFHM PAR04 TC20 "Formula Parameters" PARID
0 MFHM PAR05 TC20 "Formula Parameters" MANDT
0 MFHM PAR05 TC20 "Formula Parameters" PARID
1 MFHM PAR06 TC20 "Formula Parameters" MANDT
1 MFHM PAR06 TC20 "Formula Parameters" PARID
0 MFHM PARU1 T006 Units of Measurement MANDT
0 MFHM PARU1 T006 Units of Measurement MSEHI
1 MFHM PARU2 T006 Units of Measurement MANDT
1 MFHM PARU2 T006 Units of Measurement MSEHI
0 MFHM PARU3 T006 Units of Measurement MANDT
0 MFHM PARU3 T006 Units of Measurement MSEHI
1 MFHM PARU4 T006 Units of Measurement MANDT
1 MFHM PARU4 T006 Units of Measurement MSEHI
0 MFHM PARU5 T006 Units of Measurement MANDT
0 MFHM PARU5 T006 Units of Measurement MSEHI
1 MFHM PARU6 T006 Units of Measurement MANDT
1 MFHM PARU6 T006 Units of Measurement MSEHI
0 MFHM PLANV TC23 Key for use of the work center in the task lists MANDT
1 MFHM STEUF TCF10 PRT control key MANDT
0 MFHM WERKS T001W Plants/Branches MANDT
0 MFHM WERKS T001W Plants/Branches WERKS