Dump with select stmt

[Former Member]

Hi All,

Do you see anything wrong with this select stmt, it is giving me short dump.

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 TABLE IT_OUTPUT

WHERE LIKP~LFDAT IN S_LFDAT

AND LIKP~KUNNR IN S_KUNNR

AND LIKP~LIFSK = P_LIFSK.

Thanks

Veni.

[RichHeilman]

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

[Former Member]

<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.

[Former Member]

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.

[Former Member]

Hi

DATA: BEGIN OF it_output OCCURS 0,

One error is here:

<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,

<b>check type c,</b>

END OF it_output.

SELECT LIKP_{VBELN LIKP}LFDAT LIKP_{KUNNR LIKP}KNKLI VBAK~NETWR

FROM LIKP

• Another error is here

<b>*INNER JOIN VBAK ON LIKP_{VBELN = VBAK}VBELN</b>

INNER JOIN LIPS ON LIKP_{VBELN = LIPS}VBELN

INNER JOIN VBAK ON LIPS_{VGBEL = VBAK}VBELN

INTO TABLE IT_OUTPUT

WHERE LIKP~LFDAT IN S_LFDAT

AND LIKP~KUNNR IN S_KUNNR

AND LIKP~LIFSK = P_LIFSK.

The link between sales order and delivery is in the item data, field is LIPS-VGBEL

Max

[Former Member]

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.