Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Run time error in ALV

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 VBRKVBELN VBRKKNUMV VBRKFKDAT VBRKWAERK

VBRKKURRF VBRKKUNAG VBRK~FKART

VBRPPOSNR VBRPNETWR VBRPFKIMG VBRPMATNR

VBRPVGBEL VBRPWERKS VBRPARKTX VBRPLGORT VBRPMATKL MARAMATKL AS CMATKL

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM VBRK

INNER JOIN VBRP

ON VBRKVBELN = VBRPVBELN

INNER JOIN MARA

ON VBRPMATNR = MARAMATNR

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

Tags:
Not what you were looking for? View more on this topic or Ask a question