The DDPATH table in SAP ERP or S/4HANA stores DD: Definition of access paths data. There are total 17 fields in DDPATH table. The DD: Definition of access paths 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 DDPATH table. It is in ABAP Dictionary: Basic Tools (SDBT) ABAP package and is part of the Activation Program, Conversion Program, DB Utility, MC, SPDD (BC-DWB-DIC-AC) module.
SAP DDPATH Table Fields
Following is the list of fields that are available in SAP DDPATH table. The primary key fields of DD: Definition of access paths table in SAP are FORMID (DD: name of access path).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| FORMID | DD: name of access path | DDPATHID | CHAR (15) | |
| AS4LOCAL | Activation State of Repository Object | AS4LOCAL | CHAR (1) | |
| PTYPE | Type of access path | DDPTYPE | CHAR (1) | |
| TAB1 | Table Name | TABNAME | DD02L | CHAR (30) |
| TAB1_KEY1 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| TAB1_KEY2 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| TAB1_FRK1 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| TAB1_FRK2 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| TAB2 | Table Name | TABNAME | DD02L | CHAR (30) |
| TAB2_KEY1 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| TAB2_KEY2 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| TAB2_FRK1 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| TAB2_FRK2 | Field Name | FIELDNAME | DD03L | CHAR (30) |
| STEP1 | DD: Name of the first partial path | DDSTEP1 | DDPATH | CHAR (15) |
| STEP2 | DD: name of the second partial path | DDSTEP2 | DDPATH | CHAR (15) |
| STEP3 | DD: name of the third partial path | DDSTEP3 | DDPATH | CHAR (15) |
| STEP4 | DD: name of fourth partial path | DDSTEP4 | DDPATH | CHAR (15) |
