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
Former Member replied

Former Member

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