JP5351803B2 - BOM management system - Google Patents

Description

  The present invention relates to a system for managing a distributed component configuration of a plurality of similar products as one component configuration table in the management operation of a component configuration table in the manufacturing industry.

  Consumer products such as home appliances are based on the concept of product series and variation development. As a result, each component configuration of multiple similar products has almost the same overall configuration. Often only the components are different.

  FIG. 1 is a diagram showing an example of a general part configuration table for parts management. FIG. 1A shows an example of the data structure of a part composition table of a plurality of similar products that have been serialized or developed in variations. A device has been devised to efficiently manage similar products using a single parts composition table. The similar products are the product X103, the product Y104, and the product Z105. “Part number” 101 lists the part number of each part used for all products. “Level” 102 indicates a hierarchy of parent-child relationships in the component configuration. The numerical value in each product column indicates the number of parts (the number of uses). On the other hand, FIG. 1B is a data structure example (right diagram) of a component configuration (left diagram) and a component configuration table of one product, for example, product X. The component configuration has a hierarchical parent-child relationship. The part configuration table is a table including “parent part number” 106 that is the part number of the parent part, “child part number” 107 that is the part number of the child part, and “number” 108 of the child part. A component configuration table based on such a component configuration is created for each product.

  Therefore, in the parts configuration table management system for managing parts of a plurality of similar products, the general part configuration of each product created based on the parent-child relationship and the number of members as shown in FIG. There is a need for a mechanism for expanding and displaying (table display or matrixing) and editing an integrated parts configuration table that includes a plurality of similar products such as 1 (a).

  In the method of Patent Document 1, the similarity of component parts for a plurality of products is determined based on whether or not the child parts having a parent-child relationship in the component parts match a predetermined ratio or more, and the similarity determination is performed. A feature of this method is that it is automated to create a component configuration table for a plurality of products.

JP-A-11-203327.

  In the expanded display of the part configuration, the display order of each part is often intentionally defined by the creator / editor of the part configuration table. The same applies to similar definitions at hierarchical levels such as component level and unit level. Such an intentional definition is an act that takes into consideration the maintainability of the creator / editor. Therefore, it is important that the parts structure table of similar products is also displayed in an expanded manner as intended.

  However, in a general parts configuration table management system, management is performed using a parent-child relationship and number table, and individual parts configuration tables each made up of individual parts are stored and managed in a database. When extracting information of a plurality of target products from a database and displaying them as a single component configuration table in a matrix form, an aggregation process is performed based on the result of extracting the component configuration tables for each target product to be collected as a matrix. There is a need. In addition, if the expanded display state is not retained as a result, the expanded display intended by the creator / editor, such as which parts / units should be put together and in which order each part should be displayed There may be cases where results are not obtained.

  In the method of Patent Document 1, the similarity of component parts is determined based on whether or not the child parts having a parent-child relationship in the component parts coincide with each other by a predetermined ratio or more. However, in this case, since the determination is based on a ratio, there may occur an event that items that should be collected cannot be collected and items that should not be collected are collected.

  It is an object of the present invention to provide an information processing apparatus that displays information on a plurality of similar products in a component configuration table management system that displays the configuration information on a single component configuration table. It is to solve the problem that the expanded display result intended by the editor cannot be obtained, and to improve the maintainability of the component configuration table in a matrix form.

