Skip to Content
0
Former Member
Apr 03, 2012 at 12:15 PM

How to bring in Text of Master data in WAD/IP Report?

26 Views

Hi Experts,

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?