Skip to Content
0
Jul 30, 2016 at 06:19 PM

How to subtract one quantity field from another quantity field in amdp

2617 Views

Hello,

I am facing a difficulties while performing subtraction operation within an AMDP method. My query is as follows.

gt_mseg= Select matnr, sum (a.menge - b.menge) as menge

from :gt_mseg_101 as a

left outer join gt_mseg_102 as b

on a.matnr = b.manr

group by a.matnr;

But this query always returning menge as zero. I have used data type menge_d to declare menge in mseg. I am at my wits end to understand that what's wrong with this query. Kindly help me out. Thanks in anticipation