ABAP Netweaver

In SAP’s Netweaver based ABAP application, application developers access databases with Open SQL, which is converted by the Database Interface into native SQL statements supported by various Database providers and then executed.

SQL > select DBCON from Netweaver; SQL > select DBCON from Netweaver;

SAP CRM and C4C also support Enterprise Search(sometimes also called simple Search, fuzzy Search), which is similar to Google Search. You only need to specify the value to be searched, but do not need to specify the search criteria corresponding to the value.

The Enterprise Search implementation in both products is essentially an application making a Remote Function Call (RFC) to the TREX server to get the query results.

For more information about SAP TREX, see Wikipedia.

En.wikipedia.org/wiki/TREX_s…

Hybris

There is also a layer in Hybris that serves the same function as the API layer in the CRM WebUI and encapsulates operations on the DB.

The database Access implementation in Hybris is encapsulated in a number of Java class implementations ending in DAOs (Data Access Objects), equivalent to those function Modules in the SAP CRM API layer.

Open a DAO at random to see the implementation, which is also put together SQL statements and then thrown to DB to execute:

The SQL statement assembled in the code above is not the native SQL language associated with the data provider, but a new language called Flexible Search. Like ABAP’s OPEN SQL, it decouples the code for Hybris applications to access the database layer from the underlying database.

You can see a list of supported databases in the Hybris help documentation:

The database used in the Hybris development environment is called HSQLDB: a lightweight, pure Java developed open source relational database system