SAP Table MFHM
Production Resource Tool (PRT) Fields in the Material Master
MFHM (Production Resource Tool (PRT) Fields in the Material Master) 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 MFHM to other SAP tables.
MFHM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||
| OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||
| OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | 0 | |||||||||||
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||
| OBJTY_V | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||
| OBJID_V | Object ID of the resource | CR_OBJID | NUMC | 8 | 0 | |||||||||||
| KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR | 1 | 0 |
Possible values
|
||||||||||
| STEUF | Control key for management of production resources/tools | STEUF | TCF10 | CHAR | 4 | 0 | ||||||||||
| STEUF_REF | Control key cannot be changed | CF_STKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| FGRU1 | Grouping key 1 for production resources/tools | FGRUA | TCF12 | CHAR | 4 | 0 | ||||||||||
| FGRU2 | Grouping key 2 for production resources/tools | FGRUB | TCF12 | CHAR | 4 | 0 | ||||||||||
| PLANV | Production resource/tool usage | FH_PLANV | TC23 | CHAR | 3 | 0 | ||||||||||
| KTSCH | Standard text key for production resources/tools | CF_KTSCH | T435 | CHAR | 7 | 0 | ||||||||||
| KTSCH_REF | Reference Key Cannot be Changed | CF_KTKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| BZOFFB | Reference date to start of production resource/tool usage | BZOFFB | TCA54 | CHAR | 2 | 0 | ||||||||||
| BZOFFB_REF | Start reference date cannot be changed | CF_BBKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| OFFSTB | Offset to start of production resource/tool usage | OFFSTB | QUAN | 5 | 0 | |||||||||||
| EHOFFB | Offset unit for start of prod. resource/tool usage | EHOFFB | T006 | UNIT | 3 | 0 | ||||||||||
| OFFSTB_REF | Offset to start cannot be changed | CF_OBKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| BZOFFE | Reference date for end of production resource/tool usage | BZOFFE | TCA54 | CHAR | 2 | 0 | ||||||||||
| BZOFFE_REF | End reference date cannot be changed | CF_BEKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| OFFSTE | Offset to finish of production resource/tool usage | OFFSTE | QUAN | 5 | 0 | |||||||||||
| EHOFFE | Offset unit for end of production resource/tool usage | EHOFFE | T006 | UNIT | 3 | 0 | ||||||||||
| OFFSTE_REF | Offset to end cannot be changed | CF_OEKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| MGFORM | Formula for calculating the total quantity of PRT | CF_MGFORM | TC25 | CHAR | 6 | 0 | ||||||||||
| MGFORM_REF | Formula for calculating the total quantity cannot be changed | CF_MFKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| EWFORM | Formula for calculating the total usage value of PRT | CF_EWFORM | TC25 | CHAR | 6 | 0 | ||||||||||
| EWFORM_REF | Formula to calculate entire usage value cannot be changed | CF_EFKZR | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PAR01 | First parameter (for formulas) | CF_PAR01 | TC20 | CHAR | 6 | 0 | ||||||||||
| PAR02 | Second parameter (for formulas) | CF_PAR02 | TC20 | CHAR | 6 | 0 | ||||||||||
| PAR03 | Third parameter (for formulas) | CF_PAR03 | TC20 | CHAR | 6 | 0 | ||||||||||
| PAR04 | Fourth parameter (for formulas) | CF_PAR04 | TC20 | CHAR | 6 | 0 | ||||||||||
| PAR05 | Fifth parameter (for formulas) | CF_PAR05 | TC20 | CHAR | 6 | 0 | ||||||||||
| PAR06 | Sixth parameter (for formulas) | CF_PAR06 | TC20 | CHAR | 6 | 0 | ||||||||||
| PARU1 | Parameter unit | CF_PARUNIT | T006 | UNIT | 3 | 0 | ||||||||||
| PARU2 | Parameter unit | CF_PARUNIT | T006 | UNIT | 3 | 0 | ||||||||||
| PARU3 | Parameter unit | CF_PARUNIT | T006 | UNIT | 3 | 0 | ||||||||||
| PARU4 | Parameter unit | CF_PARUNIT | T006 | UNIT | 3 | 0 | ||||||||||
| PARU5 | Parameter unit | CF_PARUNIT | T006 | UNIT | 3 | 0 | ||||||||||
| PARU6 | Parameter unit | CF_PARUNIT | T006 | UNIT | 3 | 0 | ||||||||||
| PARV1 | Parameter value | CF_PARVAL | QUAN | 9 | 3 | |||||||||||
| PARV2 | Parameter value | CF_PARVAL | QUAN | 9 | 3 | |||||||||||
| PARV3 | Parameter value | CF_PARVAL | QUAN | 9 | 3 | |||||||||||
| PARV4 | Parameter value | CF_PARVAL | QUAN | 9 | 3 | |||||||||||
| PARV5 | Parameter value | CF_PARVAL | QUAN | 9 | 3 | |||||||||||
| PARV6 | Parameter value | CF_PARVAL | QUAN | 9 | 3 | |||||||||||
MFHM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MFHM | BZOFFB | MFHM | BZOFFB | TCA54 | Key for reference dates used in offset scheduling | BZOFF |
| MFHM | BZOFFE | MFHM | BZOFFE | TCA54 | Key for reference dates used in offset scheduling | BZOFF |
| MFHM | EHOFFB | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | EHOFFB | MFHM | EHOFFB | T006 | Units of Measurement | MSEHI |
| MFHM | EHOFFE | MFHM | EHOFFE | T006 | Units of Measurement | MSEHI |
| MFHM | EHOFFE | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | EWFORM | SYST | MANDT | TC25 | Work center formulas | MANDT |
| MFHM | EWFORM | MFHM | EWFORM | TC25 | Work center formulas | IDENT |
| MFHM | FGRU1 | SYST | MANDT | TCF12 | Key for grouping production resources/tools | MANDT |
| MFHM | FGRU1 | MFHM | FGRU1 | TCF12 | Key for grouping production resources/tools | FGRUA |
| MFHM | FGRU2 | SYST | MANDT | TCF12 | Key for grouping production resources/tools | MANDT |
| MFHM | FGRU2 | MFHM | FGRU2 | TCF12 | Key for grouping production resources/tools | FGRUA |
| MFHM | KTSCH | SYST | MANDT | T435 | Standard texts for routing/ref. op set items | MANDT |
| MFHM | KTSCH | MFHM | KTSCH | T435 | Standard texts for routing/ref. op set items | VLSCH |
| MFHM | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
| MFHM | MATNR | MFHM | MATNR | MARA | General Material Data | MATNR |
| MFHM | MGFORM | MFHM | MGFORM | TC25 | Work center formulas | IDENT |
| MFHM | MGFORM | SYST | MANDT | TC25 | Work center formulas | MANDT |
| MFHM | PAR01 | MFHM | PAR01 | TC20 | "Formula Parameters" | PARID |
| MFHM | PAR01 | SYST | MANDT | TC20 | "Formula Parameters" | MANDT |
| MFHM | PAR02 | SYST | MANDT | TC20 | "Formula Parameters" | MANDT |
| MFHM | PAR02 | MFHM | PAR02 | TC20 | "Formula Parameters" | PARID |
| MFHM | PAR03 | SYST | MANDT | TC20 | "Formula Parameters" | MANDT |
| MFHM | PAR03 | MFHM | PAR03 | TC20 | "Formula Parameters" | PARID |
| MFHM | PAR04 | SYST | MANDT | TC20 | "Formula Parameters" | MANDT |
| MFHM | PAR04 | MFHM | PAR04 | TC20 | "Formula Parameters" | PARID |
| MFHM | PAR05 | SYST | MANDT | TC20 | "Formula Parameters" | MANDT |
| MFHM | PAR05 | MFHM | PAR05 | TC20 | "Formula Parameters" | PARID |
| MFHM | PAR06 | SYST | MANDT | TC20 | "Formula Parameters" | MANDT |
| MFHM | PAR06 | MFHM | PAR06 | TC20 | "Formula Parameters" | PARID |
| MFHM | PARU1 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | PARU1 | MFHM | PARU1 | T006 | Units of Measurement | MSEHI |
| MFHM | PARU2 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | PARU2 | MFHM | PARU2 | T006 | Units of Measurement | MSEHI |
| MFHM | PARU3 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | PARU3 | MFHM | PARU3 | T006 | Units of Measurement | MSEHI |
| MFHM | PARU4 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | PARU4 | MFHM | PARU4 | T006 | Units of Measurement | MSEHI |
| MFHM | PARU5 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | PARU5 | MFHM | PARU5 | T006 | Units of Measurement | MSEHI |
| MFHM | PARU6 | SYST | MANDT | T006 | Units of Measurement | MANDT |
| MFHM | PARU6 | MFHM | PARU6 | T006 | Units of Measurement | MSEHI |
| MFHM | PLANV | SYST | MANDT | TC23 | Key for use of the work center in the task lists | MANDT |
| MFHM | PLANV | MFHM | PLANV | TC23 | Key for use of the work center in the task lists | PLANV |
| MFHM | STEUF | SYST | MANDT | TCF10 | PRT control key | MANDT |
| MFHM | STEUF | MFHM | STEUF | TCF10 | PRT control key | STEUF |
| MFHM | WERKS | SYST | MANDT | T001W | Plants/Branches | MANDT |
| MFHM | WERKS | MFHM | WERKS | T001W | Plants/Branches | WERKS |
