SAP Table EFHM
PRT fields in equipment master
EFHM (PRT fields in equipment 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 EFHM to other SAP tables.
EFHM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||
|
EQUNR
Equipment Number
|
EQUNR | EQUI |
CHAR
|
18 | 0 | |||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||
|
OBJTY
Object types of the CIM resource
|
CR_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
OBJID
Object ID of the resource
|
CR_OBJID | CRID |
NUMC
|
8 | 0 | |||||||||||
|
ZAEHL
Internal counter
|
CIM_COUNT |
NUMC
|
8 | 0 | ||||||||||||
|
OBJTY_V
Object types of the CIM resource
|
CR_OBJTY |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
OBJID_V
Object ID of the resource
|
CR_OBJID | CRID |
NUMC
|
8 | 0 | |||||||||||
|
KZKBL
Indicator: Create load records for prod. resources/tools
|
KZKBL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
EFHM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| EFHM | BZOFFB | EFHM | BZOFFB |
TCA54
Key for reference dates used in offset scheduling
|
BZOFF |
| EFHM | BZOFFE | EFHM | BZOFFE |
TCA54
Key for reference dates used in offset scheduling
|
BZOFF |
| EFHM | EHOFFB | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | EHOFFB | EFHM | EHOFFB |
T006
Units of Measurement
|
MSEHI |
| EFHM | EHOFFE | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | EHOFFE | EFHM | EHOFFE |
T006
Units of Measurement
|
MSEHI |
| EFHM | EQUNR | EFHM | MANDT |
EQUI
Equipment master data
|
MANDT |
| EFHM | EQUNR | EFHM | EQUNR |
EQUI
Equipment master data
|
EQUNR |
| EFHM | EWFORM | EFHM | MANDT |
TC25
Work center formulas
|
MANDT |
| EFHM | EWFORM | EFHM | EWFORM |
TC25
Work center formulas
|
IDENT |
| EFHM | FGRU1 | EFHM | MANDT |
TCF12
Key for grouping production resources/tools
|
MANDT |
| EFHM | FGRU1 | EFHM | FGRU1 |
TCF12
Key for grouping production resources/tools
|
FGRUA |
| EFHM | FGRU2 | EFHM | FGRU2 |
TCF12
Key for grouping production resources/tools
|
FGRUA |
| EFHM | FGRU2 | EFHM | MANDT |
TCF12
Key for grouping production resources/tools
|
MANDT |
| EFHM | KTSCH | EFHM | MANDT |
T435
Standard texts for routing/ref. op set items
|
MANDT |
| EFHM | KTSCH | EFHM | KTSCH |
T435
Standard texts for routing/ref. op set items
|
VLSCH |
| EFHM | MANDT | EFHM | MANDT |
T000
Clients
|
MANDT |
| EFHM | MGFORM | EFHM | MANDT |
TC25
Work center formulas
|
MANDT |
| EFHM | MGFORM | EFHM | MGFORM |
TC25
Work center formulas
|
IDENT |
| EFHM | OBJID | EFHM | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| EFHM | OBJID | EFHM | OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| EFHM | OBJID | EFHM | OBJID |
CRID
CIM Resource - Entities
|
OBJID |
| EFHM | OBJID_V | EFHM | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| EFHM | OBJID_V | EFHM | OBJTY_V |
CRID
CIM Resource - Entities
|
OBJTY |
| EFHM | OBJID_V | EFHM | OBJID_V |
CRID
CIM Resource - Entities
|
OBJID |
| EFHM | PAR01 | EFHM | MANDT |
TC20
"Formula Parameters"
|
MANDT |
| EFHM | PAR01 | EFHM | PAR01 |
TC20
"Formula Parameters"
|
PARID |
| EFHM | PAR02 | EFHM | PAR02 |
TC20
"Formula Parameters"
|
PARID |
| EFHM | PAR02 | EFHM | MANDT |
TC20
"Formula Parameters"
|
MANDT |
| EFHM | PAR03 | EFHM | MANDT |
TC20
"Formula Parameters"
|
MANDT |
| EFHM | PAR03 | EFHM | PAR03 |
TC20
"Formula Parameters"
|
PARID |
| EFHM | PAR04 | EFHM | MANDT |
TC20
"Formula Parameters"
|
MANDT |
| EFHM | PAR04 | EFHM | PAR04 |
TC20
"Formula Parameters"
|
PARID |
| EFHM | PAR05 | EFHM | PAR05 |
TC20
"Formula Parameters"
|
PARID |
| EFHM | PAR05 | EFHM | MANDT |
TC20
"Formula Parameters"
|
MANDT |
| EFHM | PAR06 | EFHM | MANDT |
TC20
"Formula Parameters"
|
MANDT |
| EFHM | PAR06 | EFHM | PAR06 |
TC20
"Formula Parameters"
|
PARID |
| EFHM | PARU1 | EFHM | PARU1 |
T006
Units of Measurement
|
MSEHI |
| EFHM | PARU1 | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | PARU2 | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | PARU2 | EFHM | PARU2 |
T006
Units of Measurement
|
MSEHI |
| EFHM | PARU3 | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | PARU3 | EFHM | PARU3 |
T006
Units of Measurement
|
MSEHI |
| EFHM | PARU4 | EFHM | PARU4 |
T006
Units of Measurement
|
MSEHI |
| EFHM | PARU4 | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | PARU5 | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | PARU5 | EFHM | PARU5 |
T006
Units of Measurement
|
MSEHI |
| EFHM | PARU6 | EFHM | MANDT |
T006
Units of Measurement
|
MANDT |
| EFHM | PARU6 | EFHM | PARU6 |
T006
Units of Measurement
|
MSEHI |
| EFHM | PLANV | EFHM | MANDT |
TC23
Key for use of the work center in the task lists
|
MANDT |
| EFHM | PLANV | EFHM | PLANV |
TC23
Key for use of the work center in the task lists
|
PLANV |
| EFHM | STEUF | EFHM | MANDT |
TCF10
PRT control key
|
MANDT |
| EFHM | STEUF | EFHM | STEUF |
TCF10
PRT control key
|
STEUF |
| EFHM | WERKS | EFHM | MANDT |
T001W
Plants/Branches
|
MANDT |
| EFHM | WERKS | EFHM | WERKS |
T001W
Plants/Branches
|
WERKS |