Dump with select stmt

Hi veni,

As your first field in the internal table is

check type c,

you are getting that short dump as it is trying to assign vbeln to check.

Try to remove that field and try or declare it after declaring all the fields in that internal table.

Hope this will help you.

Vinod.

You problem is the CHECK field in the internal table. You need to specific the INTO CORRESPONDING . If CHECK was not in the internal table, there would be no problem.

DATA: BEGIN OF it_output OCCURS 0,
<b>check TYPE c,</b>
vbeln LIKE likp-vbeln,
lfdat LIKE likp-lfdat,
kunnr LIKE likp-kunnr,
knkli LIKE likp-knkli,
netwr LIKE vbak-netwr,
END OF it_output.

SELECT LIKP~VBELN LIKP~LFDAT LIKP~KUNNR LIKP~KNKLI VBAK~NETWR
FROM LIKP
INNER JOIN VBAK ON LIKP~VBELN = VBAK~VBELN
INTO <b>CORRESPONDING FIELDS OF</b> TABLE IT_OUTPUT
WHERE LIKP~LFDAT IN S_LFDAT
AND LIKP~KUNNR IN S_KUNNR
AND LIKP~LIFSK = P_LIFSK.

Regards

Rich Heilman

<b>SELECT a_{VBELN a}LFDAT a_{KUNNR a}KNKLI b~NETWR

FROM LIKP as a

INNER JOIN VBAK as b ON a_{VBELN = b}VBELN

INTO TABLE IT_OUTPUT

WHERE a~LFDAT IN S_LFDAT

AND a~KUNNR IN S_KUNNR

AND a~LIFSK = P_LIFSK.</b>

Try like this.

Regards,

Prakash.

Hi Veni,

Try this

DATA: BEGIN OF it_output OCCURS 0,
check TYPE c,
vbeln LIKE likp-vbeln,
lfdat LIKE likp-lfdat,
kunnr LIKE likp-kunnr,
knkli LIKE likp-knkli,
netwr LIKE vbak-netwr,
END OF it_output.

SELECT LIKP~VBELN LIKP~LFDAT LIKP~KUNNR LIKP~KNKLI VBAK~NETWR
FROM LIKP
INNER JOIN VBAK ON LIKP~VBELN = VBAK~VBELN
INTO <b>corresponding fields of</b> TABLE IT_OUTPUT
WHERE LIKP~LFDAT IN S_LFDAT
AND LIKP~KUNNR IN S_KUNNR
AND LIKP~LIFSK = P_LIFSK.