syntax error!

[Former Member]

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]

What did the syntax error message say?

matt

[Former Member]

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]

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..