PS/PM/CS: Creating an Index for Table AFRU (Biblioteca SAP

PS/PM/CS: Creating an Index for Table AFRU

Use

Depending on the volume of confirmations you want to enter for Plant Maintenance (PM) or Project System (PS) using the Time Sheet, you may want to create an index for the document number (CATSBELNR) in table AFRU. This improves system performance when the data is transferred to the target components.

Nota

Note, if you choose to create an index, that confirmations from the Production Planning and Control (PP) component are also saved in table AFRU.

If there are considerably more PP confirmations than confirmations from PM, PS, and CS, it may be that your database system does not use the index.

Procedure

The index in table AFRU is not active in the standard system. To activate it, proceed as follows:

Choose Tools ® ABAP Workbench ® Development ® ABAP Dictionary.
Enter the object name AFRU and select the Database table field.

Choose

Este gráfico es explicado en el texto respectivo

Change.

The Dictionary: Maintain Table screen appears.

Choose Goto ® Indexes.

The Indexes for Table AFRU dialog box appears.

Select the Index with CATS doc. number option.

The Dictionary: Maintain Index screen appears.

Select the Index on all database systems field.

Choose

Activate.

Result

You have created an index for table AFRU.