Getting short dump -ABAP runtime errors DBIF_RSQL_SQL_E on select query

[Former Member]

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

[Former Member]

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

[Former Member]

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

[ThomasZloch]

What is your relation to this post?

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

Thomas

[Former Member]

but with different problem

[ThomasZloch]

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

[Former Member]

...and different countries on the business card.

Rob

[Former Member]

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

This happens from time to time.

Cheers,

Julius