P&L Report-Account Group Hierarchy -Position of lower nodes above

[Former Member]

I define P&L Statement hierarchy in ERP using T Code: KDH2 (account group). The reason why I don't use standard financial statement version is because it can't include cost object /cost element in the hierarchy.

Then I designed a query using Bex Query designer. In row item "account number", I tagged the accoung group as hierarchy and select "position of Lower-level Nodes": above

However, in crystal report, when I recall the database, it is displayed as "higher nodes above." e.g. cost of sales include lower nodes of Material cost and labor cost, it display in Crystal report as:

Cost of Sales 5000

Material Cost 3000

Labor Cost 2000

I want it to display as "lower nodes above":

Material Cost 3000

Labor Cost 2000

Cost of Sales 5000

I have tried in crystal report desinger- -change group option- sort in original order, in asending, in desending , it doesn't work as "lower node above". (i have to group the account ID)

I don't want to use "sort in specific order" in group option because if it is hard coded, it doesnt faciliate future changes if user changes account group hierarchy in SAP ERP KDH2 (account group).

To sum up, is there anyone can tell me how to show the hierarchy in Crystal Report as "lower node above"?

Regards,

Frances

[former_member11696 · Accepted solution]

Repost to the SAP Integration Kit forum

[Former Member · Accepted solution]

I find the solution by myselr: just put the account code in crystal report group footer rather than the group header, it will show lower nodes above as

Material cost 2000

Labor cost 3000

-

---

Cost of Sales 5000

Edited by: Jixiang Fan on May 14, 2011 12:12 PM