topic select giving a dump in Application Development and Automation Discussions

select giving a dump

Former Member — Tue, 11 Nov 2008 08:56:28 GMT

hi all my below select is giving a dump

select aufk~aufnr

aufk~objnr

aufk~ktext

vbap~vbeln

vbap~posnr

vbap~aufnr

vbap~matnr

vbap~netwr

vbak~auart

vbak~kunnr

from aufk inner join vbap

on aufk_{aufnr = vbap}aufnr

inner join vbak

on vbap_{vbeln = vbak}vbeln

into corresponding fields of table t_contracts

where aufk~aufnr in s_proj

and vbap~vbeln in s_vbeln

and vbap~matnr in s_matnr

and abgru = c_abgru.

DBIF_RSQL_INVALID_RSQL

CX_SY_OPEN_SQL_DB

Can anybody tell me the way to do it?

Re: select giving a dump

kesavadas_thekkillath — Tue, 11 Nov 2008 08:58:32 GMT

Check whether the fields selected are mathching the fields in ur itab.

ie.no of fields must be same....

somewhere there is mistake in ur query...check it

Re: select giving a dump

Former Member — Tue, 11 Nov 2008 09:00:16 GMT

Hello!

The field attributes of your internal table should be the same as the corresponding data dictionary fields.

Cheers!

Re: select giving a dump

Former Member — Tue, 11 Nov 2008 09:02:54 GMT

Try checking for the field names in the internal table also see the last field abgru.

Re: select giving a dump

Former Member — Tue, 11 Nov 2008 09:10:07 GMT

HI,

can you give some detailed infomation about your internal table t_contracts

what is the structure of is ?

Re: select giving a dump

Former Member — Tue, 11 Nov 2008 09:10:09 GMT

Try with the following select statement

select a~aufnr

a~objnr

a~ktext

b~vbeln

b~posnr

b~aufnr

b~matnr

b~netwr

c~auart

c~kunnr

into corresponding fields of table t_contracts

from aufk AS a

INNER JOIN vbap AS b ON a_{aufnr = b}aufnr

INNER JOIN vbak AS c ON c_{vbeln = b}vbeln

where a~aufnr in s_proj

and b~vbeln in s_vbeln

and b~matnr in s_mat and abgru = c_abgru.

Regards

Madhan D

Re: select giving a dump

Former Member — Tue, 11 Nov 2008 09:23:57 GMT

firstly make inner join between vbak and vbap and then inner join in between vbap and aufk

and i think 'aufk as aufk ' clause is missing.............

with regards

pardeep sharma

Re: select giving a dump

Former Member — Tue, 11 Nov 2008 09:26:08 GMT

Hi Bhanu,

Check the declaration of the internal table. I think the Type declaration is not same with the data you are fetching fromthe select query.

Thanks,

Chidanand