I have an IP report with dropdown selections for Calendar Year,Product & Business Partner.
This IP report is based on WAD which sits over a BEx query.
My requirement is to have Text of Product & Business Partner in the dropdown box and not the Key.
The catch is that my report layout is such that the product & business partner are in hidden mode and cannot be shown in the BEx query.
If I change the setting and make these 2 characteristics as display as 'Text & Key' the dropdown works fine. However, these fields are also shown on the IP report which is not the requirement.
Is there a way in WAD(May be through some HTML backend query) to bring in the text of master data without making it visible in the query?