SAP Table HRVQUALIF
Qualifications structure per attendee
HRVQUALIF (Qualifications structure per attendee) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link HRVQUALIF to other SAP tables.
HRVQUALIF table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
PLVAR | Plan Version | PLVAR | T778P | CHAR | 2 | 0 | ||
PATYP | Participant Type | PRTPE | T778O | CHAR | 2 | 0 | ||
PARID | Attendee ID | HRPARID | CHAR | 45 | 0 | |||
BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||
ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||
ISTAT | Planning Status | ISTAT_D | T778S | CHAR | 1 | 0 | ||
QUTYP | Qualification object type | QUTYP | T778O | CHAR | 2 | 0 | ||
QUAID | Qualification ID | QUAID | NUMC | 8 | 0 | |||
QUSHT | Qualification abbrevation | QUSHT | CHAR | 12 | 0 | |||
QUATX | Qualification name | QUATX | CHAR | 40 | 0 | |||
NYEARS | Number of years | NYEARS | DEC | 3 | 0 | |||
NMONTHS | Number of Months | NMONTHS | DEC | 3 | 0 | |||
INVAL | Indicator: qualification expired | INVAL | CHAR | 1 | 0 | |||
CHARA | Proficiency of a Qualification/Requirement | CHARA | NUMC | 4 | 0 | |||
EXPER | Necessary Experience of a Requirement (in Years) | EXPER | NUMC | 2 | 0 |
HRVQUALIF foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
HRVQUALIF | ISTAT | SYST | MANDT | T778S | Planning Status | MANDT |
HRVQUALIF | ISTAT | HRVQUALIF | ISTAT | T778S | Planning Status | ISTAT |
HRVQUALIF | PATYP | SYST | MANDT | T778O | Object Types | MANDT |
HRVQUALIF | PATYP | HRVQUALIF | PATYP | T778O | Object Types | OTYPE |
HRVQUALIF | PLVAR | SYST | MANDT | T778P | Plan Versions | MANDT |
HRVQUALIF | PLVAR | HRVQUALIF | PLVAR | T778P | Plan Versions | PLVAR |
HRVQUALIF | QUTYP | SYST | MANDT | T778O | Object Types | MANDT |
HRVQUALIF | QUTYP | HRVQUALIF | QUTYP | T778O | Object Types | OTYPE |