topic Re: Dump for a select query in Application Development and Automation Discussions

Dump for a select query

flowers_candys — Thu, 05 Feb 2009 13:44:01 GMT

Hi Gurus,

I have a select query as follows:

SELECT

vbap~vbeln

vbap~posnr

vbap~matnr

vbap~arktx

vbap~pstyv

vbap~abgru

vbap~prodh

vbap~netwr

vbap~werks

vbap~kwmeng

vbap~prctr

vbap~ps_psp_pnr

FROM vbap

INTO TABLE i_item_vbap

FOR ALL ENTRIES IN i_reg_vbak

WHERE

vbap~vbeln EQ i_reg_vbak-vbeln AND

vbap~matnr IN s_matnr AND

vbap~werks IN s_werks .

However, when I execute the program, I get the dump saying as:

I get this exception "DBIF_RSQL_INVALID_RSQL", assigned to CLASS "CX_SY_OPEN_SQL_DB"

Please help me in understanding this.

Also, there are only 85 entries in i_reg_vbak, plus not many values are there for s_matnr and s_werks.

I tried executing this query w/o for all entries, but still it gave a dump.

Waiting for your reply, thanks!

Re: Dump for a select query

Former Member — Thu, 05 Feb 2009 13:58:48 GMT

hi,

Make sure that fields in i_item_vbap match with the order you are retrieving in the SELECT query or try out using

INTO CORRESPONDING FIELDS OF TABLE i_item_vbap.

Hope this is informative

Thanks

Sharath

Re: Dump for a select query

Former Member — Thu, 05 Feb 2009 15:58:52 GMT

hi.....

the table should have same field names which you have given in sql quary

or else

you can use

into corresponding fields of like as follows

SELECT

vbap~vbeln

vbap~posnr

vbap~matnr

vbap~arktx

vbap~pstyv

vbap~abgru

vbap~prodh

vbap~netwr

vbap~werks

vbap~kwmeng

vbap~prctr

vbap~ps_psp_pnr

FROM vbap

INTO CORESSPONDING FIELDS OF TABLE i_item_vbap

FOR ALL ENTRIES IN i_reg_vbak

WHERE

vbap~vbeln EQ i_reg_vbak-vbeln AND

vbap~matnr IN s_matnr AND

vbap~werks IN s_werks .

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 03:44:46 GMT

Hi,

When ever we are using select queries better take the fields in the same order as in the table.or u can define a structure of necessary fields and fetch data from there.

Then u may not get dump.

Regards,

Jaya

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 04:29:29 GMT

hi ,

To avoid the dump you can use --- " INTO CORRESPONDING FIELDS OF TABLE i_item_vbap .... ". As because INTO CORRESPONDING is a costly statement you can declare the structure of the i_item_vbap as & in same order as in your select query .

Regards

Pinaki Mukherjee

Re: Dump for a select query

rejish_balakrishnan — Fri, 06 Feb 2009 04:52:30 GMT

HI,

Clearly there is a mismatch betwen field mapping between vbap and i_reg_vbak table . Copy paste fields of both table and compare the order of fields .

Also check in SAP library about field mapping of tables .

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 05:23:55 GMT

Hi,

bettet You define a structure for the required fields and then you use the internal table i_item_vbap of that structure and then you can use select filds from vbap into corresponding fields of table i_item_vbap

and then try .

Thanks,

Rajendra

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 05:56:11 GMT

hi,

i think the table i_reg_vbak is having problem.

please check that table document number entries. i think some of values are not having same data type are not mach to the data type of vbap. chek it once.

regds:

rajesh.k

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 07:14:26 GMT

TRY THIS.

SELECT

vbap~vbeln

vbap~posnr

vbap~matnr

vbap~arktx

vbap~pstyv

vbap~abgru

vbap~prodh

vbap~netwr

vbap~werks

vbap~kwmeng

vbap~prctr

vbap~ps_psp_pnr

FROM vbap

INTO CORRESPONDING FIELDS OF TABLE i_item_vbap

FOR ALL ENTRIES IN i_reg_vbak

WHERE

vbap~vbeln EQ i_reg_vbak-vbeln AND

vbap~matnr IN s_matnr AND

vbap~werks IN s_werks .

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 07:24:16 GMT

Make sure that the field sequence of internal table i_item_vbap should be same as of select statement fields or visa versa

regards

Shiva

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 08:29:08 GMT

hello

SELECT

vbap~vbeln

vbap~posnr

vbap~matnr

vbap~arktx

vbap~pstyv

vbap~abgru

vbap~prodh

vbap~netwr

vbap~werks

vbap~kwmeng

vbap~prctr

vbap~ps_psp_pnr

from vbap into corresponding fields of table it_vbap.

if u use any fields of vbap on selection scrren then mention as

eg: where vbeln in s_vbeln etc.

with regards,

sumanth reddy

Re: Dump for a select query

Former Member — Fri, 06 Feb 2009 10:15:24 GMT

Hi,

In the select query mention the field in the order same as that of internal table,

or use into corresponding fields of table .

Regards,

Manoj Kumar P