CN110659866A - Method for releasing BOM from PDM system to ERP system - Google Patents

Abstract

A BOM is released from PDM system to ERP system method, classify different object types according to the part classification standard in PDM system at first; then establishing a production preparation route library, distributing production preparation route codes, and defining corresponding information of each production preparation route in the ERP system; building a BOM (bill of materials) of the whole vehicle and parts in a PDM (product data management) system, configuring options, and maintaining a production preparation route for each part in the BOM; after the BOM is finished, the BOM and related data are issued to an intermediate interface system IMS through a finished vehicle CID list and a part PID list; the IMS receives the information issued by the PDM system, judges whether a vehicle model CID list or a part PID list is received by the IMS system, and sends the vehicle model CID list or the part PID list to a corresponding factory in the ERP system after classification processing is finished. According to the method, the BOM data is automatically transmitted from a product design stage to a manufacturing and production stage by establishing the part classification, the generation and preparation route library and developing the intermediate IMS system, so that the workload of BOM data maintenance is greatly reduced, and the working efficiency and the accuracy are improved.

Description

Method for releasing BOM from PDM system to ERP system

Technical 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, manufacturing, sale and the like, and is a link for connecting various departments of design, production, sale and the like. The EBOM and the PBOM are products at different stages in the whole life cycle of the products and are organic integers which are related to each other. However, currently, the EBOM is maintained in the PDM system by the product department, the PBOM is maintained in the ERP system by the manufacturing department, the two systems are not connected, and data such as parts, structures, configurations, change lists and the like in the EBOM need to be transmitted outside the system, so that the BOM data is repeatedly maintained, the efficiency is low, errors are easy to occur, and the product development progress and the market competitiveness are seriously affected. The problem that an enterprise must solve is to get through a data path between product design and production and manufacture and realize the connection between a PDM system and an ERP system.

Disclosure of Invention

The invention aims to overcome the defects of the prior art and provide a method for releasing BOM from a PDM system to an ERP system, which realizes the automatic transmission of BOM data from a product design stage to a manufacturing production stage by establishing part classification, a production-level route library and developing an intermediate IMS system, thereby greatly reducing the workload of BOM data maintenance and improving the working efficiency and the accuracy.

The invention provides a method for releasing BOM from a PDM system to an ERP system, which comprises the following steps:

step S1, classifying the FDP, the product parts, the drawing numbers, the CAD pieces and the DMU pieces of the whole vehicle by using different object types according to the part classification standard in the 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 and places and self-making/purchasing attributes corresponding to each production preparation route in the ERP system are defined;

s3, building a BOM of the whole vehicle and parts in the PDM system, configuring options, and maintaining a production preparation route for each part in the BOM;

step S4, after BOM is finished, the BOM and related data are issued to the intermediate interface system IMS through the whole vehicle CID list and the part PID list;

step S5, IMS receives the whole vehicle configuration characteristic value, the change list, the parts, the whole vehicle first-level BOM and the device-level BOM issued by the PDM system, the IMS system judges whether the received vehicle type CID list or the part PID list is the vehicle type CID list, if the received vehicle type CID list is the vehicle type CID list, the IMS system firstly obtains the configuration characteristic group on the FDP, compares the characteristic value of the characteristic group with the front version data, and detects whether the new addition exists; if the part is a PID (proportion integration differentiation) sheet, whether the part is BOM modified or part modified is judged, and the part is sent to a corresponding factory in the ERP system after classification processing is finished;

and step S6, the manufacturing department checks the data of each factory through the ERP system.

As a further technical solution of the present invention, in step S5, when the ERP system determines that the received vehicle type CID list is a vehicle type CID list, the ERP system first obtains a configuration feature group on the FDP, compares a feature value of the feature group with the front version data, checks whether there is a new feature value of the feature group, if there is a new feature value of the feature group, processes according to the configuration transfer module logic and sends a result to the ERP system, if there is a modification of the BOM of the first-level device in the FDP, selects to call the BOM processing module according to the procurement/homemade attribute in the component production route for processing, and processes the change list and the component basic information related to the BOM and sends the result to the ERP system at the same time during BOM processing.

