Passing Common Pattern in variable selection
Passing “*” as input
in the variable screen to fetch data by defining a pattern
This article would help in defining a pattern to the Purchasing Group Variable where
we have the data in the backend as CHN-G4P, BI3-G4P, and 0SR-F6P, Etc., Hence
we would define the following pattern in the variable screen as “CHN*”, which
would fetch the data pertaining to the above pattern.
- Variable Creation:
The following properties are selected for the variable
Type of variable: Characteristic Value
Processing By: Manual Input/Default Value
Reference Characteristic: Refer to the Info Object
Under the Details Tab the following selections are
Variable Represents: Selection Option
Variable Is: Optional/Mandatory (Based on the
Select the option Variable is Ready for Input.
2. Execute the query in RSRT/ Query Analyzer:
In our case the variable name is IFR-
Purchasing Group. And in the backend we have data such as CHN-G4P, BI3-G4P, and
Hence we would select the operator as *
and define the following pattern in the variable screen as “CHN*”, which would
fetch the data pertaining to the above pattern.
BeX Query Output:
It is really a rare scenario.. But good to know the solution..Thanks for sharing Priya..
Thanks Priya for your information 🙂