CRFH SAP (CIM production resource/tool master data) Table details

Dictionary Type: Table
Description: CIM production resource/tool master data




ABAP Code to SELECT data from CRFH
Related tables to CRFH
Access table CRFH




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
MANDTClient MANDTCLNT3T000MANDT
OBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
OBJIDObject ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
ZAEHLInternal counter CIM_COUNTNUMC8CIM_COUNT
FHMARProduction resources/tools category FHMARCHAR1TCF02FHMARFHMARFHA
OBJTY_VObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
OBJID_VObject ID of the resource CR_OBJIDNUMC8CRIDCR_OBJID
LOEKZDeletion indicator for production resources/tools master CF_LOEKZCHAR1XFLAG
DATUVValid-From Date DATUVDATS8DATUM
DATUBValid-to date DATUBDATS8DATUM
AENNRChange Number AENNRCHAR12AENRAENNRAENNRAEN
ANNAMUser who created record ANNAMCHAR12USNAM
ANDATDate record created on ANDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
BRGRUAuthorization Group BRGRUCHAR4TBRGBRGRU
STATUSProduction resources/tools master: Status CF_CRFHSTCHAR2TCF04CF_CRFHST
KZKBLIndicator: Create load records for prod. resources/tools KZKBLCHAR1XFELD
STOWKPlant location of the production resource/tool CF_STOWKCHAR4T001WWERKSWRK
STORTLocation of a production resource or tool CF_STORTCHAR10T499SAP_STAND
BASEHBase unit of measure for production resources/tools CF_BASEHUNIT3T006CUNITMEINS
STEUFControl key for management of production resources/tools STEUFCHAR4TCF10STEUF
STEUF_REFControl key cannot be changed CF_STKZRCHAR1XFELD
FGRU1Grouping key 1 for production resources/tools FGRUACHAR4TCF12FGRUA
FGRU2Grouping key 2 for production resources/tools FGRUBCHAR4TCF12FGRUA
PLANVProduction resource/tool usage FH_PLANVCHAR3TC23AP_PLANV
KTSCHStandard text key for production resources/tools CF_KTSCHCHAR7T435KTSCH
KTSCH_REFReference Key Cannot be Changed CF_KTKZRCHAR1XFELD
BZOFFBReference date to start of production resource/tool usage BZOFFBCHAR2TCA54CP_BZOFF
BZOFFB_REFStart reference date cannot be changed CF_BBKZRCHAR1XFELD
OFFSTBOffset to start of production resource/tool usage OFFSTBQUAN5VNZTV
EHOFFBOffset unit for start of prod. resource/tool usage EHOFFBUNIT3T006CUNITMEINS
OFFSTB_REFOffset to start cannot be changed CF_OBKZRCHAR1XFELD
BZOFFEReference date for end of production resource/tool usage BZOFFECHAR2TCA54CP_BZOFF
BZOFFE_REFEnd reference date cannot be changed CF_BEKZRCHAR1XFELD
OFFSTEOffset to finish of production resource/tool usage OFFSTEQUAN5VNZTV
EHOFFEOffset unit for end of production resource/tool usage EHOFFEUNIT3T006CUNITMEINS
OFFSTE_REFOffset to end cannot be changed CF_OEKZRCHAR1XFELD
MGFORMFormula for calculating the total quantity of PRT CF_MGFORMCHAR6TC25AP_FORMEL
MGFORM_REFFormula for calculating the total quantity cannot be changed CF_MFKZRCHAR1XFELD
EWFORMFormula for calculating the total usage value of PRT CF_EWFORMCHAR6TC25AP_FORMEL
EWFORM_REFFormula to calculate entire usage value cannot be changed CF_EFKZRCHAR1XFELD
PAR01First parameter (for formulas) CF_PAR01CHAR6TC20PARAMID
PAR02Second parameter (for formulas) CF_PAR02CHAR6TC20PARAMID
PAR03Third parameter (for formulas) CF_PAR03CHAR6TC20PARAMID
PAR04Fourth parameter (for formulas) CF_PAR04CHAR6TC20PARAMID
PAR05Fifth parameter (for formulas) CF_PAR05CHAR6TC20PARAMID
PAR06Sixth parameter (for formulas) CF_PAR06CHAR6TC20PARAMID
PARU1Parameter unit CF_PARUNITUNIT3T006CUNITMEINS
PARU2Parameter unit CF_PARUNITUNIT3T006CUNITMEINS
PARU3Parameter unit CF_PARUNITUNIT3T006CUNITMEINS
PARU4Parameter unit CF_PARUNITUNIT3T006CUNITMEINS
PARU5Parameter unit CF_PARUNITUNIT3T006CUNITMEINS
PARU6Parameter unit CF_PARUNITUNIT3T006CUNITMEINS
PARV1Parameter value CF_PARVALQUAN9(3) VGWRT
PARV2Parameter value CF_PARVALQUAN9(3) VGWRT
PARV3Parameter value CF_PARVALQUAN9(3) VGWRT
PARV4Parameter value CF_PARVALQUAN9(3) VGWRT
PARV5Parameter value CF_PARVALQUAN9(3) VGWRT
PARV6Parameter value CF_PARVALQUAN9(3) VGWRT
.INCLU--AP 0
TOOL_WC_OBJTYObject types of the CIM resource CR_OBJTYCHAR2CR_OBJTY
TOOL_WC_OBJIDObject ID of the resource CR_OBJIDNUMC8Assigned to domainCR_OBJID
TOOL_WC_WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!