The parts configuration table management system according to the present invention that achieves the above object includes a data processing device that uses the configuration information of each of a plurality of products as a set of parts configuration tables. The data processing device is configured to display a matrix in the display order in the configuration development and the component configuration table for the configuration information including the component configuration indicating the parent-child relationship of each component and the number of each component for one product. A group code indicating a part to be set and storing in a configuration master table for each product, a configuration table number assigned to the part configuration table, a product part number of a product included in the part configuration table, Means for associating a basic model flag indicating whether or not the configuration information of the product is a basic model and storing it as configuration table information; and all corresponding product product numbers from the configuration table information using the configuration table number as a key. Means for obtaining and referring to the basic model flag of the configuration table information and means for acquiring the configuration information of all corresponding products from the configuration master table based on the product part numbers In addition to expanding the configuration of the basic model product parts based on the display order, generate as many columns as the number of product part numbers acquired, and set the number of each part of the basic model product in the first column. The means for generating the initial form of the table and products other than the basic model are sequentially processed, and the component configuration of the product to be processed is expanded based on the display order, and the product of the basic model is displayed for each level of the component configuration. Means for assembling the parts configuration table by inserting a row into the part configuration table in the initial form and setting the number of each part in a column corresponding to the product to be processed, as compared with the result of configuration development And a means for displaying the received parts composition table on the composition table display edit screen.
The means for assembling the parts composition table determines whether or not each part of the product to be processed has the same parent-child relationship with each part of the basic model product. Set the number of parts without inserting, and if the parent-child relationship is different, determine whether the group code is the same, and insert the line at the next position in the parts composition table for parts with the same group code A parts configuration table management system, wherein the number of parts is set, and parts having different group codes are inserted into the next position in the parts configuration table according to the display order and the number of parts is set.

  According to the parts configuration table management system and method for similar products of the present invention, it is possible to collectively manage distributed configuration information for a plurality of products, and to create a part configuration as intended by the creator / editor of the parts configuration table. It is possible to obtain a table expansion result. This improves the visibility when confirming the component configuration contents of a plurality of products, and makes it possible to efficiently and collectively change the component configuration table in a design change across a plurality of products.

