When using create existing table, you must specify all datatypes with recognized SAP ASE datatypes.
If the remote server tables reside on a class of server that is heterogeneous, the datatypes of the remote table are automatically converted into the specified SAP ASE types when the data is retrieved. If the conversion cannot be made, CIS does not allow the table to be defined.
The Component Integration Services Users Guide contains a section for each supported server class and identifies all possible datatype conversions that are implicitly performed by CIS.