Skip to main content

Hi CDATA Team, 

There are many tables, views, and other database objects in the SAP application database. I wanted to check if the CDATA JDBC Driver aids in obtaining the filtered list based on SAP modules or an archive object, as it is quite difficult to identify tables based on any standard SAP module or standard archive object.

I therefore want to retrieve the list of all tables and views that are utilized in, say, the FI module or FI_Documents, as part of my requirement. Is it possible to retrieve the table and view names from SAP HANA DB using the CDATA JDBC Driver based on SAP modules?
 

Example:

If you're querying an SAP table, you could specify a filter such as:

SELECT * FROM "SAP_Material" WHERE "Module" = 'MM'

Or, for archived objects, the query might look something like:

SELECT * FROM "SAP_Archive" WHERE "ArchiveObject" = 'SomeArchiveObject'

 

Thanks

Hi, Ashish

 

Based on what you’ve described with modules, this sounds like this question would be directed towards a SAP S/4 Hana instance as opposed to SAP HANA; can you please confirm if that is the case?


In the case that you are referring to SAP S/4 Hana (and using the CData SAP Gateway JDBC driver), then whether or not you can filter a query by Module or ArchiveObject would depend entirely on your table’s data structure. As the driver utilizes the SAP S/4 HANA OData API to model data from SAP as tables, it obtains this metadata from your SAP instance dynamically will be unable to add additional data columns not already present within the database itself.

 

Hence, if columns such as Module and ArchiveObject do not already exist within this data, the driver will not be able to explicitly filter a query with it.

Reply


CData's Winter 2025 Release
Terms and ConditionsCookie settings