PAT03 SAP (Patch Directory) Table details
Dictionary Type: Table
Description: Patch Directory
Description: Patch Directory
Table field list including key, data, relationships and ABAP select examples
PAT03 is a standard SAP Table which is used to store Patch Directory data and is available within R/3 SAP systems depending on the version and release level.
The PAT03 table consists of various fields, each holding specific information or linking keys about Patch Directory data available in SAP. These include SHORT_TEXT (Support Package description), STATUS (Support Package import status), DELIV_DATE (Support Package arrival date), DELIV_TIME (Support Package arrival time).. 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: W - System table, contents transportable via separate TR objectsDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP PAT03 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 |
PATCH | Support Package name | PATCH | CHAR | 20 | PATCH | SH_SPAM_PATCH | |||
SHORT_TEXT | Support Package description | PATCHTXT | CHAR | 60 | TEXT60 | ||||
STATUS | Support Package import status | PATCHSTAT | CHAR | 1 | PATCHSTAT | ||||
DELIV_DATE | Support Package arrival date | PATDELDATE | DATS | 8 | SYDATS | ||||
DELIV_TIME | Support Package arrival time | PATDELTIME | TIMS | 6 | SYTIME | ||||
RESPONSIBL | Person responsible for Support Package import | PATCH_USER | CHAR | 12 | AS4USER | ||||
IMPLE_DATE | Support Package import date | PATIMPDATE | DATS | 8 | AS4DATE | ||||
IMPLE_TIME | Support Package import time | PATIMPTIME | TIMS | 6 | SYTIME | ||||
L_IMPL_REL | Release of SAP System | SYSAPRL | CHAR | 4 | SYCHAR04 | ||||
CONFLICTS | Conflicts between Support Package and add-on | PAT_CONFL | CHAR | 1 | CHAR1 | ||||
CONFIRMED | Confirmed | CONFIRMED | CHAR | 1 | CONFIRMED | ||||
BACKUP | Request/Task | TRKORR | CHAR | 20 | Assigned to domain | TRKORR | |||
FROM_REL | Release of SAP System | SYSAPRL | CHAR | 4 | SYCHAR04 | ||||
TO_REL | Release of SAP System | SYSAPRL | CHAR | 4 | SYCHAR04 | ||||
OS | Operating System of Application Server | SYOPSYS | CHAR | 10 | SYOPSYS | ||||
DB | Central Database System | SYDBSYS | CHAR | 10 | SYCHAR10 | ||||
PATCH_TYPE | OCS Package Type | PATCH_TYPE | CHAR | 3 | PATCH_TYPE | ||||
ANCESTOR | Support Package predecessor | PAT_ANCEST | CHAR | 20 | Assigned to domain | TRKORR | |||
STRICT_SEQ | Flag for fixed predecessor | PAT_STRICT | CHAR | 1 | CHAR1 | ||||
NO_GEN | Suppress generation when importing Support Package | PAT_NOGEN | CHAR | 1 | PAT_NOGEN | ||||
SPAMFIX | Support Package is an update of SAP Patch Manager (SPAM) | PAT_SPAMFX | CHAR | 1 | CHAR1 | ||||
ADDON_ID | Name of an Add-On Product | ADDONID | CHAR | 10 | Assigned to domain | ADDONID | |||
ADDON_REL | Version of an 'Add-On' Product | ADDONRL | CHAR | 12 | CHAR12 | ||||
IGN_CONFLI | Ignore conflicts with the respective add-on | IGN_CONFLI | CHAR | 1 | CHAR1 | ||||
AP_ANCEST | Add-on Support Package predecessor | AP_ANCEST | CHAR | 20 | Assigned to domain | TRKORR | |||
EPSFILSIZ | File Size Placeholder (for Unicode, Original: EPSFILSIZ) | PATFILSIZ | CHAR | 4 | CHAR4 | ||||
HI_ANCEST | High predecessor (for CRTs only) | PAT_HIAN | CHAR | 2 | CHAR2 | ||||
COMP_REL | Component release | PAT_COREL | CHAR | 10 | CHAR10 | ||||
COMPONENT | Component | PAT_COMP | CHAR | 30 | Assigned to domain | DLVUNIT |
Key field | Non-key field |
How do I retrieve data from SAP table PAT03 using ABAP code
The following ABAP code Example will allow you to do a basic selection on PAT03 to SELECT all data from the tableDATA: WA_PAT03 TYPE PAT03.
SELECT SINGLE *
FROM PAT03
INTO CORRESPONDING FIELDS OF WA_PAT03
WHERE...
How to access SAP table PAT03
Within an ECC or HANA version of SAP you can also view further information about PAT03 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects