Index is Missing in DB02

[Former Member]

Dear All,

I just check in DB02 that there is one secondary Index is missing on Production server.

Database object for VBAK is inconsistent: (Secondary indexes)

Indexes: Inconsistent with DDIC source   

ABAP Dictionary Database 

Index does not exist Index *IDX$$_6E360001* 
  AUFNR 
  MANDT

Please tell me ....

is it automatically created?

now.... how can i create this indexe with SE11 or SE14 or some other way?

Regards,

Diya

[fjhernanz]

Hi Diya,

See note 33814 and related one 117219 about how to proceed

Br,

Javier

[Former Member]

Dear javier,

i checked the note 117219 but in this simply mantioned the Database Utility while as i said that we can create via SE11 and SE14.now i want to create IDX$$_6E360001 for VBAK.

run SE11

put Table : VBAK

click on Display

click on Indexes

now i want to create IDX$$_6E360001 what are the remaining steps.

Regards,

diya

[Former Member]

Hello Diya,

If you really need to create index then Please go through the Note 334224 - Important notes for creating indexes.

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/how-to-create-index-in-abap-dictionar...

However, I am not sure whether 'creating' a new index is the solution of the problem mentioned by you initially (What I mean is, creating the index is not the solution 'everytime' for this kind of message in DB02)

Thanks