Skip to Content
author's profile photo Former Member
Former Member

select giving a dump

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 aufkaufnr = vbapaufnr

inner join vbak

on vbapvbeln = vbakvbeln

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Nov 11, 2008 at 08:58 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:00 AM

    Hello!

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

    Cheers!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:10 AM

    HI,

    can you give some detailed infomation about your internal table t_contracts

    what is the structure of is ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:10 AM

    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 aaufnr = baufnr

    INNER JOIN vbak AS c ON cvbeln = bvbeln

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 11, 2008 at 09:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 11, 2008 at 09:26 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.