cancel
Showing results for 
Search instead for 
Did you mean: 

Where information of table types (input/output) stored in sap HANA repository?

Former Member
0 Kudos

Where information of table types (input/output) stored in sap HANA repository?

Accepted Solutions (0)

Answers (2)

Answers (2)

lucas_oliveira
Advisor
Advisor
0 Kudos

Hi,

If you're referring to the design time objects that maps to table types, then you'd get those in the CDS files (.hdbdd) by using the type syntax.

During activation these will turn into catalog table types under the schema you defined.

Doc here:

CDS User-Defined Data Types - SAP HANA Developer Guide for SAP HANA Studio - SAP Library

BRs,

Lucas de Oliveira

Former Member
0 Kudos

Hi Rafi,

If you are talking about the local table types created inside the procedure, they would be stored under _SYS_BIC schema Procedures -> Table Types in catalog.

If you have created a table type using CDS approach, it would be saved under respective schema  Procedures -> Table Types in catalog.

Regards,

Anil

Former Member
0 Kudos

Hi Anil,

I meant to in which tables the information about the table types is stored and not the location in the catalog.

If I create procedure with input.Type where the information about the two objects stored in the repository of HANA (sys.repo, sys.bic etc.)

BR,

Rafi

Former Member
0 Kudos

Hi Rafi,

Try the below query,

select * from tables where is_user_defined_type = 'TRUE';

It should give you the required results.

Regards,

Anil