Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

syntax error while creating a invoice

Former Member
0 Kudos

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 aadrnr astdc1 b~name1 into table inv_head1

From kna1 as a inner join adrc as b on aadrnr = baddrnumber.

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Rupesh,

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

table ... ".

regards

Chaitanya.

4 REPLIES 4

andreas_mann3
Active Contributor
0 Kudos

it must be a~stcd1

A.

andreas_mann3
Active Contributor
0 Kudos

.

Former Member
0 Kudos

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
0 Kudos

Hi Rupesh,

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

table ... ".

regards

Chaitanya.