hierarchy 0SOLD_TO - 0CUSTOMER
I have a problem which I hope you can help me to solve it.
The situation is as follows:
In the existing query's ZQUERYA filter, 0SOLD_TO is restricted with a hierarchy ZHIERXY.
We have to build a new query (ZQUERYB), which have almost the same characteristics as ZQUERYA but slightly different. Here we also have to restrict 0SOLD_TO with the hierarchy ZHIERXY.
But the strange thing is, in ZQUERYA, ZHIERXY displays as ZHIERXY - 0CUSTOMER. While in ZQUERYB, when we tried to select ZHIERXY, it only display as ZHIERXY. Moreover, ZQUERYB does not display any result as expected.
We are totally sure that the problem lies in the hierarchy restriction, as whenever we did not select ZHIERXY, but rather selecting the single values belong to ZHIERXY then ZQUERYB worked just fine.
We suspect that there might be some setting that enable us to connect ZHIERXY with 0CUSTOMER, so that it will display as ZHIERXY - 0CUSTOMER.
(ZHIERXY is actually built on 0CUSTOMER. 0SOLD_TO is a navigation attribute of 0CUSTOMER, but we have to restrict ZHIERXY on 0SOLD_TO.)
Has anyone have had the same problem before, or know how to solve this?
Any help will be very appreciated.
Thank you very much in advance.