Hi all, Im having a problem using the range in my select, the problem is that the range contains 114 ranges... after the select statement the program cant retrieve all the data that satisfies my selection criteria using the range. Is there any possibilities to load/generate all values inside the given range? Is there a function module for that because it seems that the program is having a problem comparing the values found in the dbtable against the range since there are a lot of ranges to be check. Pls help. me. below is the program code for select:
SELECT gl_sirid "Record number of the line item record
rvers "Version
ryear "Fiscal Year
rtcur "Currency Key
poper "Posting period
rbukrs "Company Code
rprctr "Profit center
racct "Account number
hsl "Amount in transaction currency
hsl "Amount in company code currency
kostl "Cost Center
paobjnr "Profitability Segment Number (CO-PA)
pasubnr "Profitability segment changes (CO-PA)
drcrk "Debit/Credit
FROM glpca
INTO TABLE i_glpca
WHERE ( rvers EQ c_000v OR "Actual
rvers EQ c_001v OR "Budget
rvers EQ c_100v OR
rvers EQ c_200v OR
rvers EQ c_300v )
AND ryear EQ v_pyear "Fiscal year
AND poper EQ v_pperiod "Posting year
AND rbukrs IN r_ccode "Company code
AND rprctr IN r_prctr "Profit center
AND ( racct IN r_ebit1
OR racct IN r_ebit2
OR racct IN r_ebit3
OR racct IN r_ebit4
OR racct IN r_ebit5
OR racct IN r_ebit6
OR racct IN r_ebit7
OR racct IN r_ebit8
OR racct IN r_ebit9
OR racct IN r_pers
OR racct IN r_occu
OR racct IN r_depre
OR racct IN r_capxe
OR racct IN r_capxn
OR racct IN r_cnets
OR racct IN r_intcn
OR racct IN r_intcc )
AND kokrs EQ c_0030.