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
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.
create Secondary Index on table EKPO for field LGORT.