Skip to Content
Mar 11, 2019 at 03:20 PM

Accessing HANA native table stored in different schema

639 Views Last edit Mar 11, 2019 at 03:22 PM 2 rev

Hi guys,

I have a question of how to access HANA native table stored in HANA secondary DB from local SAP BW (7.40 SP18 SP) system with ABAP (ADBC_QUERY or SELECT ... FROM... CONNECTION) if the HANA table is stored in a different/other schema than the default schema (schema with the name as DBCO - User name). The other schema is defined in DBCO - according to SAP Note: 1983389 - DBCON entry for SAP HANA.

The HANA is configured in DBCO:

- User name: SAPHD1

The HANA native tables in schema SAPHD1 we can access from local SAP BW without problems.

All HANA native tables contain data, have Key field and have fields of table field types nvarchar or varchar, integer or decimal. Also, a local DDIC table in local SAP BW system is created with the same name and structure as HANA native table.

Does anybody have any experience with this situation?

Thank a lot.




capture-1.png (18.3 kB)