Run time error in ALV

[Former Member]

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

[Former Member]

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.

[former_member480923]

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.

[Former Member]

Hai Anirban

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

[former_member1245113]

Please specify the run time you are getting

regards

Ramchander Rao.K