You can locate item information using criteria that you define for each branch/plant. After you locate the item information, you can also access quantity information about the item. You can define specific criteria for an item search. Use this type of search when you know what the item is but you want to limit the search. For example, you can limit the search for an item to a specific branch/plant and supplier.
Before you complete the tasks in this recipe, you must:
- Run the Item Word Search Build batch application (R41829) to create or update the Item Word Search table (F41829)
- Verify that the Item Cross-Reference types for cross-reference numbers are set up in UDC 41/DT
- Verify that any external item numbers, such as supplier or substitute numbers are set up in the Item Cross-Reference program (P4104)
- Verify that you have set up any internal item numbers, such as the second or third item numbers, on the Item Master Revisions form
- Set up processing options for Item Word Search Build (R41829)
- For X-Ref Type, enter a code from UDC 41/DT that identifies the type of cross-reference setup for this customer. The Cross-Reference types include substitutes, replacements, and customer or supplier item numbers.
- On the Work with Item Cross Reference (P4104), click on Add, and enter the cross reference type.
- Enter the Second Item Number for defining the cross reference.
- Enter the Address Number of the customer or supplier.
- Enter the Cross-reference Item Number that the system assigns to an item number. A cross-reference number enables you to use a supplier's item number if it is different from the own item number when you are processing an order or printing.
- Enter a Cross Reference Description remark about an item.
- Enter the OEM-assigned Card Number value from UDC 40R/CD that further describes the part number.
When you search for an item using item word search, the system accesses the Item Word Search table (F41829) for item information. You must run the Item Word Search Build (R41829) batch application to create and update the F41829 table. You can run the program for the entire item master or for a specific branch/plant. When you change any of the descriptive (text) information, the system does not update the Item Word Search table. The program extracts information from the following tables: F4101, F4102, F4100, F4108, F4101D, and F4104.
You can run the Item Word Search Build batch application as often as necessary. For example, you might run the batch application monthly, depending on the number of changes to descriptions. You can set the processing option to clear and completely rebuild the Item Word Search table, if appropriate. If you do not clear the table, use data selection to specify the items to update. When you run the report by branch/plant, the processing time is significantly reduced.
In order to run the item word search build program you should access batch application (R41829) to build the item word search. To run the batch application you should follow the following steps.
- From the fast path, enter BV (Batch Version).
- The batch application will open; enter the Item Word Search batch application (R41829).
- Click Select and then click Submit.