November 2011
Intermediate to advanced
608 pages
13h 33m
English
A relational database such as Oracle, DB2, or SQL Server, with several hundreds and thousands of tables, constitutes a SAP database layer. SAP application data is stored in the database tables and ABAP (Advanced Business Applications Programming) programs use Open SQL to interact with the underlying database via a database interface. The database interface will convert the Open SQL to native SQL. Even though SAP uses a number of different relational database systems, such as Oracle, DB2, and SQL Server as a data repository, the application logic is in the SAP data dictionary that sits on top of the database data dictionary. Therefore, underlying relational databases have to be managed as a “SAP database” using SAP-provided tools. ...