Prepared for: Management & Team Review
Subject: Explanation of SAP Business One BOM Import Structure & Revision Data Sources
In SAP Business One (Beas Manufacturing), uploading a fan's Bill of Materials (BOM) requires two distinct Excel workbooks, each containing two sheets:
BOM Details.xlsx) defines the assembly structure: what components go into which assembly, how much each weighs, and scrap percentages.Item Revision Details.xlsx) defines the item governance: registering each part with quality control rules and linking it to the active engineering drawing revision.SAP operates on a strict sequence rule:
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."If someone tries to upload File 1 without File 2, SAP rejects the upload with an error: "Item revision not found".
Management asked: "Where do the revision entries in both sheets come from?"
Here is the exact origin of each field:
ItemDetails (35 Columns)This sheet is the "ID Card" for every single part in the fan.
CF-HG-HG1, CF-IM-IM1, etc.)Import_Key_1: Sequential row counter (1, 2, 3...).Code: 00091163).'MISSING CODE' (this is SAP's built-in instruction to generate a new item master record automatically).U_ItemCode: The exact part code from the drawing title block / BOM table.U_SapDfBS & U_PFDfBS = 'Released' (Authorizes the shop floor to process the item).U_SapDfQCS & U_PFDfQCS = 'Passed' (Pre-clears quality inspection).U_BatchQueue = 'FIFO' (First-In, First-Out inventory tracking).U_ShelfTime = '1d'U_Yield = 100 (100% production yield).Revisions (33 Columns)This sheet is the "Approval Stamp" authorizing the factory to make each part to a specific drawing revision.
S02627-0020259-07) originates directly from the Customer Order & Drawing Title Block:S02627 = Customer Sales Order number.0020259 = Customer Work Order / Job number.07 = Drawing Revision / Line Item number.Import_Key_1: Row number (1, 2, 3...) matching Sheet 1 row-for-row.U_Code & U_Description: The Revision Code (S02627-0020259-07).U_ParentItemCode: The part code (e.g. CF-HG-HG1).U_Status = Active (Marks this drawing version as currently valid).U_Default = Yes (Tells SAP to pick this revision by default).U_IsCostingDefault = Yes (Tells SAP cost accounting to use this version).U_IsMrpDefault = Yes (Tells SAP material procurement to order raw steel based on this version).U_ValidFrom / U_ValidTo = 0001-01-01T00:00:00Z (SAP standard date format representing perpetual validity).U_ComponentWH = B (Standard component staging warehouse).| 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-...). |