Skip to Content
avatar image
Former Member

CURR_CONVERSION not limiting account scope in default formulas

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 20, 2017 at 05:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2017 at 07:35 PM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2017 at 07:42 PM

    "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/

    Add comment
    10|10000 characters needed characters exceeded