Show TOC

Requirements for Database Tables and Database ViewsLocate this document in the navigation structure

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.

Note

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

Code Page and Sort Sequence for Source System

SAP kernel-based systems, such as the BW system, work on the assumption that the database being used was created with the codepage cp850 and using the sort sequence 'bin'. The source system configuration might be different. If the sort sequence is different, sample search ( like ) and area search ( between, >,<) operations for character fields might 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 might 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.

Note

SAP recommends using the same codepage in both the database source system and in the BW system, because using different codepages can cause problems with the data conversion and unexpected sort results.

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 using DB data types, note the database-specific SAP notes for DB Connect shown below.

Note

You can use database views to convert data types, if necessary. More information: Database Users and Database Schemas .

List of Database-Specific SAP Notes

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

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

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

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

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

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

If you are using an SAP HANA database, see SAP Note 1597627.