(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.