Showing results for 
Search instead for 
Did you mean: 

Master data and Hierarchy load based on property

Former Member
0 Kudos


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





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.


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


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:

Hope this helps.