The DB2SAPSYS table in SAP ERP or S/4HANA stores SAP systems located in one DB2 subsystem data. There are total 6 fields in DB2SAPSYS table. The SAP systems located in one DB2 subsystem table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of DB2SAPSYS table. It is in CCMS for DB2 for OS/390 (STU2) ABAP package and is part of the DB2 for z/OS (BC-DB-DB2) module.
SAP DB2SAPSYS Table Fields
Following is the list of fields that are available in SAP DB2SAPSYS table. The primary key fields of SAP systems located in one DB2 subsystem table in SAP are DBSCHEMA (DB2 creator name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| DBSCHEMA | DB2 creator name | DB2CREATOR | CHAR (8) | |
| SAPREL | SAP release | DB2SAPRL | CHAR (4) | |
| RFCDEST | Logical destination (specified in function call) | RFCDEST | * | CHAR (32) |
| SYSTEM_NR | System number | DB2SYSNR | CHAR (3) | |
| KNLREL | SAP Release | SAPRELEASE | CHAR (10) | |
| KNLPAT | Support Package Level of a Software Component | SAPPATCHLV | CHAR (10) |
