The CRFH_PRC table in SAP ERP or S/4HANA stores Process Records Of OTC 194, Table CRFH data. There are total 67 fields in CRFH_PRC table. The Process Records Of OTC 194, Table CRFH table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRFH_PRC table. It is in Master Data Consolidation: Material Data Model (MDC_MAT_MODEL) ABAP package and is part of the Material. (CA-MDG-CMP-MM) module.
SAP CRFH_PRC Table Fields
Following is the list of fields that are available in SAP CRFH_PRC table. The primary key fields of the table are CLIENT (Client), PROCESS_ID (Master Data Change Process Identifier), PROCESS_STEP_NO (Master Data Change Process Step Number), SOURCE_SYSTEM (Source System), SOURCE_ID (Master Data Consolidation: ID of a Source Objects), OBJTY (Object types of the CIM resource), OBJID (Object ID of the resource), ZAEHL (Internal counter), WERKS (Plant).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| PROCESS_ID | Master Data Change Process Identifier | MDC_PROCESS_ID | NUMC (12) | |
| PROCESS_STEP_NO | Master Data Change Process Step Number | MDC_PROCESS_STEP_NO | NUMC (4) | |
| SOURCE_SYSTEM | Source System | MDC_BUSINESS_SYSTEM | CHAR (60) | |
| SOURCE_ID | Master Data Consolidation: ID of a Source Objects | MDC_SOURCE_ID | CHAR (60) | |
| OBJTY | Object types of the CIM resource | CR_OBJTY | CHAR (2) | |
| OBJID | Object ID of the resource | CR_OBJID | NUMC (8) | |
| ZAEHL | Internal counter | CIM_COUNT | NUMC (8) | |
| WERKS | Plant | WERKS_D | CHAR (4) | |
| FHMAR | Production Resources/Tools Category | FHMAR | CHAR (1) | |
| OBJTY_V | Object types of the CIM resource | CR_OBJTY | CHAR (2) | |
| OBJID_V | Object ID of the resource | CR_OBJID | NUMC (8) | |
| LOEKZ | Deletion indicator for production resources/tools master | CF_LOEKZ | CHAR (1) | |
| DATUV | Valid-From Date | DATUV | DATS (8) | |
| DATUB | Valid-to date | DATUB | DATS (8) | |
| AENNR | Change Number | AENNR | CHAR (12) | |
| ANNAM | User who created record | ANNAM | CHAR (12) | |
| ANDAT | Date Record Created On | ANDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| BRGRU | Authorization Group | BRGRU | CHAR (4) | |
| STATUS | Production resources/tools master: Status | CF_CRFHST | CHAR (2) | |
| KZKBL | Indicator: Create load records for prod. resources/tools | KZKBL | CHAR (1) | |
| STOWK | Plant location of the production resource/tool | CF_STOWK | CHAR (4) | |
| STORT | Location of a production resource or tool | CF_STORT | CHAR (10) | |
| BASEH | Base unit of measure for production resources/tools | CF_BASEH | UNIT (3) | |
| STEUF | Control Profile for Management of Production Resources/Tools | STEUF | CHAR (4) | |
| STEUF_REF | Control key cannot be changed | CF_STKZR | CHAR (1) | |
| FGRU1 | Grouping Key 1 for Production Resources/Tools | FGRUA | CHAR (4) | |
| FGRU2 | Grouping Key 2 for Production Resources/Tools | FGRUB | CHAR (4) | |
| PLANV | Production Resource/Tool Usage | FH_PLANV | CHAR (3) | |
| KTSCH | Standard Text Key for Production Resources/Tools | CF_KTSCH | CHAR (7) | |
| KTSCH_REF | Reference Key Cannot be Changed | CF_KTKZR | CHAR (1) | |
| BZOFFB | Reference Date for Start of Production Resource/Tool Usage | BZOFFB | CHAR (2) | |
| BZOFFB_REF | Start reference date cannot be changed | CF_BBKZR | CHAR (1) | |
| OFFSTB | Offset to start of production resource/tool usage | OFFSTB | QUAN (5) | |
| EHOFFB | Offset Unit for Start of Prodn Resource/Tool Usage | EHOFFB | UNIT (3) | |
| OFFSTB_REF | Offset to start cannot be changed | CF_OBKZR | CHAR (1) | |
| BZOFFE | Reference date for end of production resource/tool usage | BZOFFE | CHAR (2) | |
| BZOFFE_REF | End reference date cannot be changed | CF_BEKZR | CHAR (1) | |
| OFFSTE | Offset to finish of production resource/tool usage | OFFSTE | QUAN (5) | |
| EHOFFE | Offset Unit for End of Production Resource/Tool Usage | EHOFFE | UNIT (3) | |
| OFFSTE_REF | Offset to end cannot be changed | CF_OEKZR | CHAR (1) | |
| MGFORM | Formula for Calculating the Total Quantity of PRT | CF_MGFORM | * | CHAR (6) |
| MGFORM_REF | Formula for calculating the total quantity cannot be changed | CF_MFKZR | CHAR (1) | |
| EWFORM | Formula for Calculating the Total Usage Value of PRT | CF_EWFORM | * | CHAR (6) |
| EWFORM_REF | Formula to calculate entire usage value cannot be changed | CF_EFKZR | CHAR (1) | |
| PAR01 | First parameter (for formulas) | CF_PAR01 | CHAR (6) | |
| PAR02 | Second parameter (for formulas) | CF_PAR02 | CHAR (6) | |
| PAR03 | Third parameter (for formulas) | CF_PAR03 | CHAR (6) | |
| PAR04 | Fourth parameter (for formulas) | CF_PAR04 | CHAR (6) | |
| PAR05 | Fifth parameter (for formulas) | CF_PAR05 | CHAR (6) | |
| PAR06 | Sixth parameter (for formulas) | CF_PAR06 | CHAR (6) | |
| PARU1 | Parameter unit | CF_PARUNIT | UNIT (3) | |
| PARU2 | Parameter unit | CF_PARUNIT | UNIT (3) | |
| PARU3 | Parameter unit | CF_PARUNIT | UNIT (3) | |
| PARU4 | Parameter unit | CF_PARUNIT | UNIT (3) | |
| PARU5 | Parameter unit | CF_PARUNIT | UNIT (3) | |
| PARU6 | Parameter unit | CF_PARUNIT | UNIT (3) | |
| PARV1 | Parameter value | CF_PARVAL | QUAN (9) | |
| PARV2 | Parameter value | CF_PARVAL | QUAN (9) | |
| PARV3 | Parameter value | CF_PARVAL | QUAN (9) | |
| PARV4 | Parameter value | CF_PARVAL | QUAN (9) | |
| PARV5 | Parameter value | CF_PARVAL | QUAN (9) | |
| PARV6 | Parameter value | CF_PARVAL | QUAN (9) | |
| SOURCE_RECENCY | Master Data Consolidation: Recency | MDC_RECENCY | DEC (15) | |
| SOURCE_MODIFIED | Indicator: Source Record modified | MDC_SOURCE_MODIFIED | CHAR (1) |
