cancel
Showing results for 
Search instead for 
Did you mean: 

DB02

Former Member
0 Kudos

Hi all,

When i execute transaction DB02 it is showing below missing indexes.

Primary indexes 2

MEMGMT_DEPLOYMNT-0

ZKELCMP-0

Unknown indexes in ABAP Dictionary

DB indexes 1

MEMGMT_DEPLOYMNT00

Please give me further step to do.

Please it is little urgent.

Vinnu.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

What was done with this index. For me it appeeared in the Unknown indices

MEMGMT_DEPLOYMNT00

Can anybody suggest please.

Thanks,

Venki

Former Member
0 Kudos

Hello Vinay ,

You can reindex the Table using Transaction SE11 or SE14.

Former Member
0 Kudos

Santosh,

I don't know how to reindex the table.

could you please give me the steps.

Please ................

VInnu.

Former Member
0 Kudos

Hello Vinay ,

Select the table using SE11 ( ZKELCMP ) - > Display -> You will get Disctionary : Display Table window .

Select Indexes -> You will get Popup for creating Index on Table ZKELCMP Index Name 0.

Regards,

Santosh

Former Member
0 Kudos

when i click on the indexes it is not showing any thing.

Please suggest me on this.

vinnu.

Former Member
0 Kudos

Hello Vinay,

There is another way to create Index using SE14 - > Specify Object Name -> check Table and click Edit.

Select Index (Create & Activate & Adjust Database).

Make sure that you have selected the Save Data.

For Eg :

Please follow the step as belows :

SE14 -> Table COEP -> Edit -> indexes.. -> choose pri.

index seperately.

For primary index, please do 'activate and adjust'.

I will advice you to create index using SE11 (Take assist of Developer for further assistance)

Former Member
0 Kudos

Thx santosh,

I will try and let u know.

vinnu.

Former Member
0 Kudos

Hey Vinay,

Go to SE38 execute RSANAORA then enter index name there and execute this will rebuild those missing indices. You need to select index radio button.

This will resolve your issue within no time buddy.

Thanks & Regards

Vivek