CN113282700B - Feature material selection method, device, equipment and medium - Google Patents
Feature material selection method, device, equipment and medium Download PDFInfo
- Publication number
- CN113282700B CN113282700B CN202110592987.0A CN202110592987A CN113282700B CN 113282700 B CN113282700 B CN 113282700B CN 202110592987 A CN202110592987 A CN 202110592987A CN 113282700 B CN113282700 B CN 113282700B
- Authority
- CN
- China
- Prior art keywords
- characteristic
- materials
- preset
- determining
- independent
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 239000000463 material Substances 0.000 title claims abstract description 579
- 238000010187 selection method Methods 0.000 title abstract description 6
- 238000000034 method Methods 0.000 claims abstract description 41
- 230000015654 memory Effects 0.000 claims description 15
- 238000000354 decomposition reaction Methods 0.000 claims description 7
- 238000010276 construction Methods 0.000 claims description 6
- 238000003860 storage Methods 0.000 claims description 4
- 230000008569 process Effects 0.000 abstract description 10
- 238000004519 manufacturing process Methods 0.000 description 9
- 238000010586 diagram Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 229910000838 Al alloy Inorganic materials 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- -1 information of types Substances 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/36—Creation of semantic tools, e.g. ontology or thesauri
- G06F16/374—Thesaurus
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the application discloses a feature material selection method, a device, equipment and a medium. The method is used for solving the problem that the process of selecting the feature materials in the super BOM defined on the basis of one object and one code is complex. According to preset material codes, a super material list BOM of the product is constructed; determining the material characteristics of the required product according to the service requirements; decomposing the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product; according to a preset material characteristic definition data table and the independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials. By the method, the complexity of selecting the characteristic materials is reduced.
Description
Technical Field
The application relates to the field of enterprise informatization, in particular to a characteristic material selection method, a characteristic material selection device, a characteristic material selection equipment and a characteristic material selection medium.
Background
With the development progress of standard technology, modern design method, information technology and advanced manufacturing technology, the mass customized production mode has the characteristics of low cost, high efficiency and high quality, and can meet the personalized requirements of customers, and has become the production mode of products generally pursued by the manufacturing industry. Super Bill of materials (BOM) and product configuration are two core modules supporting personalized customization in enterprise resource planning (Enterprise Resource Planning, ERP), where super BOM is in turn the basis for product configuration, which is the application of super BOM.
The traditional ERP software is a system constructed under the guidance of a one-object one-code concept, and in order to support product configuration, the concept of super BOM is created on the basis of manufacturing BOM, so that a large and full BOM which does not exist in practice is maintained, and all optional feature materials are enumerated. When a specific business occurs, a user is required to select feature materials meeting requirements from a large and full BOM so as to drive a purchasing business, a material receiving business and a production business.
However, the super BOM defined based on the 'one-object one-code' has larger data volume, so that the process of extracting the correct characteristic materials is more complicated.
Disclosure of Invention
The embodiment of the application provides a feature material selection method, a device, equipment and a medium, which are used for solving the following technical problems: the process of selecting feature materials from super BOM based on the "one-thing-one-code" definition is complex.
The embodiment of the application adopts the following technical scheme:
the embodiment of the application provides a feature material selecting method. According to preset material codes, a super material list BOM of the product is constructed; determining the material characteristics of the required product according to the service requirements; decomposing the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product; according to a preset material characteristic definition data table and independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining material characteristics corresponding to different materials.
According to the embodiment of the application, the traditional one-object one-code material informatization principle is replaced by combining the constructed super BOM with the material characteristics of the required product, and the super BOM does not comprise data corresponding to the variable characteristics, so that the data size for constructing the super BOM is reduced. In addition, according to the embodiment of the application, the material characteristics corresponding to the required products are decomposed, and the materials are selected according to the independent characteristic materials obtained after decomposition, so that the complicated process of manually selecting the characteristic materials from the large and full BOM is solved, the time length for selecting the characteristic materials is reduced, and the selecting accuracy is improved.
In one implementation manner of the present application, according to preset material codes, a super bill of materials BOM of a product is constructed, which specifically includes: constructing a super BOM of the product according to preset material codes of the product and preset material codes of characteristic materials forming the required product; the preset codes in the super BOM do not include codes of variable features corresponding to the feature materials.
When the super BOM is constructed, the codes of the variable parts of the characteristic materials are not reflected any more, and unique codes are not required to be set for all products, so that the difficulty of material coding is reduced. In addition, the same type of material can adopt the same material coding, so that on one hand, the data volume in the super BOM is reduced, and meanwhile, the difficulty in maintaining the super BOM is also reduced.
In an implementation manner of the present application, according to a product hierarchy of the super BOM, the material features are decomposed, and a plurality of independent material features corresponding to the required product are obtained, which specifically includes: determining a product hierarchy of the super BOM; decomposing the material characteristics, and respectively distributing the decomposed independent material characteristics to different product layers; wherein each product level corresponds to one or more individual material characteristics.
According to the method and the device, the plurality of material characteristics corresponding to the required product are decomposed, and corresponding characteristic materials are respectively found for the material characteristics of different types according to the super BOM constructed by the material codes. On one hand, the complex process that characteristic materials are enumerated one by one in the prior art is solved, and meanwhile, the accuracy rate of selecting the materials can be improved.
In one implementation manner of the present application, before determining the material characteristics of the required product according to the service requirement, the method further includes: determining material characteristics corresponding to the characteristic materials; determining a material characteristic value corresponding to the material characteristic, and recording the material characteristic value through a preset format; and constructing a characteristic unique identifier according to the preset material codes, the material characteristics and the material characteristic values.
In one implementation of the present application, before determining the material characteristics of the desired product according to the business requirements, the method further includes: through presetting a material characteristic definition data table, associating a characteristic item dictionary with a material dictionary; the preset material characteristic definition data table at least comprises any one or more of a first main key ID, a material unique identifier and a characteristic unique identifier; the feature item dictionary includes at least any one or more of a second primary key ID, a feature name, and a range of feature values.
In one implementation of the present application, after associating the feature item dictionary with the material dictionary, the method further includes: determining an independent material characteristic value corresponding to the independent material characteristic; determining a unique characteristic identifier according to preset material codes, independent material characteristics and independent material characteristic values; determining a material unique identifier corresponding to the characteristic unique identifier in a material characteristic definition data table; and determining characteristic materials corresponding to the characteristics of the independent materials according to the unique material identifiers.
In one implementation manner of the present application, after determining the independent material characteristic value corresponding to the independent material characteristic, the method further includes: determining the product level of the independent material characteristics in the super BOM; and recording the characteristic values of the independent materials in a product layer.
According to the embodiment of the application, the independent material characteristics are recorded in the product hierarchy, and corresponding materials can be searched according to the recorded independent material characteristics. The found materials are compared with the recorded characteristics, whether the selected characteristic materials are correct or not can be determined, so that the normal operation of the processes of material receiving, processing and the like of the selected materials is ensured, and the production error rate is reduced.
The embodiment of the application provides a device is selected to feature material, includes: the super BOM construction unit is used for constructing a super bill of materials BOM of the product according to the preset material codes; the material characteristic determining unit is used for determining the material characteristics of the required product according to the service requirements; the material characteristic decomposition unit decomposes the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product; the characteristic material determining unit is used for determining characteristic materials corresponding to the independent material characteristics according to a preset material characteristic definition data table and the independent material characteristics; the preset material characteristic definition data table is used for defining material characteristics corresponding to different materials.
The embodiment of the application provides a characteristic material selecting device, which comprises: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the at least one processor, the instructions being executable by the at least one processor to enable the at least one processor to: according to preset material codes, a super material list BOM of the product is constructed; determining the material characteristics of the required product according to the service requirements; decomposing the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product; according to a preset material characteristic definition data table and independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining material characteristics corresponding to different materials.
The embodiment of the application provides a nonvolatile computer storage medium, which stores computer executable instructions, wherein the computer executable instructions are configured to: according to preset material codes, a super material list BOM of the product is constructed; determining the material characteristics of the required product according to the service requirements; decomposing the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product; according to a preset material characteristic definition data table and independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining material characteristics corresponding to different materials.
The above-mentioned at least one technical scheme that this application embodiment adopted can reach following beneficial effect: according to the embodiment of the application, the traditional one-object one-code material informatization principle is replaced by combining the constructed super BOM with the material characteristics of the required product, and the super BOM does not comprise data corresponding to the variable characteristics, so that the data size for constructing the super BOM is reduced. In addition, according to the embodiment of the application, the material characteristics corresponding to the required products are decomposed, and the materials are selected according to the independent characteristic materials obtained after decomposition, so that the complicated process of manually selecting the characteristic materials from the large and full BOM is solved, the time length for selecting the characteristic materials is reduced, and the selecting accuracy is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments described in the present application, and that other drawings may be obtained according to these drawings without inventive effort to a person skilled in the art. Attached at
In the figure:
fig. 1 is a flowchart of a feature material selecting method provided in an embodiment of the present application;
FIG. 2 is a schematic diagram illustrating an exemplary feature material selection according to an embodiment of the present disclosure;
fig. 3 is a block diagram of a feature material selecting device according to an embodiment of the present application;
fig. 4 is a schematic structural diagram of a feature material selecting device according to an embodiment of the present application.
Detailed Description
The embodiment of the application provides a feature material selection method, device, equipment and medium.
In order to better understand the technical solutions in the present application, the following description will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art based on the embodiments herein without making any inventive effort, shall fall within the scope of the present application.
Under the guidance of enterprise informatization guidelines of 'one-object one-code', extremely complex 'super BOM' needs to be defined in traditional ERP software and enterprise informatization practice to describe a customizable product structure, and all feature materials are enumerated. When the user places an order, the user also needs to select the options meeting the configuration requirement according to the actual service requirement, and the preparation and use processes are complex no matter whether the user selects the characteristic materials indirectly or directly through the characteristic values.
In addition, the traditional super BOM requires maintenance of all optional feature materials, but the required products are gradually perfected, and the data are continuously updated, so that the data of the feature materials required to be maintained by the traditional super BOM are huge.
Thus, the maintenance complexity and usage complexity inherent to conventional superBOMs affects and reduces the successful implementation of custom production mode services.
In order to solve the above problems, embodiments of the present application provide a method, an apparatus, a device, and a medium for selecting feature materials. By combining the constructed super BOM with the material characteristics of the required product, the traditional material informatization principle of one object and one code is replaced, and the super BOM does not comprise data corresponding to the variable characteristics, so that the data volume for constructing the super BOM is reduced. In addition, according to the embodiment of the application, the material characteristics corresponding to the required products are decomposed, and the materials are selected according to the independent characteristic materials obtained after decomposition, so that the complicated process of manually selecting the characteristic materials from the large and full BOM is solved, the time length for selecting the characteristic materials is reduced, and the selecting accuracy is improved.
The following describes in detail the technical solution proposed in the embodiments of the present application through the accompanying drawings.
Fig. 1 is a flowchart of a feature material selecting method according to an embodiment of the present application. As shown in fig. 1, the feature material selection includes the steps of:
s101, a material selecting system constructs a super BOM of a product according to preset material codes.
In one embodiment of the present application, material encodings are established for different feature materials.
Specifically, the super BOM of the product is constructed according to the preset material codes of the product and the preset material codes of the characteristic materials forming the required product.
For example, the configured product is a computer of a specific model, and the feature materials required for assembling the computer comprise a memory and a CPU. Different preset material codes are respectively established for the computer, the memory and the CPU of the current specific model, and the material codes corresponding to different characteristic materials can be the same.
In one embodiment of the present application, the preset codes in the super BOM do not include codes for the variable features corresponding to the feature materials.
For example, the feature materials required for forming the computer include a memory and a CPU, and the memory can be divided into different models such as 1G and 2G according to the size of the memory, and the CPU can be divided into different models such as 1.5HZ and 2HZ according to the frequency size. The memory size and frequency size are thus variable features. According to the embodiment of the application, unique codes can be not set for memories and CPUs of different models, so that the data size in the super BOM is reduced.
In one embodiment of the present application, super BOM is built from preset material encodings. The constructed super BOM comprises information of the configurable product, such as the name, model number, material code and the like of the configurable product. In addition, the method also comprises information of the characteristic materials, such as information of types, material codes and the like of the characteristic materials, and also comprises material codes of which the names of the basic materials correspond to the basic materials.
S102, determining the material characteristics of the required product according to the service requirements.
In one embodiment of the present application, all of the feature materials are pre-set with their corresponding material characteristics. To distinguish between different materials.
Table 1 is a feature dictionary data table provided in an embodiment of the present application.
TABLE 1
As shown in table 1, the material characteristic values of different characteristic materials pre-determined in advance are added into the characteristic item dictionary data table. The feature item dictionary data table includes information such as a second primary key ID, a feature name, a feature value range, and the like. The feature names are feature name columns, and the feature value range is the value range of the defined features. Different features and which feature values each feature has can be defined by a feature item dictionary data table. For example, the feature name may be a color, and the range of values of the feature value may be a red, yellow, green, or the like value.
Table 2 is a material characteristic value data table provided in the examples of the present application.
TABLE 2
As shown in table 2, the material characteristic value data table contains information such as material characteristics. Wherein, the material characteristic is that the complete characteristic value information of the material is recorded through Json or other formats.
It should be noted that, where the characteristic material is used, the characteristic value row of the material is added after the material is encoded, so as to record the specific characteristics of the material and complete the combination of the material encoding and the material characteristics.
In one embodiment of the present application, the unique signature is constructed from a preset material code, material characteristics, and material characteristic values. And determining the unique material identifier of each characteristic material according to the material dictionary, matching the unique material identifier with the unique material identifier, and determining the unique material corresponding to the characteristics of different materials.
Table 3 is a preset material characteristic definition data table provided in the embodiment of the present application.
Alias name | Column name | Data type | Annotating |
Main key ID | ID | varchar(36) | Unique primary key |
Unique identification of material | WLID | varchar(36) | Unique identification of material |
Feature unique identification | TZID | varchar(36) | Feature unique identification |
TABLE 3 Table 3
As shown in table 3, the preset material characteristic definition data table at least comprises any one or more of a first main key ID, a material unique identifier, and a characteristic unique identifier.
In one embodiment of the present application, a material characteristic definition data table is preset, which is used to associate a characteristic item dictionary with a material dictionary, so as to define material characteristics corresponding to different materials respectively.
In one embodiment of the present application, the material characteristics of the product required in the current business are determined based on the received business requirements. For example, the received service requirement is a computer of a certain model, the memory corresponding to the computer of the model is determined to be 2G, and the CPU is determined to be 1.5HZ.
According to the embodiment of the application, optional material characteristics are maintained through the characteristic item dictionary data table. And the material characteristics which can be used by the characteristic materials are maintained according to the preset material characteristic definition data table, the super BOM definition function is provided, the material characteristics are ignored, the super BOM is maintained by using the material codes, and the maintenance difficulty is reduced.
S103, decomposing the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product.
In one embodiment of the present application, a product hierarchy of a super BOM is determined.
Specifically, the structural hierarchy of the constructed super BOM is determined according to preset material codes. The super BOM is constructed to include a configurable product layer, a plurality of feature material layers, and a base material layer. Wherein each configurable product layer is composed of a plurality of feature material layers and a base material layer.
In one embodiment of the present application, material characteristics are decomposed and the decomposed individual material characteristics are respectively assigned to different product levels. Wherein each product level corresponds to one or more individual material characteristics.
Specifically, preset material codes of a configurable product layer in the super BOM are combined with a plurality of material characteristics of the product according to business requirements. Decomposing the plurality of material characteristics to obtain a plurality of independent material characteristics, so that each independent material characteristic can correspond to one or more characteristic materials. And according to the product hierarchical structure in the super BOM, combining each independent material characteristic with different characteristic material layers respectively to construct a characteristic unique identifier for combining the independent material characteristic with the material code.
S104, determining characteristic materials corresponding to the independent material characteristics according to a preset material characteristic definition data table and the independent material characteristics.
In one embodiment of the present application, individual material characteristic values corresponding to individual material characteristics are determined.
Specifically, according to the product requirement, one or more specific independent material characteristic values of the currently configurable product are determined, for example, the required computer memory is 2G, and the independent material characteristic value is 2G.
In one embodiment of the present application, a product hierarchy of individual material features in the super BOM is determined, and individual material feature values are recorded in the product hierarchy.
Specifically, determining each independent material characteristic and a corresponding product level, automatically inheriting the material characteristic value of the configurable product by the characteristic material in the super BOM, and recording the material characteristic value in the corresponding product level.
For example, the material characteristics corresponding to the characteristic material 1 layer in the super BOM are computer memory, and at this time, the independent material characteristics with the memory size of 2G are recorded in the characteristic material 1 layer.
In one embodiment of the present application, the unique identification of the feature is determined based on a preset material code, an independent material feature, and an independent material feature value. And determining the unique material identifier corresponding to the unique characteristic identifier in a preset material characteristic definition data table. And determining characteristic materials corresponding to the characteristics of the independent materials according to the unique material identifiers.
For example, in the constructed super BOM, the material codes in the layer 1 of the characteristic materials are X103, the independent material characteristics are frequency 1.5HZ, at the moment, the unique characteristic identifiers can be determined according to the material codes X103 and the independent material characteristic frequency 1.5HZ, and then the unique material identifiers corresponding to the unique characteristic identifiers are determined according to a preset material characteristic definition data table, so that the required CPU can be selected.
In the embodiment of the application, a BOM structure is built by using a material code, and in actual application, service can only occur by specifying two items of the material code and the material characteristic of a product, and the super BOM definitely features the material by inheriting the material characteristic of an upper product. In addition, the super BOM design method disclosed by the embodiment of the application has the characteristics of easiness in understanding, implementation and operation, and can be used for strongly supporting the mass customization production mode of enterprises.
Fig. 2 is a schematic diagram of an exemplary feature material selection provided in an embodiment of the present application. As shown in fig. 2, the feature material selection instantiation includes the following steps:
in one embodiment of the present application, super BOM is built from preset material encodings. Wherein, the material code that configurable product layer corresponds is X001, and the material code that characteristic material 1 layer corresponds is X101, and the material code that characteristic material 2 layer corresponds is X102, and the material code that basic material layer corresponds is F101.
In one embodiment of the present application, it is determined that the material characteristic of the currently configurable product is color-red, material-aluminum alloy, according to business requirements. And according to the structural hierarchy of the constructed super BOM, different characteristic material layers inherit and record different material characteristics. For example, the characteristic material 1 layer inherits the recorded material characteristic of a material-aluminum alloy, and the characteristic material 2 layer inherits the recorded material characteristic of a color-red. And determining the unique characteristic identifiers by different characteristic material layers according to preset material codes and material characteristics, and determining the unique material identifiers corresponding to the unique characteristic identifiers according to a preset material characteristic definition data table, so that the characteristic materials corresponding to the unique material identifiers can be determined.
Fig. 3 is a block diagram of a feature material selecting device according to an embodiment of the present application. The device comprises: the device comprises a super BOM construction unit 301, a material characteristic determination unit 302, a material characteristic decomposition unit 303 and a characteristic material determination unit 304.
The super BOM construction unit 301 constructs a super bill of materials BOM of the product according to the preset material codes;
the material characteristic determining unit 302 determines the material characteristic of the required product according to the service requirement;
the material characteristic decomposition unit 303 decomposes the material characteristic according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product;
the feature material determining unit 304 determines feature materials corresponding to the independent material features according to a preset material feature definition data table and the independent material features; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials.
Further, the apparatus further comprises:
a preset code construction super BOM unit 305 for constructing super BOM of the product according to the preset material code of the product and the preset material code of the characteristic materials composing the required product; the preset material codes in the super BOM do not include codes of variable features corresponding to the feature materials.
Further, the apparatus further comprises:
a material characteristic distribution unit 306, configured to determine a product hierarchy of the super BOM; decomposing the material characteristics, and respectively distributing the decomposed independent material characteristics to different product layers; wherein each product level corresponds to one of the individual material characteristics.
Further, the apparatus further comprises:
a feature unique identifier construction unit 307 determines the material feature corresponding to the feature material; determining a material characteristic value corresponding to the material characteristic, and recording the material characteristic value through a preset format; and constructing a characteristic unique identifier according to the preset material codes, the material characteristics and the material characteristic values.
Further, the apparatus further comprises:
the association unit 308 associates the feature item dictionary with the material dictionary through the preset material feature definition data table; the preset material characteristic definition data table at least comprises any one or more of a first main key ID, a material unique identifier and a characteristic unique identifier; the feature item dictionary comprises at least any one or more of a second primary key ID, a feature name and a range of feature values.
Further, the apparatus further comprises:
an independent material characteristic determining unit 309 that determines an independent material characteristic value corresponding to the independent material characteristic; determining the unique identification of the characteristic according to the preset material code, the independent material characteristic and the independent material characteristic value; determining the unique material identifier corresponding to the unique characteristic identifier in the preset material characteristic definition data table; and determining the characteristic materials corresponding to the independent material characteristics according to the material unique identification.
Further, the apparatus further comprises:
a recording unit 310, configured to determine a product level of the independent material feature in the super BOM; and recording the independent material characteristic values in the product hierarchy.
Fig. 3 is a schematic structural diagram of a feature material selecting device according to an embodiment of the present application. The device comprises:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
according to preset material codes, a super material list BOM of the product is constructed;
determining the material characteristics of the required product according to the service requirements;
decomposing the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product;
according to a preset material characteristic definition data table and the independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials.
A non-volatile computer storage medium according to an embodiment of the present application stores computer-executable instructions configured to:
according to preset material codes, a super material list BOM of the product is constructed;
determining the material characteristics of the required product according to the service requirements;
decomposing the material characteristics according to the product hierarchical structure of the super BOM to obtain a plurality of independent material characteristics corresponding to the required product;
according to a preset material characteristic definition data table and the independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials.
All embodiments in the application are described in a progressive manner, and identical and similar parts of all embodiments are mutually referred, so that each embodiment mainly describes differences from other embodiments. In particular, for apparatus, devices, non-volatile computer storage medium embodiments, the description is relatively simple, as it is substantially similar to method embodiments, with reference to the section of the method embodiments being relevant.
The foregoing describes specific embodiments of the present application. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and variations of the embodiments of the present application will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the embodiments of the present application should be included in the scope of the claims of the present application.
Claims (7)
1. A method of selecting a feature material, the method comprising:
according to preset material codes, a super material list BOM of the product is constructed;
determining the material characteristics of the required product according to the service requirements;
decomposing the material characteristics according to the product hierarchical structure of the super bill of materials BOM to obtain a plurality of independent material characteristics corresponding to the required products;
according to a preset material characteristic definition data table and the independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials;
before determining the material characteristics of the required product according to the service requirement, the method further comprises:
the characteristic item dictionary is associated with the material dictionary through the preset material characteristic definition data table;
wherein, the preset material characteristic definition data table comprises: a first main key ID, a material unique identifier and a characteristic unique identifier; the feature item dictionary includes: a second primary key ID, a feature name, and a range of feature values;
after associating the feature item dictionary with the material dictionary, the method further comprises:
determining an independent material characteristic value corresponding to the independent material characteristic;
determining the unique identification of the characteristic according to the preset material code, the independent material characteristic and the independent material characteristic value;
determining the unique material identifier corresponding to the unique characteristic identifier in the preset material characteristic definition data table;
determining characteristic materials corresponding to the independent material characteristics according to the material unique identification;
the method for constructing the super bill of materials BOM of the product according to the preset material codes specifically comprises the following steps:
constructing a super bill of materials BOM of the product according to preset material codes of the product and preset material codes of characteristic materials forming the required product; the preset material codes in the super bill of materials BOM do not include codes of variable features corresponding to the feature materials.
2. The method for selecting the characteristic materials according to claim 1, wherein the decomposing the material characteristics according to the product hierarchy of the super bill of materials BOM to obtain a plurality of independent material characteristics corresponding to the required product specifically comprises:
determining a product hierarchy of the super bill of materials BOM;
decomposing the material characteristics, and respectively distributing the decomposed independent material characteristics to different product layers; wherein each of the product levels corresponds to one or more of the individual material characteristics.
3. A method of selecting a feature material according to claim 1, wherein prior to determining the material characteristics of the desired product based on business requirements, the method further comprises:
determining the material characteristics corresponding to the characteristic materials;
determining a material characteristic value corresponding to the material characteristic, and recording the material characteristic value through a preset format;
and constructing a characteristic unique identifier according to the preset material codes, the material characteristics and the material characteristic values.
4. A method of feature material selection as claimed in claim 1, wherein after determining the individual material feature values corresponding to the individual material features, the method further comprises:
determining the product level of the independent material characteristics in the super bill of materials BOM;
and recording the independent material characteristic values in the product hierarchy.
5. A feature material selection apparatus, comprising:
the super BOM construction unit is used for constructing a super bill of materials BOM of the product according to the preset material codes;
the material characteristic determining unit is used for determining the material characteristics of the required product according to the service requirements;
the material characteristic decomposition unit is used for decomposing the material characteristic according to the product hierarchical structure of the super bill of materials BOM to obtain a plurality of independent material characteristics corresponding to the required product;
the characteristic material determining unit is used for determining characteristic materials corresponding to the independent material characteristics according to a preset material characteristic definition data table and the independent material characteristics; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials;
the apparatus further comprises:
the association unit is used for associating the characteristic item dictionary with the material dictionary through the preset material characteristic definition data table;
wherein, the preset material characteristic definition data table comprises: a first main key ID, a material unique identifier and a characteristic unique identifier; the feature item dictionary includes: a second primary key ID, a feature name, and a range of feature values;
the apparatus further comprises:
an independent material characteristic value determining unit for determining an independent material characteristic value corresponding to the independent material characteristic;
the characteristic unique identifier determining unit is used for determining the characteristic unique identifier according to the preset material codes, the independent material characteristics and the independent material characteristic values;
a material unique identifier determining unit, configured to determine, in the preset material characteristic definition data table, the material unique identifier corresponding to the characteristic unique identifier;
the characteristic material determining unit is used for determining characteristic materials corresponding to the independent material characteristics according to the material unique identification;
the method for constructing the super bill of materials BOM of the product according to the preset material codes specifically comprises the following steps:
constructing a super bill of materials BOM of the product according to preset material codes of the product and preset material codes of characteristic materials forming the required product; the preset material codes in the super bill of materials BOM do not include codes of variable features corresponding to the feature materials.
6. A feature material selecting apparatus, comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
according to preset material codes, a super material list BOM of the product is constructed;
determining the material characteristics of the required product according to the service requirements;
decomposing the material characteristics according to the product hierarchical structure of the super bill of materials BOM to obtain a plurality of independent material characteristics corresponding to the required products;
according to a preset material characteristic definition data table and the independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials;
before determining the material characteristics of the desired product according to the business requirements, the processor can further comprise:
the characteristic item dictionary is associated with the material dictionary through the preset material characteristic definition data table;
wherein, the preset material characteristic definition data table comprises: a first main key ID, a material unique identifier and a characteristic unique identifier; the feature item dictionary includes: a second primary key ID, a feature name, and a range of feature values;
after associating the feature item dictionary with the material dictionary, the processor is further capable of:
determining an independent material characteristic value corresponding to the independent material characteristic;
determining the unique identification of the characteristic according to the preset material code, the independent material characteristic and the independent material characteristic value;
determining the unique material identifier corresponding to the unique characteristic identifier in the preset material characteristic definition data table;
determining characteristic materials corresponding to the independent material characteristics according to the material unique identification;
the method for constructing the super bill of materials BOM of the product according to the preset material codes specifically comprises the following steps:
constructing a super bill of materials BOM of the product according to preset material codes of the product and preset material codes of characteristic materials forming the required product; the preset material codes in the super bill of materials BOM do not include codes of variable features corresponding to the feature materials.
7. A non-transitory computer storage medium storing computer-executable instructions configured to:
according to preset material codes, a super material list BOM of the product is constructed;
determining the material characteristics of the required product according to the service requirements;
decomposing the material characteristics according to the product hierarchical structure of the super bill of materials BOM to obtain a plurality of independent material characteristics corresponding to the required products;
according to a preset material characteristic definition data table and the independent material characteristics, determining characteristic materials corresponding to the independent material characteristics; the preset material characteristic definition data table is used for defining the material characteristics corresponding to different materials;
before determining the material characteristics of the desired product according to the business requirements, the computer-executable instructions are further capable of:
the characteristic item dictionary is associated with the material dictionary through the preset material characteristic definition data table;
wherein, the preset material characteristic definition data table comprises: a first main key ID, a material unique identifier and a characteristic unique identifier; the feature item dictionary includes: a second primary key ID, a feature name, and a range of feature values;
after associating the feature item dictionary with the material dictionary, the computer-executable instructions are further capable of:
determining an independent material characteristic value corresponding to the independent material characteristic;
determining the unique identification of the characteristic according to the preset material code, the independent material characteristic and the independent material characteristic value;
determining the unique material identifier corresponding to the unique characteristic identifier in the preset material characteristic definition data table;
determining characteristic materials corresponding to the independent material characteristics according to the material unique identification;
the method for constructing the super bill of materials BOM of the product according to the preset material codes specifically comprises the following steps:
constructing a super bill of materials BOM of the product according to preset material codes of the product and preset material codes of characteristic materials forming the required product; the preset material codes in the super bill of materials BOM do not include codes of variable features corresponding to the feature materials.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110592987.0A CN113282700B (en) | 2021-05-28 | 2021-05-28 | Feature material selection method, device, equipment and medium |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202110592987.0A CN113282700B (en) | 2021-05-28 | 2021-05-28 | Feature material selection method, device, equipment and medium |
Publications (2)
Publication Number | Publication Date |
---|---|
CN113282700A CN113282700A (en) | 2021-08-20 |
CN113282700B true CN113282700B (en) | 2023-07-07 |
Family
ID=77282459
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202110592987.0A Active CN113282700B (en) | 2021-05-28 | 2021-05-28 | Feature material selection method, device, equipment and medium |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN113282700B (en) |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1628248A1 (en) * | 2004-08-20 | 2006-02-22 | Sap Ag | Modelling a bill of materials for a configurable product in a managed supply chain. |
CN112347750A (en) * | 2020-10-29 | 2021-02-09 | 浪潮通用软件有限公司 | Method, device and medium for generating bill of materials |
Family Cites Families (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102663533A (en) * | 2012-03-02 | 2012-09-12 | 浪潮集团山东通用软件有限公司 | BOM implementation method for product configuration based on characteristics of materials and configuration rules |
CN105389653A (en) * | 2015-10-30 | 2016-03-09 | 广东石油化工学院 | Adaptive material requirement plan (MRP) calculation method |
CN108711035A (en) * | 2018-05-21 | 2018-10-26 | 广东科达洁能股份有限公司 | A kind of implementation method of configurable super BOM |
CN109242253A (en) * | 2018-08-06 | 2019-01-18 | 智车优行科技(上海)有限公司 | Bill of materials extracting method, device and storage medium |
CN109948938A (en) * | 2019-03-25 | 2019-06-28 | 深圳职业技术学院 | The bill of materials configuration method and device and equipment of a kind of enterprise resource planning |
CN111369190A (en) * | 2020-03-02 | 2020-07-03 | 深圳百胜扬工业电子商务平台发展有限公司 | Super BOM (bill of material) matching number selecting method and device |
CN111581369A (en) * | 2020-03-31 | 2020-08-25 | 山东浪潮通软信息科技有限公司 | Material management method, equipment and medium capable of automatically matching features |
-
2021
- 2021-05-28 CN CN202110592987.0A patent/CN113282700B/en active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP1628248A1 (en) * | 2004-08-20 | 2006-02-22 | Sap Ag | Modelling a bill of materials for a configurable product in a managed supply chain. |
CN112347750A (en) * | 2020-10-29 | 2021-02-09 | 浪潮通用软件有限公司 | Method, device and medium for generating bill of materials |
Also Published As
Publication number | Publication date |
---|---|
CN113282700A (en) | 2021-08-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110580649B (en) | Method and device for determining commodity potential value | |
CN101930443A (en) | Data service system and data service realization method | |
CN110543303A (en) | Visual business platform | |
CN1407426A (en) | Graphic user interface for data input | |
CN104102670A (en) | Performance indicator analytical framework | |
CN106844320B (en) | Financial statement integration method and equipment | |
US20090287868A1 (en) | Master data managemnt system with improved data structure and storage medium storing the master data | |
CN110852559A (en) | Resource allocation method and device, storage medium and electronic device | |
CN107590259A (en) | The dissemination method and device of a kind of data, services | |
CN101354723A (en) | Method and apparatus for implementing combined field | |
CN113282700B (en) | Feature material selection method, device, equipment and medium | |
CN112650798A (en) | Data interfacing method, electronic device and storage medium | |
CN109634637A (en) | A kind of PDM system and BOM multi version CAD data disparity comparative approach | |
CN108874762A (en) | Online display system and method are reported in a kind of investment research | |
US20220309238A1 (en) | Method for configuring documents for circulation and device implementing method | |
KR101815561B1 (en) | Client program of erp system | |
CN102542364B (en) | Method and system for balancing substitute materials in material requirement planning | |
CN115409014A (en) | Document template generation method and device, computer equipment and storage medium | |
CN114004587A (en) | Design system and method for automatic management and control of whole machine model | |
CN114356889A (en) | Data conversion method, migration method, conversion device and migration device | |
JP5049800B2 (en) | Chemical substance management method | |
US9489438B2 (en) | Systems and methods for visualizing master data services information | |
CN113297434A (en) | Material gene code generation method and system | |
CN111652489A (en) | BOM-driven intelligent manufacturing service task decomposition method and system | |
US20020123811A1 (en) | Production management system and program |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20230609 Address after: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
GR01 | Patent grant | ||
GR01 | Patent grant |