Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Display caracteristics only if hierarchy expanded

Hi,

I looking for help to produce a report using a hierarchy and didn't found any thread or documentation about what I'm trying to do...

In row I have 3 caracteristics: Car1, Car2, Car3.

In colums: my key figures.

I want to display Car1 with a hierarchy.

Here is an example of the result I wish:

<b>__________________________________________________Amount

Car1_______________Car2_______________Car3</b>

Node 1

_Node 2

___Car1Val_________Car2 Val____________Car3Val_______1000$

But here is the result I have:

<b>__________________________________________________Amount

Car1_______________Car2_______________Car3</b>

Node 1_____________Car2 Val____________Car3Val

Node 2___________Car2 Val____________Car3Val

___Car1Val_________Car2 Val____________Car3Val_____1000$

I would like to know how to design my query so my caracreristics 2 and 3 show values only Car1 hierarchy is fully expanded.

Here is an example with my real data:

ZCS_ITEM = our corporate chart of accounts presented under a coporate group of accounts (hierarchy)

0CS_ITEM = our internal chart of accounts.

Exepcted result

<b>__________________________________________________Amount

ZCS_ITEM___________0CS_ITEM________0FUNC_AREA</b>

ASSET

CURRRENTASSET

___100001__________11100___________6000____________1000$

Actual result:

<b>__________________________________________________Amount

ZCS_ITEM___________0CS_ITEM________0FUNC_AREA</b>

ASSET________________11100___________6000

CURRRENTASSET____11100___________6000

___100001_____________11100___________6000___________1000$

Any ideas?

Thanks in advance!

Former Member
Not what you were looking for? View more on this topic or Ask a question