topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Tue, 24 Apr 2007 10:09:48 GMT

HI,

While executing the select statement is showing syntax error,

anybody let me know the correct synatx.

SELECT exidv vpobjkey

FROM vekp

INTO TABLE lt_hu

FOR ALL ENTRIES IN lt_vbeln

WHERE vpobjkey+0(10) = lt_vbeln-vbeln.

thanks in advance.

Re: select statement

Former Member — Tue, 24 Apr 2007 10:13:08 GMT

what sytax error u are getting ?

u cannt use Offset lengths in where clause.

Regards

Prabhu

Re: select statement

Former Member — Tue, 24 Apr 2007 10:13:32 GMT

WHERE vpobjkey+0(10) = lt_vbeln-vbeln.

there´s the error.

you cannot check against a whole table.

you probably intended to code

WHERE vpobjkey+0(10) = wa_vbeln-vbeln.

where wa_vbeln-vbeln is a workarea of your table lt_vbeln-vbeln.

Re: select statement

Former Member — Tue, 24 Apr 2007 10:13:48 GMT

SELECT exidv vpobjkey

FROM vekp

INTO TABLE lt_hu

FOR ALL ENTRIES IN lt_vbeln

WHERE <b>vpobjkey+0(10)</b> = lt_vbeln-vbeln.

U cant use <b>vpobjkey+0(10)</b> in where condition u have to use the cpmlete field name

Re: select statement

Former Member — Tue, 24 Apr 2007 10:14:19 GMT

Which is the error...?

Re: select statement

Former Member — Tue, 24 Apr 2007 10:16:25 GMT

Hi,

You should not use offset when using for all entries in where condition.

join VEKP and VEPO tables and use this VBELN in where condition.

if not lt_vbeln[] is initial.

SELECT a_{exidv b}vbeln

FROM vekp as a join vepo as b

on a_{exidv = b}exidv

INTO TABLE lt_hu

FOR ALL ENTRIES IN lt_vbeln

WHERE b~vbeln = lt_vbeln-vbeln.

endif.

reward points if useful

regards,

Anji