topic syntax error! in Application Development and Automation Discussions

syntax error!

Former Member — Fri, 11 Apr 2008 06:26:36 GMT

hi,

i got the synatx error for the following code!

select

vbak~vbeln

vbak~submi

vbak~bstdk

vbak~bstnk

vbap~vgpos

from vbak inner join vbap on vbak_{vbeln = vbap}vbeln

into table lt_vbak

for all entries in lt_lips

where vbeln = lt_lips-vgbel

and vgpos = lt_lips-vgpos.

and i had declared internal table lt_vbak with the five fields as i had mentioned!

whats wrong with this code?

Raj

matt — Fri, 11 Apr 2008 06:32:05 GMT

What did the syntax error message say?

matt

Former Member — Fri, 11 Apr 2008 06:34:02 GMT

When u use inner joins u need to specify the table in the where condition if the field exists in the both the tables. So put like this:

select

vbak~vbeln

vbak~submi

vbak~bstdk

vbak~bstnk

vbap~vgpos

from vbak inner join vbap on vbak_{vbeln = vbap}vbeln

into table lt_vbak

for all entries in lt_lips

where vbak~vbeln = lt_lips-vgbel

and vbap~vgpos = lt_lips-vgpos.

Thanks,

Anon

Former Member — Fri, 11 Apr 2008 06:42:21 GMT

when you use inner join betweeen 2 tables, then in the where condition you need to specify from which table you want to retrieve the fields..