Skip to Content
0
Former Member
Dec 16, 2010 at 07:14 AM

COEP index 2 does not exist in the database

472 Views

Hi all experts,

I have a select query as :

        SELECT * FROM COEP INTO TABLE IT_COEP
                 FOR ALL ENTRIES IN IT_PRPS
                 WHERE OBJNR = IT_PRPS-OBJNR
                   AND KSTAR LIKE '004%'
                   AND GJAHR IN S_GJAHR
                   AND PERIO IN S_PERIO
                   AND WRTTP = '04'.

It should use the index COEP2 but when I traced it using ST05 it it is not using the index COEP2, when I checked, I found that COEP2 does not exist in the database. As this report is one of the very frequent reoprts which our client uses, I need this index. I don't want to use COEP1 by adding LEDNR in my where clause, as it has many fields which doesnot improve the performance much.

1) I have created indexes whenever necessary but Iam confused here because SAP has created an Index at dictionary level and has not created the same at DB level, what is the reason behind this?

2) What is the use of an index which does not exist in the database ?.

3)If I activate it at DB level with the help of BASIS or by using SE14, will it create any issue? will I face any data loss? currently this table has over 20,00,000 entries?

Hoping for expert replies 😊

Thanks & Regards,

Faheem.