RSQL error

[Former Member]

Hi all,

I have written selectr statement.

select bukrs "Company code

lifnr "Vendor account no

gjahr "Fin year

belnr "Posting document no

buzei "Line item

budat "Posting date

augbl "clearing document no

augdt "Clearing date

blart "Doc type

xblnr "Invoice reference

wrbtr "Invoice amount

waers "Invoice currency

shkzg

• saknr "GL a/c no "-RV01

• projk "Project code "-RV01

• prctr "Profit centre "-RV01

• kostl "Cost centre "-RV01

mwskz "tax code

dmbtr "Sterling equivalent

from bsak

• appending corresponding fields of table i_bsikbsak

• into table i_bsikbsak

appending table i_bsikbsak

where bukrs in s_bukrs

and lifnr in s_lifnr

and ( lifnr like '008%' or "-RV01+RV01

lifnr eq '0070000001' or "-RV01+RV01

lifnr like '006%' )

and budat in s_budat

and augdt in s_augdt

• and hkont in s_saknr "-RV01

and blart in s_blart

• and projk in s_projk

• and prctr in s_prctr

• and kostl in s_kostl

and mwskz in s_mwskz

• and augdt in s_budat

and ( blart between 'KA' and 'KZ' or "-RV01 +RV01

blart between 'RA' and 'RZ' ). "-RV01 +RV01

When I execute this statement I am getting shotdump as below

" Error in the module RSQL accessing the database interface "

pls any one help me.

[Former Member]

hi Praveen,

Remove conditions on blart and fill the ranges table from blart and later delete other data from internal table using ranges table ...

*and ( blart between 'KA' and 'KZ' or

*blart between 'RA' and 'RZ' ).

[Former Member]

Still I am getting the same error.

[Former Member]

hi,

check this condition:L

and lifnr in s_lifnr             *<---- 1st
and ( lifnr like '008%' or "-RV01+RV01  *<---- 2nd
lifnr eq '0070000001' or "-RV01+RV01
lifnr like '006%' )

u have 2 different condition for lifnr. this is causing the error.

[Former Member]

No,

First I tried by commenting those Lifnr statements.

But still it is giving me dump

[Former Member]

hi,

comment one of the lifnr's. if you have changed the code, post it here!

regards,

madhu

[Former Member]

add:

appending corresponding fields of table i_bsikbsak

regards,

madhu

[Former Member]

I got the solution.

Now my select statement is working fine.

[Former Member]

I am getting the same error.Thanks!

[Former Member]

hi

if u r getting short dump just see the structure of the iternal table is in the same structure with the table or not.

or test

1. remove the appending table statement

just use "into corresponding fields of table itab.."

try it

afetr that if dump occurs just analyze the dump what r the cause and how to avoid it

after that let me know...

thanks

rewards if useful

sachhidananda