Defining Where Clause 

Use

It may be necessary to view only a selected set of objects in the browser. For example, you may like to see only the objects related to a particular business context. You need to filter on these conditions. The conditions that you specify in the WHERE CLAUSE can consist of several elementary comparisons linked with NOT, AND or OR. For getting one object, or restricting one’s selection, SQL provides the WHERE CLAUSE. WHERE CLAUSE allows the filters for Segment fields to be set.

Procedure

  1. Select the BDoc to whose segment and mappings you want to add the Where Clause.
  2. Select the segment and then collapse the segment to view the mappings.
  3. Right click on the Mapping.

    4. A Context menu appears.

  4. Select the View option.

    5. Segment Table Map Details screen gets displayed.

  5. Choose Where Clause tab.
  6. Define the properties for Where Clause.
  7. Save the settings.

Example

You want to retrieve a customer record that has the customer key 0001.

Select *

From <Customer>

Where customer record = 0001.