Skip to Content

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

Reg: Slow performance of BKPF table due to AEDAT column in where clause

HI,

I have used following query in ABAP code in ABAP extract stage (in Datastage)

SELECT

bukrs

belnr

gjahr

INTO TABLE it_bkpf

FROM bkpf

WHERE cpudt >= 'date' OR aedat >=.'date'

The performance is very slow for 4000 records it is taking 22 minutes.

If i use the query

SELECT

bukrs

belnr

gjahr

INTO TABLE it_bkpf

FROM bkpf

WHERE cpudt >= 'date'

Then i got almost same records but it took only 1 minute.

But i must use first SQL .

Can anyone tell me how can i improve performance.?

Thanks in advance.

Pavan

Helpful Answer

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