Skip to Content
Author's profile photo Former Member

Passing Common Pattern in variable selection

Use/Purpose:

Passing “*” as input
in the variable screen to fetch data by defining a pattern

Proposed Solution:

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.

Procedure:

  1. Variable Creation:

The following properties are selected for the variable
creation.

Type of variable: Characteristic Value

Processing By: Manual Input/Default Value

Reference Characteristic: Refer to the Info Object
required.

S1.png

Under the Details Tab the following selections are
chosen:

Variable Represents: Selection Option

Variable Is: Optional/Mandatory (Based on the
requirement)

Select the option Variable is Ready for Input.

S2.png

2. Execute the query in RSRT/ Query Analyzer:

S3.png

In our case the variable name is IFR-
Purchasing Group. And in the backend we have data such as CHN-G4P, BI3-G4P, and
0SR-F6P, Etc.,

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.

S4.png

BeX Query Output:

S5.png

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      It is really a rare scenario.. But good to know the solution..Thanks for sharing Priya..

      Author's profile photo Matthew Jones
      Matthew Jones

      Thanks Priya for your information 🙂