Defining a WHERE Clause for Segment Field Filtering 

Use

A WHERE clause is a search condition that allows you to filter records from the database. When you query the database to retrieve specific records, you can specify the search condition by using the WHERE clause. The conditions that you specify in a WHERE clause can consist of several elementary comparisons linked with the AND or OR filters.

Procedure

...

       1.      Log on to the CRM server and choose Architecture and Technology ® Middleware ® Development ® Meta Object Modeling ® BDoc Modeler.

The CRM BDoc Modeler screen appears.

       2.      Expand the synchronization or Mobile Application BDoc type in the tree.

A WHERE clause cannot be defined for mBDoc types.

       3.      To view the tables, expand the segment under the required BDoc type.

       4.      Double-click the table to which you want to add the WHERE clause.

The Map Overview and Where Clauses panes appear.

To view the table definition, click on the mapped table name in the Map Overview pane.

       5.      In the Where Clauses pane, Choose .

The Where 1 dialog box appears.

       6.      Enter the WHERE clause.

BDoc Modeler does not validate the text you enter as the WHERE clause.

       7.      Save the BDoc type.

Example

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

Select *

                        From <Customer>

                        Where customer record = 0001.