Practical BOM (Bill of Material) construction method for complex aerospace product

Abstract

The invention discloses a practical BOM (Bill of Material) construction method for a complex aerospace product. The method comprises the following steps: step 1, constructing a structure of a practical BOM; step 2, acquisition and processing of practical data; step 3, carrying out data mounting on the practical data and the practical BOM structure; and step 4, generating a practical BOM (Bill of Materials). For the conditions that the MBOM and an actual product structure are possibly inconsistent, the change is frequent and the response speed requirement is high, a scheme of directly constructing a BBOM from the MBOM is canceled, a practical BOM is directly constructed according to the actual situation, task information is issued through matching and associated to the MBOM, meanwhile, aiming at the actual requirement of aerospace product manufacturing, the combination of practical data and the practical BOM is completed, and the implementation efficiency is improved. Any product can quickly generate the actual BOM, and the actual structure tree and all process data of the product can be inquired, so that the quality control traceability is improved, and the conditions of wrong loading, neglected loading and the like are reduced.

Description

Technical Field

[0001] The present invention relates to the field of aerospace manufacturing industry, and in particular to a practical BOM construction method for complex aerospace products. Background Art

[0002] The Bill of Materials (BOM) is a technical document that describes the composition of manufacturing products, indicating the structural relationship between the product's assembly parts, components, assemblies, parts, and raw materials, as well as the required quantity. BOM is the core document of a manufacturing enterprise, which is required for all activities at all levels and is divided into multiple forms according to the purpose of use, such as EBOM (design) composed of assembly relationships and parts lists, PBOM (process) that combines manufacturing processes with product structures, and MBOM (manufacturing) that adds process flow and tooling resources based on PBOM. Through BOM views of different business dimensions, the company's information digital main line is formed. As the last link in manufacturing, digital delivery of aerospace products is the last mile of digital main line construction: first, it supports the subsequent construction of reliable and accurate twin models for the simulation application of aerospace products in digital space; second, it enables aerospace manufacturing companies to provide efficient, accurate, and fast after-sales service guarantees, trace quality issues, conduct data statistical analysis on demand, and predict trends in life and status. Therefore, in the face of the current trend of digital development, a new practical BOM construction method suitable for aerospace product manufacturing is needed to support the future needs of digital main line construction and digital twin model construction.

[0003] Chinese invention patent application CN114881566A discloses a method for tracing information data problems in the installation process based on a depth-first traversal strategy. It proposes to build a BBOM (actual installed material list) based on MBOM, and then establish an association with the fact table of the data warehouse. According to the subdivided business domain of the BBOM view, the data association of the upstream and downstream business processes is opened up, so as to help business personnel discover business data problems in a timely manner, thereby improving data quality, and ultimately promoting the efficient production process of aircraft and improving aircraft production capacity. This patent focuses on the supply chain data of installation. Starting from the dimension of the number of inbound and outbound warehouses in the logistics process, it checks the actual number of installed materials and the theoretical installed material list around the production plan, procurement warehousing, distribution, outbound and borrowing, so as to find wrong data and carry out governance. The core of this patent is the tracing method of data problems. It only mentions the construction of BBOM based on MBOM, but this method is not suitable for the aerospace field where data changes frequently, the technical status is complex, the finished product of materials put into production is uncertain, and the MBOM and the actual finished product structure may be inconsistent. Summary of the invention

[0004] In order to overcome the above shortcomings of the prior art, the present invention proposes a method for constructing an actual BOM for complex aerospace products, introduces a BOM classification suitable for the field of aerospace manufacturing, and constructs a single product's actual material list and actual data for manufacturing results, including planning, process, processing records, supply chain, inspection and testing, quality deviation, supporting information and other data. The technical problem solved by the present invention is that, for the situation where the MBOM may be inconsistent with the actual product structure and changes frequently, and the response speed is required to be high, the solution of directly constructing the BBOM (actual installed material list) from the MBOM is cancelled, and the actual BOM is directly constructed according to the actual situation and associated with the MBOM by matching the task information issued. At the same time, according to the actual requirements of aerospace product manufacturing, the scope of actual data is defined and sorted, and the combination of actual data and actual BOM is completed, so that any product can quickly generate an actual BOM, and its actual structure tree and all process data can be queried, thereby improving the quality control traceability capability, reducing the situation of errors and missing installations, and laying a solid foundation for the subsequent digital delivery model and product digital model construction.

