select statement

[Former Member]

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.

[Former Member]

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

[Former Member]

what sytax error u are getting ?

u cannt use Offset lengths in where clause.

Regards

Prabhu

[Former Member]

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.

[Former Member]

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

[Former Member]

Which is the error...?

[Former Member]

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