The DD12MSS table in SAP ERP or S/4HANA stores Index Parameters for MS SQL Server data. There are total 3 fields in DD12MSS table. The Index Parameters for MS SQL Server 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 DD12MSS table. It is in Data Dictionary Porting for Microsoft SQL Server (SMSS_DDIC) ABAP package and is part of the SQL Server in SAP NetWeaver Products (BC-DB-MSS) module.
SAP DD12MSS Table Fields
Following is the list of fields that are available in SAP DD12MSS table. The primary key fields of Index Parameters for MS SQL Server table in SAP are INDNAME (Database index), SOURCE (Source, originator of the DB values parameter).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| INDNAME | Database index | DBINDEX_D | CHAR (40) | |
| SOURCE | Source, originator of the DB values parameter | TPARSOURCE | CHAR (3) | |
| USEFLAG | Storage parameters used for conversion/creation | NEWSTOPAR | CHAR (1) |
