SAP table PATCHHIST (History of Kernel Patch)
SAP table PATCHHIST has 6 primary key fields being EXECUTABLE,SAPRELEASE,HOSTNAME,PLATFORM,DBVENDOR,TIMESTAMP.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| EXECUTABLE | Executable Program Name | CHAR | 20 | 0 | EXECUTABLE | ||
| SAPRELEASE | SAP Release | CHAR | 10 | 0 | SAPRELEASE | ||
| HOSTNAME | Server name | CHAR | 22 | 0 | HOST_NAME | ||
| PLATFORM | OS type without release no. (or '*'): HP-UX, Windows NT, ... | CHAR | 10 | 0 | OSTYPE | ||
| DBVENDOR | Database Vendor | CHAR | 3 | 0 | DBVENDOR | ||
| TIMESTAMP | Oracle: dba_tables.last_analyzed | CHAR | 14 | 0 | DATEORA | ||
| PATCHNO | 10 digit number | NUMC | 10 | 0 | NUM10 | ||
| DBSLPATCHN | 10 digit number | NUMC | 10 | 0 | NUM10 |