topic Re: Function to get Table indices in Application Development and Automation Discussions

Function to get Table indices

Former Member — Mon, 04 Jan 2010 13:31:00 GMT

Dear all,

i'm looking for a function modul to get indices of individuell table.

I could'nt dfinde any one!

best regards

vinod_vemuru2 — Mon, 04 Jan 2010 13:36:54 GMT

Hi,

I you can check the table DD12L for INDEX definitions of a table and DD12T for descriptions of indexes. Here pass the table name

Thanks,

Vinod.

Former Member — Mon, 04 Jan 2010 13:38:31 GMT

Hello

DD12L, DD12T, DD12V

former_member194416 — Mon, 04 Jan 2010 13:38:56 GMT

Hi,

You can use FM " DB_GET_INDEXES'.

Regards,

Former Member — Mon, 04 Jan 2010 13:50:42 GMT

Thank you very very much to all

ehmm @Gungor Ozcelebi

I get now all index fields from the FM. How can I determine the secondary indices.

I think its everything fields without '~0' right?

best regards

Edited by: handeglo on Jan 4, 2010 2:53 PM

Former Member — Mon, 04 Jan 2010 14:00:04 GMT

you get the following tables in the FM.. right?

DBINDEXES

DBINDFLDS

in this DBINDEXES you have 1 field for index another for unique.. for primary key it would be 'X'.

or any ways the index <tab_name>~0 means primary key( ~0).

after getting this...

you delete the lines for <tab_name>~0 from DBINDFLDS and rest are your secondary keys

Former Member — Mon, 04 Jan 2010 14:01:10 GMT

Yes, that's

Thank you again !

best regards

Clemenss — Mon, 04 Jan 2010 17:41:19 GMT

yes, ~0 is allways the primary index, all others are secondary.

Regards,

Clemens