/
(SM-1902) MS SQL Transparent Storage

(SM-1902) MS SQL Transparent Storage

Jan 15, 2019

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.