Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 28, 2015 at 11:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Rafi,

      Try the below query,

      select * from tables where is_user_defined_type = 'TRUE';

      It should give you the required results.

      Regards,

      Anil

  • Oct 28, 2015 at 11:35 AM

    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

    Add comment
    10|10000 characters needed characters exceeded