Application Development and Automation 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: 
Read only

SUM in Select Stmnt: Syntax Error

Former Member
0 Likes
524

Keeps saying field (LABST)not there. It is. and I can select alone but cannot do sum...why? Thanks.

select sum(LABST) from MARD into (tlabst)

where MATNR = tlocations-MATERIAL

and WERKS = tlocations-PLANT

and LFGJA = year

and LABST > 0.

endselect.

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
491

Add spaces:

select sum( LABST ) from MARD into (tlabst)

Rob

1 REPLY 1
Read only

Former Member
0 Likes
492

Add spaces:

select sum( LABST ) from MARD into (tlabst)

Rob