Identify the database used for backend in ABAP

In SAP ABAP development, identifying the backend database system is essential for writing database-specific code and understanding system architecture. ABAP provides built-in system classes to retrieve this information programmatically.

Using CL_DB_SYS Class

The CL_DB_SYS class provides the DBSYS_TYPE attribute to fetch the current database type. This system class is available in all SAP systems and returns a standardized database identifier.

Example

Here's how to identify the database system using ABAP code ?

DATA: lv_db_type TYPE string.

" Get the database system type
lv_db_type = cl_db_sys=>dbsys_type.

" Display the result
WRITE: 'Current Database System: ', lv_db_type.

Common Database Type Values

The DBSYS_TYPE returns different values depending on the backend database ?

• HDB ? SAP HANA Database
• DB6 ? IBM DB2
• ORA ? Oracle Database
• MSS ? Microsoft SQL Server
• SYB ? SAP Sybase ASE

For example, if your SAP system is running on SAP HANA as the database, the DBSYS_TYPE will return the value HDB.

Conclusion

Using CL_DB_SYS=>DBSYS_TYPE is the standard method to programmatically identify the backend database in ABAP, enabling developers to write database-aware applications and implement system-specific logic.