topic Re: RSQL error in Application Development and Automation Discussions

RSQL error

Former Member — Fri, 23 May 2008 05:12:27 GMT

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.

Re: RSQL error

Former Member — Fri, 23 May 2008 05:20:28 GMT

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' ).

Re: RSQL error

Former Member — Fri, 23 May 2008 05:55:21 GMT

Still I am getting the same error.

Re: RSQL error

Former Member — Fri, 23 May 2008 06:18:32 GMT

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.

Re: RSQL error

Former Member — Fri, 23 May 2008 06:34:06 GMT

No,

First I tried by commenting those Lifnr statements.

But still it is giving me dump

Re: RSQL error

Former Member — Fri, 23 May 2008 06:35:40 GMT

hi,

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

regards,

madhu

Re: RSQL error

Former Member — Fri, 23 May 2008 06:40:14 GMT

add:

appending corresponding fields of table i_bsikbsak

regards,

madhu

Re: RSQL error

Former Member — Fri, 23 May 2008 09:15:34 GMT

I got the solution.

Now my select statement is working fine.

Re: RSQL error

Former Member — Sun, 25 May 2008 04:18:39 GMT

I am getting the same error.Thanks!

Re: RSQL error

Former Member — Tue, 27 May 2008 08:30:00 GMT

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