Skip to Content
0
Former Member
Aug 03, 2006 at 02:16 PM

Short Dump while fetching values from a Database view

69 Views

Hi ALL,

Here is the code that is giving short dump

SELECT * FROM ZVMATLMOVE INTO TABLE I_MATLMOVE

WHERE BUDAT >= V_LASTRUN_DATE

AND WERKS IN S_WERKS

AND LIFNR IN S_LIFNR

AND EBELN IN S_EBELN

AND MATNR IN S_MATNR

AND BWART IN S_BWART

(Please don't say that I am using * in the select query,

I knew that it is not a good way of fetching values)

Declaration of the internal table is:

DATA I_MATLMOVE LIKE ZVMATLMOVE OCCURS 0 WITH HEADER LINE.

The variable V_LASTRUN_DATE is:

DATA V_LASTRUN_DATE LIKE SY-DATUM.

We will be getting the lastrundate value from another table. And it is passing correct value (ex. 20060731)

ZVMATLMOVE is a database view created for MKPF and MSEG table. And I checked both table were consistent.

Dump Analysis:

Runtime errors DBIF_RSQL_SQL_ERROR

Exception CX_SY_OPEN_SQL_DB

Every thing is fine. But I don't know how it is going to dump. Any suggestions?