Skip to Content
0
Former Member
Dec 05, 2008 at 05:59 AM

Dump in Native SQL join statement

148 Views

Hello,

When the same is used in the ecc 5.0 it was working good but when this code is executed in ecc 6.0 then it is throwing dump.

This is the code :

EXEC SQL PERFORMING MAIN_ITAB_SUB5_APPEND.

SELECT A.WERKS, A.MATNR, B.MAKTX, SUM(A.LBLAB), C.MEINS

INTO :ZIT_WEBIF_SUB5

FROM MSLB A, MAKT B, MARA C

WHERE A.MANDT = :SY-MANDT

AND A.LIFNR = :P_I_LIFNR

AND A.MANDT = B.MANDT

AND A.MATNR = B.MATNR

AND B.SPRAS = sy-langu

AND A.MANDT = C.MANDT

AND A.MATNR = C.MATNR

GROUP BY A.WERKS, A.MATNR, B.MAKTX, C.MEINS

ENDEXEC.

The same native sql is converted into open SQL and it is working fine. Since there is no inconsistancy in the Database. Also when i remove the joins it is working fine.

Dump error :

One of the columns addressed in a table or view does not exist in the database.

table) exists in the ABAP/4 Dictionary, but not in the database.

The error 904 occurred in the current database connection "DEFAULT".

Any suggestions would be apprecaitaed.

Regards,

Kittu