Object documentation Replacement Path: Replacement with Query Locate the document in its SAP Library structure

Definition

A step in the variable wizard that appears for characteristic value variables with the processing type Replacement Path.

Use

Characteristic value variables with the processing type Replacement Path, are replaced by the results of a query.

Select the query whose result you want to use as the variable. You can now use the data result of the selected query as a variable in a different query.

Example

You want to insert the result for the query Top 5 products as a variable in the query Sales – Calendar year / month.

  1. Select the characteristic Product and from the context menu, choose New Variable. The Variable Wizard appears.
  2. Enter a variable name and a description.
  3. Choose the processing type Replacement Path.
  4. Choose Next. You reach the Replacement Path dialog step.
  5. Enter the query Top 5 Products.
  6. Choose Next. You reach the Save Variable dialog step.
  7. Choose Exit.

You are now able to insert the variable into the query Sales – Calendar year / month. This allows you to determine how the sales for these five, top-selling products have developed month for month.

Caution

Every time you execute the query Sales – Calendar year / month, the query Top 5 Products is executed beforehand (= pre-query). This can lead to long run times. If you do not need to execute the pre-query (that is, if you do not have to determine the top 5 products every time because these change monthly, for example), we recommend that you use a variable that represents a pre-calculated value set.

For more information, see Details and Structure linkDefining the Value Set Setting.