Programme SAP COM_PRODUCT_IDX_CREATE - Creation of the Index Table comm_product_idx

Purpose
An index table can be used to improve the performance of the searchfunctionality for products. This program sets up the tableCOMM_PRODUCT_IDX based on the contents of table COMM_PRODUCT and theproduct descriptions and assigned categories. This is performed for theclient in which you are working.

Prerequisites

  • To execute the program, you should be registered in table
  • COMC_PR_TOOL_REG using transaction SE16.
    • Products and individual objects must not be maintained while the program
    • is running.
      • The central Customizing table COMC_PRODUCT must not be maintained while
      • the program is running (for example, Customizing activityAllow Inactive Products).

        Features
        A runtime of about 10 minutes is required for 20,000 products. It is notpossible to maintain products or individual objects during this period.
        When the program has been executed, an indicator is set in tableCOMC_PRODUCT indicating that the index table is used.
        The program COM_PRODUCT_IDX_DELETE should be used to delete the indextable. Note that the programs COM_PRODUCT_IDX_SET_FLAG andCOM_PRODUCT_IDX_RESET_FLAG can be used for test purposes.