[0005] The technical solution adopted by the present invention to solve the technical problem is: a method for constructing a BOM for complex aerospace products, comprising the following steps:

[0006] Step 1: Implement the BOM structure.

[0007] Step 2: Collection and processing of implementation data;

[0008] Step 3: Load the implementation data and implementation BOM structure;

[0009] Step 4: Create and implement BOM.

[0010] Compared with the prior art, the present invention has the following positive effects:

[0011] 1) The implementation of the BOM construction method of the present invention is beneficial to the analysis of mis-assembly and missing assembly of aerospace products

[0012] Since aerospace products have problems of frequent changes and complex technical status, the present invention cancels the method of directly constructing the implementation BOM from the MBOM. By subsequently comparing the structures of the MBOM and the implementation BOM and classifying and summarizing them according to different systems, the misinstallation and missing of materials can be effectively avoided.

[0013] 2) The implementation of the BOM construction method of the present invention is conducive to improving the quality control traceability capability

[0014] The implemented BOM of the present invention can realize online quality traceability of complex aerospace products with multiple structures, reduce paper-based traceability and query, save manpower cost, and reduce operation and control cost; at the same time, through the full collection of quality data and centralized control of quality data accurate to each component, it can solve a series of problems such as process quality data collection and control in aerospace discrete equipment manufacturing.

[0015] 3) The BOM construction method of the present invention is conducive to rapid data statistics and analysis

[0016] The present invention can solve the problem that the original records in the past were piled up in a discrete form at the grassroots level and had weak management capabilities. The implementation BOM can greatly improve the data statistics speed of a single product by collecting all manufacturing data, such as tools, equipment, and automation equipment used in the manufacturing process (including usage quantity, validity period, and software version), and generate forms by classification; classify and summarize various technical status changes, processes after deviation, production, and inspection implementation, and form analysis reports. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] The present invention will now be described by way of example with reference to the accompanying drawings, in which:

[0018] Figure 1 It is a flow chart of BOM construction for implementing the present invention. DETAILED DESCRIPTION

[0019] A practical BOM construction method for complex aerospace products, such as Figure 1 As shown, the following steps are included: construction of the structure of the implementation BOM, collection and processing of implementation data, mounting relationship between the implementation data and the implementation BOM structure, and generation of the implementation BOM, wherein:

[0020] 1. Implement the BOM structure:

[0021] The product's implementation BOM consists of the product's implementation material list and structural relationships, including the hierarchical structure information from the top level of the product - components - assemblies - parts - raw materials, recording the product's production and assembly, as well as the actual component information of the product.

[0022] The implementation BOM is structured based on the actual assembly information of the product task. During the production process, a single-layer implementation BOM is formed for each of the processed components. The BOM structure is expanded layer by layer from the top to the bottom of the finished product. Each level of BOM matches the corresponding physical data and its implementation BOM structure, and finally forms a complete implementation BOM structure.

[0023] The construction process of the product implementation BOM is as follows: after the implementation data of each physical object is finalized (that is, after the production is completed and put into storage), based on the implementation material list of each physical object, a single-layer implementation BOM structure is formed with each physical object as the parent node and the physical product corresponding to its implementation material list as the child node; determine the physical product that needs to be delivered, search for the unique identifiers of all physical objects in the sub-layer of its single-layer implementation BOM, and obtain the single-layer implementation BOM structure of the sub-layer; the single-layer BOM structure is combined according to the parent-child relationship and recursively based on this logic, forming a BOM structure layer by layer until the last layer forms a complete implementation BOM structure. The specific method includes the following steps:

[0024] 1.1. Build a recursive function to query all direct child nodes based on the current parent node ID. When a parent node has no child node information, it is considered a leaf node of the BOM structure tree and no recursion is performed;

