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_EKETMENGE-X_EKETDABMG) as MENGE " PROBLEM!!
X_EKET~EINDT as EINDT
from EKKO as X_EKKO
inner join EKPO as X_EKPO on X_EKPOEBELN = X_EKKOEBELN
inner join EKET as X_EKET on X_EKETEBELN = X_EKPOEBELN AND X_EKETEBELP = X_EKPOEBELP
into corresponding fields of table i_zopenpo_schedule
where
(i_where_clause).
//Martin