Master data and Hierarchy load based on property

[Former Member]

Hi,

My GL account FSV looks like this in ECC:

Node 1

a/c 100

a/c 200

Node 2

a/c 100

a/c 200

Node 1 accounts are all debits (so debit flag is checked for them).

Node 2 accounts are all credits (so credit flag is checked for them).

The same comes in BW.

When I am pulling it in BPC, it is saying that a/c 100 and a/c 200 has different parents.

I want to create two new accounts for each i.e. 4 in total

credit_100

credit_200

debit_100

debit_200

Need some help in writing the conversion logic for these.

Basically, we have to look at the property (debit/credit) and then assign a/c100 either to credit_100 or debit_100.

same for a/c 200.

Please advise at earliest.

Thanks.

[Former Member]

Hi,

You can use the mapping section of the transformation file for this purpose. It should be something like:

*COL(5) + *Str(_) + *COL(1)

I am considering that the 5th column of your file is the property. The 1st column is the ID.

Please take a look at the below link for more information:

http://help.sap.com/saphelp_bpc75_nw/helpdata/en/5d/9a3fba600e4de29e2d165644d67bd1/content.htm

Hope this helps.