Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

VAKPA

Former Member
0 Kudos

Hello All,

The index tables of SD like VAKPA and VAPMA as I understand are special tables where Sales data is stored and indexed by partner function or material. My question is, is there any logic or advantage in declaring more indexes on these type of tables? For e.g. a index on VAKPA with sales doc number!

Do you think this really is advised and are there any possible impacts?

Thanks in advance for your help.

Best Regards

Anirban

3 REPLIES 3

Former Member
0 Kudos

Hi,

Firstly,

Creating more number of indexes on a table will lead to problems in selection of the proper index.

Index should be created for those fields which are majorly used in the queries so that the search is optimized...

If the indexes are already available then you should try to use them as far as possible,

if its required then you can create your own index

Regards,

Siddarth

Former Member
0 Kudos

Hello

Thanks for your reply, but I can understand that for a normal table, in case of VAKPA, it is an index table hence my question, whether any further index on VAKPA is advisable or not.

Thanks and Regards

Anirban

0 Kudos

Hi,

Further index on an indexed table is not advisable

Regards,

Siddarth