SAP DDSTORAGE1 Table – Storage clause for tables and indexes

The DDSTORAGE1 table in SAP ERP or S/4HANA stores Storage clause for tables and indexes data. There are total 7 fields in DDSTORAGE1 table. The Storage clause for tables and indexes 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 DDSTORAGE1 table. It is in ABAP Dictionary (SDIC) ABAP package and is part of the Activation Program, Conversion Program, DB Utility, MC, SPDD (BC-DWB-DIC-AC) module.

SAP DDSTORAGE1 Table Fields

Following is the list of fields that are available in SAP DDSTORAGE1 table. The primary key fields of Storage clause for tables and indexes table in SAP are DBSYSABBR (3-Character Database ID), TABNAME (Table Name), INDEXNAME (Unique Index ID in a Table), USEFLAG (Storage parameters used for conversion/creation), POSNR (ABAP Dictionary: Item in Log).

Field Description Data Element Check Table Data Type
DBSYSABBR 3-Character Database ID DBSYSABBR CHAR (3)
TABNAME Table Name TABNAME * CHAR (30)
INDEXNAME Unique Index ID in a Table INDEXID CHAR (3)
USEFLAG Storage parameters used for conversion/creation NEWSTOPAR CHAR (1)
POSNR ABAP Dictionary: Item in Log DDPOS DEC (5)
PARNAME SAP object name OBJNAME CHAR (30)
TEXT Text (79 characters) TEXT79_D CHAR (79)