The DD05S table in SAP ERP or S/4HANA stores Foreign key fields data. There are total 8 fields in DD05S table. The Foreign key fields 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 DD05S table. It is in ABAP Dictionary: Objects Accessed in Kernel (SDDD) ABAP package and is part of the Activation Program, Conversion Program, DB Utility, MC, SPDD (BC-DWB-DIC-AC) module.
SAP DD05S Table Fields
Following is the list of fields that are available in SAP DD05S table. The primary key fields of Foreign key fields table in SAP are TABNAME (Table Name), FIELDNAME (Name of the field to be checked), PRIMPOS (Position of corresp. foreign key field in primary key), AS4LOCAL (Activation State of Repository Object), AS4VERS (Version of the entry (not used)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TABNAME | Table Name | TABNAME | DD08L | CHAR (30) |
| FIELDNAME | Name of the field to be checked | FORFIELD | DD08L | CHAR (30) |
| PRIMPOS | Position of corresp. foreign key field in primary key | PRIMPOS | NUMC (4) | |
| AS4LOCAL | Activation State of Repository Object | AS4LOCAL | CHAR (1) | |
| AS4VERS | Version of the entry (not used) | AS4VERS | NUMC (4) | |
| FORTABLE | Table of the foreign key field | FORTABLE | * | CHAR (30) |
| FORKEY | Names of Foreign Key Fields | FORKEY | * | CHAR (30) |
| FORSTRING | Foreign Key Part in Other Table | FORSTRING | CHAR (60) |