It is a figure which shows the example of the general components structure management method. (A) is for a plurality of similar products, and (b) is for one product. It is a figure which shows the system configuration | structure of the component structure management system of the similar product concerning one embodiment of this invention. It is a flowchart figure of the data processing of the components structure table | surface management system concerning one embodiment of this invention. It is a figure which shows the example of a data structure of the component structure table made into the matrix of the component structure table management system concerning one embodiment of this invention. It is a figure which shows the example of a data structure of the structure master table of the components structure table management system concerning one embodiment of this invention. It is a figure which shows an example which decomposed | disassembled the component structure table made into the matrix into the structure information for every product. It is a figure which shows the example of a data structure of the structure table information of the components structure table management system concerning one embodiment of this invention. It is a flowchart (the first half) figure of the parts structure table assembly process of the parts structure table management system concerning one embodiment of this invention. It is a flowchart (latter half) figure of the parts structure table assembly process of the parts structure table management system concerning one embodiment of this invention. It is a figure which shows the state of the parts structure table after step S605 of parts structure table assembly process (product X). It is a figure which shows the state of the parts structure table after step S608 of parts structure table assembly processing (product Y). It is a figure which shows the state of the parts structure table after step S610 of parts structure table assembly processing (product Y). It is a figure which shows the state of the components structure table after step S611 of a components structure table assembly process (product Y). It is a figure which shows the state of the parts structure table after step S608 of parts structure table assembly processing (product Z). It is a figure which shows the state of the parts structure table after step S610 of parts structure table assembly process (product Z).

  Hereinafter, a system and method for managing a component configuration table of similar products according to the present invention will be described with reference to the drawings.

  Reference is again made to FIG. FIG. 1 is a diagram showing an example of a general part configuration table for parts management. FIG. 1A shows an example of the data structure of a part composition table of a plurality of similar products that have been serialized or developed in variations. In “product number” 101, all components used for all products to be collected, that is, all units and parts are arranged. “Level” 102 indicates the hierarchical level of the parent-child relationship in the component configuration. “Product X” 103, “Product Y” 104, and “Product Z” 105 define products to be collected as columns, and set the number of units or parts to be used for each column.

  On the other hand, FIG. 1B is a data structure example (right diagram) of a component configuration (left diagram) of one product, for example, product X, and its component configuration table. As shown in the component configuration, the product level and each unit level have a parent-child relationship, and one unit level and each component level have a parent-child relationship. The parts configuration table is all expressed by a parent-child relationship, and “parent part number” 106 that is the part number of the parent part, “child part number” 107 that is the part number of the child part, and “number” that indicates the number of child parts used. 108.

  For this reason, in order to express a part configuration table as shown in FIG. 1A in which a plurality of similar products are collected as a part configuration table management system, individual parts managed in a parent-child relationship as shown in FIG. A mechanism for assembling and disassembling based on the information in the composition table is required.

  In the following description of the present invention, a part configuration table summarizing a plurality of similar products is referred to as a “part configuration table”, and a part configuration table (or information included in one product) is referred to as “configuration information”. I will do it.

  FIG. 2 shows the configuration of a similar product parts configuration table management system according to the present invention. The configuration database (DB) 200 stores a configuration master table 201 and configuration table information 202. The data processing unit 203 has functions realized by a program installed in a data processing apparatus that is a computer. Based on the information in the configuration database 200, the data processing unit 203 performs processing for displaying and storing a component configuration table of similar products. The data processing unit 203 includes a configuration table product management unit 204, a configuration information extraction unit 205, a configuration table assembly / disassembly unit 206, and a configuration information update unit 207. The user can refer to and edit the parts configuration table using the configuration table display editing screen 208.

  FIG. 3 is a flowchart showing data processing by the data processing unit 203 of FIG. 2 for managing the component configuration table of similar products in a matrix form.

  First, the configuration table product management unit 204 acquires a product item number to be expanded from information stored in the configuration table information 202 in advance (step S301). The configuration table information 202 stores information defined for each of a plurality of target products collected as a part configuration table. Here, FIG. 5 shows a data structure example of the configuration table information 202. The configuration table information 202 includes a “configuration table number” 501 assigned to each part configuration table of a similar product, a “product part number” 502 assigned to each product, and whether the configuration information of the product is a basic model. It is a table consisting of “basic model flag” 503 shown. For example, when it is desired to refer to or edit the parts configuration table of a plurality of similar products including the product X, “product X” is acquired from the configuration table information of FIG.

  Next, the configuration information extraction unit 205 acquires all necessary configuration information from the configuration master table 201 using the product product number acquired in step S301 as the parent product number (step S302). FIG. 4B shows an example of the data structure of the configuration master table 201. The configuration master table 201 is a table including “parent product number” 402, “child product number” 403, “number” 404, “display order” 405, and “group code” 406. As described above, the configuration master table 201 is disassembled and stored in the configuration information for each product.

  The configuration table assembling / disassembling unit 206 assembles a component configuration table by comparing the acquired configuration information of a plurality of similar products for each development level and performing matrix expansion, that is, matrixing (step S303).

  The configuration information acquisition process in step S302 and the parts configuration table assembly process in step S303 will be described in detail with reference to FIGS. 6A and 6B described later.

  Subsequently, the configuration table assembling / disassembling unit 206 expands and displays the matrix information assembled in step S303, that is, the component configuration table of the similar product on the configuration table display editing screen 208 (step S304). FIG. 4A shows an example of the data structure of the component configuration table expanded and displayed on the configuration table display editing screen 208. “Level” indicates a hierarchical level in the parent-child relationship of each part, column 1 indicates the product X, column 2 indicates the product Y, and column 3 indicates the number of each part of the product Z. Thereby, the user can refer to the part composition table of the similar product.

  On the configuration table display editing screen 208, the configuration master table 201 shown in FIG. 4B can also be displayed. In the configuration table display editing screen 208, for the purpose of defining the product part numbers to be collected, the setting of the “group code” 406 and the setting of the “display order” 405 of the configuration master table 201 can be performed. . Thereby, the user can edit the parts composition table of similar products.

  After the reference or editing is completed, the parts configuration table edited on the configuration table display editing screen 208 is decomposed into configuration information for each product by the configuration table assembly / disassembly unit 206 (step S305). FIG. 4C shows an example in which the matrix component configuration table 401 is decomposed into configuration information 4011, 4012, and 4013 for each product when stored in the configuration master table 201. Each column of the parts configuration table is broken down into configuration information for each product.

  The configuration information update unit 207 updates the configuration master table 201 by storing the configuration information disassembled for each product in the configuration master table 201 for each product (step S306).

  FIG. 6A and FIG. 6B show details of acquisition processing (step S302 in FIG. 3) and component configuration table assembly processing (step S303 in FIG. 3) of a plurality of products in the similar product parts configuration table management system. It is a flowchart figure. Note that reference numerals in FIGS. 1 to 5 may be referred to. FIG. 7A to FIG. 7F are diagrams schematically showing an example of the parts composition table assembling process of similar products along the process.

