topic Re: Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query in Application Development and Automation Discussions

Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

Former Member — Tue, 28 Oct 2008 13:11:12 GMT

Hi,

I am getting a short dump when executing the below statement in background

SELECT B_{VBELN B}POSNR A_{FKART A}KUNAG A_{KUNRG A}ERDAT B~MATNR

B_{PMATN B}PRSDT B_{ARKTX B}FKIMG B_{MEINS B}NETWR B~MWSBP

B_{ABRBG B}FBUDA B_{PRODH B}AUBEL B~AUPOS

INTO TABLE I_VBRP

FROM VBRK AS A

INNER JOIN VBRP AS B

ON A_{VBELN = B}VBELN

FOR ALL ENTRIES IN I_FINAL

WHERE ( B~AUBEL = I_FINAL-VBELN AND

B~AUPOS = I_FINAL-POSNR ) AND

A~ERDAT >= '20070101'.

would appreciate your early response.

Thanks

Yamini

Re: Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

Former Member — Tue, 28 Oct 2008 15:01:21 GMT

Hi,

Have you declared the internal table I_VBRP to match the fields that you are selecting. They must be the same type and be in the same order to use the "into table" addition.

Darren

Re: Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

ThomasZloch — Tue, 28 Oct 2008 15:06:28 GMT

What is your relation to this post?

It contains the exact same code and problem, but by a different person.

Thomas

Re: Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

Former Member — Tue, 28 Oct 2008 15:09:07 GMT

but with different problem

Re: Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

ThomasZloch — Tue, 28 Oct 2008 15:27:26 GMT

How do you know? The OP here did not reveal much, other than the name of the dump.

It just occurred to me that this might be standard SAP code. A case for SAP Support Portal then.

Or an interview/exam type of problem? A case for SDN Moderator then.

Thomas

Re: Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

Former Member — Tue, 28 Oct 2008 15:33:22 GMT

...and different countries on the business card.

Rob

Re: Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

Former Member — Tue, 28 Oct 2008 16:53:50 GMT

Looks like 2 different people, working on the same support case.

This happens from time to time.

Cheers,

Julius