EBS Reference
BOM & Costing
Supply chainBills of material, routings, and the item cost records manufacturing and margin analytics draw from
12 tables
Tables
Master · 9
- BOM_COMPONENTS_BSingle-level bill components — one row per component per operation per effectivity window, with usage quantity, yield, supply type, and the supply subinventory shop-floor issues pull fromSchema: BOMmaster
- BOM_DEPARTMENTSThe department (work center) master per inventory organization — the places operations happen, with class, location, and the scrap accountSchema: BOMmaster
- BOM_OPERATION_RESOURCESResources required per routing operation — usage rate, assigned units, and the basis and charge types that drive costing, capacity, and schedulingSchema: BOMmaster
- BOM_OPERATION_SEQUENCESRouting operations — one row per operation per routing per effectivity window, department-assigned, with the count-point and backflush controls that decide where work is recordedSchema: BOMmaster
- BOM_OPERATIONAL_ROUTINGSThe routing header — one routing per assembly item, organization, and alternate designator, with the common-routing pointer and the completion subinventory finished assemblies land inSchema: BOMmaster
- BOM_RESOURCESThe resource master — machines, labor, and outside processing, plus overhead and material sub-elements sharing the table (the cost element discriminates), each with its UOM, charge behavior, and absorption accountSchema: BOMmaster
- BOM_STRUCTURES_BThe bill-of-material header — one bill per assembly item, organization, and alternate designator (manufacturing or engineering), with the common-bill pointer that lets organizations share one structureSchema: BOMmaster
- CST_ITEM_COST_DETAILSThe cost-element breakdown under each item cost — one row per element, level, and department/operation/resource contribution; where a rolled-up cost's ingredients liveSchema: BOMmaster
- CST_ITEM_COSTSThe item cost header — one row per item, organization, and cost type, carrying the total unit cost and its five cost-element buckets plus this-level/previous-level splitsSchema: BOMmaster
View · 2
- BOM_BILL_OF_MATERIALSThe compatibility view legacy queries know BOM headers by — a window onto the structures table under the familiar 11i nameSchema: BOMview
- BOM_INVENTORY_COMPONENTSThe compatibility view legacy queries know BOM components by — a filtered window onto the components table that hides PLM-object and unimplemented-change rowsSchema: BOMview