Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Issue in the script logic for writing a value

Hi,

We are integrated the TCURR table from ECC to BPC to load the exchange rates. As  as a part of the same, since we have no rates in ECC for group currency and as the same has to be maintained as 1 in BPC we are trying to write a default logic for bringing the USD rates as 1.00000 for the account type AVG. Dont know if we have any other work around.

But the below issue appreas while running the DMP.

Model Dimensions:

CATEGORY

TIME

R_ENTITY

R_ACCOUNT

INPUTCURRENCY

Logic is as below:

*XDIM_MEMBERSET CATEGORY= Actual

*XDIM_MEMBERSET TIME = %TIME_SET%

*XDIM_MEMBERSET R_ENTITY = Global

*XDIM_MEMBERSET INPUTCURRENCY = USD

*WHEN R_ACCOUNT=AVG

*REC(EXPRESSION =1.00000)

*ENDWHEN

The DMP runs successful with no records updated in the data base.

Kindly Suggest.


Regards,

Shilpa

Former Member
replied

Ups, definitely an error:

*WHEN R_ACCOUNT=AVG - incorrect!

Correct:

*WHEN R_ACCOUNT

*IS AVG

Vadim

Or:

*XDIM_MEMBERSET R_ACCOUNT=AVG

*WHEN R_ACCOUNT

*IS * // * - scoped - AVG

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question