topic DB02 in Application Development and Automation Discussions

DB02

Former Member — Tue, 28 Jan 2014 10:32:25 GMT

Team,

In DB02 transaction, on clicking tab ' Missing Indexes ', i need to diplay the primary index and secondary index count in abap report. So can you let me know if ant function module available or any standard reports to get this counts.

Thanks in advance.

Regards,

Gururaj.

Re: DB02

Arun_Prabhu_K — Tue, 28 Jan 2014 10:39:29 GMT

Hello Gururaj.

For primary index: Table DD03L (Pass TABNAME = table name and KEYFLAG = 'X' to get the count)

For secondary index: Table DD12V (Pass SQLTAB = table name to get the count)

Regards.

Re: DB02

Former Member — Tue, 28 Jan 2014 11:17:23 GMT

Hi,

Looked at these tables DD03L and DD12V.

But if i check DB02 transaction and click the tab "Missing indexes", the counts are different.

Attached the screen shot for reference. Here Primary index is 0 and Secondary index is 3.

i want to display only these 3 names in my report and if i cross check this this object name in DD12V for secondary index, the ibject does not exist in the table.

Please let me know how to get these counts.

regards,

Gururaj.

Re: DB02

Arun_Prabhu_K — Tue, 28 Jan 2014 11:31:07 GMT

Actually I am not used to DB02 tcode functionality.

To get secondary index count of a table:

Just pass the table name to field SQLTAB of table DD12V.

I am getting the records correctly.

Re: DB02

Former Member — Tue, 28 Jan 2014 12:04:23 GMT

Hi,

I'm not getting the counts correctly. On clicking, 'Missing indexs, the counts for primary and secondary is different. Also i dont want to pass any table name specifically for field SQLTAB.

Anyways thanks for support.

Regards,

Gururaj.

Re: DB02

RaymondGiuseppi — Tue, 28 Jan 2014 12:24:37 GMT

You could try to use native SQL commands, select from dba_tables or dba_indexes (After an analyze statement) Either use native SQL or an ADBC class CL_SQL*. Then cross the result with SAP ddic table like DD02L or DD12L.

Regards,

Raymond