topic fixed point arithmetic error in include file in Application Development and Automation Discussions

fixed point arithmetic error in include file

former_member625844 — Mon, 23 Nov 2020 05:44:57 GMT

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.

Re: fixed point arithmetic error in include file

FredericGirod — Mon, 23 Nov 2020 06:49:59 GMT

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

Re: fixed point arithmetic error in include file

RaymondGiuseppi — Mon, 23 Nov 2020 13:30:00 GMT

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)

Re: fixed point arithmetic error in include file

former_member625844 — Tue, 24 Nov 2020 02:26:55 GMT

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

Re: fixed point arithmetic error in include file

RaymondGiuseppi — Tue, 24 Nov 2020 07:23:35 GMT

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.

Re: fixed point arithmetic error in include file

GaneshVunnam — Mon, 12 Feb 2024 06:50:41 GMT

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