Sequential Read- Performance issue

[Former Member]

Hi All,

Its taking too long for viewing the PREVIEW of a print document by EA40 tcode.

When I check the process overview in SM50, it shows sequential read from table EABP.

In the exit of the form used for the print document there is just a single query on this table.

   SELECT  SINGLE opbel
              FROM  eabp
              INTO  gv_inv-abpopbel
              WHERE invopbel EQ wa_doc_header-sto_opbel.

Is there anything wrong with the query?? Or there can be some other reason for the degraded performance??

Please suggest some way out...

Thanks in advance.

Moderator note - thread locked - do research prior to posting.  Understand your situation before asking others.

[sitakant_tripathy2]

Hi Gundeep,

INVOPBEL is not the key field...Could you try passing the key fields OPBEL and VERTRAG alongwith INVOPBEL.

If its not possible try creating a secondary index for the field INVOPBEL only...

Regards,

Sitakant.

[Former Member]

This message was moderated.

[Former Member]

Its a basic question. Before posting, Please search thoroughly in SCN.

Moderator note - please do not respond in this manner - flag the posting and the moderators will take action.