cancel
Showing results for 
Search instead for 
Did you mean: 

Incomes and Expenses

Former Member
0 Kudos

Hello Everybody,

I need some help with a conversion file in BPC.

I have to update the type of the accounts I have in BPC, and i'm doing that task with a conversion file, in which I indicate that accounts starting with 1 and 2 are acctype = INC, and beginning with 3 are Acctype = EXP.

First, in the Transformation file I introduce the Account ID in the Acctype field, and later, in the conversion file I have written, for the Acctype:

External                Internal

1*                          INC

2*                          INC

3*                          EXP

But the package doesn't recognize this mapping and gives me an error like "value for the component 30001000.B is not valid: ACCTYPE = 30001000.B" for all my accounts.

Any idea of what's happening?

Thank you very much in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Check with the SAP BPC help file, but the only conversion you will be able to perform during a data load from external sources is to the ID in the source (external) file.  The transformation file is limite dto the instructions at the top of the file and then on the conversion files you plan to apply against the values (tuples or strings of data) that are loaded into the system.

The ACCTYPE property is defined in the dimension once, and doesn't need to be modified with each external source load.  The type also impacts the manner is which the data is loaded in the FACT tables. REV is loaded as a negative, EXP is loaded as a positive value.

Hope this helps.

Answers (2)

Answers (2)

former_member186498
Active Contributor
0 Kudos

Hi Antonio,

the Acctype is a property of the Accounts in BPC and you needn't to import from outside, if you setted properly the account master data then you shouldn't do anything else for this property.

Kind regards

     Roberto

Former Member
0 Kudos

Hi,

Try this, no conversion file is reequired for ACCTYPE.

In the transformation file maintain the following:

ACCTYPE=*IF(ACCOUNT_ID(1:1)=3  then *STR(EXP);ACCOUNT_ID(1:1)=1  then *STR(INC);ACCOUNT_ID(1:1)=2  then *STR(INC);*STR(INC))

Hope this helps.

Regards,

Kalyan.