Adding columns to a lookup in Maximo

Technote (FAQ)

Question

How can I display additional columns in a lookup.

Answer

All the lookups in Maximo exist in the LOOKUPS.XML file and are referneced by a table id value. When a field has a lookup associated to it, the properties for that field will show the lookup's table id value in the Lookup property. Once you have the name of the lookup, the LOOKUPS.XML file can be searched for that table id value. To modify this file, you will need to export the LOOKUPS.XML file. In App Designer, from the Select Action menu, select Export System XML option. Select the blue icon next to LOOKUPS.XML The XML file will display. Save the file to your desktop anmd keep a copy as a backup. Open the LOOKUPS.XML file to be modified using Word Pad or another test editor. Search for the table id for your lookup. Typically this will be the name of the object the lookup takes it's values from. For example you want to add a serialnum column to the Asset lookup. You would find the following sectionin the LOOKUPS.XML <table id="asset" inputmode="readonly" selectmode="single" >