topic Re: select syntax in Application Development and Automation Discussions

select syntax

Former Member — Tue, 20 Mar 2007 19:55:34 GMT

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.

Re: select syntax

ferry_lianto — Tue, 20 Mar 2007 19:57:09 GMT

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

Re: select syntax

amit_khare — Tue, 20 Mar 2007 19:57:56 GMT

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

Re: select syntax

Former Member — Tue, 20 Mar 2007 19:58:30 GMT

vbeln unknown

Re: select syntax

Former Member — Tue, 20 Mar 2007 19:59:07 GMT

how do i write the join

Re: select syntax

Former Member — Tue, 20 Mar 2007 19:59:08 GMT

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

Re: select syntax

Former Member — Tue, 20 Mar 2007 19:59:09 GMT

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.

Re: select syntax

Former Member — Tue, 20 Mar 2007 20:07:42 GMT

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

Re: select syntax

ferry_lianto — Tue, 20 Mar 2007 20:09:53 GMT

Hi,

Did you try above my sample code?

Let me know ...

Regards,

Ferry Lianto