Skip to Content
author's profile photo
Former Member

Balance sheet report - cube 0FIGL_C10 (NW04s)

I am creating a balance sheet report using 0GL_ACCOUNT as a hierarchy. The infoprovider is 0FIGL_C10.

The 0GL_ACCOUNT hierarchy has nodes:

-> Stockholder's equity

.....

--> Profit/loss current year

--> Calculated profit

--> Calculated loss

The nodes Calculated profit & Calculated loss have no leaves, so these hierarchy nodes don't show in query. However they show on ECC report.

What is the link?

I ran a delivered quey for virtual cube 0FIGL_V11 which uses 0GLACCEXT (financial statement item) and these nodes still don't show.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 20, 2007 at 04:00 PM

    the dynamic display of the hierarchy only takes those nodes into consideration that have data against them during query execution. So the report would pou up only with those nodes that has data against it and not the ones which doesnt have any.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 04:26 PM

    Voodi,

    Description of problem

    - The <b>P&L statement node</b> amount is supposed to roll up to the <b>Profit/Loss current Year</b> node in the balance sheet

    - If amount is a profit, amount goes to <b>calculated profit node</b>

    - If amount is a loss, amount goes to <b>calculated loss node</b>

    - When I run a balance sheet report the <b>Profit/Loss current Year node</b> does not show at all. I assume because no data for leaves.

    - When the customer runs a FS report in ECC, they see the <b>Profit/Loss current Year node</b>

    - Also, the chart of accounts used is WACA, but the leaf for<b>calculated profit </b> is <b>0COA0BRESULT 2A</b> and the leaf for <b>calculated loss</b> is <b>0COA0BRESULT 1A</b>.

    - Where does this config take place in ECC for the FS hierarchy? I went into ECC and looked at FS item versions and don't see an item under calculated profit or loss.

    - The customer expects these leaves to appear in query result. I am trying to determine if some config is required in ECC for FS item or do I need to perform calculation in query

    - Not FI savvy

    Add comment
    10|10000 characters needed characters exceeded