Further, in step S5, when the ERP system determines that the received part PID is a part PID list, it determines whether the part is a BOM modification or a part modification, if the part is a part modification, it determines whether the part is a self-manufactured part or a purchased part, if the part is a purchased part, the part is not transmitted to the ERP system, if the part is a self-manufactured part, a basic part information transmission module is called to transmit the part basic information to the ERP system, if the part is a BOM modification, the part basic information transmission module is compared with a previous version of the BOM structure to obtain a modification content, a processing logic is determined according to the purchase/self-manufacture attribute of the part in the BOM, and the processing logic and the basic part information related to the BOM.

Further, the service logic processing of the vehicle characteristic value in step S5 includes the following steps:

s511, receiving change list information from the PDM;

s512, judging whether the vehicle CID single type exists or not, and 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 finished automobile CID list, and sequentially processing;

s514, checking whether the data is the first version data, if so, writing all the configuration attribute information into the interface table, and if not, comparing the configuration attribute information with the previous version, and writing the added FDP part number, version number, configuration option code, configuration code name, configuration option value code and configuration option value name into the interface table;

and S515, after all FDPs in the vehicle type CID list are processed, writing the information into an interface transmission table and sending the information 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 finished automobile CID list or a part PID list;

s523, if the finished automobile CID list is obtained, reading the finished automobile FDP part number, the lower BOM structure and the information of the sub-parts; reading variable condition information on the FDP of the whole vehicle, the lower BOM and the sub-parts; checking whether the FDP of the whole vehicle is the first version data, if so, sending BOM structure and sub-component information to an interface table; if not, comparing the version of BOM data with the previous version of BOM data to obtain BOM modification content; writing the interface table;

s524, the IMS system sends the processed BOM data to an ERP system, and the BOM structure of the complete vehicle FDP is sent to a complete vehicle factory of the ERP system by default;

s525, if the part PID list is the part production preparation route, firstly reading the part production preparation route in the PID list, acquiring self-making/purchasing, factory, material type, purchasing type and virtual part identification information of the part, then filtering the self-made part in the production preparation route, reading a lower BOM structure of the part, and completely filtering CAD parts, drawings and DMU parts in the EBOM according to the classification of the part;

s526, judging whether the BOM of the part is the first version, if so, writing all the BOM into an interface table, if not, comparing the BOM structures of the secondary version and the previous version to obtain BOM modification content, and writing information into the interface table;

and S527, the IMS system sends the BOM structure of each self-made part to a corresponding factory of the ERP system according to the 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 attributes of each part, such as part number, version number, material type, basic metering unit, name, material group, self-making/purchasing, virtual part identification, inlet part identification, color part identification, standard part identification and the like, and transmitting the attributes and the BOM to a corresponding factory in the ERP system.

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 order number, a change order entry number, a corresponding designer, a design unit, a change description, a BOM parent material version number, a change classification and associated change information of the finished vehicle CID list and the part PID list according to the change order number;

and S533, sending the change order information to the corresponding factory in the ERP system according to the factory corresponding to each BOM parent material.

The method automatically releases the data of the BOM, the parts, the whole vehicle configuration, the change order and the like in the PDM to each factory in the ERP system, realizes the butt joint of the BOM data of the PDM system and the ERP system, opens a designed to-be-produced BOM data path, and greatly improves the PBOM data maintenance efficiency and the accuracy in the ERP system.

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 releasing a BOM from a PDM system to an ERP system, as shown in fig. 1, the method includes the following steps:

step S1, classifying the FDP, the product parts, the drawing numbers, the CAD pieces and the DMU pieces of the whole vehicle by using different object types according to the part classification standard in the 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 and places and self-making/purchasing attributes corresponding to each production preparation route in the ERP system are defined;

s3, building a BOM of the whole vehicle and parts in the PDM system, configuring options, and maintaining a production preparation route for each part in the BOM;

