syntax error while creating a invoice

[Former Member]

Hi I am new to this forum hope u guys can help me out,

I am ruuning following syntax for creating an invoice and for this error message is coming which is given below.

Select a_{adrnr a}stdc1 b~name1 into table inv_head1

From kna1 as a inner join adrc as b on a_{adrnr = b}addrnumber.

Unknown column name "A~STDC1" . field list. . field list. field list.

[andreas_mann3]

it must be a~stcd1

A.

[andreas_mann3]

.

[Former Member]

Hi,

I think you have wrongly typed the field name.

Currect field name is STCD1, but you have mentioned STDC1.

Please check and correct it.

Regards,

Ashok

[Former Member]

Hi Rupesh,

u have to mention as " select ... into corresponding fields of

table ... ".

regards

Chaitanya.