Method for releasing BOM from PDM system to ERP systemTechnical Field
The invention belongs to the technical field of information management, and particularly relates to a method for releasing BOM from a PDM system to an ERP system.
Background
BOM is an important basic data in the automobile manufacturing industry, covers the processes of product design, production, manufacture, sales and the like, and is a tie for connecting all departments of design, production, sales and the like. EBOM and PBOM are products at different stages of the full life cycle of a product, and are organic integers associated with each other. However, at present, the EBOM is maintained in a PDM system by a product department, the PBOM is maintained in an ERP system by a manufacturing department, the two systems are not in butt joint, and data such as parts, structures, configurations, change orders and the like in the EBOM are required to be transmitted outside the system, so that BOM data is repeatedly maintained, the efficiency is low, errors are easy to occur, and the development progress and the market competitiveness of the product are seriously affected. The data path of product design and production manufacture is opened, and the connection between the PDM system and the ERP system is realized, which is a problem that an enterprise must solve.
Disclosure of Invention
The technical problem to be solved by the invention is to overcome the defects of the prior art, and provide a method for releasing BOM from a PDM system to an ERP system, wherein the automatic transfer of BOM data from a product design stage to a manufacturing production stage is realized by establishing a part classification, generating a quasi-route library and developing an intermediate IMS system, so that the workload of BOM data maintenance is greatly reduced, and the working efficiency and the accuracy are improved.
The invention provides a method for releasing BOM from PDM system to ERP system, comprising the following steps:
s1, classifying a whole vehicle FDP, a product part, a drawing number, a CAD part and a DMU part by using different object types according to part classification standards in a PDM system;
step S2, a production preparation route library is established in the PDM system, corresponding production preparation route codes are distributed for each factory and purchase, and material groups, purchase types, factories, places and homemade/purchased attributes corresponding to each production preparation route in the ERP system are defined;
s3, building a whole vehicle and a part BOM in a PDM system, configuring options, and maintaining a production preparation route for each part in the BOM;
s4, after the BOM is finished, the BOM and related data are distributed to an intermediate interface system IMS through a whole vehicle CID list and a part PID list;
s5, the IMS receives the whole vehicle configuration characteristic value, the change list, the parts, the whole vehicle primary BOM and the device primary BOM issued by the PDM system, the IMS judges whether the received vehicle type CID list or the part PID list, if the received vehicle type CID list is the vehicle type CID list, the IMS firstly acquires the configuration characteristic group on the FDP, compares the characteristic value of the characteristic group with the former edition data, and detects whether the new increase exists; if the part PID list is the part PID list, judging whether the part is modified by the BOM or the part, and sending the part PID list to a corresponding factory in the ERP system after finishing classification processing;
and S6, the manufacturing department views the factory data through the ERP system.
As a further technical scheme of the invention, in step S5, when the ERP system judges that the received vehicle type CID list is received, firstly, the configuration feature group on the FDP is obtained, the feature value of the feature group is compared with the previous version data, whether the feature value of the feature group is newly increased is checked, if yes, the feature group is processed according to the logic of the configuration transfer module and the result is sent to the ERP system, if the FDP is modified by the primary device BOM, the BOM processing module is selected and invoked according to the purchasing/self-made attribute in the part generation route for processing, and the change list related to the BOM and the part basic information are processed simultaneously during BOM processing and the result is sent to the ERP system.
Further, in step S5, when the ERP system determines that the received part PID list is part PID list, it determines whether the received part PID list is part PID list or part PID list, if the received part PID list is part PID list, it determines whether the received part PID list is self-made part or purchase part, if the received part PID list is part PID list, it does not transfer the received part PID list to the ERP system, and if the received part PID list is part PID list, it transfers the received part PID list to the ERP system, if the received part PID list is part PID list, it compares the received part PID list with a previous BOM structure to obtain a modified content, determines processing logic according to a purchase/self-made attribute of a part in the BOM, and sends the processed part PID list and part PID list to the ERP system.
Further, the business logic processing of the whole vehicle characteristic value in the step S5 includes the following steps:
s511, receiving change order information from the PDM;
s512, judging whether the vehicle CID is of a single type, if not, not processing the vehicle characteristic value;
s513, acquiring all FDP part numbers, version numbers, configuration option codes, configuration code names, configuration option value codes and configuration option value name information in the CID list of the whole vehicle, and sequentially processing the FDP part numbers, the version numbers, the configuration option codes, the configuration option value name information;
s514, checking whether the data is the first edition, if so, writing all the configuration attribute information into an interface table, if not, comparing the data with the previous edition, and writing the added FDP part number, the version number, the configuration option code, the configuration code name, the configuration option value code and the configuration option value name into the interface table;
s515, after all FDPs in the vehicle type CID list are processed, information is written into an interface transmission table and is sent to a whole vehicle factory of the ERP system.
Further, the business logic processing of the BOM data in step S5 includes the following steps:
s521, acquiring change order data from the PDM;
s522, judging whether the type of the change list is a whole vehicle CID list or a part PID list;
s523, if the vehicle CID list is the vehicle CID list, reading the vehicle FDP part number, the lower BOM structure and the sub-part information; reading variable condition information on the FDP, the lower BOM and the sub-parts of the whole vehicle; checking whether the FDP of the whole vehicle is the first edition of data, if so, sending BOM structure and sub-part information to an interface table; if not, comparing the BOM data of the version with the BOM data of the previous version to obtain BOM modified content; writing an interface table;
s524, the IMS system sends the processed BOM data to the ERP system, and the BOM structure of the whole vehicle FDP is sent to a whole vehicle factory of the ERP system by default;
s525, if the PID list is a component PID list, firstly reading a component production preparation route in the PID list, acquiring self-made/purchased, factory, material type, purchase type and virtual component identification information of the component, filtering out the self-made component in the production preparation route, reading a lower BOM structure of the component, and filtering out all CAD components, drawings and DMU components in the EBOM according to the classification of the component;
s526, judging whether the BOM of the part is the first version, if so, writing all the BOM into the interface table, if not, comparing the BOM structures of the second version and the previous version to obtain BOM modified content, and writing information into the interface table;
s527, the IMS system sends the BOM structure of each self-made part to a corresponding factory of the ERP system according to factory information of the part production preparation route.
Further, the business logic processing of the material basic data in step S5 includes the following steps:
and receiving a part number list transmitted by the BOM processing module, acquiring the part number, the version number, the material type, the basic measurement unit, the name, the material group, the self-made/purchased, the virtual part identifier, the imported part identifier, the color part identifier, the standard part identifier and other attributes of each part, and transmitting the attributes to corresponding factories in the ERP system with the BOM.
Further, the service logic processing of the change order delivery module in step S5 includes the following steps:
s531, receiving change order information transmitted by the BOM processing module;
s532, acquiring a change list number, a change list item number, a corresponding designer, a design unit, a change description, a BOM father material version number, change classification and associated change information of the whole vehicle CID list and the part PID list according to the change list number;
s533, the change list information is sent to corresponding factories in the ERP system according to the factories corresponding to each BOM parent material.
According to the method, the BOM, the parts, the whole vehicle configuration, the change list and other data in the PDM are automatically released to each factory in the ERP system, so that the docking of the BOM data of the PDM system and the ERP system is realized, a BOM data path designed to production is opened, and the PBOM data maintenance efficiency and accuracy in the ERP system are greatly improved.
Drawings
FIG. 1 is a flow chart of BOM processing business logic.
Detailed Description
Referring to fig. 1, the present embodiment provides a method for publishing a BOM from a PDM system to an ERP system, as shown in fig. 1, the method includes the following steps:
s1, classifying a whole vehicle FDP, a product part, a drawing number, a CAD part and a DMU part by using different object types according to part classification standards in a PDM system;
step S2, a production preparation route library is established in the PDM system, corresponding production preparation route codes are distributed for each factory and purchase, and material groups, purchase types, factories, places and homemade/purchased attributes corresponding to each production preparation route in the ERP system are defined;
s3, building a whole vehicle and a part BOM in a PDM system, configuring options, and maintaining a production preparation route for each part in the BOM;
s4, after the BOM is finished, the BOM and related data are distributed to an intermediate interface system IMS through a whole vehicle CID list and a part PID list;
s5, the IMS receives the whole vehicle configuration characteristic value, the change list, the parts, the whole vehicle primary BOM and the device primary BOM issued by the PDM system, the IMS judges whether the received vehicle type CID list or the part PID list, if the received vehicle type CID list is the vehicle type CID list, the IMS firstly acquires the configuration characteristic group on the FDP, compares the characteristic value of the characteristic group with the former edition data, and detects whether the new increase exists; if the part PID list is the part PID list, judging whether the part is modified by the BOM or the part, and sending the part PID list to a corresponding factory in the ERP system after finishing classification processing;
and S6, the manufacturing department views the factory data through the ERP system.
In step S5, when the ERP system determines that the received vehicle type CID sheet is a vehicle type CID sheet, the configuration feature set on the FDP is obtained first, the feature values of the feature set are compared with the previous data, whether the feature value of the feature set is newly added is checked, if yes, the configuration transfer module logic is used for processing and sending the result to the ERP system, if the FDP has a primary device BOM modified, the BOM processing module is used for processing according to the purchase/self-made attribute selection in the part generation route, and when the BOM processing is performed, the change sheet and the part basic information related to the BOM are processed at the same time and the result is sent to the ERP system.
The specific implementation of each step is as follows,
in step S1, the design engineer needs to determine the class of each part when creating the part in the PDM, the class table is shown in table 1,
TABLE 1 part Classification Table
In step S2, the quasi-engineer creates quasi-route criteria, and sets quasi-routes for each part object in the PDM, and the quasi-routes and the criteria are shown in table 2.
TABLE 2 preparation routes and Standard sample tables
In step S3, the engineer creates a P6F vehicle BOM, configuration options, and a quasi-route in the PDM, and issues the same using the vehicle CID sheet E00112, as shown in tables 3 and 4.
TABLE 3 Whole vehicle CID Single E00112 release Table (1)
| Option codes | Option name | Option value code | Option value name |
| VE | Product series | P6 | XXXX model |
| US | Product sub-series | F | XX series |
| EG | Engine with a motor | M2 | X1 type engine |
| | C1 | X2 type engine |
| | C2 | X3 type engine |
| JBN00 | Air conditioning system | 76997 | 10kw with post-steaming |
| | 76950 | 8kw with post-steaming |
| … | … | … | … |
TABLE 4 Whole vehicle CID Single E00112 release Table (2)
In step S4, the intermediate system IMS receives the CID list of the whole vehicle issued by the PDM, reads the version number of the configuration information of the model P6F A, and issues all the configuration data to the whole vehicle factory, wherein the 001 version is indicated as the initial version.
In step S5, the version of P6F is checked to be 001 version, and information such as sub-components, usage, variable conditions and the like of P6F is obtained as the first version BOM data and sent to the whole vehicle factory of the ERP system.
In step S6, the part number list and the generating route of the P6F and the sub parts are received, and the part number, the version number, the material type, the measuring unit, the name, the material group, the homemade/purchased, the virtual part identifier, the import part identifier, the color part identifier, the standard part identifier and other attributes of each part are obtained and sent to the whole factory of the ERP system.
In step S7, the information of the change order E00112 is received, and the change order number, the change order entry number, the corresponding designer, the design unit, the change description, the BOM parent material version number, the change classification, and the associated change information are obtained. And obtaining the generating and standard route of the P6F as a general assembly, and sending E00112-0002 change order information to a whole vehicle factory in the ERP system.
In step S8, the engineer issues 3 assemblies using the part PID list, part number, BOM structure, change list number as shown in table 5,
table 5, parts PID list issues change information table
Step S9, the IMS system reads the part generation and approval route in the PID list, and acquires the self-control/purchase, factory, material type, purchase type and virtual part identification information of the part. 1011 engine assemblies, 2010 air conditioner assembly generating route is self-made assembly, reads subordinate BOM structure, 2030 condenser assembly is purchase piece then BOM structure need not issue to ERP system.
And step S10, only the types of parts required by the ERP system are reserved according to the part classification standard, and the IMS system filters CAD01 parts in the BOM detail of the 1011 engine assembly.
In step S11, 1011 the version numbers of the engine assembly and 2010 the air conditioning assembly are 001, and are the first version. And writing the information of the change list number, the change list type, the change list item number, the father material number, the son material number, the consumption, the search number and the operation code (newly added, deleted and modified) into the interface table.
In step S12, 1011 the engine assembly generating route is "F1 engine 1, assembly 0", and the system sends BOM data to the F1 engine factory. And 2010, sending BOM data to the whole vehicle factory when the quasi-route of the air conditioner assembly is 'assembly'.
And S13, reading the attributes of the 1011 engine assembly and the lower sub-components, such as the part numbers, the version numbers, the material types, the basic measurement units, the names, the material groups, the self-control/purchase, the virtual part identifiers, the inlet part identifiers, the color part identifiers, the standard part identifiers and the like, and sending the attributes to the F1 engine factory, wherein the cross-factory identifiers exist in the generating route of the 1011 engine assembly, so that the part numbers and the attribute information of the 1011 engine parts are simultaneously sent to the whole vehicle factory. And reading 2010 the attributes such as the part numbers, version numbers, material types, basic measuring units, names, material groups, self-made/purchased parts, virtual part identifiers, import part identifiers, color part identifiers, standard part identifiers and the like of the air conditioner assemblies and lower-level sub-parts, and sending the attributes to a whole vehicle factory in the ERP system.
Step S14, obtaining the change list number, the change list item number, the corresponding designer, the design unit, the change description, the BOM father material version number, the change classification and the associated change information of the PID list of the parts P00110 and P00112. And respectively transmitting the P00110 part PID list to a whole vehicle factory and an F1 engine factory in the ERP system according to the generating standard route of the 1011 engine assembly, and transmitting the P00112 part PID list to the whole vehicle factory in the ERP system according to the generating standard route of the 2010 air conditioner assembly.
In step S15, the manufacturing engineer of each factory checks the BOM data issued to each factory by the PDM in the ERP system, and accordingly performs the PBOM maintenance work.
According to the embodiment, the BOM, the parts, the whole vehicle configuration, the change list and other data in the PDM are automatically released to each factory in the ERP system, so that the docking of the BOM data of the PDM system and the ERP system is realized, a BOM data path designed to production is opened, and the PBOM data maintenance efficiency and accuracy in the ERP system are greatly improved.
The foregoing has shown and described the basic principles, principal features and advantages of the invention. It will be understood by those skilled in the art that the present invention is not limited to the specific embodiments described above, and that the above specific embodiments and descriptions are provided for further illustration of the principles of the present invention, and that various changes and modifications may be made therein without departing from the spirit and scope of the invention as defined in the appended claims. The scope of the invention is defined by the claims and their equivalents.