Skip to Content
0
Former Member
Apr 07, 2009 at 11:06 AM

Selecting Wildcard ' *** ' as a value in Bex and Active Table for DSO

31 Views

Good day

I have search SDN, but could not find a similar request/enquiry.

I am extracting master data for vehicle category and vehicle sub-category via DB Connect from an Oracle db. From a source in Germany, the vehicle subcat is filled with ' *** ' due to business reasons. This ' *** ' carries a value and BW should be able to display all the ' *** ' for a certain vehicle category in BEx and in the master data or active data in DSO when transaction data is loaded. The master data is loaded with the ' *** ', no problem there, but when you want to display only the subcategories = ' *** ' , then all the data for all the subcategories registered under the specific category will display:

Master Data

Vehicle Cat : Vehicle Subcat : Description

Z : *** : Freigtliner

Z : CAT : Caterpillar

Z : DD : Detroit Diesel

Thus Z and *** will display the data for Z ***, Z CAT and Z DD.

Is there a way I can change this and only display data for ***?

Your expert assistance will be appreciated.

Cj