topic Re: Run time error in ALV in Application Development and Automation Discussions

Run time error in ALV

Former Member — Fri, 17 Oct 2008 05:09:23 GMT

Hi to all

my problem is that when i executed the ALV report for excise details by giving only the invoice date and plant, it gives a runtime error and the error is in the select statement.

SELECT VBRK_{VBELN VBRK}KNUMV VBRK_{FKDAT VBRK}WAERK

VBRK_{KURRF VBRK}KUNAG VBRK~FKART

VBRP_{POSNR VBRP}NETWR VBRP_{FKIMG VBRP}MATNR

VBRP_{VGBEL VBRP}WERKS VBRP_{ARKTX VBRP}LGORT VBRP_{MATKL MARA}MATKL AS CMATKL

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM VBRK

INNER JOIN VBRP

ON VBRK_{VBELN = VBRP}VBELN

INNER JOIN MARA

ON VBRP_{MATNR = MARA}MATNR

WHERE VBRK~VBELN IN VBELN

AND VBRK~FKART IN FKART

AND VBRK~FKDAT IN FKDAT

AND MARA~MATKL IN MATKL

AND VBRP~WERKS IN WERKS

AND VBRP~LGORT IN LGORT

AND VBRK~FKSTO NE 'X' .

i like to know how to rectify it and run the report

thanks in advance

Re: Run time error in ALV

Former Member — Fri, 17 Oct 2008 05:12:45 GMT

Hi Mahesh,

The syntax of your select statement seems to be wrong. Please check. It shud be something like this :

SELECT  p~carrid p~connid f~fldate b~bookid
  INTO  CORRESPONDING FIELDS OF TABLE itab
  FROM  ( ( spfli AS p
            INNER JOIN sflight AS f ON p~carrid = f~carrid AND
                                       p~connid = f~connid    )
            INNER JOIN sbook   AS b ON b~carrid = f~carrid AND
                                       b~connid = f~connid AND
                                       b~fldate = f~fldate     )
  WHERE p~cityfrom = 'FRANKFURT' AND
        p~cityto   = 'NEW YORK'  AND
        f~seatsmax > f~seatsocc.

Regards,

Swapna.

Re: Run time error in ALV

former_member480923 — Fri, 17 Oct 2008 06:01:03 GMT

Hi,

There is no problem in the select statements, if there was u could have caught it in the syntax check it wouldn't have dumped. The dump might happen because of the Incorrect definition of the Internal table: The way the fields have been defined, their names (u are using matkl as cmatkl for e.g.). Other than this there should not be any difference which might cause the problem.

Hope That Helps

Anirban M.

Re: Run time error in ALV

Former Member — Tue, 25 Nov 2008 05:09:11 GMT

Hai Anirban

even if i dont use matkl,im getting t same dump error.

Re: Run time error in ALV

Former Member — Tue, 25 Nov 2008 05:14:29 GMT

Please specify the run time you are getting

regards

Ramchander Rao.K