topic Re: Select statements in Application Development and Automation Discussions

Select statements

Former Member — Tue, 06 May 2008 17:16:39 GMT

Hi,

I hve problem in this statement, only vttk values get populated and not the likp or ttds...

SELECT k_{tknum t}bukrs k_{route k}dtabf k_{add04 k}text2 k_{text3 k}text1 l_{vbeln l}inco1 l~ntgew

l~btgew

INTO TABLE gt_vttk

FROM vttk AS k INNER JOIN vttp AS

p ON k_{tknum = p}tknum

INNER JOIN ttds as

t on t_{tplst = k}tknum

INNER JOIN likp AS

l ON p_{vbeln = l}vbeln

WHERE k~tknum in s_tknum.

SORT gt_vttk BY tknum.

can someone check this and tell me whats wrong...

Stal.

Re: Select statements

Former Member — Tue, 06 May 2008 17:28:22 GMT

Hello,

I suggest you to use FOR ALL ENTRIES, first because the performance and second that it made you debug and see the problem.

Regards,

Re: Select statements

Former Member — Tue, 06 May 2008 17:31:27 GMT

Hi,

Your second inner join (below one) is not correct. here you are doing the join comparing shipment document (TKNUM) with Transportation planning point (TPLST). Please correct it.

t on t_{tplst = k}tknum

Re: Select statements

Former Member — Tue, 06 May 2008 22:54:59 GMT

Hi,

Check your select query and correct it like this

t on t_{tplst = k}tknum this is wrong.

correct like this.

t on t_{tplst = k}tplst .

Regards,

Kinjal