[0025] 1.2. Starting from the top-level node of the product, use the product physical code to call the recursive function, query the loading part information in the manufacturing system database, obtain the single-layer sub-node information of the current product, and obtain the structure of the implementation BOM by recursively performing traversal operations on each sub-node;

[0026] 1.3. Create a new database table in the data platform to store the recursively obtained nodes and structural relationships.

[0027] 2. Collection and processing of implementation data:

[0028] Implementation data refers to all process data generated during the production and manufacturing process of each physical product, including planning data, process data, processing data, inspection and testing data, quality exceptions and deviations data, supporting parts information data, supply chain data, etc.

[0029] According to the dimensions of concern in the aerospace field, implementation data can be divided into three dimensions: process design, manufacturing process, and quality. Therefore, implementation data should be reorganized and divided into the following data objects:

[0030]

[0031] The specific method of collecting and processing the implementation data includes the following steps:

[0032] 2.1. Build a mounting model for implementation data and implementation BOM, requiring the mounted data objects to serve as the basis for dimension table construction in step 2.2;

[0033] 2.2. According to the output source of each node of the actual BOM, label it as "self-made / purchased / matching" in the data platform;

[0034] 2.3. Create different dimension tables according to the data objects of the implementation data;

[0035] 2.4. Collect the operational data in each business system, and after operations such as content cleaning and conversion, and field standardization, store it in the corresponding dimension table.

[0036] 3. Implementation data and implementation BOM structure mounting:

[0037] The implementation BOM is a hierarchical structure, and all relevant implementation data can be collected during the production process for the physical object corresponding to each BOM node.

[0038] The implementation BOM consists of the top level of the product, components, assemblies, parts (including standard parts), and raw materials. The output sources of each node are divided into self-made, purchased / outsourced, and supporting. Accordingly, each node mounts the corresponding implementation data items according to the output source. The following is the mounting model of implementation data and nodes:

[0039] Mounting data of self-made parts: ① Process design data, including MBOM, standardized process procedures, process simulation model and simulation results, tooling design model, and process design model; ② Manufacturing process data, including manufacturing task information, work order information (process level), self-inspection records, actual process parameter records, process resources used, loaded parts information, and equipment operation records; ③ Quality data, including process quality inspection item requirements, process inspection and testing records, certificate information, metrological physical and chemical test records, non-conforming product review records, questioning orders, deviation orders, design change orders, material substitution records, exception release records, and tooling, measuring instruments, and equipment instrument identification records.

[0040] Mounting data of purchased / outsourced parts: ① Manufacturing process data, including supplier information, purchase and warehousing records, and outsourcing records; ② Quality data, including certificate information and non-conforming product review records.

[0041] The mounting data of supporting parts: ① Quality data, including supporting product quality information.

[0042] After clarifying the data sources of various nodes, build the dimension table according to the above requirements to mount the data content and complete the data entry.

[0043] According to the mounting relationship model between the implementation data and the implementation BOM, as well as the data labels of each node obtained in step 2, a new relationship table is constructed in the application layer of the data platform to complete the association between the single implementation BOM node and the required dimension table.

[0044] 4. Implementation of BOM generation:

[0045] The actual BOM generated in step 3 already contains the structure and actual manufacturing data of a single product. According to the association results between the actual BOM nodes and the actual data, manual review is required before release. If it is found that the relationship between the data and the nodes does not match or matches incorrectly, the original system is informed to correct the data and re-collect and mount the data until the actual data of all nodes and the reference relationship of the actual BOM components are reviewed, so as to officially release the actual BOM of the product, complete the final version storage, and support subsequent business analysis applications.

[0046] In addition, it explains how the implementation BOM and MBOM are associated: this method cancels the direct construction of the implementation BOM from the MBOM, and relies on the data association relationship to reversely trace the MBOM structure of the node. Each node can be traced back to the process specification number and version used during processing through the physical code. The associated MBOM object is further traced through this version of the process specification, thereby completing the association between the implementation BOM and the MBOM, and performing structural comparison to determine whether there are errors, missing installations, etc.

