select giving a dump

[Former Member]

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?

[Former Member]

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

[kesavadas_thekkillath]

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

[Former Member]

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

[Former Member]

Hello!

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

Cheers!

[Former Member]

HI,

can you give some detailed infomation about your internal table t_contracts

what is the structure of is ?

[Former Member]

Hi

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

[Former Member]

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

[Former Member]

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