The configuration table product management unit 204 uses the configuration table number 501 corresponding to one product item number 502 acquired from the configuration table information 202 of FIG. 5 in step S301 of FIG. 3 as a key and the same configuration from the configuration table information 202 of FIG. All the information stored in the configuration table information 202 for all products having a table number is acquired (step S601). Products having these product numbers are processed.
For example, when the configuration table number “01-001” corresponding to the product product number “product X” is used as a key, the configuration table information 202 for each of the product product numbers “product X”, “product Y”, and “product Z” is stored. Get all the information.

  It is determined whether there is a product to be processed corresponding to the configuration table number (step S602). When there is a product to be processed, the configuration information extraction unit 205 acquires all the configuration information having the product product number as the parent product number from the configuration master table 201 and generates as many columns as the number of product product numbers to be acquired. (Step S603). For example, the configuration information having the product product numbers “product X”, “product Y”, and “product Z” as the parent product numbers is acquired from the configuration master table 201, and the columns 1, 2, and 3 in the parts configuration table are acquired. Generate three columns. At this time, the product configuration information (step S604) in which the basic model flag 503 of the configuration table information 202 in FIG. 5 is “1” among the acquired product product numbers is prioritized as a basic model, and the configuration in FIG. In accordance with the display order 405 of the master table 201, all levels of the component configuration of the basic model are expanded and set in the first column of the component configuration table (step S605). In this way, an initial form of the parts configuration table is generated.

For example, since the basic model flag of the product item number “product X” is “1”, the configuration information of the product X becomes the basic model. Referring to the display order 405 (up to the first to ninth lines of the configuration master table), level 1 is only “product X” and display order is only “10”. Set "and number""1".
Next, level 2 child product numbers having “product X” as the parent product number are “unit A”, “unit B”, and “part X1”, and their display order is “10”, “20”, “ Since it is 30 ", the second to fourth lines are added in ascending order, and the level" 2 "and the numbers" 1 "," 2 "and" 2 "are set.
Next, the level 3 child product numbers having “unit A” as the parent product number are “part A1” and “part A2”, and their display order is “10” and “20”. Accordingly, two lines are inserted between the lines of “unit A” and “unit B”, and the level “3” and the numbers “2” and “5” are set. The child part numbers “part B1”, “part B2”, and “part C1” having “unit B” as the parent part number are inserted in the same manner by inserting three lines between the “unit B” and “part X1” rows. The Since there is no child part number for “part X1”, there is no further processing.
At the time of completion of step S605 for the product X, the parts configuration table is in the state shown in FIG. 7A.

Subsequently, the process proceeds to the processing of the configuration information of the next product (returning to step S602 and repeating, from step S604 to step S613).
Subsequently, among the acquired product part numbers, the part configuration of the product whose basic model flag 503 of the configuration table information 202 in FIG. 5 is “0” is expanded for each level, and compared with the configuration expansion result of the previously expanded basic model. (Step S606). Based on the comparison result, the number is set in the column corresponding to the product. In the example, “product Y” is set in the second column and “product Z” is set in the third column.

  First, it is compared whether or not there is the same parent product number 402 and child product number 403 in the configuration development of the part configuration of the basic model and the configuration development of the part configuration of the processing target product (step 607).

  If the parent product number 402 and the child product number 403 are the same, no row is inserted into the parts structure table, and the number is set in the column of the product (step S608).

For example, since the product part number “Product Y” has “Unit A”, the combination of “Unit A” and “Part A1” and “Unit” are the same as “Product X”. This is a combination of “A” and “Part A2”. Accordingly, the numbers “2” and “5” are set in the second column of “component A1” and “component A2”, respectively.
At the time of completion of step S608 for this product Y, the parts configuration table is in the state shown in FIG. 7B.

  If either or both of the parent product number 402 and the child product number 403 are different, the group codes 406 are compared (step S609). If the group code 406 is the same, a row is inserted at the position next to the comparison target row in the parts structure table, and the number is set in the corresponding column (step S610). This means that the lower structure of the part number having the same group code is formed into a matrix.

