SAP table EFHM (PRT fields in equipment master)

SAP table EFHM has 1 primary key field being MANDT.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
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 CRID 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 CRID 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
TOOL_WC_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
TOOL_WC_OBJID Object ID of the resource NUMC 8 0 * CR_OBJID
TOOL_WC_WERKS Plant CHAR 4 0 WERKS_D

EFHM foreign key relationships

Table Field Check Table Check Field
0 EFHM BZOFFB TCA54 Key for reference dates used in offset scheduling BZOFF
1 EFHM BZOFFE TCA54 Key for reference dates used in offset scheduling BZOFF
0 EFHM EHOFFB T006 Units of Measurement MANDT
1 EFHM EHOFFE T006 Units of Measurement MANDT
0 EFHM EQUNR EQUI Equipment master data MANDT
1 EFHM EWFORM TC25 Work center formulas MANDT
0 EFHM FGRU1 TCF12 Key for grouping production resources/tools MANDT
1 EFHM FGRU2 TCF12 Key for grouping production resources/tools MANDT
0 EFHM KTSCH T435 Standard texts for routing/ref. op set items MANDT
1 EFHM MANDT T000 Clients MANDT
0 EFHM MGFORM TC25 Work center formulas MANDT
1 EFHM OBJID CRID CIM Resource - Entities MANDT
1 EFHM OBJID CRID CIM Resource - Entities OBJID
0 EFHM OBJID_V CRID CIM Resource - Entities MANDT
0 EFHM OBJID_V CRID CIM Resource - Entities OBJID
1 EFHM PAR01 TC20 "Formula Parameters" MANDT
1 EFHM PAR01 TC20 "Formula Parameters" PARID
0 EFHM PAR02 TC20 "Formula Parameters" MANDT
0 EFHM PAR02 TC20 "Formula Parameters" PARID
1 EFHM PAR03 TC20 "Formula Parameters" MANDT
1 EFHM PAR03 TC20 "Formula Parameters" PARID
0 EFHM PAR04 TC20 "Formula Parameters" MANDT
0 EFHM PAR04 TC20 "Formula Parameters" PARID
1 EFHM PAR05 TC20 "Formula Parameters" MANDT
1 EFHM PAR05 TC20 "Formula Parameters" PARID
0 EFHM PAR06 TC20 "Formula Parameters" MANDT
0 EFHM PAR06 TC20 "Formula Parameters" PARID
1 EFHM PARU1 T006 Units of Measurement MANDT
1 EFHM PARU1 T006 Units of Measurement MSEHI
0 EFHM PARU2 T006 Units of Measurement MANDT
0 EFHM PARU2 T006 Units of Measurement MSEHI
1 EFHM PARU3 T006 Units of Measurement MANDT
1 EFHM PARU3 T006 Units of Measurement MSEHI
0 EFHM PARU4 T006 Units of Measurement MANDT
0 EFHM PARU4 T006 Units of Measurement MSEHI
1 EFHM PARU5 T006 Units of Measurement MANDT
1 EFHM PARU5 T006 Units of Measurement MSEHI
0 EFHM PARU6 T006 Units of Measurement MANDT
0 EFHM PARU6 T006 Units of Measurement MSEHI
1 EFHM PLANV TC23 Key for use of the work center in the task lists MANDT
0 EFHM STEUF TCF10 PRT control key MANDT
1 EFHM WERKS T001W Plants/Branches MANDT
1 EFHM WERKS T001W Plants/Branches WERKS