(SM-1903) MS SQL Transparent Storage

Storage setup

• Storage ID: name of the storage
• Storage Type: type of the storage. Use the storage type "SM_TRS_MSS" for MS SQL transparent storage.
• Description:  short text description

• DB Connection Name: existing SAP database connection.
• Column Oriented: switch between the columnar and row-oriented database management system
• MSSQL Collation: collation rules
  
• Enable update: support of direct update statements

Limitations

While altering a table, only new fields (characteristics or key figures) can be added. It isn't possible to modify the existing field’s datatype or length.