Hi
We have a requirement in a report to limit the list of Vendors that is displayed to the user to only Merch Vendors. This is an attribute of Vendor.
I have implemented the RSR_VARIABLE_F4_RESTRICT_BADI in BW, which correctly limits the list of Vendors when the BEx Query is run via RSRT or in a web template. If run in this fashion, when the user clicks on the F4 Help, then only Merch Vendors are displayed.
However, when that query is now used in a WebI document, the list of values displayed in the WebI prompt area does not take this filtered list into account.
I can update the object in the Universe and adjust the WHERE clause to limit the list to Merch Vendors, but I need the BEx variable populated, as there is a secondary variable on article, which restricts the list of articles to only articles associated with that vendor. This secondary processing is done in a post-popup customer exit variable, and I am not sure if the value selected in a WebI prompt will be available in the customer exit code. Also, a WebI prompt does not nicely display key & text, so we're opting for BEx variables in this case.
Any ideas on how to ensure the limited List of Values is applied in Universe / WebI ?
Cheers,
Andrew