Skip to Content
0
Former Member
Dec 03, 2007 at 09:24 AM

Problems selecting bsis data

204 Views

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.