step S4, after BOM is finished, the BOM and related data are issued to the intermediate interface system IMS through the whole vehicle CID list and the part PID list;

step S5, IMS receives the whole vehicle configuration characteristic value, the change list, the parts, the whole vehicle first-level BOM and the device-level BOM issued by the PDM system, the IMS system judges whether the received vehicle type CID list or the part PID list is the vehicle type CID list, if the received vehicle type CID list is the vehicle type CID list, the IMS system firstly obtains the configuration characteristic group on the FDP, compares the characteristic value of the characteristic group with the front version data, and detects whether the new addition exists; if the part is a PID (proportion integration differentiation) sheet, whether the part is BOM modified or part modified is judged, and the part is sent to a corresponding factory in the ERP system after classification processing is finished;

and step S6, the manufacturing department checks the data of each factory through the ERP system.

In step S5, when the ERP system determines that the received vehicle type CID list is a vehicle type CID list, first obtaining a configuration feature group on the FDP, comparing a feature value of the feature group with the front version data, checking whether a new feature value of the feature group exists, if the new feature value exists, processing according to the configuration transfer module logic and sending a result to the ERP system, if the first-level device BOM in the FDP is modified, selecting to call the BOM processing module according to the procurement/self-made attribute in the component production route for processing, and processing the change list related to the BOM and the component basic information simultaneously and sending the result to the ERP system during BOM processing.

The specific implementation of each step is as follows,

in step S1, the design engineer needs to determine the classification of each component when creating the component in the PDM, the classification table is shown in table 1,

TABLE 1 parts classification table

In step S2, the planning engineer creates planning route standards, and sets a planning route for each component object in the PDM, where the planning route and the standard sample are shown in table 2.

TABLE 2, generation and calibration routes and Standard example Table

In step S3, the engineer creates a P6F vehicle model complete BOM, configuration options, a generation and planning route in the PDM, and issues it using a complete vehicle CID sheet E00112, as shown in tables 3 and 4.

TABLE 3 CID Single E00112 distribution table of the whole vehicle (1)

Option code	Option name	Option value code	Option value name
				VE	Product series	P6	XXXXX vehicle type
US	Product series	F	Series XX
				EG	Engine	M2	X1 type engine
		C1	X2 type engine
						C2	X3 type engine
JBN00	Air conditioning system	76997	After 10kw of beltSteaming food
						76950	8kw with after-steaming
…	…	…	…

TABLE 4 CID Single E00112 distribution table of the whole vehicle (2)

In step S4, the intermediate system IMS receives the complete vehicle CID list issued by the PDM, reads the version number of the configuration information of the P6F a vehicle type, and issues all the configuration data to the complete vehicle factory, with the version 001 being denoted as the initial version.

In step S5, the version of P6F is checked to be 001, which is the first version of BOM data, and information such as the sub-parts, the usage amount, and the variable conditions of P6F is obtained and sent to the whole car factory of the ERP system.

In step S6, the part number list and the production route of the P6F and the sub-parts are received, and attributes of each part, such as the part number, the version number, the material type, the measurement unit, the name, the material group, the self-control/purchase, the virtual part identifier, the inlet part identifier, the color part identifier, the standard part identifier, and the like are obtained and sent to the whole plant of the ERP system.

In step S7, change order E00112 information is received, and a change order number, a change order entry number, a corresponding designer, a design unit, a change description, a BOM parent material version number, a change classification, and associated change information are obtained. And (4) acquiring a production and preparation route of P6F as a total assembly, and sending the 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 sheet, the part number, BOM configuration, and change sheet number are shown in table 5,

TABLE 5 change information Table issued by part PID

Step S9, the IMS system reads the part production route in the PID list, and obtains the self-making/purchasing, factory, material type, purchasing type, and virtual part identification information of the part. 1011 engine assembly, 2010 air conditioner assembly production route are self-control assembly, read lower BOM structure, 2030 condenser assembly is the purchase piece then BOM structure need not distribute to ERP system.

And step S10, only reserving type parts required by the ERP system according to the part classification standard, and filtering CAD01 parts in the BOM specification of the 1011 engine assembly by the IMS system.

