Skip to Content
0
Former Member
Oct 13, 2005 at 03:50 AM

Range Problems

78 Views

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.