cancel
Showing results for 
Search instead for 
Did you mean: 

How to find the existing hierarchy variable?

Former Member
0 Kudos

Dear SAP gurus,

In this existing query, there is a Cost Element hierarchy variable created. When I run the query (second attempt by refreshing the query selection screen), the Cost Element Node variable field was not available to be changed again. Believe this has to do with the option 'Changeable with query navigation' option in the variable created. I was trying to confirm on this via the variable properties, but I had trouble identifying where it is located, because there are just too many cost element hierarchies available for reporting.

Anyone can help me? Thank you in advance.

Regards,

Adelynn

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Lim,

If it Hierarchy Node Variable hidden while executing Query, then place the Cursor on CostElement Hierarchy Node Variable in Variable Screen and Press F4(Possible Values). You can select any other Values otherthan Default Value.

If you want to see Hierarchy Variable, select Properties on Infoobject where you enabled Hierarchy i.e. Cost Element Infoobject. Under Hierarchy section, you need to press F4. You will get one popup screen there exactly you will provide Hieararchy Node Variable.

Let me know if you have any Questions.

Nagesh Ganisetti.

  • Assign points if it helps.

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Nagesh,

Just tried creating the new variable, the option was not available at all.

Any idea comes to you?

Thanks,

Adelynn

Former Member
0 Kudos

HI Nagesh,

Thanks for your highlight, I found the variable, however, I didnt see any option "Changeable with query navigation" for this hierarchy variable. Any reason for this?

The issue I am facing was, say, when I run the query for the first time with Cost Element Node 1, and i was trying to change my selection to CE node 2, so I refreshed my variable screen but the field to select CE hierarchy Node was no longer there. Normally this happens to variable that has the option "Changeable with query navigation" unchecked.

But in this case, I did not see this option for the hierarchy variable used, how do we justify the scenario in this case?

Please kindly assist, thanks again.

Regards,

Adelynn

Former Member
0 Kudos

I got your point... right now i don't have access to system. that can be possible only with "Can be changed in Query Navagation checkbox".

Can you try create new Hierarchy Node Variable and see whether you are getting that cjheck box to select.

Nagesh.