Skip to Content
0

CURR_CONVERSION not limiting account scope in default formulas

Feb 20, 2017 at 05:34 PM

42

avatar image

I am trying to run the CURR_CONVERSION process in our DEFAULT.LGF script logic file, but I am unable to limit the scope of the FX conversion to just the accounts that were changed in the Excel input template.

I am calling the CURR_CONVERSION process from an *INCLUDE statement in the DEFAULT.LGF file, but I have also tried copying & pasting the code directly into the DEFAUT.LGF file.

The code for the CURR_CONVERSION call is:

*SELECT(%REPORTING_CURRENCIES%, [ID], RPTCURRENCY, [REPORTING] = 'Y')

*FOR %CAT% = %CATEGORY_SET%

*RUN_PROGRAM CURR_CONVERSION
CATEGORY = %CAT%
TID_RA = %TIME_SET%
CURRENCY = %REPORTING_CURRENCIES%
RATEENTITY = Global
INCREMENTAL_MODE = X
OTHER = [ACCOUNT = %ACCOUNT_SET%;COSTCENTER = %COSTCENTER_SET%;DATASRC = %DATASRC_SET%;M_ENTITY = %M_ENTITY_SET%;M_INTERCO = %M_INTERCO_SET%;PROFITCENTER = %PROFITCENTER_SET%;P_COSTCENTER = %P_COSTCENTER_SET%;P_PROFITCENTER = %P_PROFITCENTER_SET%;]
*ENDRUN_PROGRAM

*COMMIT
*NEXT

Any ideas as to why the logic executes for all accounts even if the user only updates the data related to a few account numbers.

One more question...what is the correct syntax for the INCREMENTAL_MODE call? I can't seem to find much documentation for this parameter.

We are currently running BPC 10.0 NW

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Feb 20, 2017 at 05:40 PM
0

Not all dimensions are supported in OTHER section! Also it depends on PROGRAM.

ACCOUNT is not supported for currency conversion.

You can perform simple tests yourself in UJKT

Share
10 |10000 characters needed characters left characters exceeded
Bill Fahrendorf Feb 20, 2017 at 07:35 PM
0

If I understand you correctly, there is no way to limit the scope of the CURR_CONVERSION program to just the account numbers that were updated. This logic will run for all accounts regardless of the %ACCOUNT_SET% value.

Is there another way to only calculate FX on the accounts that were updated without creating our own custom FX logic calculations?

Is there an official list of dimensions that are not supported in the OTHER section of CURR_CONVERSION?

I have additional script logic that runs after the CURR_CONVERSION, which copies the changed account data to another model so that the models stay in sync. Is there a way to expand the scope of the included account numbers to just those that were affected without including all account numbers using *XDIM_MEMBERSET ACCOUNT = <ALL>

Thanks!

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Feb 20, 2017 at 07:42 PM
0

"Is there another way to only calculate FX on the accounts that were updated without creating our own custom FX logic calculations?"

Only script logic code with WHEN/ENDWHEN and LOOKUP to RATE model!

"Is there an official list of dimensions that are not supported in the OTHER section of CURR_CONVERSION?" - No :) Use ABAP debugging or simply test script to check!

"Is there a way to expand the scope of the included account numbers to just those that were affected without including all account numbers using *XDIM_MEMBERSET ACCOUNT = " - please read my blog: https://blogs.sap.com/2014/06/09/how-to-write-defaultlgf/

Share
10 |10000 characters needed characters left characters exceeded