The DD02ALL table in SAP ERP or S/4HANA stores Table Parameters for ALLBASE data. There are total 6 fields in DD02ALL table. The Table Parameters for ALLBASE 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 DD02ALL table. It is in sall (SALL) ABAP package and is part of the Business Suite on Adaptive Server Enterprise (BC-DB-SYB) module.
SAP DD02ALL Table Fields
Following is the list of fields that are available in SAP DD02ALL table. The primary key fields of Table Parameters for ALLBASE table in SAP are TABNAME (Table Name), SOURCE (Source, originator of the DB values parameter).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| TABNAME | Table Name | TABNAME | * | CHAR (30) |
| SOURCE | Source, originator of the DB values parameter | TPARSOURCE | CHAR (3) | |
| USEFLAG | Storage parameters used for conversion/creation | NEWSTOPAR | CHAR (1) | |
| DBFILESET | dbfileset name for ALLBASE | DBFILESET | CHAR (20) | |
| ALL_TYPE | Type in SYSTEM.TABLE of ALLBASE | ALLTYPE | INT1 (3) | |
| ALL_RTYPE | Locking mode for ALLBASE database tables | ALL_RTYPE | CHAR (10) |
