Extension Index in SAP

[Former Member]

Hello Experts,

I have a requirement to create secondary index on VBPA for fields PARVW and KUNNR. In VBPA i could see an extension index already available. The status of the index is new and there is a warning that says Index does not exist in MSSQL. Is it possible to activate this index and will it improve the performance if activated?

Please help.

Regards,

Ramanan R.S.

[former_member391265]

Hi

If it is already there, just activate and use it.

Thanks

Reward points, if helpful.

[Former Member]

Hi Ketan,

Thanks for the reply. The question is how to activate it. SE14 database utility does not activate the index.

[former_member491621]

Hi Ramanan,

SE14 activates the indexes.

Go to SE14 and click on Indexes button on the application toolbar of the screen.

A Pop-Up will appear showing the indexes of the table.

Double click on the one you want to activate.

The click Activate and Adjust Database button.

Hope this helps

[Former Member]

Hi Aniket,

SE14 will show list of secondary indexes. It does not show extension index. Thanks for the reply.

[raymond_giuseppi]

Look better at SE11 on the index...

Check Switch ISM_MEDIA_BASIS_MODIF activation status.

if switch activated

• You can activate the index (of Note 1239267 - Long runtimes when starting input in the Service Cockpit ?)
• For performance, it will improve some read performance, but of course not for the update of database.
• Also VBPA can be very huge on your system, so activation in database can be long and should be executed  outside of peak hours.

Else

• Transactions SE11, SE14 or DB02 wont have any effect (Read the activation log if you already tried)
• Create you own index in your namespace (like VBPA~Z01) (but activate in production outside of peak hours)

Regards,

Raymond

[Former Member]

Thanks Raymond. The ISM_MEDIA_BASIS_MODIF is switched off. I will have to create my own index.

Regards,

Ramanan

[gouravkumar64]

Hi,

Tr like this

in se11 >then go to >indexes> then ur MESSAGE will be raise probably.

like this

Just save & activate.

Maximum number of secondary index is 9.

Hope it helps.

Thanks

Gourav.