SAP-based material inventory management system

Abstract

The invention relates to the technical field of production management, in particular to an SAP-based material inventory management system, which comprises a material inventory checking module, a material shortage production pre-work module, a material waiting area storage module, a manual material picking assembly module and a material waiting area assembly module, the material inventory checking module comprises a material prediction model and is used for checking whether the material inventory meets the material demand quantity in the work order task or not and forming a material list; if not, additionally generating a material shortage signal and a material shortage list; the material shortage production forecasting module is used for executing forecasting and completing material shortage assembly; the material waiting area storage module is used for pushing the products subjected to material shortage assembly out of the production line to a material waiting area and binding the positions of the products; and the material waiting area assembling module is used for further material assembling of the products subjected to material shortage assembling. Through the management system, the technical problem of how to efficiently and accurately meet production task requirements under the normalized condition of material shortage in the production process is solved.

Description

Technical Field

[0001] The present invention relates to the technical field of production management, and in particular to a material inventory management system based on SAP. Background Art

[0002] In the manufacturing industry, material management is a key link to ensure smooth production. However, traditional material management methods often rely on manual inspection and manual recording, which is not only inefficient but also prone to errors. When material inventory is insufficient, it cannot be discovered and replenished in time, which affects production plans.

[0003] In the prior art, a Chinese invention patent document with a publication number of CN1684077A and a publication date of October 19, 2005 is proposed to solve the above-mentioned technical problems. The technical solution disclosed in the patent document is as follows: a shortage query system and method, which can generate shortage tables for multiple weeks in the future, including an application server, multiple user-end computers and a database. Among them: the application server is used to generate a product demand forecast shortage table, which includes an information import module, a calculation module, a query module and a shortage table generation module. The user-end computer provides an interactive user interface to facilitate users to query the generated product demand forecast shortage table. The database is used to store the quantity of each material in stock, the quantity of each material shipped this week and next week, the product demand forecast for multiple weeks in the future, the expected completion quantity this week, the bill of materials and the product demand forecast shortage table.

[0004] The above technical solution can only roughly determine whether there is a material shortage, but it cannot be combined with the production process, nor can it predict material consumption based on actual production, resulting in inaccurate judgments on material inventory and material demand, and it is impossible to timely determine whether there is a material shortage, which can easily lead to production interruptions or delays due to material shortages. Summary of the invention

[0005] In order to solve the above technical problems, the present invention proposes a material inventory management system based on SAP, which solves the technical problem of how to efficiently and accurately meet the production task requirements under the normal situation of material shortage in the production process.

[0006] A material inventory management system based on SAP, comprising a material inventory inspection module for information exchange through digital signals, a material shortage production forecasting module, a material waiting area storage module, a manual material picking assembly module and a material waiting area assembly module; The material inventory check module includes a material prediction model, which is used to check whether the material inventory meets the material requirements in the work order task and form a material list; if not, an additional material shortage signal and a material shortage list are generated; the material inventory check module is also used to send the material shortage list to the manual material picking and assembly module; The manual material picking and assembly module is used to pick up materials according to the shortage list and move them to the waiting area; The short-material production forecasting module is used to perform forecasting work and complete the short-material assembly; The material waiting area storage module is used to push the products after the lack of materials assembly out of the production line to the material waiting area and bind the position of the products; The assembly module in the waiting area is used to further assemble materials for the product after the lack of materials assembly.

[0007] It also includes an execution module, which is used to give priority to the work order task requirements of the executed short-material assembly according to the work order task details; when the material is short of material, execute the short-material production mode; when the material is not short of material, execute the normal production mode.

[0008] Checking whether the material inventory meets the material requirements in the work order task specifically includes the following steps: the material inventory checking module receives the production instruction, obtains the production information, and inputs it into the material prediction model, predicts the material requirements through the trained material prediction model, and forms a bill of materials; obtains the corresponding material inventory according to the bill of materials, and judges whether the material inventory meets the material requirements in the work order task by comparing the material requirements with the material inventory.

[0009] The material prediction model is established based on an artificial intelligence model, and the training method of the material prediction model is: Obtain standard training data from the material inventory inspection module; train the artificial intelligence model through the standard training data, and mark the trained artificial intelligence model as a material prediction model; wherein the standard training data includes several groups of input information and the corresponding bill of materials, and the input information and production information content attributes are consistent.

[0010] The artificial intelligence model is a deep convolutional neural network model or a RBF neural network model.

[0011] The material inventory checking module is also used to provide real-time inventory information.

