Sql problem in select clause...

Hi,

I need some help with my sql-statement.

I need to substract MENGE from DABMG.

It gives me an error below...

Any pointers ?

• Get PO data Schedule

select

X_EKKO~EBELN as EBELN

X_EKKO~LIFNR as LIFNR

X_EKKO~BEDAT as BEDAT

X_EKKO~EKGRP as EKGRP

X_EKPO~WERKS as WERKS

X_EKPO~EBELP as EBELP

X_EKPO~MATNR as MATNR

(X_EKET_{MENGE-X_EKET}DABMG) as MENGE " PROBLEM!!

X_EKET~EINDT as EINDT

from EKKO as X_EKKO

inner join EKPO as X_EKPO on X_EKPO_{EBELN = X_EKKO}EBELN

inner join EKET as X_EKET on X_EKET_{EBELN = X_EKPO}EBELN AND X_EKET_{EBELP = X_EKPO}EBELP

into corresponding fields of table i_zopenpo_schedule

where

(i_where_clause).

//Martin