SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability28
Data types used by SAP
SAP uses simple data types including:
Variable length character types only
Normal integers and a few small integers
Float and decimal, especially for the SAP BW fact tables
In addition, for SQL Server 2005 the varbinary(max) data type is used instead of the image data type for BLOB and Clob fields. The data type image/varbinary(max) is used in approximately 450 tables. The data type is changed from image to varbinary(max) as a metadata operation only. No data movement takes place when changing the data type. For more information, see SAP OSS Note 799058.
Note that SAP does not use user-defined data types and SQL variants.
Microsoft Corporation © 2005