1 开始 abap语句是这样的
SELECT SINGLE drad~dokar drad~doknr drad~doktl
INTO (drad-dokar ,
drad-doknr ,
drad-doktl)
FROM drad
INNER JOIN draw
ON drad~dokar = draw~dokar AND
drad~doknr = draw~doknr AND
drad~dokvr = draw~dokvr AND
drad~doktl = draw~doktl
WHERE drad~dokob = 'MARA' AND
drad~objky = <f_data>-matnr AND
draw~loedk = '' .
通过跟踪,发现他最慢
2 第一次优化
EXEC SQL.
select drad.dokar, drad.doknr, drad.doktl
from drad inner join draw on
drad.mandt = draw.mandt and
drad.dokar = draw.dokar and
drad.doknr = draw.doknr and
drad.dokvr = draw.dokvr and
drad.doktl = draw.doktl
where rownum = 1
and