Understanding the Populate F4311 Commodity/UNSPSC Program

If you create the commodity structure after you have already entered requisitions and purchase orders into the system, run the Populate F4311 Commodity/UNSPSC program (R43910) to attach commodities and UNSPSC codes to existing transactions. Based on data selection that you specify, the system reviews existing records in the F4311 table and attempts to find a commodity and UNSPSC code to assign to the lines. For stock lines, the system uses the item number to find a commodity relationship using the F40540 table. If the system does not find a commodity, the system assigns the Unknown commodity. For account-based lines (services), the system uses the account number to search for a commodity relationship using the F40551 table. After the system finds a commodity for a line, it searches for a UNSPSC relationship for the commodity, by using the F40510 table.

Note: This program overwrites any existing values in the Commodity and UNSPSC Code fields, including blank and Unknown. Therefore, you should be certain that the data selection that you enter does not include requisition lines for which you do not want the values updated.

If you decide that the commodity structure provides too much or too little detail on spend information, you can change the commodity structure and run the Populate F4311 Commodity/UNSPSC program to update existing transactions with the new commodities and UNSPSC codes.