[0012] The material shortage production forecasting module is used to execute the forecasting tool body: the material shortage production forecasting module sends a forecasting instruction to the assembly station; after the assembly station receives the forecasting instruction, it performs the corresponding assembly work to complete the material shortage assembly, and does not upload the data to the SAP system.

[0013] The location of the bound product specifically refers to: using a PDA to scan the product and ground coordinate barcode for binding.

[0014] The assembly module in the waiting area is used to perform further material assembly on the products after the missing materials are assembled, specifically including: the assembler finds the corresponding materials and the products after the missing materials are assembled in the waiting area according to the product information and the missing materials list; the assembler checks the matching of the materials and the products after the missing materials are assembled, and starts the assembly operation after the matching is consistent; during the assembly process, the assembly module in the waiting area provides real-time inventory information; after the assembly is completed, the assembly module in the waiting area records the key information of the assembly process.

[0015] It also includes an intermediate library and an assembly report upload module. The intermediate library is used to receive various data. The assembly report upload module is used to set a scheduled work order task in the SAP system, regularly process the report data in the intermediate library, and write back the processing result information.

[0016] Compared with the prior art, the beneficial effects of the present invention are as follows: 1. The present invention can accurately determine the material demand in real time through the material forecasting model, which can be combined with the production process, and judge in real time whether the material inventory meets the material demand. When the material demand does not meet the production requirements, a material shortage signal and a material shortage list are generated to remind the administrator to replenish the materials. By setting up the material inventory check module, the accuracy of the production plan can be improved, production interruptions or delays caused by material shortages can be avoided, thereby reducing production costs.

[0017] Furthermore, this management system also includes a module for forecasting production when there is a shortage of materials. In the production mode when there is a shortage of materials, the assembly station will conduct forecasting work, and the data will not be uploaded to the SAP system. After the materials are replenished, the materials will be manually picked up to the waiting area for assembly, and the final report will be made, and the product and material data will be uploaded to the SAP system. This can improve the quality of the product and reduce defects and errors.

[0018] The present invention is designed based on the information management platform of the SAP system to realize production with insufficient materials; through the information management platform, comprehensive monitoring and management of the production process can be achieved, thereby improving the efficiency and accuracy of production management.

[0019] 2. In the present invention, the material inventory check module can help planners better manage material inventory and ensure smooth production. The artificial intelligence model is a deep convolutional neural network model or an RBF neural network model, which has strong nonlinear fitting ability and is particularly suitable for predicting material demand.

[0020] 3. In the present invention, a PDA is used to scan the product and the ground coordinate barcode for binding, so as to facilitate the positioning of the product during subsequent offline assembly, ensure the accurate position of the product, and avoid affecting the subsequent assembly and reporting operations due to position errors.

[0021] 4. The present invention can ensure that the assembly work can still proceed smoothly in the case of material shortage through the material shortage production forecasting module and the material waiting area storage module, and avoid uploading unqualified products to the SAP system. At the same time, it can also ensure that the products that have completed the material shortage assembly are properly stored and managed, avoiding the impact of improper storage on the subsequent assembly and production progress.

[0022] 5. In the present invention, the assembly module in the waiting area can ensure that the missing materials are used and assembled in time in the waiting area, avoiding the impact of material shortages or assembly errors on production progress and quality; at the same time, through the recording of real-time inventory information and key information, subsequent traceability and management can be facilitated to improve production efficiency and product quality.

[0023] 6. In the present invention, the assembly report upload module can ensure that the assembled product information is accurate and avoid affecting the production quality and traceability due to material errors or information mismatches; at the same time, through real-time report operations and data uploads, product information and production progress can be updated in time, facilitating subsequent planning and inventory management. DETAILED DESCRIPTION

[0024] Example 1 As a basic implementation mode of the present invention, the present invention includes a material inventory management system based on SAP, including a material inventory inspection module for information exchange through digital signals, a material shortage production forecasting module, a material waiting area storage module, a manual material picking and assembly module and a material waiting area assembly module.

[0025] The material inventory check module includes a material prediction model, which is used to check whether the material inventory meets the material requirements in the work order task and form a material list; if not, an additional material shortage signal and a material shortage list are generated; the material inventory check module is also used to send the material shortage list to the manual material picking and assembly module.

[0026] The manual material picking and assembly module is used to pick up materials according to the shortage list and move them to the waiting area.

[0027] The short-material production forecasting module is used to execute forecasting work and complete the short-material assembly.

[0028] The material waiting area storage module is used to push the products after the lack of materials assembly out of the production line to the material waiting area and bind the position of the products.

[0029] The assembly module in the waiting area is used to further assemble materials for the product after the lack of materials assembly.