Claims

1. A BOM construction method for complex aerospace products, characterized by: The steps include: Step 1: Implement the BOM structure. Step 2: Collect and process implementation data; Step 3: Load the implementation data and implementation BOM structure; Step 4: Create and implement BOM.

2. The BOM construction method for complex aerospace products according to claim 1, characterized in that: The nodes for implementing the BOM structure include: product top level, components, assemblies, parts, and raw materials.

3. The BOM construction method for complex aerospace products according to claim 2, characterized in that: The method for constructing the structure of the implementation BOM described in step 1 is: S11. Construct a recursive function to query all direct child nodes of the current parent node according to its ID; S12, starting from the top-level node of the product, using the physical code of the product to call the recursive function, query the loading part information in the manufacturing system database, obtain the single-layer child node information of the current product, and obtain the structure of the implementation BOM by recursively performing a traversal operation on each child node; S13. Create a new database table in the data platform to store the recursively obtained nodes and structural relationships.

4. The BOM construction method for complex aerospace products according to claim 3, characterized in that: In step S11, when the parent node has no child node information, it is regarded as a leaf node of the BOM structure tree and no recursion is performed.

5. The BOM construction method for complex aerospace products according to claim 2, characterized in that: The collection and processing of the implementation data described in step 2 includes the following process: S21. Construct a mounting model for implementation data and implementation BOM; S22. According to the output source of each node of the implementation BOM, label it as "self-made / purchased / matching" in the data platform; S23, establishing different dimension tables according to each data object of the implementation data; S24. Collect the operational data in each business system, and after operations such as content cleaning and conversion and field standardization, store it in the corresponding dimension table.

6. The BOM construction method for complex aerospace products according to claim 2, characterized in that: Implementation data is divided into three dimensions: process design, manufacturing process and quality.

7. The BOM construction method for complex aerospace products according to claim 6, characterized in that: The method for mounting the implementation data and the implementation BOM structure in step 3 is: mounting the corresponding implementation data items on the top level, components, assemblies, parts, and raw material nodes of the implementation BOM structure according to the output source, wherein: 1) Mounting data of self-made parts: ① process design data, including MBOM, standardized process procedures, process simulation model and simulation results, tooling design model, process design model; ② manufacturing process data, including manufacturing task information, work order information, self-inspection records, actual process parameter records, process resources used, loading parts information, equipment operation records; ③ quality data, including process quality inspection item requirements, process inspection and testing records, certificate information, metrological physical and chemical test records, non-conforming product review records, questioning orders, deviation orders, design change orders, material substitution records, exception release records, tooling, metrological instruments and equipment instrument identification records; 2) Mounting data of purchased parts: ① Manufacturing process data, including supplier information, purchase and warehousing records, and outsourcing records; ② Quality data, including certificate information and non-conforming product review records; 3) Mounting data of accessories: ① Quality data, including quality information of supporting products.

8. The BOM construction method for complex aerospace products according to claim 7, characterized in that: In step three, the implemented data and the implemented BOM structure are used to mount the generated implemented BOM, which already contains the structure and actual manufacturing data of a single product. According to the association results between the implemented BOM nodes and the implemented data, manual review is required before release: If it is found that the relationship between the data and the nodes does not match or matches incorrectly, the original system is informed to correct the data and re-collect and mount the data until the reference relationship between the implemented data of all nodes and the implemented BOM components is reviewed, so that the implemented BOM of the product is officially released and the final version is put into storage.

9. The BOM construction method for complex aerospace products according to claim 2, characterized in that: The method for associating the implementation BOM and MBOM generated in step 4 is: relying on the data association relationship to trace back the MBOM structure of the node, each node is traced back to the process specification number and version used during processing through the physical code, and the associated MBOM object is further traced through the process specification of this version, so as to complete the association between the implementation BOM and MBOM.

10. The BOM construction method for complex aerospace products according to claim 9, characterized in that: After completing the association between the implementation BOM and MBOM, perform a structural comparison to determine whether there are any errors or omissions.

Images