CRFHD SAP (Structure of the production resources/tools master) Structure details
Description: Structure of the production resources/tools master
Structure field list including key, data, relationships and ABAP select examples
CRFHD is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Structure of the production resources/tools master" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CRFHD TYPE CRFHD.
The CRFHD table consists of various fields, each holding specific information or linking keys about Structure of the production resources/tools master 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CRFHD structure 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 | ||||
FHWRK | Production resources/tools in plant | FHWRK | CHAR | 4 | T001W | WERKS | WRK | ||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
SFHNR | Production resources and tools | SFHNR | CHAR | 18 | ALPHA | SFHNR | FHS | FHMS | |
DOKAR | Document Type | DOKAR | CHAR | 3 | TDWA | DOKAR | CV2 | ||
DOKNR | Document number | DOKNR | CHAR | 25 | DRAW | ALPHA | DOKNR | CV1 | |
DOKVR | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
EQUNR | Equipment Number | EQUNR | CHAR | 18 | EQUI | ALPHA | EQUNR | EQN | EQUI |
FHKTX | Description of the production resource/tool | FHKTX | CHAR | 40 | TEXT40 | ||||
MMSTA | Plant-Specific Material Status | MMSTA | CHAR | 2 | T141 | MMSTA | |||
DOKST | Document Status | DOKST | CHAR | 2 | TDWS | DOKST | |||
DOKAS | Change Number | DAENR | CHAR | 12 | AENR | AENNR | AENNR | ||
DOKGV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
EQSTO | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
EQTYP | Equipment category | EQTYP | CHAR | 1 | T370T | EQTYP | EQT | ||
EQWPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
EQWTX | Maintenance Plan Text | WPTXT | CHAR | 40 | TEXT40 | ||||
EQPNT | Measuring Point | IMRC_POINT | CHAR | 12 | IMPTT | ALPHA | IMRC_POINT | IPT | IMPM |
EQPTX | Description of Measuring Point | IMRC_PTTXT | CHAR | 40 | TEXT40 | ||||
ATNAM | Characteristic Name | ATNAM | CHAR | 30 | ATNAM | FEA | |||
ATVOR | Indicator: Negative Values Allowed | IMRC_INEGV | CHAR | 1 | X | ||||
MSEHI | Unit of Measurement | MSEHI | UNIT | 3 | T006 | CUNIT | MEINS | ||
ATDIM | Exponent display | ATDIM | INT2 | 5 | EXP10 | ||||
ANZDZ | Number of Decimal Places | ANZDZ | INT2 | 5 | ANZDZ | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
MODKZ | Modification indicator (new, changed, to be deleted ...) | CF_MODKZ | CHAR | 1 | CF_MODKZ | ||||
MSTAE | Cross-Plant Material Status | MSTAE | CHAR | 2 | Assigned to domain | MMSTA | |||
INACT | Indicator: Measuring Point Inactive | IMRC_INACT | CHAR | 1 | X | ||||
.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 structure CRFHD using ABAP code?
As CRFHD is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRFHD as there is no data to select.How to access SAP table CRFHD
Within an ECC or HANA version of SAP you can also view further information about CRFHD 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