SAP Table CRFH
CIM production resource/tool master data
CRFH (CIM production resource/tool master data) 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 CRFH to other SAP tables.
CRFH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | 0 |
Possible values
|
||||||||||
| OBJID | Object ID of the resource | CR_OBJID | CRID | NUMC | 8 | 0 | ||||||||||
| ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | 0 | |||||||||||
| FHMAR | Production resources/tools category | FHMAR | TCF02 | CHAR | 1 | 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 | CRID | NUMC | 8 | 0 | ||||||||||
| LOEKZ | Deletion indicator for production resources/tools master | CF_LOEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||
| DATUV | Valid-From Date | DATUV | DATS | 8 | 0 | |||||||||||
| DATUB | Valid-to date | DATUB | DATS | 8 | 0 | |||||||||||
| AENNR | Change Number | AENNR | AENR | CHAR | 12 | 0 | ||||||||||
| ANNAM | User who created record | ANNAM | CHAR | 12 | 0 | |||||||||||
| ANDAT | Date record created on | ANDAT | DATS | 8 | 0 | |||||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||
| BRGRU | Authorization Group | BRGRU | TBRG | CHAR | 4 | 0 | ||||||||||
| STATUS | Production resources/tools master: Status | CF_CRFHST | TCF04 | CHAR | 2 | 0 | ||||||||||
| KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR | 1 | 0 |
Possible values
|
||||||||||
| STOWK | Plant location of the production resource/tool | CF_STOWK | T001W | CHAR | 4 | 0 | ||||||||||
| STORT | Location of a production resource or tool | CF_STORT | T499S | CHAR | 10 | 0 | ||||||||||
| BASEH | Base unit of measure for production resources/tools | CF_BASEH | T006 | UNIT | 3 | 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 |
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 | |||||||||||
CRFH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CRFH | AENNR | CRFH | MANDT | AENR | Change Master | MANDT |
| CRFH | AENNR | CRFH | AENNR | AENR | Change Master | AENNR |
| CRFH | BASEH | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | BASEH | CRFH | BASEH | T006 | Units of Measurement | MSEHI |
| CRFH | BRGRU | CRFH | BRGRU | TBRG | Authorization groups | BRGRU |
| CRFH | BRGRU | CRFH | MANDT | TBRG | Authorization groups | MANDT |
| CRFH | BRGRU | BROBJ | C_CRFH_BRG | TBRG | Authorization groups | BROBJ |
| CRFH | BZOFFB | CRFH | BZOFFB | TCA54 | Key for reference dates used in offset scheduling | BZOFF |
| CRFH | BZOFFE | CRFH | BZOFFE | TCA54 | Key for reference dates used in offset scheduling | BZOFF |
| CRFH | EHOFFB | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | EHOFFB | CRFH | EHOFFB | T006 | Units of Measurement | MSEHI |
| CRFH | EHOFFE | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | EHOFFE | CRFH | EHOFFE | T006 | Units of Measurement | MSEHI |
| CRFH | EWFORM | CRFH | EWFORM | TC25 | Work center formulas | IDENT |
| CRFH | EWFORM | CRFH | MANDT | TC25 | Work center formulas | MANDT |
| CRFH | FGRU1 | CRFH | FGRU1 | TCF12 | Key for grouping production resources/tools | FGRUA |
| CRFH | FGRU1 | CRFH | MANDT | TCF12 | Key for grouping production resources/tools | MANDT |
| CRFH | FGRU2 | CRFH | MANDT | TCF12 | Key for grouping production resources/tools | MANDT |
| CRFH | FGRU2 | CRFH | FGRU2 | TCF12 | Key for grouping production resources/tools | FGRUA |
| CRFH | FHMAR | CRFH | FHMAR | TCF02 | PRT categories | FHMAR |
| CRFH | KTSCH | CRFH | MANDT | T435 | Standard texts for routing/ref. op set items | MANDT |
| CRFH | KTSCH | CRFH | KTSCH | T435 | Standard texts for routing/ref. op set items | VLSCH |
| CRFH | MANDT | CRFH | MANDT | T000 | Clients | MANDT |
| CRFH | MGFORM | CRFH | MANDT | TC25 | Work center formulas | MANDT |
| CRFH | MGFORM | CRFH | MGFORM | TC25 | Work center formulas | IDENT |
| CRFH | OBJID | CRFH | OBJID | CRID | CIM Resource - Entities | OBJID |
| CRFH | OBJID | CRFH | MANDT | CRID | CIM Resource - Entities | MANDT |
| CRFH | OBJID | CRFH | OBJTY | CRID | CIM Resource - Entities | OBJTY |
| CRFH | OBJID_V | CRFH | MANDT | CRID | CIM Resource - Entities | MANDT |
| CRFH | OBJID_V | CRFH | OBJTY_V | CRID | CIM Resource - Entities | OBJTY |
| CRFH | OBJID_V | CRFH | OBJID_V | CRID | CIM Resource - Entities | OBJID |
| CRFH | PAR01 | CRFH | MANDT | TC20 | "Formula Parameters" | MANDT |
| CRFH | PAR01 | CRFH | PAR01 | TC20 | "Formula Parameters" | PARID |
| CRFH | PAR02 | CRFH | MANDT | TC20 | "Formula Parameters" | MANDT |
| CRFH | PAR02 | CRFH | PAR02 | TC20 | "Formula Parameters" | PARID |
| CRFH | PAR03 | CRFH | PAR03 | TC20 | "Formula Parameters" | PARID |
| CRFH | PAR03 | CRFH | MANDT | TC20 | "Formula Parameters" | MANDT |
| CRFH | PAR04 | CRFH | MANDT | TC20 | "Formula Parameters" | MANDT |
| CRFH | PAR04 | CRFH | PAR04 | TC20 | "Formula Parameters" | PARID |
| CRFH | PAR05 | CRFH | MANDT | TC20 | "Formula Parameters" | MANDT |
| CRFH | PAR05 | CRFH | PAR05 | TC20 | "Formula Parameters" | PARID |
| CRFH | PAR06 | CRFH | MANDT | TC20 | "Formula Parameters" | MANDT |
| CRFH | PAR06 | CRFH | PAR06 | TC20 | "Formula Parameters" | PARID |
| CRFH | PARU1 | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | PARU1 | CRFH | PARU1 | T006 | Units of Measurement | MSEHI |
| CRFH | PARU2 | CRFH | PARU2 | T006 | Units of Measurement | MSEHI |
| CRFH | PARU2 | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | PARU3 | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | PARU3 | CRFH | PARU3 | T006 | Units of Measurement | MSEHI |
| CRFH | PARU4 | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | PARU4 | CRFH | PARU4 | T006 | Units of Measurement | MSEHI |
| CRFH | PARU5 | CRFH | PARU5 | T006 | Units of Measurement | MSEHI |
| CRFH | PARU5 | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | PARU6 | CRFH | MANDT | T006 | Units of Measurement | MANDT |
| CRFH | PARU6 | CRFH | PARU6 | T006 | Units of Measurement | MSEHI |
| CRFH | PLANV | CRFH | MANDT | TC23 | Key for use of the work center in the task lists | MANDT |
| CRFH | PLANV | CRFH | PLANV | TC23 | Key for use of the work center in the task lists | PLANV |
| CRFH | STATUS | CRFH | MANDT | TCF04 | Status of the PRT master | MANDT |
| CRFH | STATUS | CRFH | STATUS | TCF04 | Status of the PRT master | STATUS |
| CRFH | STEUF | CRFH | MANDT | TCF10 | PRT control key | MANDT |
| CRFH | STEUF | CRFH | STEUF | TCF10 | PRT control key | STEUF |
| CRFH | STORT | CRFH | MANDT | T499S | Location | MANDT |
| CRFH | STORT | CRFH | STOWK | T499S | Location | WERKS |
| CRFH | STORT | CRFH | STORT | T499S | Location | STAND |
| CRFH | STOWK | CRFH | STOWK | T001W | Plants/Branches | WERKS |
| CRFH | STOWK | CRFH | MANDT | T001W | Plants/Branches | MANDT |
