Joining cobk and coep table using Inner join taking too long
I am placing an Inner join on cobk and coep table to get data in an internal table but it is taking too long. I also tried to get data from db view COVP but it is also taking long time.
SELECT bk~kokrs
bk~belnr
bk~budat
bk~cpudt
bk~bltxt
ep~buzei
ep~wkgbtr
ep~objnr
ep~gjahr
ep~kstar
ep~vrgng
ep~parob1
ep~beknz
ep~sgtxt
ep~objnr_n1
ep~bukrs
INTO TABLE covp_itab
FROM cobk AS bk
INNER JOIN coep AS ep ON (bk~kokrs = ep~kokrs AND bk~belnr = ep~belnr)
WHERE bk~kokrs = co_kokrs
AND ep~wrttp = '04'
AND ep~kstar IN s_kstar
AND ep~vrgng IN s_vrgng
AND ep~bukrs IN r_bukrs
AND bk~timestamp IN r_stamp.