select syntax

[Former Member]

select zterm vtext 
from tvzbt into table itab8 
for all entries in itab4 
where zterm = vbkd-zterm and vbkd-vbeln = itab4-vbeln and spras = sy-langu.

Error is Field "VBKD-VBELN" unknown.

[ferry_lianto]

Hi,

Please try this.

select tvzbt~zterm tvzbt~vtext 
from tvzbt inner join vbkd on tvzbt~zterm = vbkd~zterm
into table itab8 
for all entries in itab4 
where vbkd~vbeln = itab4-vbeln 
and tvzbt~spras = sy-langu.

Regards,

Ferry Lianto

[amit_khare]

where zterm = vbkd-zterm and <b>vbkd-vbeln = itab4-vbeln</b> and spras = sy-langu.

You cann not check the VBKD in the select statement where it is not used with FROm or JOIN clause.

Regards,

Amit

[Former Member]

vbeln unknown

[Former Member]

how do i write the join

[Former Member]

Hello,

In the below select u r selecting data from the table TVZBT.

select zterm vtext 
from tvzbt into table itab8 
for all entries in itab4 
where zterm = vbkd-zterm 
   and vbkd-vbeln = itab4-vbeln   "  Check here
   and spras = sy-langu

Instead give like this

"Check Here   and vbeln = itab4-vbeln   "  Check here

Regards,

Vasanth

[Former Member]

megan,

try this

select zterm vtext

from tvzbt into table itab8

for all entries in itab4

where zterm = vbkd-zterm and <b>vbeln = itab4-vbeln</b> and spras = sy-langu.

hope it will work.

Regards....

Arun.

[Former Member]

these statements dont work. it gives me unknown field error

I want to select zterm vtext from tvzbt

vbkd and tvzbt have zterm in common

and vbkd and vbak have vbeln in common

[ferry_lianto]

Hi,

Did you try above my sample code?

Let me know ...

Regards,

Ferry Lianto