The DD02MSS table in SAP ERP or S/4HANA stores Table Parameters for Microsoft SQL Server data. There are total 3 fields in DD02MSS table. The Table Parameters for Microsoft 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 DD02MSS 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 DD02MSS Table Fields
Following is the list of fields that are available in SAP DD02MSS table. The primary key fields of Table Parameters for Microsoft SQL Server 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) |
