Mobile Client Index Manager 

Purpose

This tool allows you to define and maintain indexes for the tables present in the user database of the mobile client. This tool is present on the CRM server. It allows you to efficiently create and maintain index information, as you do not need to manually create and maintain indexes associated with the tables in the user database.

Integration

You need to generate the indexes on the mobile client, as the index definitions exist in the CRM server. In addition, to maintain index definitions, you need to upload the existing indexes to the CRM server.

To:	Use:
Generate indexes on the mobile client	Client Console
Upload existing indexes to the CRM server	Mobile Client Index Migration

Features

·        Create and maintain index definitions

You can define new indexes for the tables in the user database. In addition, you can maintain index information for the indexes that you need to create for the tables in the user database. However, you can maintain indexes only for the tables linked to BDoc types. The index information that you maintain using this tool is not related to the index information specified for the corresponding tables in the CRM server. To maintain indexes, this tool allows you to capture information, such as:

¡        The name of the table

¡        The name of the index

¡        The position of the index field

¡        The comments specified for an index

¡        The name of the clustered index (if exists)

           The above details are stored in the mobile client index repository in the CRM server.

·        Check index definition information

When you create a new index definition or modify an existing one, this tool checks whether:

¡        You have violated the configuration settings, such as the maximum number of indexes per table or the maximum number of fields per index

¡        You have violated the restrictions imposed by Microsoft SQL Server and BDoc layer

¡        Only one unique index exists for a table

You can define only oneunique index for a table and that must be defined on the primary key of the table. This restriction is imposed by the BDoc layer.

·        Enable or disable an index definition

If you do not need an index definition, you can disable it. As a result, you can maintain index definitions because the index definition is not deleted when you disable it.

To generate an index on the mobile client, the index definition must be active and enabled.

·        Maintain index definitions created or modified by the customer

Customers can create new index definitions or modify the index definitions provided by SAP. For example, in a composite index provided by SAP, the customer can delete a field on which the index is defined. In such a case, when you generate indexes on the mobile client, Client Console considers the customer version of the index definition. However, if the customer discards the modifications to the index definition, the SAP version of the index definition is restored. In such a case, when you generate indexes on the mobile client, Client Console considers the SAP version of the index definition.

·        Assign applications and components

You can assign applications and components within the applications to an index definition. This indicates the applications and components that will use the index definition. For example, you can assign the Mobile Sales Application and the Activities component to an index definition. For more information, see Assigning an Application and Component to an Index Definition.

Only SAP can assign applications and components within the application to an index definition.

·        Add and modify comments for an index definition

You can add a comment to a new index definition or modify the comment of an existing index definition. The comments provide information, such as the purpose of creating and modifying an index definition.

Constraints

When you create an index definition by using this tool, the tool considers the restrictions imposed by Microsoft SQL Server and BDoc layer.

See also:

Creating an Index Definition