GL ACCOUNT hierarchy load

[Former Member]

Hi BI Guru's,

Could someone help me to understand a strange issue on my customer BW.

I mantained a GL_ACCOUNT hierarchy for my P&L on SAP R/3 ECC 6 throw t-code ob58.

As a test I created a simple structure with only 10 account under Profit node.

Save and load into BW.

Now, a strange issue appear.

The accounts under Profit Node are showing correctly but I have the same 10 accounts under "Unassigned nodes"!Only the 10 accounts are showing twice!

If I load into BW the standard P&L hier (complete of all the nodes) ALL THE ACCOUNTS are duplicated into "Unassigned nodes"!

I have to make a precisation: I don't need to see GL ACCOUNT Hier into a bex query, I've to load it into BPC 7.5 with dedicated package.

Someone can help me to solve the issue?

Thanks and sorry for my english!

Andrea

Edited by: Andrea Davoli on Sep 23, 2011 6:22 PM

[Former Member]

Hi,

If the hierarchy is matching in R/3 and BW system and hierarchy nodes are similar to R/3 (means in R/3 also if the nodes are appearing in the Unassigned Nodes) then you will need to rectify it first in the R/3 and then load it to BW.

However if you want to manipulate them in BW system you need to go to RSH1 and give the hierarchy name. And then delete the Unassigned nodes from the hierarchy manually and activate the hierarchy again.

Navesh

[Former Member]

Thanks to all for your replies.

I try to clarify: the structure under R/3 and under BW are the same.

So the nodes and the account under standards nodes are the same. But under unassigned nodes into BW I've all the account that are under the other nodes but in R/3 the unassigned node is empty (I suppose that node is populated by system at runtime when abap report is run).

BW

+ Asset

++ 1000001 - Asset

+ Unassigned nodes

++ 1000001 - Asset

R/3

+ Asset

++ 1000001 - Asset

+ Unassigned nodes

It's possible to have some customization under R/3 customizing?

[Former Member]

Hi,

When you set up this "Financial Statement Version" a GL Account can be in two places based on whether it has Debit (D) or Credit (C) balance. There are tick boxes for this D and C.

In most cases both boxes should be ticked, only exceptional accounts are in different places based on balance.

Could it be that the hierarchy in ERP has only ticked one of the two (D or C)?

Then it is normal to shown in two places in BW. And then the "Balance Dependency" (last column in the BW hierarchy) should have "1" or "2" for those. At least that is how it is in my 7.3 system.

Regards, Reynir

[former_member188080]

Hi,

First check your G/L account hierarchy in BW and R/3 if it is not matching.

Delete hierarchy in BW and try to reload again through G/L hierarchy datasource.See if it comes up correctly or not?

Thanks and regards

Kiran

[Former Member]

hi,

You can check if the hierarchy in BW is the same in FSE3 in R/3 system as well or not. If it is same then maintain the hierarchy properly in source and then load to BW.

regards,

Arvind.