topic Re: Dump with select stmt in Application Development and Automation Discussions

Dump with select stmt

Former Member — Wed, 25 Oct 2006 17:43:18 GMT

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.

Re: Dump with select stmt

RichHeilman — Wed, 25 Oct 2006 17:45:16 GMT

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

Re: Dump with select stmt

Former Member — Wed, 25 Oct 2006 17:46:10 GMT

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.

Try like this.

Regards,

Prakash.

Re: Dump with select stmt

Former Member — Wed, 25 Oct 2006 17:47:29 GMT

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.

Re: Dump with select stmt

Former Member — Wed, 25 Oct 2006 17:48:27 GMT

DATA: BEGIN OF it_output OCCURS 0,

One error is here:

*check TYPE c,

vbeln LIKE likp-vbeln,

lfdat LIKE likp-lfdat,

kunnr LIKE likp-kunnr,

knkli LIKE likp-knkli,

netwr LIKE vbak-netwr,

check type c,

END OF it_output.

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

FROM LIKP

Another error is here

*INNER JOIN VBAK ON LIKP_{VBELN = VBAK}VBELN

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

Re: Dump with select stmt

Former Member — Wed, 25 Oct 2006 17:50:19 GMT

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.