CRFH SAP (CIM production resource/tool master data) Table details
Dictionary Type: Table
Description: CIM production resource/tool master data
Description: CIM production resource/tool master data
Table field list including key, data, relationships and ABAP select examples
CRFH is a standard SAP Table which is used to store CIM production resource/tool master data data and is available within R/3 SAP systems depending on the version and release level.
The CRFH table consists of various fields, each holding specific information or linking keys about CIM production resource/tool master data data available in SAP. These include OBJTY (Object types of the CIM resource), OBJID (Object ID of the resource), ZAEHL (Internal counter), FHMAR (Production resources/tools category).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CRFH table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | CRID | CR_OBJID | |||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
FHMAR | Production resources/tools category | FHMAR | CHAR | 1 | TCF02 | FHMAR | FHMAR | FHA | |
OBJTY_V | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
OBJID_V | Object ID of the resource | CR_OBJID | NUMC | 8 | CRID | CR_OBJID | |||
LOEKZ | Deletion indicator for production resources/tools master | CF_LOEKZ | CHAR | 1 | XFLAG | ||||
DATUV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
DATUB | Valid-to date | DATUB | DATS | 8 | DATUM | ||||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
ANNAM | User who created record | ANNAM | CHAR | 12 | USNAM | ||||
ANDAT | Date record created on | ANDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
BRGRU | Authorization Group | BRGRU | CHAR | 4 | TBRG | BRGRU | |||
STATUS | Production resources/tools master: Status | CF_CRFHST | CHAR | 2 | TCF04 | CF_CRFHST | |||
KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR | 1 | XFELD | ||||
STOWK | Plant location of the production resource/tool | CF_STOWK | CHAR | 4 | T001W | WERKS | WRK | ||
STORT | Location of a production resource or tool | CF_STORT | CHAR | 10 | T499S | AP_STAND | |||
BASEH | Base unit of measure for production resources/tools | CF_BASEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
STEUF | Control key for management of production resources/tools | STEUF | CHAR | 4 | TCF10 | STEUF | |||
STEUF_REF | Control key cannot be changed | CF_STKZR | CHAR | 1 | XFELD | ||||
FGRU1 | Grouping key 1 for production resources/tools | FGRUA | CHAR | 4 | TCF12 | FGRUA | |||
FGRU2 | Grouping key 2 for production resources/tools | FGRUB | CHAR | 4 | TCF12 | FGRUA | |||
PLANV | Production resource/tool usage | FH_PLANV | CHAR | 3 | TC23 | AP_PLANV | |||
KTSCH | Standard text key for production resources/tools | CF_KTSCH | CHAR | 7 | T435 | KTSCH | |||
KTSCH_REF | Reference Key Cannot be Changed | CF_KTKZR | CHAR | 1 | XFELD | ||||
BZOFFB | Reference date to start of production resource/tool usage | BZOFFB | CHAR | 2 | TCA54 | CP_BZOFF | |||
BZOFFB_REF | Start reference date cannot be changed | CF_BBKZR | CHAR | 1 | XFELD | ||||
OFFSTB | Offset to start of production resource/tool usage | OFFSTB | QUAN | 5 | VNZTV | ||||
EHOFFB | Offset unit for start of prod. resource/tool usage | EHOFFB | UNIT | 3 | T006 | CUNIT | MEINS | ||
OFFSTB_REF | Offset to start cannot be changed | CF_OBKZR | CHAR | 1 | XFELD | ||||
BZOFFE | Reference date for end of production resource/tool usage | BZOFFE | CHAR | 2 | TCA54 | CP_BZOFF | |||
BZOFFE_REF | End reference date cannot be changed | CF_BEKZR | CHAR | 1 | XFELD | ||||
OFFSTE | Offset to finish of production resource/tool usage | OFFSTE | QUAN | 5 | VNZTV | ||||
EHOFFE | Offset unit for end of production resource/tool usage | EHOFFE | UNIT | 3 | T006 | CUNIT | MEINS | ||
OFFSTE_REF | Offset to end cannot be changed | CF_OEKZR | CHAR | 1 | XFELD | ||||
MGFORM | Formula for calculating the total quantity of PRT | CF_MGFORM | CHAR | 6 | TC25 | AP_FORMEL | |||
MGFORM_REF | Formula for calculating the total quantity cannot be changed | CF_MFKZR | CHAR | 1 | XFELD | ||||
EWFORM | Formula for calculating the total usage value of PRT | CF_EWFORM | CHAR | 6 | TC25 | AP_FORMEL | |||
EWFORM_REF | Formula to calculate entire usage value cannot be changed | CF_EFKZR | CHAR | 1 | XFELD | ||||
PAR01 | First parameter (for formulas) | CF_PAR01 | CHAR | 6 | TC20 | PARAMID | |||
PAR02 | Second parameter (for formulas) | CF_PAR02 | CHAR | 6 | TC20 | PARAMID | |||
PAR03 | Third parameter (for formulas) | CF_PAR03 | CHAR | 6 | TC20 | PARAMID | |||
PAR04 | Fourth parameter (for formulas) | CF_PAR04 | CHAR | 6 | TC20 | PARAMID | |||
PAR05 | Fifth parameter (for formulas) | CF_PAR05 | CHAR | 6 | TC20 | PARAMID | |||
PAR06 | Sixth parameter (for formulas) | CF_PAR06 | CHAR | 6 | TC20 | PARAMID | |||
PARU1 | Parameter unit | CF_PARUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PARU2 | Parameter unit | CF_PARUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PARU3 | Parameter unit | CF_PARUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PARU4 | Parameter unit | CF_PARUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PARU5 | Parameter unit | CF_PARUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PARU6 | Parameter unit | CF_PARUNIT | UNIT | 3 | T006 | CUNIT | MEINS | ||
PARV1 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV2 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV3 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV4 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV5 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
PARV6 | Parameter value | CF_PARVAL | QUAN | 9(3) | VGWRT | ||||
.INCLU--AP | 0 | ||||||||
TOOL_WC_OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR | 2 | CR_OBJTY | ||||
TOOL_WC_OBJID | Object ID of the resource | CR_OBJID | NUMC | 8 | Assigned to domain | CR_OBJID | |||
TOOL_WC_WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C |
Key field | Non-key field |
How do I retrieve data from SAP table CRFH using ABAP code
The following ABAP code Example will allow you to do a basic selection on CRFH to SELECT all data from the tableDATA: WA_CRFH TYPE CRFH.
SELECT SINGLE *
FROM CRFH
INTO CORRESPONDING FIELDS OF WA_CRFH
WHERE...
How to access SAP table CRFH
Within an ECC or HANA version of SAP you can also view further information about CRFH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects