(SM-1811) MS SQL Transparent Storage

Storage setup

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

• DB Connection Name: existing SAP Database Connection. Use the following link for more information.
• Column Oriented: switch between the columnar and row-oriented database management system
• MSSQL Collation: collation rules (between charsets operations)
• Enable Update: support of direct update statements

Limitations

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