topic Re: Unknown colunmn name - Abap code error in Application Development and Automation Discussions

Unknown colunmn name - Abap code error

bhat_vaidya2 — Wed, 27 May 2009 08:08:07 GMT

I have this error in my code.

Unknown column name "SUM(EKBE-MENGE)" field list. field list. field

My code

*Select sum(ekbe-menge)

into MCSTRUCT-ZQuant

from ekbe*

How do I resolve this.

thanks

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 08:09:04 GMT

try like this

*Select sum(menge)

into MCSTRUCT-ZQuant

from ekbe*

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 08:10:32 GMT

Hi,

Do not use the table name with in the braces, only use the field name

Thanks

Sudheer

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 08:11:16 GMT

use just columnname. maybe you even need a space before and after it.

Edited by: Florian Kemmer on May 27, 2009 10:11 AM

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 08:12:46 GMT

Hi Bhat Vaidya,

DATA : v_menge TYPE ekbe-menge.

SELECT SUM( menge )
INTO v_menge
FROM ekbe.

Regards,

Suneel G

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 08:13:20 GMT

hi,


Select sum(menge) into MCSTRUCT-ZQuant from ekbe .
endselect.

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 08:14:10 GMT

are you sure an aggregate function will work with an select endselect?

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 08:23:18 GMT

i m sorry.


data : begin of it_data occures 0,
          ebeln like ekbe-ebeln,
          ebelp like ekbe-ebelp,
          menge like ekbe-menge,
          end of it_data .

Select ebeln ebelp sum(menge) into it_data from ekbe  Group by ebeln, ebelp .

Re: Unknown colunmn name - Abap code error

bhat_vaidya2 — Wed, 27 May 2009 10:03:55 GMT

Hi experts

Thanks all for your help

I used this code with space and apersand and it resolve the issue.

SELECT SUM( ekbe~menge )

Much appreciated.

thanks

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 10:07:06 GMT


Select sum*(* ekbe-menge *)*
into MCSTRUCT-ZQuant
from ekbe

maintain the single space between the field and the brackets. that should do.

Re: Unknown colunmn name - Abap code error

Former Member — Wed, 27 May 2009 10:13:08 GMT

Hi,

If you use tilde you will hit performance issue.

DATA : v_menge TYPE ekbe-menge.

SELECT SUM( ekbe~menge )
INTO v_menge
FROM ekbe.

Regards,

Suneel G