[0030] Example 2 As a preferred embodiment of the present invention, the present invention includes a material inventory management system based on SAP, including a material inventory inspection module for information exchange through digital signals, a material shortage production forecasting module, a waiting area storage module, a manual material picking and assembly module, a waiting area assembly module and an execution module.

[0031] The material inventory check module includes a material prediction model, which is used to check whether the material inventory meets the material requirements in the work order task and form a bill of materials. If not, a shortage signal and a shortage list are additionally generated. The material inventory check module is also used to send the bill of materials and the shortage list to the manual material picking and assembly module. Specifically, the material inventory check module receives production instructions, obtains production information, and inputs it into the material prediction model, predicts the material requirements through the trained material prediction model, and forms a bill of materials; obtains the corresponding material inventory according to the bill of materials, and compares the material requirements with the material inventory to determine whether the material inventory meets the material requirements in the work order task. When the material requirements are all less than or equal to the material inventory, the material inventory meets the production requirements; when any of the material requirements is greater than the material inventory, the material inventory does not meet the production requirements.

[0032] Among them, the material prediction model is established based on the artificial intelligence model, and the training method of the material prediction model is: obtaining standard training data from the material inventory inspection module; training the artificial intelligence model through the standard training data, and marking the trained artificial intelligence model as a material prediction model; wherein, the standard training data includes several groups of input information and corresponding bills of materials, and the input information and production information content attributes are consistent.

[0033] Specifically, the artificial intelligence model is a deep convolutional neural network model or a RBF neural network model.

[0034] The manual material picking and assembly module is used to pick up materials according to the material list and move them to the wiring area; it is used to pick up materials according to the missing material list and move them to the waiting area.

[0035] The short-material production forecasting module is used to execute forecasting work and complete the short-material assembly.

[0036] The material waiting area storage module is used to push the products after the lack of materials assembly out of the production line to the material waiting area and bind the position of the products.

[0037] The assembly module in the waiting area is used to further assemble materials for the product after the lack of materials assembly.

[0038] The execution module is used to process the work order task requirements of the executed short-material assembly according to the work order task details. When the material is short of material, the short-material production mode is executed; when the material is not short of material, the normal production mode is executed.

[0039] Example 3 As another preferred embodiment of the present invention, the present invention includes a material inventory management system based on SAP, including a material inventory inspection module for information exchange through digital signals, a material shortage production forecasting module, a waiting area storage module, a manual material picking and assembly module, and a waiting area assembly module.

[0040] The material inventory check module includes a material prediction model, which is used to check whether the material inventory meets the material requirements in the work order task and form a material list; if not, an additional material shortage signal and a material shortage list are generated; the material inventory check module is also used to send the material list and the material shortage list to the manual material picking and assembly module.

[0041] The manual material picking and assembly module is used to pick up materials according to the material list and move them to the wiring area, and is used to pick up materials according to the missing material list and move them to the waiting area.

[0042] The short-material production forecasting module is used to execute the forecasting work and complete the short-material assembly. Specifically, the short-material production forecasting module sends a forecasting work instruction to the assembly station; after receiving the forecasting work instruction, the assembly station performs the corresponding assembly work to complete the short-material assembly, and does not upload the data to the SAP system.

[0043] The material waiting area storage module is used to push the products after the lack of materials assembly out of the production line to the material waiting area and bind the position of the products.

[0044] The assembly module in the waiting area is used to perform further material assembly on the products after the missing materials are assembled. Specifically, the assembler finds the corresponding materials and the products after the missing materials are assembled in the waiting area according to the product information and the missing materials list; the assembler checks the matching of the materials and the products after the missing materials are assembled, and starts the assembly operation after the matching is consistent; during the assembly process, the assembly module in the waiting area provides real-time inventory information; after the assembly is completed, the assembly module in the waiting area records the key information of the assembly process.

[0045] Example 4 As the most preferred embodiment of the present invention, the present invention includes a material inventory management system based on SAP, including a material inventory inspection module, a material shortage production forecasting module, a material waiting area storage module, a manual material picking assembly module, a material waiting area assembly module, an execution module, an intermediate library, and an assembly report upload module, etc. Each module exchanges information through digital signals.

[0046] The material inventory check module includes a material forecasting model, which is used to check whether the material inventory meets the material requirements in the work order task and form a material list. If not, a material shortage signal and a material shortage list are additionally generated. The material inventory check module is also used to send the material list and the material shortage list to the manual material collection and assembly module, and to send the material shortage signal to the administrator's smart device. After the administrator receives the material shortage signal, the material is replenished according to the material shortage list. It should be further explained that the smart device includes devices such as mobile phones and computers. The material list includes data such as material name, material specification and material model. The material shortage list includes missing materials and the corresponding missing quantities.