In step S11, the version numbers of the 1011 engine assembly and the 2010 air conditioner assembly are 001, both being the first version. And writing the information of the change order number, the change order type, the change order entry number, the parent material number, the child material number, the usage amount, the search number and the operation code (newly added, deleted and modified) into the interface table.

In step S12, the engine assembly generation route 1011 is "F1 Engine 1, Assembly 0", and the system sends BOM data to the F1 engine plant. 2010 the production line of the air conditioning assembly is 'final assembly', and then BOM data is sent to the whole vehicle factory.

And step S13, reading attributes of the 1011 engine assembly and the subordinate sub-parts, such as the part number, the version number, the material type, the basic metering unit, the name, the material group, the self-making/purchasing, the virtual part identifier, the inlet part identifier, the color part identifier, the standard part identifier and the like, and sending the attributes to an F1 engine plant, wherein the part number and the attribute information of the 1011 engine part are sent to the whole vehicle plant simultaneously because the cross-plant identifier exists in the production and alignment route of the 1011 engine assembly. Reading attributes of the air conditioner assembly 2010 and subordinate sub-components such as the component number, the version number, the material type, the basic metering unit, the name, the material group, self-making/purchasing, virtual component identification, inlet component identification, color component identification and standard component identification, and sending the attributes to a whole vehicle plant in the ERP system.

And step S14, acquiring 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 of the PID list of the P00110 and the P00112 parts. And respectively sending the P00110 part PID list to a whole vehicle factory and an F1 engine factory in the ERP system according to the production route of the 1011 engine assembly, and sending the P00112 part PID list to the whole vehicle factory in the ERP system according to the production route of the 2010 air-conditioning assembly.

In step S15, the manufacturing engineers in the factories view the BOM data issued by the PDM to the factories in the ERP system, and perform PBOM maintenance work accordingly.

In the embodiment, data such as the BOM, parts, vehicle configuration, change lists and the like in the PDM are automatically released to each factory in the ERP system, so that the butt joint 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 illustrates and describes the principles, general features, and advantages of the present invention. It will be understood by those skilled in the art that the present invention is not limited to the embodiments described above, which are intended to further illustrate the principles of the invention, and that various changes and modifications may be made without departing from the spirit and scope of the invention, which is intended to be protected by the appended claims. The scope of the invention is defined by the claims and their equivalents.

Claims (7)

1. A method for releasing BOM from PDM system to ERP system is characterized by comprising the following steps:

step S1, classifying the FDP, the product parts, the drawing numbers, the CAD pieces and the DMU pieces of the whole vehicle by using different object types according to the part classification standard in the 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 and places and self-making/purchasing attributes corresponding to each production preparation route in the ERP system are defined;

s3, building a BOM of the whole vehicle and parts in the PDM system, configuring options, and maintaining a production preparation route for each part in the BOM;

step S4, after BOM is finished, the BOM and related data are issued to the intermediate interface system IMS through the whole vehicle CID list and the part PID list;

step S5, IMS receives the whole vehicle configuration characteristic value, the change list, the parts, the whole vehicle first-level BOM and the device-level BOM issued by the PDM system, the IMS system judges whether the received vehicle type CID list or the part PID list is the vehicle type CID list, if the received vehicle type CID list is the vehicle type CID list, the IMS system firstly obtains the configuration characteristic group on the FDP, compares the characteristic value of the characteristic group with the front version data, and detects whether the new addition exists; if the part is a PID list, whether BOM modification or part modification is judged; after classification processing is completed, sending the data to a corresponding factory in the ERP system;

and step S6, the manufacturing department checks the data of each factory through the ERP system.

2. The method as claimed in claim 1, wherein in step S5, when the IMS system determines that the received vehicle type CID list is a vehicle type CID list, the IMS system first obtains the configuration feature set on the FDP, compares the feature value of the feature set with the previous version data, checks whether there is a new feature value of the feature set, and if there is a new feature value of the feature set, processes the new feature value according to the configuration transfer module logic and sends the result to the ERP system, and if there is a modification of the BOM of the primary device in the FDP, selects and calls the BOM processing module according to the procurement/homemade attribute in the part production route for processing, and processes the change list and the basic information of the parts related to the BOM at the same time and sends the result to the ERP system.

