Material classification method and system and material matching method and system
1. A material classification method is applied to a PLM system and comprises the following steps:
q1, receiving the newly added material, and judging whether the newly added material has the same material in the BOM of the newly added material:
if yes, go to step Q2;
if not, a material characteristic classification database is established for the materials belonging to the newly added materials, the established material characteristic classification database is added into a pre-established classification database set, and then the step Q2 is executed;
q2, determining each material characteristic classification database of the newly added material in the classification database set;
q3, adding the material number of the newly added material into each determined material characteristic classification database.
2. The material classification method according to claim 1, wherein the method for creating the material characteristic classification database for the class material of the newly added material in the step Q1 comprises the following steps:
inputting a first-level material classification rule which is designed for a target material in advance, wherein the target material is a material to which the newly added material belongs; the primary material classification rule is a group of material attribute information of the target material which is specified in advance;
correspondingly constructing a corresponding material characteristic classification database for each material attribute information contained in the input first-level material classification rule;
and adding all the constructed material characteristic classification databases into the classification database set.
3. The material sorting method according to claim 2, characterized in that the material sorting method further comprises: adding a material characteristic classification database;
the material characteristic classification database adding step specifically comprises the following steps:
adding a first-level material classification rule of a specified material;
constructing a material characteristic classification database for the specified materials according to the primary material classification rule of the added specified materials to obtain a newly added material characteristic classification database of the corresponding quantity of the specified materials;
acquiring material attribute information of each material belonging to the specified class of materials in the BOM;
determining the materials belonging to the specified materials in the BOM corresponding to each newly added material characteristic classification database based on the material attribute information of each material belonging to the specified materials in the obtained BOM;
writing the determined material number of each material into a corresponding newly added material characteristic classification database;
and adding all newly added material characteristic classification databases obtained after writing the material numbers of all the determined materials into the classification database set.
4. The material sorting method according to claim 1, characterized in that the material sorting method further comprises: OD relation limiting and transferring steps;
the OD relationship limiting and passing step comprises:
adding each related material characteristic classification database which is selected from the classification library set in advance and used for OD relation limitation and transmission in BOM;
adding preset upgraded material classification rules, wherein the upgraded material classification rules are database operation rules;
performing database operation on each added material characteristic classification database by using the added upgraded material classification rule to obtain a corresponding number of newly added material characteristic classification databases;
and adding all the obtained newly added material characteristic classification databases into the classification database set.
5. A material matching method based on the material classification method of any one of claims 1 to 4, which is applied to an ERP system and is based on a PLM system, and is characterized in that the PLM system adopts the material classification method to classify each newly added material in BOM in advance to obtain a material characteristic classification database corresponding to each material in BOM;
the material matching method comprises the following steps:
receiving a material option which is marked with auxiliary materials in a PLM system in advance and is transmitted upwards;
receiving auxiliary material screening OD conditions which are filled in a PLM system in advance and transmitted upwards;
receiving a bill of materials to be selected from the PLM system;
screening OD conditions and material options according to the received auxiliary materials, and carrying out material matching on each material on the bill of materials;
when a target material on the bill of materials is selected and matched, a material characteristic classification database where the target material is located is searched and returned to the PLM system; the PLM system searches corresponding material classification rules based on the received material characteristic classification database, searches materials corresponding to the material classification rules preset for the material options corresponding to the target materials from each material characteristic classification database of the target materials returned from the ERP system according to the searched material classification rules and the material classification rules preset for the material options corresponding to the target materials, the searched materials are required auxiliary materials, and the material numbers of the auxiliary materials are returned to the ERP system; the target material is a material under the selected material option with a label;
and correspondingly receiving the material number fed back by the PLM system, and adding the material number into the bill of materials.
6. A material classification system is applied to a PLM system and comprises a first module, a second module and a third module, wherein:
the first module is used for receiving the newly added material, judging whether the newly added material has the same kind of material in the BOM to which the newly added material belongs, calling the second module when the judgment result is yes, creating a material characteristic classification database for the material to which the newly added material belongs when the judgment result is no, adding the created material characteristic classification database into a pre-created classification database set, and then calling the second module;
the second module is used for determining each material characteristic classification database to which the newly added material belongs in the classification database set;
and the third module is used for adding the material number of the newly added material into each determined material characteristic classification database.
7. The material classification system according to claim 6, characterized in that the first module comprises a first unit for creating a material property classification database for the material belonging to the newly added material;
the first unit includes:
the input module is used for inputting a primary material classification rule which is designed for a target material in advance, wherein the target material is a material to which the newly added material belongs; the primary material classification rule is a group of material attribute information of a preselected target material;
the first classification library construction module is used for correspondingly constructing a corresponding material characteristic classification database for each material attribute information contained in the input first-level material classification rule;
and the first classification library supplementing module is used for adding all the material characteristic classification databases constructed by the first classification library constructing module into the classification library set.
8. The material classification system according to claim 6, further comprising a second unit for adding a material characteristic classification database;
the second unit includes:
the first adding module is used for adding a first-level material classification rule of a specified material;
the second classification library construction module is used for constructing a material characteristic classification database for the specified materials according to the added first-level material classification rules of the specified materials to obtain a newly-added material characteristic classification database with the corresponding quantity of the specified materials;
the target material attribute information acquisition module is used for acquiring material attribute information of each material belonging to the specified class of materials in the BOM;
the associated material acquisition module is used for determining the materials belonging to the specified materials in the BOM corresponding to each newly added material characteristic classification database based on the material attribute information of each material belonging to the specified materials in the acquired BOM;
a material number writing module, which is used for writing the determined material number of each material into the respective corresponding newly added material characteristic classification database;
and the second classification library supplementing module is used for adding all newly added material characteristic classification databases obtained after the material numbers of all the determined materials are written into the classification library set.
9. The material sorting system of claim 6, further comprising a third unit for limiting and communicating the OD relationship;
the third unit includes:
the second adding module is used for adding each related material characteristic classification database which is selected from the classification database set in advance and used for OD relation limitation and transmission in BOM;
the third adding module is used for adding preset upgraded material classification rules, and the upgraded material classification rules are database operation rules;
the operation module is used for performing database operation on each added material characteristic classification database by using the added upgraded material classification rule to obtain a corresponding number of newly added material characteristic classification databases;
and the third classification library supplementing module is used for adding all the obtained newly added material characteristic classification databases into the classification library set.
10. A material matching system based on the material classification system of any one of claims 6 to 9, applied to an ERP system and based on a PLM system,
the PLM system is integrated with the material classification system, and the PLM system adopts the material classification system to classify each newly added material in the BOM of the system in advance to obtain a material characteristic classification database corresponding to each material in the BOM;
the PLM system is also integrated with a marking module, a bill of materials uploading module and an auxiliary material screening OD condition input module, wherein:
the marking module is used for marking the material options with the auxiliary materials and sending the marked material options to the ERP system;
the auxiliary material screening OD condition input module is used for inputting auxiliary material screening OD conditions corresponding to the bill of materials of the materials to be selected and uploading the input auxiliary material screening OD conditions to the ERP system;
the material list uploading module is used for uploading a material list of materials to be selected to the ERP system;
the material matching system comprises:
the first data receiving module is used for receiving all related contents transmitted by the marking module, the auxiliary material screening OD condition input module and the bill of material uploading module;
the matching module is used for screening OD conditions and material options according to the received auxiliary materials and performing material matching on each material in the bill of materials;
wherein the matching module, when matching the target material on the bill of materials, is configured to perform the following steps:
searching a material characteristic classification database of the target material and returning the material characteristic classification database to the PLM system; the target material is a material under the selected material option with a label;
correspondingly receiving the material number fed back by the PLM system, and adding the material number into the bill of materials;
when the PLM system receives a material characteristic classification database of a target material returned by the ERP system, the PLM system searches a corresponding material classification rule based on the received material characteristic classification database, searches a material corresponding to the material classification rule preset for the material option corresponding to the target material from each material characteristic classification database of the target material returned by the ERP system according to the searched material classification rule and the material classification rule preset for the material option corresponding to the target material, the searched material is a required auxiliary material, and the material number of the searched auxiliary material is returned to the ERP system.
Background
The present invention relates to a development of a Product Lifecycle Management (PLM) system and an sap (system Applications and products) erp (enterprise Resource planning) system, and the operation method is that when a new Material is added to a BOM (Bill of Material ), a Material code (i.e., a Material number) is uploaded to the system and added to the BOM, and then a combination of the relationship is determined manually, a document of a limit relationship (i.e., an OD relationship or an OD limit relationship) is downloaded from the PLM system by filling the Material code, and the Material code is manually added to the corresponding relationship in each set.
In addition, when the materials in the BOM have auxiliary materials, the processing method in the prior art is usually to add all the relevant auxiliary materials of each BOM once in the BOM, and fill in the 0D relationship with the relevant auxiliary materials on each material with auxiliary materials, which not only affects the accuracy and work efficiency, but also needs to modify the BOM when updating the auxiliary materials of the selected materials, including modifying the 0D relationship between the materials and the auxiliary materials in the BOM, which further affects the improvement of the accuracy and work efficiency.
Therefore, the invention provides a material classification method and system and a material matching method and system, which are used for solving the problems.
Disclosure of Invention
Aiming at the defects of the prior art, the invention provides a material classification method and system, and a material matching method and system, which are used for automatically realizing the establishment of an OD (origin-destination) restriction relationship when materials are newly added in a BOM (bill of materials), not only can avoid the use of a manual adding mode, but also can avoid the addition of auxiliary materials and a 0D relationship thereof in the BOM, reduce the workload in the later maintenance process, and improve the accuracy and the working efficiency.
The invention provides a material classification method, which is applied to a PLM system and comprises the following steps:
q1, receiving the newly added material, and judging whether the newly added material has the same material in the BOM of the newly added material:
if yes, go to step Q2;
if not, a material characteristic classification database is established for the materials belonging to the newly added materials, the established material characteristic classification database is added into a pre-established classification database set, and then the step Q2 is executed;
q2, determining each material characteristic classification database of the newly added material in the classification database set;
q3, adding the material number of the newly added material into each determined material characteristic classification database.
Further, the method for creating the material characteristic classification database for the class material of the newly added material in the step Q1 includes:
inputting a first-level material classification rule which is designed for a target material in advance, wherein the target material is a material to which the newly added material belongs; the primary material classification rule is a group of material attribute information of the target material which is specified in advance;
correspondingly constructing a corresponding material characteristic classification database for each material attribute information contained in the input first-level material classification rule;
and adding all the constructed material characteristic classification databases into the classification database set.
Further, the material classification method further comprises the following steps: adding a material characteristic classification database;
the material characteristic classification database adding step specifically comprises the following steps:
adding a first-level material classification rule of a specified material;
constructing a material characteristic classification database for the specified materials according to the primary material classification rule of the added specified materials to obtain a newly added material characteristic classification database of the corresponding quantity of the specified materials;
acquiring material attribute information of each material belonging to the specified class of materials in the BOM;
determining the materials belonging to the specified materials in the BOM corresponding to each newly added material characteristic classification database based on the material attribute information of each material belonging to the specified materials in the obtained BOM;
writing the determined material number of each material into a corresponding newly added material characteristic classification database;
and adding all newly added material characteristic classification databases obtained after writing the material numbers of all the determined materials into the classification database set.
Further, the material classification method further comprises the following steps: OD relation limiting and transferring steps;
the OD relationship limiting and passing step comprises:
adding each related material characteristic classification database which is selected from the classification library set in advance and used for OD relation limitation and transmission in BOM;
adding preset upgraded material classification rules, wherein the upgraded material classification rules are database operation rules;
performing database operation on each added material characteristic classification database by using the added upgraded material classification rule to obtain a corresponding number of newly added material characteristic classification databases;
and adding all the obtained newly added material characteristic classification databases into the classification database set.
In a second aspect, the invention provides a material matching method based on the material classification method in the above aspects, the material matching method is applied to an ERP system and is based on a PLM system, the PLM system adopts the material classification method in advance to classify each newly added material in a BOM, and a material characteristic classification database corresponding to each material in the BOM is obtained;
the material matching method comprises the following steps:
receiving a material option which is marked with auxiliary materials in a PLM system in advance and is transmitted upwards;
receiving auxiliary material screening OD conditions which are filled in a PLM system in advance and transmitted upwards;
receiving a bill of materials to be selected from the PLM system;
screening OD conditions and material options according to the received auxiliary materials, and carrying out material matching on each material on the bill of materials;
when a target material on the bill of materials is selected and matched, a material characteristic classification database where the target material is located is searched and returned to the PLM system; the PLM system searches corresponding material classification rules based on the received material characteristic classification database, searches materials corresponding to the material classification rules preset for the material options corresponding to the target materials from each material characteristic classification database of the target materials returned from the ERP system according to the searched material classification rules and the material classification rules preset for the material options corresponding to the target materials, the searched materials are required auxiliary materials, and the material numbers of the auxiliary materials are returned to the ERP system; the target material is a material under the selected material option with a label;
and correspondingly receiving the material number fed back by the PLM system, and adding the material number into the bill of materials.
In a third aspect, the present invention provides a material classification system, which is applied to a PLM system, and includes a first module, a second module, and a third module, wherein:
the first module is used for receiving the newly added material, judging whether the newly added material has the same kind of material in the BOM to which the newly added material belongs, calling the second module when the judgment result is yes, creating a material characteristic classification database for the material to which the newly added material belongs when the judgment result is no, adding the created material characteristic classification database into a pre-created classification database set, and then calling the second module;
the second module is used for determining each material characteristic classification database to which the newly added material belongs in the classification database set;
and the third module is used for adding the material number of the newly added material into each determined material characteristic classification database.
Further, the first module comprises a first unit, and the first unit is used for creating a material characteristic classification database for the materials belonging to the newly added materials;
the first unit includes:
the input module is used for inputting a primary material classification rule which is designed for a target material in advance, wherein the target material is a material to which the newly added material belongs; the primary material classification rule is a group of material attribute information of a preselected target material;
the first classification library construction module is used for correspondingly constructing a corresponding material characteristic classification database for each material attribute information contained in the input first-level material classification rule;
and the first classification library supplementing module is used for adding all the material characteristic classification databases constructed by the first classification library constructing module into the classification library set.
Further, the material classification system also comprises a second unit, wherein the second unit is used for newly adding a material characteristic classification database;
the second unit includes:
the first adding module is used for adding a first-level material classification rule of a specified material;
the second classification library construction module is used for constructing a material characteristic classification database for the specified materials according to the added first-level material classification rules of the specified materials to obtain a newly-added material characteristic classification database with the corresponding quantity of the specified materials;
the target material attribute information acquisition module is used for acquiring material attribute information of each material belonging to the specified class of materials in the BOM;
the associated material acquisition module is used for determining the materials belonging to the specified materials in the BOM corresponding to each newly added material characteristic classification database based on the material attribute information of each material belonging to the specified materials in the acquired BOM;
a material number writing module, which is used for writing the determined material number of each material into the respective corresponding newly added material characteristic classification database;
and the second classification library supplementing module is used for adding all newly added material characteristic classification databases obtained after the material numbers of all the determined materials are written into the classification library set.
Further, the material classification system also comprises a third unit, wherein the third unit is used for limiting and transmitting the OD relation;
the third unit includes:
the second adding module is used for adding each related material characteristic classification database which is selected from the classification database set in advance and used for OD relation limitation and transmission in BOM;
the third adding module is used for adding preset upgraded material classification rules, and the upgraded material classification rules are database operation rules;
the operation module is used for performing database operation on each added material characteristic classification database by using the added upgraded material classification rule to obtain a corresponding number of newly added material characteristic classification databases;
and the third classification library supplementing module is used for adding all the obtained newly added material characteristic classification databases into the classification library set.
In a fourth aspect, the invention provides a material matching system based on the material classification system in the above aspects, the material matching system is applied to an ERP system and is based on a PLM system,
the PLM system is integrated with the material classification system, and the PLM system adopts the material classification system to classify each newly added material in the BOM of the system in advance to obtain a material characteristic classification database corresponding to each material in the BOM;
the PLM system is also integrated with a marking module, a bill of materials uploading module and an auxiliary material screening OD condition input module, wherein:
the marking module is used for marking the material options with the auxiliary materials and sending the marked material options to the ERP system;
the auxiliary material screening OD condition input module is used for inputting auxiliary material screening OD conditions corresponding to the bill of materials of the materials to be selected and uploading the input auxiliary material screening OD conditions to the ERP system;
the material list uploading module is used for uploading a material list of materials to be selected to the ERP system;
the material matching system comprises:
the first data receiving module is used for receiving all related contents transmitted by the marking module, the auxiliary material screening OD condition input module and the bill of material uploading module;
the matching module is used for screening OD conditions and material options according to the received auxiliary materials and performing material matching on each material in the bill of materials;
wherein the matching module, when matching the target material on the bill of materials, is configured to perform the following steps:
searching a material characteristic classification database of the target material and returning the material characteristic classification database to the PLM system; the target material is a material under the selected material option with a label;
correspondingly receiving the material number fed back by the PLM system, and adding the material number into the bill of materials;
when the PLM system receives a material characteristic classification database of a target material returned by the ERP system, the PLM system searches a corresponding material classification rule based on the received material characteristic classification database, searches a material corresponding to the material classification rule preset for the material option corresponding to the target material from each material characteristic classification database of the target material returned by the ERP system according to the searched material classification rule and the material classification rule preset for the material option corresponding to the target material, the searched material is a required auxiliary material, and the material number of the searched auxiliary material is returned to the ERP system.
The beneficial effect of the invention is that,
(1) according to the material classification method and system provided by the invention, the code (namely material number) addition of the newly added material is automatically completed by establishing the material characteristic classification database, so that the use of a manual addition mode is avoided, and the BOM maintenance time is shortened and the maintenance error rate is reduced to a certain extent.
(2) The material classification method and the material classification system provided by the invention can also add the material characteristic classification database when a new material characteristic classification database needs to be added according to actual needs, so that the flexibility and the expandability of the method are increased on the premise of ensuring that the addition of the material number of the newly added material is automatically completed, and the newly added material characteristic classification databases are added into the classification library set for the classification of the subsequently added material, thereby being beneficial to ensuring the refinement of the classification of the newly added material on the premise of not adding the material number in a manual adding mode to a certain extent.
(3) The material classification method and the material classification system provided by the invention can further limit and transmit the OD relationship based on the preselected material characteristic classification database and the preset upgraded material classification rule according to actual needs to obtain a corresponding number of newly added material characteristic classification databases and add the newly added material characteristic classification databases into the classification database set, further ensure the automatic limit and transmission of the OD relationship on the premise of not adding material numbers in an artificial adding mode, further contribute to realizing the classification refinement of the newly added materials, further contribute to shortening the BOM maintenance time and reducing the maintenance error rate.
(4) The material classification method and the material classification system provided by the invention can transmit the OD relationship through the database, so that auxiliary materials are not required to be added once in the BOM, 0D relationship is not required to be filled in each material, and when the auxiliary materials of the selected materials are updated, the BOM is not required to be changed, the 0D relationship in the BOM is not required to be modified, the workload of the maintenance process is reduced to a certain extent, and the accuracy and the working efficiency are improved.
(5) The material matching method and the material matching system provided by the invention are sequentially based on the material classification method and the material classification system provided by the invention, have all the advantages of the material classification method and the material classification system provided by the invention, and are not described again.
In addition, the invention has reliable design principle, simple structure and very wide application prospect.
Drawings
In order to more clearly illustrate the embodiments or technical solutions in the prior art of the present invention, the drawings used in the description of the embodiments or prior art will be briefly described below, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without creative efforts.
FIG. 1 is a schematic flow diagram of a method of material classification in accordance with an embodiment of the present invention.
FIG. 2 is a schematic flow diagram of a material sorting system in accordance with one embodiment of the present invention.
Detailed Description
In order to make those skilled in the art better understand the technical solution of the present invention, the technical solution in the embodiment of the present invention will be clearly and completely described below with reference to the drawings in the embodiment of the present invention, and it is obvious that the described embodiment is only a part of the embodiment of the present invention, and not all embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
FIG. 1 is a schematic flow diagram of a method of material classification in accordance with an embodiment of the present invention. The material classification method is applied to a PLM system.
As shown in fig. 1, the method for classifying materials includes:
step Q1, receiving the newly added material, and judging whether the newly added material has the same kind of material in the BOM to which the newly added material belongs:
if yes, go to step Q2;
if not, a material characteristic classification database is established for the materials belonging to the newly added materials, the established material characteristic classification database is added into a pre-established classification database set, and then the step Q2 is executed;
step Q2, determining each material characteristic classification database of the newly added material in the classification database set;
and step Q3, adding the material number of the newly added material into each determined material characteristic classification database.
As an exemplary embodiment of the present invention, the method for creating the material characteristic classification database for the class material of the newly added material in step Q1 includes:
inputting a first-level material classification rule which is designed for a target material in advance, wherein the target material is a material to which the newly added material belongs; the primary material classification rule is a group of material attribute information of the target material which is specified in advance;
correspondingly constructing corresponding material characteristic classification databases (all marked as primary classification databases) for each material attribute information contained in the input primary material classification rules;
and adding all the constructed material characteristic classification databases into the classification database set.
As an exemplary embodiment of the present invention, the implementation method of step Q2 is:
acquiring all material attribute information of the newly added material from the PLM system;
and searching all material characteristic classification databases related to the acquired material attribute information of the newly added material from the classification library set to obtain each material characteristic classification database of the newly added material in the classification library set.
As an exemplary embodiment of the present invention, the material classifying method further includes: and adding a material characteristic classification database. In this embodiment, the adding step of the material characteristic classification database specifically includes:
adding a first-level material classification rule of a specified material;
constructing a material characteristic classification database for the specified materials according to the primary material classification rule of the added specified materials to obtain a newly added material characteristic classification database of the corresponding quantity of the specified materials;
acquiring material attribute information of each material belonging to the specified class of materials in the BOM;
determining the materials belonging to the specified materials in the BOM corresponding to each newly added material characteristic classification database based on the material attribute information of each material belonging to the specified materials in the obtained BOM;
writing the determined material number of each material into a corresponding newly added material characteristic classification database;
and adding all newly added material characteristic classification databases obtained after writing the material numbers of all the determined materials into the classification database set.
The specified material in the present invention is a certain material in the BOM to be subjected to the related operation, for example, a "hard disk" material in the BOM, a "CPU" hard disk material, or any other material in the BOM, and may be specifically selected by a person skilled in the art according to actual situations.
The adding step of the material characteristic classification database can be repeatedly executed, and each execution can be carried out by a person skilled in the art to select a certain type of material in the BOM as a specified type of material according to actual conditions.
The added first-level material classification rule of the specified material is composed of at least one piece of material attribute information of the specified material selected in advance, and can be specifically set by a person skilled in the art according to actual needs.
As an exemplary embodiment of the present invention, the material classifying method further includes: OD relation limits and pass steps. Specifically, the OD relationship limiting and transferring step includes:
adding each related material characteristic classification database which is selected from the classification library set in advance and used for OD relation limitation and transmission in BOM;
adding preset upgraded material classification rules, wherein the upgraded material classification rules are database operation rules;
performing database operation on each added material characteristic classification database by using the added upgraded material classification rule to obtain a corresponding number of newly added material characteristic classification databases;
and adding all the obtained newly added material characteristic classification databases into the classification database set.
In order to facilitate understanding of the present invention, the material classification method provided by the present invention is further described below by using the principle of the material classification method of the present invention and combining with the process of classifying the newly added material when the PLM system creates a new modular BOM.
Specifically, the material classification method comprises the following steps:
s1, receiving the newly added material, and judging whether the newly added material has the same kind of material in the BOM of the newly added material, if so, continuing to execute the step S2; if not, a material characteristic classification database is created for the material to which the newly added material belongs, the created material characteristic classification database is added into a pre-created classification database set, and then step S2 is executed.
All the materials in the materials of the present embodiment are similar materials.
In the concrete implementation, the implementation method for creating the material characteristic classification database for the class material of the newly added material in step S1 specifically includes:
inputting a first-level material classification rule which is designed for a target material in advance, wherein the target material is a material to which the newly added material belongs; the primary material classification rule is a group of material attribute information of the target material which is specified in advance;
correspondingly constructing a corresponding material characteristic classification database for each material attribute information contained in the input first-level material classification rule;
and adding all the constructed material characteristic classification databases into the classification database set.
For example, if there is a new material a in the newly-built modular BOM, it is first determined whether there is a similar material in the new-built modular BOM (i.e., the newly-built modular BOM), if so, the next step S2 is continuously executed, and if not, a material characteristic classification database is created for the similar materials of the new material a (all the materials in the class of materials are similar materials), and the created material characteristic classification database is added into the classification database set, and then step S2 is executed.
Wherein, the materials to which the added materials belong can be confirmed by the technicians in the field according to the prior art. For example, if the newly added material a is a hard disk a, the material to which the newly added material a belongs is a "hard disk"; and for example, if the newly added material A is the memory B, the material belonging to the newly added material A is the memory.
When the method is realized, a classification library set is established for the BOM in advance.
And step S2, determining each material characteristic classification database of the newly added material in the classification database set.
In a specific implementation, the implementation method of step S2 is:
acquiring all material attribute information of the newly added material from the PLM system;
and searching all material characteristic classification databases related to the acquired material attribute information of the newly added material from the classification library set to obtain each material characteristic classification database of the newly added material in the classification library set.
Taking the newly added material as the hard disk a for example, the class material of the hard disk a is a "hard disk", and after the step S2 is executed, each material characteristic classification database to which the newly added material a belongs in the classification database set is determined, that is, for the hard disk a (newly added material), each material characteristic classification database determined after the step S2 is executed contains at least one material attribute information of the newly added material a.
And step S3, adding the material number of the newly added material into each determined material characteristic classification database.
Taking the newly added material as the hard disk a as an example, assuming that three material characteristic classification databases to which the newly added material "hard disk a" belongs in the classification database set are determined in step S2, after step S3 is executed, the material numbers of the hard disk a are stored in the three determined material characteristic classification databases.
In this embodiment, the method for classifying materials further includes step S4: and adding a material characteristic classification database. This step S4 is independent of the above-described steps S1 to S3. The skilled person can perform step S4 when the material characteristic classification database needs to be supplemented according to actual needs.
In a specific implementation, the implementation method of step S4 is:
adding a first-level material classification rule of a specified material;
constructing a material characteristic classification database for the specified materials according to the primary material classification rule of the added specified materials to obtain a newly added material characteristic classification database of the corresponding quantity of the specified materials;
acquiring material attribute information of each material belonging to the specified class of materials in the BOM;
determining the materials belonging to the specified materials in the BOM corresponding to each newly added material characteristic classification database based on the material attribute information of each material belonging to the specified materials in the obtained BOM;
writing the determined material number of each material into a corresponding newly added material characteristic classification database;
and adding all newly added material characteristic classification databases obtained after writing the material numbers of all the determined materials into the classification database set.
The method comprises the following steps of establishing a material characteristic classification database for the specified materials according to the added first-level material classification rules of the specified materials, wherein the specific implementation method comprises the following steps:
and correspondingly constructing a material characteristic classification database of the specified materials for each material attribute information contained in the primary material classification rule of the added specified materials.
In this embodiment, the method for classifying materials further includes step S5: OD relation limits and pass steps. This step S5 is independent of the above-described steps S4 and S1 to S3. The skilled person can choose to execute step S5 when it is necessary to increase the limitation and transmission of the OD relationship according to actual needs.
In a specific implementation, the implementation method of step S5 is:
step S51, adding each relevant material characteristic classification database which is selected from the classification database set in advance and used for OD relation limitation and transmission in BOM;
step S52, adding preset upgraded material classification rules which are database operation rules;
step S53, performing database operation on each added material characteristic classification database by using the added upgraded material classification rule to obtain a corresponding number of newly added material characteristic classification databases;
and step S54, adding all the obtained newly added material characteristic classification databases into the classification database set.
The upgraded material classification rules referred to in this specification are composed of intersection, union or complement of databases. The specific implementation can be set by those skilled in the art according to actual needs.
In this embodiment, the upgraded material classification rule may include a second-level material classification rule, a third-level material classification rule, a fourth-level material classification rule, a. Wherein:
the secondary material classification rule represents that every two of all the primary classification libraries input in the step S51 are crossed and combined or supplemented; material characteristic classification databases established based on the secondary material classification rules are recorded as secondary classification databases;
the third-level material classification rule represents the intersection, the union or the supplement of the second-level classification library and the first-level classification library input in the step S51; material characteristic classification databases established based on the three-level material classification rules are recorded as three-level classification databases;
the fourth-level material classification rule represents the intersection, the union or the supplement of the third-level classification library and the second-level classification library input in the step S51;
and so on,
the N-level material classification rule represents the intersection, union or complement of the N-1-level classification library and the N-2-level classification library input in the step S51.
The material characteristic classification databases constructed by the material attribute information included in the first-level material classification rule referred in the specification are the first-level classification databases.
For example, the value of N may be 4, and when the method is used in detail, the step S5 may be repeatedly executed to perform OD relationship restriction and transmission, for example, the step S5 may be executed once to obtain the secondary classification library, the step S5 may be executed once again to obtain the tertiary classification library, and the step S5 may be executed once again to obtain the quaternary classification library. N referred to in this specification is an integer having a value greater than 1.
For example, when the secondary classification library is obtained in step S5, the step S5 is executed as follows:
adding each relevant primary classification library which is selected from the classification library set in advance and is used for OD relation limitation and transmission in the BOM;
adding a preset secondary material classification rule;
performing database operation on each added material characteristic classification database by using the added secondary material classification rule to obtain a corresponding number of newly added material characteristic classification databases (namely the obtained secondary classification databases);
and adding all the obtained newly added material characteristic classification databases into the classification database set.
For example, when the step S5 is used to obtain three-level classification libraries, the step S5 is executed as follows:
adding each relevant primary classification library and secondary classification library which are selected from the classification library set in advance and used for OD relation limitation and transmission in BOM;
adding a preset three-level material classification rule;
performing database operation on each added relevant primary classification library and secondary classification library by using the added three-level material classification rules to obtain a corresponding number of newly added material characteristic classification databases (namely the obtained three-level classification libraries);
and adding all the obtained newly added material characteristic classification databases into the classification database set.
The four-level classification library can be acquired by referring to the three-level classification library.
The invention also provides a material matching method based on the material classification method in each aspect, the material matching method is applied to an ERP system and is based on a PLM system, the PLM system adopts the material classification method to classify each newly added material in the BOM in advance, and a material characteristic classification database corresponding to each material in the BOM is obtained;
the material matching method comprises the following steps:
receiving a material option which is marked with auxiliary materials in a PLM system in advance and is transmitted upwards;
receiving auxiliary material screening OD conditions which are filled in a PLM system in advance and transmitted upwards;
receiving a bill of materials to be selected from the PLM system;
screening OD conditions and material options according to the received auxiliary materials, and carrying out material matching on each material on the bill of materials;
when a target material on the bill of materials is selected and matched, a material characteristic classification database where the target material is located is searched and returned to the PLM system; the PLM system searches corresponding material classification rules based on the received material characteristic classification database, searches materials corresponding to the material classification rules preset for the material options corresponding to the target materials from each material characteristic classification database of the target materials returned from the ERP system according to the searched material classification rules and the material classification rules preset for the material options corresponding to the target materials, the searched materials are required auxiliary materials, and the material numbers of the auxiliary materials are returned to the ERP system; the target material is a material under the selected material option with a label;
and correspondingly receiving the material number fed back by the PLM system, and adding the material number into the bill of materials.
Fig. 2 is an embodiment of the material classifying system according to the present invention, which is applied to a PLM system.
As shown in fig. 2, the system 100 includes a first module 101, a second module 102, and a third module 103. Wherein:
the first module 101 is configured to receive a newly added material, determine whether the newly added material has a similar material in the BOM to which the newly added material belongs, call the second module if the determination result is yes, create a material characteristic classification database for the material belonging to the newly added material if the determination result is no, add the created material characteristic classification database to a pre-created classification library set, and then call the second module 102.
A second module 102, configured to determine each material characteristic classification database to which the newly added material belongs in the classification database set;
and a third module 103, configured to add the material number of the newly added material to each determined material characteristic classification database.
As an exemplary embodiment of the present invention, the first module 101 includes a first unit, and the first unit is configured to create a material characteristic classification database for the material belonging to the newly added material.
Specifically, the first unit includes:
the input module is used for inputting a primary material classification rule which is designed for a target material in advance, wherein the target material is a material to which the newly added material belongs; the primary material classification rule is a group of material attribute information of a preselected target material;
the first classification library construction module is used for correspondingly constructing a corresponding material characteristic classification database for each material attribute information contained in the input first-level material classification rule;
and the first classification library supplementing module is used for adding all the material characteristic classification databases constructed by the first classification library constructing module into the classification library set.
As an exemplary embodiment of the present invention, the material classification system further includes a second unit, and the second unit is used for adding a material characteristic classification database.
Specifically, the second unit includes:
the first adding module is used for adding a first-level material classification rule of a specified material;
the second classification library construction module is used for constructing a material characteristic classification database for the specified materials according to the added first-level material classification rules of the specified materials to obtain a newly-added material characteristic classification database with the corresponding quantity of the specified materials;
the target material attribute information acquisition module is used for acquiring material attribute information of each material belonging to the specified class of materials in the BOM;
the associated material acquisition module is used for determining the materials belonging to the specified materials in the BOM corresponding to each newly added material characteristic classification database based on the material attribute information of each material belonging to the specified materials in the acquired BOM;
a material number writing module, which is used for writing the determined material number of each material into the respective corresponding newly added material characteristic classification database;
and the second classification library supplementing module is used for adding all newly added material characteristic classification databases obtained after the material numbers of all the determined materials are written into the classification library set.
As an exemplary embodiment of the present invention, the material sorting system further comprises a third unit for limitation and transfer of OD relations.
Specifically, the third unit includes:
the second adding module is used for adding each related material characteristic classification database which is selected from the classification database set in advance and used for OD relation limitation and transmission in BOM;
the third adding module is used for adding preset upgraded material classification rules, and the upgraded material classification rules are database operation rules;
the operation module is used for performing database operation on each added material characteristic classification database by using the added upgraded material classification rule to obtain a corresponding number of newly added material characteristic classification databases;
and the third classification library supplementing module is used for adding all the obtained newly added material characteristic classification databases into the classification library set.
The invention also provides a material matching system based on the material classification system in each embodiment, which is applied to an ERP system and is based on a PLM system;
the PLM system is integrated with the material classification system, and the PLM system adopts the material classification system to classify each newly added material in the BOM of the system in advance to obtain a material characteristic classification database corresponding to each material in the BOM;
the PLM system is also integrated with a marking module, a bill of materials uploading module and an auxiliary material screening OD condition input module, wherein:
the marking module is used for marking the material options with the auxiliary materials and sending the marked material options to the ERP system;
the auxiliary material screening OD condition input module is used for inputting auxiliary material screening OD conditions corresponding to the bill of materials of the materials to be selected and uploading the input auxiliary material screening OD conditions to the ERP system;
the material list uploading module is used for uploading a material list of materials to be selected to the ERP system;
the material OD limit relation transfer system comprises:
the first data receiving module is used for receiving all related contents transmitted by the marking module, the auxiliary material screening OD condition input module and the bill of material uploading module;
and the matching module is used for screening OD conditions and material options according to the received auxiliary materials and performing material matching on each material in the bill of materials.
Wherein the matching module, when matching the target material on the bill of materials, is configured to perform the following steps:
searching a material characteristic classification database of the target material and returning the material characteristic classification database to the PLM system; the target material is a material under the selected material option with a label;
correspondingly receiving the material number fed back by the PLM system, and adding the material number into the bill of materials;
when the PLM system receives a material characteristic classification database of a target material returned by the ERP system, the PLM system searches a corresponding material classification rule based on the received material characteristic classification database, searches a material corresponding to the material classification rule preset for the material option corresponding to the target material from each material characteristic classification database of the target material returned by the ERP system according to the searched material classification rule and the material classification rule preset for the material option corresponding to the target material, the searched material is a required auxiliary material, and the material number of the searched auxiliary material is returned to the ERP system.
In summary, when the material is newly added to the BOM in the PLM, the present invention can automatically add the material number of the material to the corresponding classification library, and is helpful for transmitting the OD relationship through the restriction between the classification library and the classification library when the ERP system selects and matches the material, and performing the relationship restriction on the material, so as to achieve the effect of restricting the wrong selection and matching and bringing out the correct material, reduce the maintenance work on the BOM when updating the auxiliary material of the selected and matched material, improve the efficiency, reduce the human intervention, reduce the probability of error, be helpful for improving the efficiency of the selection and matching at the sale end and the production at the factory end, avoid the repeated communication and confirmation due to the addition error, and be further helpful for improving the first production rate.
Although the present invention has been described in detail by referring to the drawings in connection with the preferred embodiments, the present invention is not limited thereto. Various equivalent modifications or substitutions can be made on the embodiments of the present invention by those skilled in the art without departing from the spirit and scope of the present invention, and these modifications or substitutions are within the scope of the present invention/any person skilled in the art can easily conceive of the changes or substitutions within the technical scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.
