Skip to Content
author's profile photo Former Member
Former Member

Financial Statement hierarchy not extracted correctly from ECC into BW.

Recently, one of my clients modified a FS hierarchy in production environment by moving some nodes from revenue to expenses, but BW is not picking up the change.

In ECC via transaction FSE3, one of our Financial Statement hierarchies shows three nodes - (Group Life_, Vehicle Plan only_, and Cost of Removal_) as Expenses. However, the BW extractor still shows these three nodes as Revenue and loads the hierarchy into BW that way as well.

DataSource is 0GL_ACCOUNT_T011_HIER with field HIENM = AE03. When running RSA3 Extractor Checker in ECC, the displayed data still shows the three nodes in question as Revenue and not correctly as Expenses.

Found SAP note 1061847 - Ind. For reversing plus/minus signs not extracted correctly. Applied note in ECC development environment, tested the extractor, and checked the load into BW, but the error regarding the nodes still exists after applying the fix.

Appreciate any suggestions or thoughts from the community.


SAP landscape is as follows:

SAP_BW 700 0009 SAPKW70009 SAP NetWeaver BI 7.0

SAP_AP 700 0007 SAPKNA7007 SAP Application Platform

SAP_BASIS 700 SAPKB70010 SAP Basis Component

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2007 at 11:56 PM

    May be the note 1037447 could help you, since you are on BI 7.0 (NetWeaver 2004s)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks SDNBI. I reviewed the suggested OSS note 1037447, but I am not sure how it applies in my situation. The suggested note seems to address a problem with the display of transfer structure in BW. Our problem seems to be that the extractor on ECC is incorrectly extracting the hierarchy structure. When viewing the data in RSA3 extract checker in ECC, I see the three nodes in question incorrectly positioned in the hierarchy. Thus loaded the same incorrect way into BW. Yet, when I display the hierarchy through transaction FSE2, the three nodes are displayed correctly.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.