47 Update Item Search Information

This chapter contains this topic:

Run the Rebuild Item Search program to update the Item Search table. When you run a query search by item in Inventory Management, the system accesses the Item Search table (F41200) for item information. When you change item information through item master, item branch/plant, or item cross-reference information, those changes do not update the Item Search table.

47.1 Updating Item Search Information

From Inventory Management (G41), enter 27

From Inventory Advanced and Technical Operations (G4131), choose Global Updates and Purges

From Global Updates and Purges (G41311), choose Rebuild Item Search

After you enter or change item master information, you must update the item search information. However, you can access items that have been entered or changed using other search modes. You can run the Rebuild Item Search program as often as necessary.

The Rebuild Item Search program (P41BDWRD) reads the Item Master file (F4101), the Item Alternate Description file (F4101D), and the Item Cross-Reference file (F4104) and writes to the Item Word Search Master file (F00X41). In the F00X41, it creates one record for each unique branch-plant/location/lot-serial-number combination as listed below:

  • Each word in the second item number field, LITM

  • Each word in the description fields DSC1 and DSC2

  • Each word in the catalog number, AITM

  • Each word in the search field, SRTX

  • The short item number, ITM

  • Each word in each alternate description, DSC1 and DSC2 (F11 from Item Master)

  • Each word in each alternate description search text (F11 from Item Master)

  • Each branch plant in which the item is set up.

47.1.1 Files Used

  • F4101 - Item Master

  • F4101D - Item Alternate Description

  • F4101 - Item Cross Reference

  • F00X41 - Item Word Search Master

  • F009141 - Word Search Occurrences Master