Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Abap: EKPO table

Dear Abap experts,

I am running this simple query on the EKPO table but it takes more  than 20 minutes.

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_ekpo

           FROM ekpo

          WHERE lgort = '1003'.

I checked ST05 and noted that others users are accessing EKPO table. But when no user is accessing this table then this query runs fast. How can I overcome this problem. So that we could get the report also during data entry time.

I want to also mention that even SE11 not works and gives output very slow.

Regards,

Aneel

Former Member replied

@Aneel Munawar

create Secondary Index on table EKPO for field LGORT.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question