[0047] Specifically, after receiving the production instruction, the material inventory check module obtains production information. The production information includes production plan data. The production plan data includes production items and production quantities. It should be further explained that the production items are the items or products that need to be produced; the production quantity is the planned production quantity, which will directly affect the demand for materials.

[0048] A material forecasting model is obtained from the material inventory checking module, wherein the material forecasting model is established based on an artificial intelligence model.

[0049] Input the production information into the material forecasting model to obtain a bill of materials. The bill of materials includes N materials and corresponding material requirements; N is an integer greater than 0. The material requirements are marked as Xn, and the value of n is 1, 2...N. Obtain the corresponding material inventory in the factory according to the bill of materials; mark the material inventory as Kn. When the material requirements are all less than or equal to the material inventory, the material inventory meets the production demand. When any of the material requirements is greater than the material inventory, the material inventory does not meet the production demand.

[0050] For example, in the bill of materials, material A must meet 100 pieces, and material B must meet 150 pieces. When the inventory of material A is 150 pieces and the inventory of material B is 200 pieces, the inventory of the materials meets the production requirements and production can be carried out normally. When the inventory of material A is 50 pieces and the inventory of material B is 200 pieces, the inventory of material A does not meet the production requirements and production cannot be carried out normally.

[0051] In this embodiment, the missing quantity in the missing material list is marked as Qn; The calculation formula of the missing amount is: Qn=Xn-Kn; In this embodiment, the material prediction model is established based on an artificial intelligence model, and its training method includes the following steps: Obtain standard training data from the material inventory inspection module; train the artificial intelligence model using the standard training data, and mark the trained artificial intelligence model as a material prediction model.

[0052] In this embodiment, the standard training data includes several groups of input information and corresponding bills of materials, and the input information and production information content attributes are consistent. In this embodiment, the artificial intelligence model includes a deep convolutional neural network model or an RBF neural network model with strong nonlinear fitting capabilities.

[0053] This module can help planners better manage material inventory and ensure smooth production.

[0054] The execution module is used to prioritize the work order task requirements for the work order assembly that has been executed according to the work order task details. When the material is short of material, the short of material production mode is executed; when the material is not short of material, the normal production mode is executed. In the normal production mode, the manual material collection and assembly module can collect materials according to the material list and move them to the wiring area, or it can also deliver the materials in the material list to the wiring area by other means, and complete the normal assembly work in the wiring area.

[0055] The manual material collection and assembly module is also used to collect materials according to the missing material list and move them to the waiting area. Specifically, when the missing materials are replenished, the material collector goes to the designated sorting area to collect the required materials according to the missing material list. The material collector checks the missing material list to ensure that the collected materials are consistent with the missing material list. The material collector moves the materials to the waiting area and matches them with the corresponding cabinets.

[0056] The short-material production forecasting module is used to execute the forecasting work and complete the short-material assembly. Specifically, the assembly station assembles, the station with no material shortage reports the work normally, and the short-material station executes the forecasting work. In a specific embodiment, in the short-material production mode, the short-material production forecasting module sends a forecasting work instruction to the assembly station. After receiving the forecasting work instruction, the assembly station will perform the corresponding assembly work, but will not upload the data to the SAP system.

[0057] The storage module in the waiting area is used to push the products after the assembly of the missing materials out of the production line to the waiting area, and bind the position of the products. Specifically, the assembly station uses a PDA to scan the product and the ground coordinate barcode for binding, which is convenient for locating the product during the subsequent offline assembly. The waiting area will set up corresponding signs so that the subsequent material collection and assembly personnel can quickly find the required materials.

[0058] Through the material shortage production forecasting module and the material waiting area storage module, it can be ensured that the assembly work can still proceed smoothly in the event of material shortage, while avoiding uploading unqualified products to the SAP system.

[0059] The assembly module in the waiting area is used to further assemble materials for products after the lack of materials assembly. Specifically, the assembler checks the location of the current work order task product in the PDA and performs assembly. According to the product information and the list of missing materials, the corresponding materials and products are found in the waiting area. The assembler checks the matching of materials and products, and starts the assembly operation after ensuring that there are no errors. During the assembly process, the assembly module in the waiting area provides real-time inventory information to help assemblers understand the use of materials in a timely manner and avoid material shortages or waste. After the assembly is completed, the assembly module in the waiting area records key information in the assembly process, such as assembly time, assemblers, etc., to facilitate subsequent traceability and management. The assembly module in the waiting area will also perform work reporting operations and upload product and assembly material information to the intermediate library.