3. The method according to claim 1, wherein in step S5, when the IMS system determines that the received PID is a part PID list, it determines whether the part is a BOM modification or a part modification, if the part is a part modification, it determines whether the part is a self-manufactured part or a procurement part, if the part is a procurement part, the part is not transferred to the ERP system, and if the part is a self-manufactured part, the part basic information transfer module is called to transfer the part basic information to the ERP system;

and if the BOM is modified, comparing the BOM with a previous BOM structure to obtain modified contents, determining processing logic according to the purchasing/self-making attributes of the parts in the BOM, sending the processing logic to the ERP system, and simultaneously processing the change list and the basic information of the parts related to the BOM and sending the change list and the basic information of the parts to the ERP system.

4. The method of claim 1, wherein the business logic processing of the vehicle characteristic values in step S5 includes the following steps:

s511, receiving change list information from the PDM;

s512, judging whether the vehicle CID single type exists or not, and 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 finished automobile CID list, and sequentially processing;

s514, checking whether the data is the first version data, if so, writing all the configuration attribute information into the interface table, and if not, comparing the configuration attribute information with the previous version, and writing the added FDP part number, version number, configuration option code, configuration code name, configuration option value code and configuration option value name into the interface table;

and S515, after all FDPs in the vehicle type CID list are processed, writing the information into an interface transmission table and sending the information to a whole vehicle factory of the ERP system.

5. The method of claim 1, wherein the business logic processing of the BOM data in step S5 comprises the following steps:

s521, acquiring change order data from the PDM;

s522, judging whether the type of the change list is a finished automobile CID list or a part PID list;

s523, if the finished automobile CID list is obtained, reading the finished automobile FDP part number, the lower BOM structure and the information of the sub-parts; reading variable condition information on the FDP of the whole vehicle, the lower BOM and the sub-parts; checking whether the FDP of the whole vehicle is the first version data, if so, sending BOM structure and sub-component information to an interface table; if not, comparing the version of BOM data with the previous version of BOM data to obtain BOM modification content; writing the interface table;

s524, the IMS system sends the processed BOM data to an ERP system, and the BOM structure of the complete vehicle FDP is sent to a complete vehicle factory of the ERP system by default;

s525, if the part PID list is the part production preparation route, firstly reading the part production preparation route in the PID list, acquiring self-making/purchasing, factory, material type, purchasing type and virtual part identification information of the part, then filtering the self-made part in the production preparation route, reading a lower BOM structure of the part, and completely filtering CAD parts, drawings and DMU parts in the EBOM according to the classification of the part;

s526, judging whether the BOM of the part is the first version, if so, writing all the BOM into an interface table, if not, comparing the BOM structures of the secondary version and the previous version to obtain BOM modification content, and writing information into the interface table;

and S527, the IMS system sends the BOM structure of each self-made part to a corresponding factory of the ERP system according to the factory information of the part production preparation route.

6. The method of claim 1, wherein the business logic processing of the material basic data in the step S5 includes the following steps:

and receiving a part number list transmitted by the BOM processing module, acquiring attributes of each part, such as part number, version number, material type, basic metering unit, name, material group, self-making/purchasing, virtual part identification, inlet part identification, color part identification, standard part identification and the like, and transmitting the attributes and the BOM to a corresponding factory in the ERP system.

7. The method of claim 1, wherein the step of changing the business logic process of the single pass module in the step S5 comprises the steps of:

s531, receiving change order information transmitted by the BOM processing module;

s532, acquiring a change order number, a change order entry number, a corresponding designer, a design unit, a change description, a BOM parent material version number, a change classification and associated change information of the finished vehicle CID list and the part PID list according to the change order number;

and S533, sending the change order information to the corresponding factory in the ERP system according to the factory corresponding to each BOM parent material.

Images