For example, since “Product Y” has the same group code “G001” as “Product X”, “Product Y” is inserted after “Product X”, and the number “1” is inserted in the second column. Set. At this time, the component numbers of the subordinate components of “product Y” are set for each of which the number can be set without inserting a row. Since “Unit C” has the same group code “G002” as “Unit B”, “Unit C” is inserted after “Unit B”, and the number “2” is inserted in the second column. Set. At this time, regarding the part number of the subordinate component of “unit C”, those that can set the number without inserting a row are set.
At the time of completion of step S610 for the product Y, the parts configuration table is in the state shown in FIG. 7C.

  If the group codes 406 are different, the display order 405 of the basic model and the display order 405 of the configuration information to be processed are compared, and a row is inserted in ascending order, and the number is set in the corresponding column (step S611). .

For example, the child part number “part C2” of “unit C” is inserted after the line of “part C1”, and the number “1” is set.
At the time of completion of step S611 for this product Y, the parts configuration table is in the state shown in FIG. 7D.

If the processing is completed at all levels of the product Y, the process proceeds to the configuration processing of the next product number or less. In the example, “product Z” is next processed, and the same processing is performed.
When the step S608 for the product Z is completed, the parts configuration table is in the state shown in FIG. 7E. Furthermore, at the time of completion of step S610 for the product Z, the parts configuration table is in the state of FIG. 7F. Although not shown, in step S611 for the product Z, the row of “component C3” is inserted after the row of “component C2”, and the number “1” is set. As a result, the parts structure table is completed, and the parts structure table is in the state of FIG. 4A.

  When the processing for all the products to be processed is completed, that is, when the matrixed component configuration table is completed, the component configuration table that is matrixed is expanded on the configuration table display editing screen 208, that is, on the screen. It is displayed (step 612).

  200: parts configuration DB, 201: configuration master table, 202: configuration table information, 203: data processing unit, 204: configuration table product management unit, 205 configuration information extraction unit, 206: configuration table assembly / disassembly unit, 207: configuration information Update unit, 208: Composition table display edit screen

Claims (1)

In a component configuration table management system including a data processing device that sets each configuration information of a plurality of products as a single component configuration table, the data processing device includes:
Group code that indicates the parts to be matrixed when they are organized in the display order in the component development and the component configuration table for the configuration information including the component configuration indicating the parent-child relationship of each component and the number of each component for one product Means for storing in the configuration master table for each product,
A configuration table in which a configuration table number given to a parts configuration table, a product number of a product included in the parts configuration table, and a basic model flag indicating whether the configuration information of the product is a basic model are associated with each other Means for storing as information;
Means for acquiring all corresponding product product numbers from the configuration table information using the configuration table number as a key, and acquiring configuration information of all corresponding products from the configuration master table based on those product product numbers;
By referring to the basic model flag in the configuration table information, the component configuration of the basic model product is expanded based on the display order, and as many columns as the number of product part numbers acquired are generated, and the basic model product is displayed in the first column. Means for generating an initial form of the parts composition table by setting the number of parts of each of
The product other than the basic model is sequentially processed, the component configuration of the product to be processed is configured and expanded based on the display order, and compared with the configuration expansion result of the basic model product for each level of the component configuration. Means for assembling a parts composition table by inserting a row into the parts composition table and setting the number of parts in a column corresponding to the product to be processed;
Means for displaying the assembled parts composition table on the composition table display edit screen,
The means for assembling the parts composition table is:
Determine whether each part of the product to be processed has the same parent-child relationship with each part of the basic model product. For parts having the same parent-child relationship, the number of parts can be calculated without inserting a row into the parts structure table. When the parent-child relationship is different, it is determined whether the group code is the same. For parts having the same group code, a line is inserted at the next position in the part composition table to set the number of parts. A parts configuration table management system, wherein parts having different codes are inserted into the next position in the parts configuration table according to the display order, and the number of the parts is set.

Images