[0060] The assembly module in the waiting area can ensure that the missing materials are used and assembled in time in the waiting area, avoiding the impact of material shortages or assembly errors on production progress and quality. At the same time, through the real-time recording of inventory information and key information, subsequent traceability and management can be facilitated to improve production efficiency and product quality.

[0061] The assembly report upload module is used to set up scheduled work order tasks in the SAP system, regularly process the report data in the intermediate library, and write back the processing result information. Among them, after the assembler completes the assembly work order task, the assembly report upload module performs the report operation. The assembly report upload module records the assembled product information, including product name, quantity, batch, etc. The assembly report upload module uploads the assembled product information to the SAP system and matches it with the material information recorded in the system. If the match is successful, the assembly report upload module writes the assembled product information back to the intermediate library and updates the inventory information.

[0062] In summary, after reading the present invention document, ordinary technicians in this field can make various other corresponding transformation schemes based on the technical scheme and technical concept of the present invention without creative mental labor, which all fall within the scope of protection of the present invention.

Claims

1. A material inventory management system based on SAP, characterized by: It includes a material inventory inspection module that exchanges information through digital signals, a material shortage production forecasting module, a material waiting area storage module, a manual material picking assembly module, and a material waiting area assembly module; The material inventory check module includes a material prediction model, which is used to check whether the material inventory meets the material requirements in the work order task and form a material list; if not, an additional material shortage signal and a material shortage list are generated; the material inventory check module is also used to send the material shortage list to the manual material picking and assembly module; The manual material picking and assembly module is used to pick up materials according to the shortage list and move them to the waiting area; The short-material production forecasting module is used to perform forecasting work and complete the short-material assembly; The material waiting area storage module is used to push the products after the lack of materials assembly out of the production line to the material waiting area and bind the position of the products; The assembly module in the waiting area is used to further assemble materials for the product after the lack of materials assembly.

2. The material inventory management system based on SAP according to claim 1, characterized in that: It also includes an execution module, which is used to give priority to the work order task requirements of the executed short-material assembly according to the work order task details; when the material is short of material, execute the short-material production mode; when the material is not short of material, execute the normal production mode.

3. The material inventory management system based on SAP according to claim 1, characterized in that: Checking whether the material inventory meets the material requirements in the work order task specifically includes the following steps: the material inventory checking module receives the production instruction, obtains the production information, and inputs it into the material prediction model, predicts the material requirements through the trained material prediction model, and forms a bill of materials; obtains the corresponding material inventory according to the bill of materials, and judges whether the material inventory meets the material requirements in the work order task by comparing the material requirements with the material inventory.

4. The material inventory management system based on SAP according to claim 3, characterized in that: The material prediction model is established based on an artificial intelligence model, and the training method of the material prediction model is: Obtain standard training data from the material inventory inspection module; train the artificial intelligence model through the standard training data, and mark the trained artificial intelligence model as a material prediction model; wherein the standard training data includes several groups of input information and the corresponding bill of materials, and the input information and production information content attributes are consistent.

5. The SAP-based material inventory management system according to claim 4, characterized in that: The artificial intelligence model is a deep convolutional neural network model or a RBF neural network model.

6. The material inventory management system based on SAP according to claim 4, characterized in that: The material inventory checking module is also used to provide real-time inventory information.

7. The material inventory management system based on SAP according to claim 1, characterized in that: The material shortage production forecasting module is used to execute the forecasting tool body: the material shortage production forecasting module sends a forecasting instruction to the assembly station; after the assembly station receives the forecasting instruction, it performs the corresponding assembly work to complete the material shortage assembly, and does not upload the data to the SAP system.

8. The material inventory management system based on SAP according to claim 1, characterized in that: The location of the bound product specifically refers to: using a PDA to scan the product and ground coordinate barcode for binding.

9. The material inventory management system based on SAP according to claim 1, characterized in that: The assembly module in the waiting area is used to perform further material assembly on the products after the missing materials are assembled, specifically including: the assembler finds the corresponding materials and the products after the missing materials are assembled in the waiting area according to the product information and the missing materials list; the assembler checks the matching of the materials and the products after the missing materials are assembled, and starts the assembly operation after the matching is consistent; during the assembly process, the assembly module in the waiting area provides real-time inventory information; after the assembly is completed, the assembly module in the waiting area records the key information of the assembly process.

10. A material inventory management system based on SAP according to any one of claims 1 to 9, characterized in that: It also includes an intermediate library and an assembly report upload module. The intermediate library is used to receive various data. The assembly report upload module is used to set a scheduled work order task in the SAP system, regularly process the report data in the intermediate library, and write back the processing result information.