Requirements for Database Tables and Database Views 

Table Names, View Names and Field Names

The naming conventions for the ABAP dictionary usually apply for table names and field names.

Make sure that you only use tables and views in the extraction whose technical names consist solely of upper case letters, numbers, and underscores (_). Problems may arise if you use other characters.

You can use database views to convert original names in table names to uppercase and to apply other conversions. For more information see Database Users and Database Schemas

Code Page and Sort Sequence for Source System

SAP kernel-based systems, like the BI system, work on the assumption that the database was created with code page cp850 and is using sort sequence ‘bin’. The source system configuration may be different from this. If the sort sequence is different, sample search ( like ) and area search ( between, >,<) operations for character fields may return different results.

If you use multibyte code pages in the source system to store data for character records with more than 256 characters (special characters for Japanese (kanji and hiragana), Korean, Chinese, and so on) there is a risk that some of the characters may be corrupted.

When you create the DataSource, you can check the result of the extraction in the preview to determine whether this problem has occurred.

Since data conversion problems and unexpected sort results may arise if the database source system and BI do not use the same code page, we recommend that you use the same code page in both the database source system and in BI.

DB Data Types

As a rule, the only data types that can be supported are those that can be modeled on ABAP Dictionary data types.

When you use DB data types, refer to the database-specific SAP notes for DB Connect shown below.

You can use database views to convert data types, if necessary. For more information see Database Users and Database Schemas .

List of Database-Specific SAP Notes

If you are using an MSS database, refer to SAP Note 512739.

If you are using an Oracle database, refer to SAP Note 518241.

If you are using an SAP DB or MaxDB database, refer to SAP Note 520647.

If you are using an IBM DB2/390 database, refer to SAP Note 523552.

If you are using an IBM DB2/400 database, refer to SAP Note 523381.

If you are using an IBM DB2 UDB database, refer to SAP Note 523622.