Skip to Content
author's profile photo Former Member
Former Member

Execution of Fox Formula's

Hi,

I have a general question about Fox Formula's. We created a planning function based on a Fox Formula which should distribute values from region not-assigned to other regions. I debugged the Fox Formula and am quite surprised to see that the Fox logic is processed/called twice.

Why is the Fox logic called twice ? Can anyone explain this ?

For your info, in our case the first time the internal tables contain all assigned values for region, the second time the internal tables contain just the not-assigned region. This is horrible if you need to define calculated fields in Fox that make calculations based on the assigned and not-assigned data. I managed to solve this via putting the variables in the ABAP memory (via a self created ABAP function) but this is really a solution I am not too happy about.

Any ideas about this behaviour of Fox ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 01:07 AM

    Put the Region in the fields to be changed.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 08:24 AM

    hi

    fox works as follows:

    for example i hv given some restriction in field for conditions:

    with that i got selected some 4 records (assume)

    now u hv fox code (single line) as follows

    here i am copying 2006 data and revaluating 10%

    ={2006)*1.10

    Now this code is applied for all the four records as 4 different threads. There is no loop here but this code is applied for all the four records which are selected.

    Summary: For each selected record the code will be applied.

    srin

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Subha,

      I am sure there are plently of options but what I usually do is the following :

      1) I place an endless loop in the Fox Code : e.g.

      DO.

      IF FLAG = 'X'.

      EXIT.

      ENDIF.

      ENDDO.

      2) I launch the Fox Function in my IP application which will then hang due to the endless loop.

      3) Via transaction SM50 I search for my process which is hanging and I take it in debugging mode via Process > Mode > Debugging in the menu

      4) You will then arrive in debugging mode in your Fox formula and you'll see that ABAP is generated based on your FOX.

      5) Then you jump outside the endless loop in debugging, in this example you put value X in field flag and start debugging as usual via single step or others (F5, F6, F7,...)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.