E1: 30: P3002/F3002 Setup and Use of BOM (Bill of Material) (Doc ID 626105.1)

Last updated on NOVEMBER 07, 2024

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version XE and later
JD Edwards EnterpriseOne Product Data Management - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

Enter/Change Bill of Material or BOM, is one of the first steps within the setup process to support the Product Data Management and Shop Floor Control Modules. This is where component item and parent relationships are made, and stored prior to costing, running MRP or creating work orders. Dates for all components should be "in effect" today or earlier.

BOMs are normally used with a production routing (P3003) to manufacture assemblies or sub-assemblies. The Stocking Type (STKT) from the Item Branch/Plant record (P41026) will use the first character of Description 2 in UDC 41/I, to determine if the item is purchased (P) or manufactured (M). Bills of Material (BOMs) may be added to purchased items with stocking type 'P', but as information only. Manufacturing applications will use only 'M' type BOMs to perform Cost Simulations (R30812) or Frozen Updates (R30835), as does MRP (R3482/R3483) when planning demand. A common reason for this type of setup would be when the item is commonly purchased outside complete, but in emergencies can be produced internally.

The Simulated Rollup (R30812) only uses M Type Bills of Material and Routings. Alternate BOMs and Routings with the Type fields (TBM) or (TRT) populated with anything other than "M" will not be used in a cost rollup/cost simulation.

Tables used:

F3002 - Bill of Material Master Table

The unique keys to table F3002 :

Alias      Field Name
KIT        Parent (short) Item Number
MMCU    Branch
TBM           Typ BOM
BQTY         Units-Batch Quantity
CPNB         Component Line Number BOM
SBNT         Substitution Item Sequence Number
COBY        Co By (Component By Product)

The Effective From and Effective Thru Serial Numbers fields exist only in the BOM file (F3002). These two fields, Effective From (FSER) and Effective Thru Serial Numbers (TSER), are not currently used in JD Edwards applications. They are not driven by any other applications, but as they are not marked "Reserved for Future Use," Oracle suggests refraining from using them as they may be removed in future releases.

F3011 - Bill of Material Change Table

This table records the modified or changed data associated with the BOM of items. It can be used to retrieve the changes done to a BOM, starting with the current values in F3002 and working backward through the changes and dates using the records in F3011. It is managed via the Branch Plant Manufacturing Constants (P3009) under the check box option - Log Bill of Material.

In XE, the table displays the entire BOM list with the changes made since its inception until the present date.
In 8.12, it displays only the lines associated with the changes or modifications made on the BOM since its inception until the present date.

Use this quick reference document for all the field locations and uses for each. This documentation is a supplement to our Product Data Management Implementation Guides, Document 1109563.1, and includes commonly asked questions.