The COMM_IL_IOBQFR table in SAP ERP or S/4HANA stores Qualif. Requirements IBase Components (As for BPQFR) History data. There are total 14 fields in COMM_IL_IOBQFR table. The Qualif. Requirements IBase Components (As for BPQFR) History 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 COMM_IL_IOBQFR table. It is in Qualification Requirements/Link to Master Data (CRM_QUALIF_REL) ABAP package and is part of the Service Resource Planning (CRM-RPL-SRV) module.
SAP COMM_IL_IOBQFR Table Fields
Following is the list of fields that are available in SAP COMM_IL_IOBQFR table. The primary key fields of the table are CLIENT (Client), ILGUID (Internal, Unique ID of a Relationship).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| ILGUID | Internal, Unique ID of a Relationship | COMT_IL_ILGUID | RAW (16) | |
| SOURCEGUID | Internal ID for Source in a Relationship | COMT_IL_SOURCEGUID | RAW (16) | |
| DESTINGUID | Internal ID for Destination in a Relationship | COMT_IL_DESTINGUID | RAW (16) | |
| VALIDFROM | Qualification Requirement Valid From | CRMT_QUALIF_REQ_VALID_FROM | DEC (15) | |
| VALIDTO | Qualification Requirement Valid To | CRMT_QUALIF_REQ_VALID_TO | DEC (15) | |
| OBLIGATORY | Is Requirement Mandatory | CRMT_QUALIF_REQ_OBLIGATORY | CHAR (1) | |
| PRFCY_MIN | Required Minimum Qualification Proficiency | CRMT_QUALIF_REQ_PROF_MIN | NUMC (4) | |
| PRFCY_MAX | Maximum Required Qualification Proficiency | CRMT_QUALIF_REQ_PROF_MAX | NUMC (4) | |
| PRFCY_OPT | Optimum Qualification Requirement | CRMT_QUALIF_REQ_PROF_OPT | NUMC (4) | |
| WEIGHING | Weighting | CRMT_QUALIF_REQ_WEIGHING | DEC (4) | |
| LOGSYS | Logical System in Which the Relationship Was Created | COMT_IL_LOGSYS | * | CHAR (10) |
| UPNAME | Relationship Last Changed By | COMT_IL_UPNAME | CHAR (12) | |
| VALID_FROM | Valid From (Time Stamp) | COMT_IL_VALID_FROM | DEC (15) |
