Hi all,
I'm taking a data from table bsis and bsas but it's make my program run very slow... When I check for the problem, I found out that when reading from table bsis was very slow. Is there any ways or solution for this problem? Here is my coding in selection from bsis. Any suggestion or help needed here....
SELECT b~monat
b~hkont
b~gsber
b~geber
b~bschl
b~shkzg
b~budat
b~dmbtr
b~fkber
b~blart
b~belnr
APPENDING CORRESPONDING FIELDS OF TABLE itaba
FROM bsis AS b
INNER JOIN ska1 AS c ON c~ktopl = 'FGCA' AND
csaknr = bhkont
WHERE b~bukrs = p_bukrs
AND b~gjahr = p_gjahr
AND b~budat LE s_budat-high
AND b~monat LE p_monat
AND b~hkont IN s_hkont
and b~gsber in s_gsber.
thanks,
saiful.