How to import Master Data Hierarchy with Balance Dependent Nodes from Info Object

[former_member720264]

Hello,

I have a following problem: I want to extract from SAP BW Accounts Hierarchy based on 0GL_ACCOUNT hierarchy.

In hierarchy there are several accounts which are balance dependent i.e. depending on balance side (Debit\Credit) they should be shown in different segment of balance statement (Assets \ Liabilities) - the best example here I think are VAT accounts.

Now, when I am trying to import hierarchy from ECC I get several errors like:

Detected duplicate member ID 'CHAC4461021234'

Detected duplicate member ID 'CHAC4464567890'

What is the best way to deal with it?

Thanks for answers!

ak

[former_member186338]

Use 2 accounts for each: 1 in Assets and 1 in Liabilities.

Vadim

[former_member720264]

Hi Vadim,

I understand that but what is best practice in maitaining this process to avoid manual updates each time:

1. Reloading hierarchy data: I should modify hierarchy structure on BW side or is it possible implement sth on BPC side (in conversion file???)

2. Reloading transactional data: on BW side I will have original acount e.g. CHAC1234567890 and on BPC I will have

CHAC1234567890A and

CHAC1234567890L

In my model I have ENTITY (and maybe SEGMENT).

I guess I will have to calculate each time which account should be used depending on balance and for each combination.

Where is the best place to do it: BW or BPC?

Regards,

Ak

[former_member186338]

Use 2 and after loading data to one member you can use simple script to check sign and move value to another account if necessary.

Vadim