How to use Database Indexes in ABAP

In SE11, use menu path Goto->Indexes. Then select the relevant index and get the "DB index name".

Use the select statement as below.

  SELECT docnum sndprn docnum AS docnum1 

    INTO CORRESPONDING FIELDS OF TABLE i_edidc

    FROM edidc

   WHERE mestyp = 'REMADV'  AND

         status = '53'      AND 

         credat IN s_credat AND 

         docnum IN s_docnum

         %_hints oracle 'INDEX("EDIDC" "EDIDC~4")'.