Master data and Hierarchy load based on property

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.