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.