Skip to Content

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

Problems selecting bsis data

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.

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