SAP table CRFH (CIM production resource/tool master data)

SAP table CRFH has 4 primary key fields being MANDT,OBJTY,OBJID,ZAEHL.

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 T000 MANDT
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
FHMAR Production Resources/Tools Category CHAR 1 0 TCF02 FHMAR
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
LOEKZ Deletion indicator for production resources/tools master CHAR 1 0 CF_LOEKZ
DATUV Valid-From Date DATS 8 0 DATUV
DATUB Valid-to date DATS 8 0 DATUB
AENNR Change Number CHAR 12 0 AENR AENNR
ANNAM User who created record CHAR 12 0 ANNAM
ANDAT Date Record Created On DATS 8 0 ANDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
BRGRU Authorization Group CHAR 4 0 TBRG BRGRU
STATUS Production resources/tools master: Status CHAR 2 0 TCF04 CF_CRFHST
KZKBL Indicator: Create load records for prod. resources/tools CHAR 1 0 KZKBL
STOWK Plant location of the production resource/tool CHAR 4 0 T001W CF_STOWK
STORT Location of a production resource or tool CHAR 10 0 T499S CF_STORT
BASEH Base Unit of Measure for Production Resources/Tools UNIT 3 0 T006 CF_BASEH
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

CRFH foreign key relationships

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