on 12-11-2012 7:22 AM
hi
if any ABAP function module is there to fetch HANA table details.
Thanks in Advance...
Hi,
Do you mean Fact tables of info cubes and Active record table of DSO?
Could you please elaborate your requirement.
Thanks,
Swarupa.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sureshkumar ,
what kind of table Details ?
Please be more precise.
In terms of SAP HANA native database Data Dictionary table details You can query
the HANA dictionnary views like tables, m_cs_tables columns ,... with Open SQL.
From the view TABLES can retrive informations like:
This table shows available tables. Column name | Data type | Description |
SCHEMA_NAME | NVARCHAR(256) | Schema name |
TABLE_NAME | NVARCHAR(256) | Table name |
TABLE_OID | BIGINT | Object id of the table |
COMMENTS | NVARCHAR(5000) | Table description |
FIXED_PART_SIZE | SMALLINT | Fixed part size of the table |
IS_LOGGED | VARCHAR(5000) | Specifies whether logging the table or not: 'TRUE'/'FALSE' |
IS_SYSTEM_TABLE | VARCHAR(5000) | Specifies whether the table is system table or not: 'TRUE'/'FALSE' |
IS_COLUMN_TABLE | VARCHAR(5000) | Specifies whether the table is a column table or not: 'TRUE'/'FALSE' |
For more Dictionnary Views please refer to the
SAP HANA Database - Administratior Guide.
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.