Integration SAP FIM and SAP BPC(ACCTYPE LEQ INC reverse sign)

[Former Member]

Hello everybody,

I've managed to integrate SAP FIM(Financial Information Management) with SAP BPC,

but when I try to  load a file from FIM to BPC all the amounts with ACCTYPE = LEQ or INC have their sign going the opposite way(e.g. file with 300 it stored as -300 in DB).

I used to Import the file via Import job in BPC and the sign didn't change only when we displayed it on a report the sign changed back again(But that's normal for us).

Example with FIM integration

FILE     BPC_DB     REPORT

-300        300             -300

Example with import via BPC

FILE    BPC_DB     REPORT

-300        -300             300

I was wondering if SAP FIM could have kind of transformation file where I could use CREDIT NEGATIVE = YES option or something like that.

Thank you in advance for your advice.

Kr,

Tuan

[former_member186498]

Hi Tuan,

you can change the sign during import putting CREDITPOSITIVE=NO in the OPTIONS of the transformation file.

Regards

     Roberto

[Former Member]

Hi Roberto,

This works if I do it directly with Import job via EPM Excel add-in.

But I want to use SAP FIM to load my file directly into BPC then I don't see anywhere how to integrate the transformation file in the SAP FIM tool.

Thanks for your answer.

Kr,

Tuan