Creating an Index Definition 
Use
You use this procedure to create an index definition that is used by the applications on the mobile client.
Procedure
...
1. Log on to the CRM server and start the Mobile Client Index Manager by using the transaction (CMW_MIDX).
The Mobile Client Index Manager screen appears.
2. To select the table on which you want to define the index, enter the name of the table and choose Enter.
The name of the table appears in the tree.
·
To view the list of
tables, choose 
.
· In addition, to select a set of tables on which you want to define indexes, you can use the wild card characters asterisk (*) and percentage (%). For example, to select tables names that start with SMOG, enter smog* and choose Enter.
3. Right-click the table in the tree and choose Create Index from the context menu.
The Attributes and Index Overview tabs appear.
4. Under Index Header, specify the following details:
|
Field name |
Description |
Req./Opt./Dep. |
User action and values |
Comment |
|
Index ID |
Indicates a unique ID assigned to the index |
Req. |
Enter an ID for the index definition. |
The index ID must not exceed three characters. The index ID is a combination of the table name and three character ID you specify. |
|
Index Name |
Indicates the name of the index definition |
Req. |
Enter a name for the index definition. |
|
|
Description |
Specifies the description for the index definition |
Opt. |
Enter a description for the index definition. |
|
|
Status |
Displays the status of the index definition |
Dep. |
This field is read-only.
The status of an index definition can be: · New · Inactive · Active |
When you are creating an index definition, the status of the index definition is New. When you save the index definition, the status changes to Inactive. Subsequently, when you activate the index definition, the status changes to Active. |
|
Version |
Indicates the version of the index definition |
Dep. |
This field is read-only. |
When you create an index definition, a number is assigned to it. Subsequently, when you modify the index definition, this number is incremented to represent the new version. |
|
Disable Index |
Specifies whether the index definition is disabled |
Opt. |
Select the option. |
|
5. Under Index Options, specify the following details:
|
Field name |
Description |
Req./Opt./Dep. |
User action and values |
Comment |
|
Clustered Index |
Specifies whether the index is a clustered index |
Opt. |
Select the option. |
|
|
Fill Factor |
Specifies the fill factor for the index definition |
Opt. |
Select the option and enter the fill factor. |
|
6.
Under Index Field Details, select the field(s) on which you want to
define the index and choose 
.
·
To remove a field on which
you do not want to define the index, select 
.
·
To change the order of
index fields, choose 
or 
.
7. Save the index definition.
The Prompt for transportable Workbench request dialog box appears.
8. In the Request field, enter the transport request and choose Enter.
To create a transport request, choose Create request.
Result
You have created an index definition. You can now add a comment to the index definition (if required). For more information, see Adding a Comment to an Index Definition.
See also: