JPH07296081A - System for construction parts table - Google Patents

Abstract

PURPOSE:To accelerate the speed of an MRP processing by permitting item information and configuration information required for MRP calculation to a form where one-level lower order evolution is easily executed when they are constructed in a memory. CONSTITUTION:When reference information (item information and configuration information) stored in a disk is fetched onto the memory at the time of starting the MRP processing, an item information table is permitted to have a configuration address 2 and a configuration information table is permitted to have item addresses 6 and 7 in the item information table corresponding to a master item and a slave item. At the time of one-level lower order evolution in MRP, evolution is executed in the low-order item only by address designation without retrieving the slave item from the master item.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a parts table construction method, and more particularly to a parts table construction method for building a parts table having a tree structure from item information and configuration information.

[0002]

2. Description of the Related Art A conventional parts table construction method will be described in detail with reference to the drawings. As a conventional method, there is JP-A-6
The component creation management system disclosed in Japanese Patent Laid-Open No. 3-200950 and the high-speed MR disclosed in Japanese Patent Laid-Open No. 3-287357.
There is an arrangement planning support system using the P method. Next, these conventional examples will be described with reference to the drawings.

FIG. 3 _shows an example _{of an} item information table used for conventional parts table construction. The item information table shown in FIG. 3 is configured to include an item number and various pieces of information related to the item, such as an item name, a unit of measurement, and an inventory quantity.

FIG. 4 shows an example of a configuration information table used for conventional parts table construction. The configuration information table shown in FIG. 4 is configured to include a parent item number, a child item number of the parent item, and various types of information such as a configuration quantity, a configuration lead time, and the like that are related to one parent-child relationship.

In the prior art, the item information table and the configuration information table are stored in the database in the disk, and when the lower level development of the parts table 1 is performed, the parent item is searched from the configuration information table and the corresponding item is found. Child items are expanded on the memory.

[0006]

In the above-mentioned conventional parts table construction method, when all the processing of the items existing on the parts table is performed at the level-by-level, after the processing of the higher level is completed, the lower level of one level is completed. When starting the processing of the above items, the information of the processed higher level items is written to the disk, and the child items to be processed next are matched with the key items such as the item number and the item type from the configuration table in the disk. Is done, searched and retrieved in memory,
There is a drawback that the whole processing time becomes long.

[0007]

A parts table construction method of the present invention includes an item number and an item name, a unit of measurement, and an inventory quantity.
Includes an item information table consisting of item-specific information and a configuration address indicating the beginning of the child item group of the item in the configuration information table, a parent item number, a child item number of the parent item, a configuration quantity, and a configuration lead time Configuration _information composed of _information related to one parent-child relationship, the address of the parent item and the address of the child item in the item information table
And a table.

[0008]

The present invention will be described in detail with reference to the drawings.

FIG. 1A shows an item information table in one embodiment of the present invention. The item information table shown in FIG. 1A includes an item number 1, various pieces of information related to the item, and a configuration address 2 indicating the head of a child item group of the item in the configuration information table. .

FIG. 1B shows a configuration information table in an embodiment of the present invention. The configuration information table shown in FIG. 1B has a parent item number 4, _a child item number 5 _, various information related to the one parent-child relationship, and a parent item in the item information table shown in FIG. 6 _and the address 7 of the child item. Figure 1 (a) below
A construction method of the item information table shown in FIG. 1 and the configuration information table shown in FIG. 1B will be described.

In the item information table, necessary information is read from the disk into the memory, stored as a temporary item information table, and sorted using the item number 1 as a key. next,
The configuration information table reads necessary information from the disk into the memory and stores it as a temporary configuration information table. next,
The process of associating the item information table and the configuration information table is performed.

In order to associate the item information with the configuration information, the temporary configuration information table is first sorted by the child item number 5, and the relative position 3 of the item information table is set in the child item address 7. Next, the records of the temporary configuration information table are sorted with the parent item number 4 as the first key and the child item number 5 as the second key, and the relative position 3 of the item information table is set to the parent item address 6 of the temporary configuration information table. set. Finally, the relative position 8 of the temporary configuration information table in which the first configuration information of the child item group of item number 1 is stored is set to the configuration address 2 of the temporary item information table. The temporary item information table and the temporary configuration information table are stored as the item information table and the configuration information table when the configuration address of the temporary item information table is set and the parent item address and the child item address of the temporary configuration information table are set. To be done.

FIG. 2 is a parts table tree image showing an embodiment of the present invention. This parts table tree is a parts table tree constructed from the item information table of FIG. 1A and the configuration information table of FIG. 1B. When the processing of the item number AAA-007 of the first level is finished, the constituent address of the item number AAA-007 in the item information table of FIG. Item number AAA-00
Since the composition address of 7 is 0001, item number AAA-
The child items of 007 are CCC-001, CCC-003, from the relative position 0001 of the configuration information table of FIG. 1B to the range where the parent item address is equal, that is, the relative position 0003.
It is found to be DDD-111, and these child items are expanded to the BOM level 1 level.

[0014]

According to the parts table construction method of the present invention, the item information table has the composition address, the composition information table has the item address, the child item is designated by the address, and the parts table 1 level expansion is performed at any time. As a result, it is possible to shorten the search time for child items, and it is possible to shorten the processing time for complicated processing such as calculation of material requirements.

[Brief description of drawings]

1A and 1B show an embodiment of the present invention.
_{3 is a} diagram _{showing an} item information table and a configuration information table _in FIG.

FIG. 2 is a diagram showing a parts table tree according to an embodiment of the present invention.

FIG. 3 is a diagram showing an item information table in a conventional example.

FIG. 4 is a diagram showing a configuration information table in a conventional example.

[Explanation of symbols]

 1 Item number 2 Configuration address 3 Relative position of item information table 4 Parent item number 5 Child item number 6 Parent item address 7 Child item address 8 Relative position of configuration information table

Claims (2)

[Claims] 1. An item information table including an item number, an item name, a unit of measure, an inventory quantity, an item-specific information and a configuration address indicating the head of a child item group of the item in the configuration information table, and a parent. 1 including the item number and its parent item's child item number, component quantity, and component lead time
A parts table construction method comprising: information related to a parent-child relationship and a configuration _information table configured by an address of a parent item and an address of a child item in the item _information table. 2. In the item information table, necessary information is read from the disk into the memory, stored as a temporary item information table, sorted using the item number as a key, and then,
In the configuration information table, the necessary information is read from the disk into the memory, stored as a temporary configuration information table, and then the first step of performing the processing of relating the item information table and the configuration information table, and the item information. In order to correlate the temporary configuration information table with the configuration information, first, the temporary configuration information table is sorted by the child item number, the relative position of the item information table is set to the child item address, and then the record of the temporary configuration information table is set to the parent item. The item number is sorted as the first key and the child item number is sorted as the second key, the relative position of the item information table is set to the parent item address of the temporary configuration information table, and the configuration address of the temporary item information table is set to The relative position of the temporary configuration information table in which the first configuration information of the child item group of the item number is stored is set, and the temporary item information table is set. When the configuration address is set and the parent item address and the child item address of the temporary configuration information table are set, the temporary item information table and the temporary configuration information table are stored as the item information table and the configuration information table. A parts table construction method comprising: a second step.