Hierarchy
SAP_ABA (Software Component) Cross-Application Component⤷
AP-MD-PRO (Application Component) Central Part of Product Master⤷
COM_PRODUCT_CUST (Package) Product Master Customizing - General
IMG Activity
| ID | COM_PRODUCT_INDEXTAB | Activate Index Table for Search |
| Transaction Code | S_PLC_83000180 | (empty) |
| Created on | 20030626 | |
| Customizing Attributes | COM_PRODUCT_INDEXTAB | Activate Index Table for Search |
| Customizing Activity | COM_PRODUCT_INDEXTAB | Activate Index Table for Search |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | COM_PRODUCT_INDEXTAB |
Use
In this activity, you can activate or deactivate the index table used in the search functionality for products. Depending on your specific situation and data, the use of the index table may enable you to optimize your search procedure for products and therefore improve performance. You may otherwise experience problems when searching for products, as products and individual objects are both stored in the same tables for technical reasons. However, you will need to test the extent to which this is effective.
It is particularly beneficial to use the index table in the following situations:
- You have very few products and a very large number of individual objects.
- Products and individual objects are assigned to the same categories or have similar descriptions.
- You often use the category and description as search criteria and also make generic entries such as AB* or *CD*.
The activation indicator should be set or removed using the reports described below, as these make the necessary database changes and set or remove the indicator, as appropriate. Setting the indicator manually will not perform the necessary actions on the index table.
The following reports are available for setting or removing the activation indicator as required:
- COM_PRODUCT_IDX_CREATE - sets up the index table and sets the activation indicator in the Customizing table
- COM_PRODUCT_IDX_DELETE - deletes the entries in the index table and removes the activation indicator in the Customizing table
- COM_PRODUCT_IDX_SET_FLAG - sets the activation indicator in the Customizing table, no database changes, therefore suitable for test purposes
- COM_PRODUCT_IDX_RESET_FLAG - removes the activation indicator in the Customizing table, no database changes, therefore suitable for test purposes
The index table is optional and can therefore be used for a while and deactivated when required. You are advised to carry out the following steps:
- Analyze the search performance.
- Set up the index table by executing the report COM_PRODUCT_IDX_CREATE. This automatically sets the activation indicator in this Customizing table. The time required for 20,000 products is about 10 minutes.
- Analyze the search performance using the index table.
- If you no longer wish to use the index table, you can delete the entries from the index table using the report COM_PRODUCT_IDX_DELETE and therefore remove the activation indicator in the Customizing table.
Note that the index table does not cover the following cases:
- Searching for products by distribution chain
- Searching for individual objects
Requirements
Standard settings
Activities
Example
The technical criteria for searching for products are ID, description, and assigned categories. This data has been linked together for products and saved in a separate file (COMM_PRODUCT_IDX).
For example, product P1 has descriptions in three languages, T1, T2, and T3. It is assigned to categories K1 and K2. There are therefore six records in the index table:
P1, K1, T1
P1, K1, T2
P1, K1, T3
P1, K2, T1
P1, K2, T2
P1, K2, T3
See also
Refer to notes about performance in the product master area in SAP OSS.
Business Attributes
| ASAP Roadmap ID | 201 | Make global settings |
| Mandatory / Optional | 2 | Optional activity |
| Critical / Non-Critical | 2 | Non-critical |
| Country-Dependency | A | Valid for all countries |
Assigned Application Components
| Documentation Object Class | Documentation Object Name | Current line number | Application Component | Application Component Name |
|---|---|---|---|---|
| SIMG | COM_PRODUCT_INDEXTAB | 0 | A4C0000261 | Central Part of Product Master |
Maintenance Objects
| Maintenance object type | C | Customizing Object |
| Assigned objects | ||||||
|---|---|---|---|---|---|---|
| Customizing Object | Object Type | Transaction Code | Sub-object | Do not Summarize | Skip Subset Dialog Box | Description for multiple selections |
| COMV_PRODUCT_IDX | V - View | SM30 |
History
| Last changed by/on | SAP | 20030626 |
| SAP Release Created in | 400 |
