Understanding the SAP BOM & Item Revision Files

Prepared for: Management & Team Review
Subject: Explanation of SAP Business One BOM Import Structure & Revision Data Sources


1. Overview: What Are These Files?

In SAP Business One (Beas Manufacturing), uploading a fan's Bill of Materials (BOM) requires two distinct Excel workbooks, each containing two sheets:

[Diagram]

2. Why Does SAP Require Two Files?

SAP operates on a strict sequence rule:

  1. You cannot assemble parts that do not exist yet in the system.
    When a new fan is engineered, many components are brand-new custom parts (e.g., custom laser-cut casing plates or specific impeller blades). SAP does not have barcode or inventory records for them yet.
  2. SAP needs to know which drawing revision is authorized.
    A part like CF-HG-HG1 might have been drawn 3 times over 2 years (Rev 0, Rev 1, Rev 2). SAP refuses to let the factory cut steel until an official document states: "For this project, Revision S02627-0020259-07 is Active and Approved."
  3. The Workflow:
    • File 2 is uploaded first: It registers all the parts and gives them an active revision stamp.
    • File 1 is uploaded second: It builds the BOM tree linking those registered parts together.

If someone tries to upload File 1 without File 2, SAP rejects the upload with an error: "Item revision not found".


3. How Do the Revision Entries Come About?

Management asked: "Where do the revision entries in both sheets come from?"

Here is the exact origin of each field:

[Diagram]

Sheet 1: ItemDetails (35 Columns)

This sheet is the "ID Card" for every single part in the fan.


Sheet 2: Revisions (33 Columns)

This sheet is the "Approval Stamp" authorizing the factory to make each part to a specific drawing revision.


4. Summary Table of All 4 Sheets

Workbook Sheet Name Plain-English Purpose Data Source
FILE 1: BOM Details BillOfMaterial Top-level fan and 18 subassembly headers. Fan configuration and customer order specifications.
Items Detailed list of 217 individual child parts, weights, quantities, line numbers, and scrap percentages. Part callouts and dimension tables extracted from drawing sheets.
FILE 2: Item Revision Details ItemDetails Inventory ID card and quality rules for each unique part. Master list of all unique part codes from drawings + SAP Master Data.
Revisions Drawing revision authorization linking each part to the customer order. Sales order & drawing title block revision number (S02627-...).