Exit Function

[Former Member]

HI Experts

I have a multi planning area

We have to read the data from one planning area and perform the calculation and post it in other planning area.

As the formula is complex one we decided to use the function type Exit. Can you give me the refernce Exits which I can use as template.

Thanks

Lakshminarayana

[Former Member]

Are you sure you can not use FOX formula? I have written very complex FOX, the largest one number some 10 pages and the performance was decent since I modeled for it and also was very careful how I structured the FOX.

[Former Member]

HI

I´m using Fox formula .. and I need string Concatination and I have used in the following way

DATA ACC TYPE 0GL_ACCOUNT.

DATA ACC TYPE 0GL_ACCOUNT.

DATA T1 TYPE STRING .

DATA T2 TYPE STRING .

DATA T3 TYPE STRING .

T1='C'.

T3 ='D'.

T2 = SUBSTR(ACC,1,9).

ACC = T2 + T1.

ACC1 = T2 + T3.

Basically based on the amount value I want to suffix Credit or Debit and write in to nother Planning area.

I´m executing the planning function with Trace and it is retruning me the error

'The generated data is not contained in the selection condition'

When I´m putting the Breakpoint in the Fox it is showing there is no values in ACC and ACC1 but at the end in the error message details I can see

G/L Account 100100

G/L Account 100100C

G/L Account 100100D

Can any one what that error message suggest?

Thanks

Lakshminarayana

[Former Member]

Hi,

To concatenate two strings, you cannot use the '+' operator. You should use the 'concat' statement in Fox.

CONCAT(<string1>, <string2>)

<string2> is appended to <string1> und the result is returned. <string1> remains unchanged

The error message 'The generated data is not contained in the selection condition' implies that the data generated by the function has at least one value for some characteristic outside the selection restrictions of the filter using which the function was executed.

[Former Member]

Thanks Mayank for Quick response...

I´m using BW (3.5) BPS system not BI -IP

When I´m using CONACT it give the following message

Formula error: Formula element CONCAT could not

recognized

Thanks

Nerusu

[Former Member]

Hi Nerusu,

You cannot use functions like CONCAT / REPLACE in FOX if you are working in BPS.

Regards,

Deepti

[Former Member]

HI Deepti..

Thanks for the resposnse.

Can we call FM in FOX editor in BW BPS? ?

Thanks

Nerusu

[Former Member]

Hi,

There is a call function statement available in FOX, but that will only work in BPS if the system is a BI 7.0 system. If it is, then Concat will also work.