fixed point arithmetic error in include file

[former_member625844]

I create an enhancement in exit EXIT_SAPMM06E_012. In the inlude file ZXM06U43. I wrote SQL like below.

SELECT 
   ekbe~gjahr,
   ekbe~belnr,ekbe~buzei,
   CASE 
      WHEN ekbe~bwart = '102' OR ekbe~bwart = '122'
           THEN ekbe~menge * -1
      WHEN ekbe~bwart = '101' OR ekbe~bwart = '123' 
           THEN ekbe~menge END  AS mtotal
from ekbe into table @DATA(gt_ekbe) WHERE ekbe~ebeln = i_ekko-ebeln.

And it has error " This Open SQL statement uses additions that can only be used when the fixed point arithmetic flag is activated ". But it's a include file and I can't find fixed point arithmetic flag in property. So do I have to query original data into itab then process it or some bypass exist? Thx for any help.

[FredericGirod]

Did you try to create a Class/Interface and put your code in this class/interface ?

[raymond_giuseppi]

ZXM06U43 is an include of the main exit function group XM06, did you check this FG main program SAPLXM06 attributes, else move your code to a customer main object: interface, class, function group, subroutines pool, etc.

NB: Did you consider using EKBE-SHKZG to identify the movement sign (rather than a list of movement codes)

[former_member625844]

I used FM instead. I also checked SAPLXM06 and its fixed point arithmetic flag is checked. I don't know why this error happened.

[raymond_giuseppi]

You could have activated the main program or the exit FM when the include was created to insure the include is correctly linked to FG.

[GaneshVunnam]

when I get this type of error message, I have updated my code to work in the presentation layer instead database layer. Issue solved.