topic SUM in Select Stmnt: Syntax Error in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sum-in-select-stmnt-syntax-error/m-p/3050944#M722309 <HTML><HEAD></HEAD><BODY><P>Keeps saying field (LABST)not there. It is. and I can select alone but cannot do sum...why? Thanks. </P><P></P><P>select sum(LABST) from MARD into (tlabst)</P><P></P><P>where MATNR = tlocations-MATERIAL</P><P></P><P>and WERKS = tlocations-PLANT</P><P></P><P>and LFGJA = year</P><P></P><P>and LABST &gt; 0.</P><P></P><P>endselect.</P></BODY></HTML> Tue, 04 Dec 2007 19:13:38 GMT Former Member 2007-12-04T19:13:38Z SUM in Select Stmnt: Syntax Error https://community.sap.com/t5/application-development-and-automation-discussions/sum-in-select-stmnt-syntax-error/m-p/3050944#M722309 <HTML><HEAD></HEAD><BODY><P>Keeps saying field (LABST)not there. It is. and I can select alone but cannot do sum...why? Thanks. </P><P></P><P>select sum(LABST) from MARD into (tlabst)</P><P></P><P>where MATNR = tlocations-MATERIAL</P><P></P><P>and WERKS = tlocations-PLANT</P><P></P><P>and LFGJA = year</P><P></P><P>and LABST &gt; 0.</P><P></P><P>endselect.</P></BODY></HTML> Tue, 04 Dec 2007 19:13:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sum-in-select-stmnt-syntax-error/m-p/3050944#M722309 Former Member 2007-12-04T19:13:38Z Re: SUM in Select Stmnt: Syntax Error https://community.sap.com/t5/application-development-and-automation-discussions/sum-in-select-stmnt-syntax-error/m-p/3050945#M722310 <HTML><HEAD></HEAD><BODY><P>Add spaces:</P><P></P><PRE><CODE>select sum( LABST ) from MARD into (tlabst) </CODE></PRE><P></P><P>Rob</P></BODY></HTML> Tue, 04 Dec 2007 19:17:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sum-in-select-stmnt-syntax-error/m-p/3050945#M722310 Former Member 2007-12-04T19:17:30Z