Information processing method, apparatus, computing device, and medium
By acquiring and adjusting discrepancy information, the problem of distorted component cost calculation in SAP ERP was resolved, resulting in more accurate cost information processing.
Patent Information
- Application Number
- CN202210420464.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-04-20
- Publication Date
- 2026-02-10
- Estimated Expiration
- 2042-04-20
AI Technical Summary
Existing technologies may lead to distorted component cost calculations when performing variance calculations and actual cost adjustments through SAP ERP.
By obtaining the difference information between the product components of the target product, the difference adjustment information is determined, and the first cost information calculated by the material ledger module is adjusted based on this to obtain the second cost information that is closer to the actual cost.
It improves the accuracy of component cost calculation, reduces calculation distortion, and ensures that cost information is closer to the company's actual costs.
Smart Images

Figure CN114782088B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of data processing technology, and in particular to an information processing method, apparatus, computing device, and medium. Background Technology
[0002] According to accounting standards, inventory accounting must use the historical cost method (also known as the actual cost method). If an enterprise uses the calculated cost method (also known as the standard cost method) or the standard cost method for daily accounting, it should periodically transfer its cost variances and adjust the planned cost or standard cost to the actual cost. For example, in related technologies, SAP's Enterprise Resource Planning (ERP) products can be used to calculate variances and adjust the actual cost of each component.
[0003] Taking the process of using SAP ERP to implement variance calculation and actual cost adjustment as an example, firstly, based on the output of each process reported at the end of the period, the quantity of work-in-process for each component and the total cost of work-in-process are calculated; then, the quantity of work-in-process for each component is multiplied by the standard component cost to obtain the standard work-in-process cost for each component; then, based on the ratio of "standard work-in-process component cost / product standard cost" for each component, the work-in-process cost of each component is recalculated according to the total work-in-process cost calculated in the product calculation process, so as to calculate the cost variance for each component based on the work-in-process cost of each component calculated in the settlement process and the work-in-process cost of each component calculated in the variance calculation process; finally, by running the material ledger module, the variances calculated in the above process are restored to each cost component to obtain the actual cost of each cost component.
[0004] In the above implementation process, since the work-in-process cost and difference of each component are recalculated according to the standard work-in-process cost ratio of the components during the settlement process, the actual component cost calculated after running the material ledger may be distorted. Summary of the Invention
[0005] This invention provides an information processing method, apparatus, computing device, and medium to address the shortcomings of related technologies.
[0006] According to a first aspect of the present invention, an information processing method is provided, the method comprising:
[0007] Obtain first difference information on the difference between the standard in-product cost of the product components that characterize the target product and the first theoretical in-product cost of the product components. The first theoretical in-product cost is determined based on the standard in-product cost of the product components, the standard in-product cost of the target product, and the total in-product cost of the target product.
[0008] Obtain second difference information between the standard for characterizing product components in product cost and the second theory in product cost, whereby the second theory in product cost is determined based on the input cost, output, and scrap of product components;
[0009] Based on the first difference information and the second difference information, the difference adjustment information is determined;
[0010] Based on the difference adjustment information, the first cost information of the product components is adjusted to obtain the second cost information. The first cost information is obtained through the material ledger module.
[0011] In one embodiment of the present invention, obtaining first difference information between the standard of a product component characterizing the target product in terms of product cost and the first theoretical difference of the product component in terms of product cost includes:
[0012] Retrieve the first difference information located at the first target field from the first table of the target database.
[0013] In one embodiment of the present invention, obtaining first difference information located at a first target field from a first table of a target database includes:
[0014] Based on the business information in the second table associated with the first table and the component information in the third table associated with the first table, product components that meet the first set conditions are determined.
[0015] Obtain the first difference information corresponding to the product component that meets the first set conditions from the first target field of the first table.
[0016] In one embodiment of the present invention, obtaining second difference information, which characterizes the difference between the standard cost of a product component and the second theoretical cost of the product component, includes:
[0017] Retrieve the second difference information located in the second target field from the fourth table of the target database.
[0018] In one embodiment of the present invention, obtaining second difference information located at the second target field from the fourth table of the target database includes:
[0019] Obtain the second difference information corresponding to the product component that meets the second set conditions from the second target field of the fourth table.
[0020] In one embodiment of the present invention, determining difference adjustment information based on first difference information and second difference information includes:
[0021] The difference between the first difference information and the second difference information is determined as the difference adjustment information.
[0022] In one embodiment of the present invention, based on the difference adjustment information, the first cost information of the product components is adjusted to obtain the second cost information, including:
[0023] The second cost information is obtained by overlaying the difference adjustment information on the first cost information.
[0024] In one embodiment of the present invention, the first cost information is obtained through an enterprise resource planning system;
[0025] Before adjusting the first cost information of the product components based on the difference adjustment information to obtain the second cost information, the method further includes:
[0026] The first target parameter carries the value of the difference adjustment information, the second target parameter carries the information type of the difference adjustment information, and the value and information type of the difference adjustment information are stored in the enterprise resource planning system by transmitting the first target parameter and the second target parameter.
[0027] According to a second aspect of the present invention, an information processing apparatus is provided, the apparatus comprising:
[0028] The first acquisition unit is used to acquire first difference information between the standard in-product cost of the product components that characterize the target product and the first theoretical in-product cost of the product components. The first theoretical in-product cost is determined based on the standard in-product cost of the product components, the standard in-product cost of the target product, and the total in-product cost of the target product.
[0029] The second acquisition unit is used to acquire second difference information between the standard product cost and the second theoretical product cost of the product component, which characterizes the product component. The second theoretical product cost is determined based on the input cost, output and scrap of the product component.
[0030] The determining unit is used to determine the difference adjustment information based on the first difference information and the second difference information;
[0031] The adjustment unit is used to adjust the first cost information of the product components based on the difference adjustment information to obtain the second cost information. The first cost information is obtained through the material ledger module.
[0032] In one embodiment of the present invention, the first acquisition unit, when acquiring first difference information between the standard in-product cost of a product component characterizing a target product and the first theoretical in-product cost of the product component, is configured to:
[0033] Retrieve the first difference information located at the first target field from the first table of the target database.
[0034] In one embodiment of the present invention, the first acquisition unit, when acquiring first difference information located at a first target field from a first table in a target database, is configured to:
[0035] Based on the business information in the second table associated with the first table and the component information in the third table associated with the first table, product components that meet the first set conditions are determined.
[0036] Obtain the first difference information corresponding to the product component that meets the first set conditions from the first target field of the first table.
[0037] In one embodiment of the present invention, the second acquisition unit, when acquiring second difference information characterizing the difference between the standard in-product cost of a product component and the second theoretical in-product cost of the product component, is configured to:
[0038] Retrieve the second difference information located in the second target field from the fourth table of the target database.
[0039] In one embodiment of the present invention, the second acquisition unit, when acquiring second difference information located at the second target field from the fourth table of the target database, is configured to:
[0040] Obtain the second difference information corresponding to the product component that meets the second set conditions from the second target field of the fourth table.
[0041] In one embodiment of the present invention, the determining unit, when determining difference adjustment information based on the first difference information and the second difference information, is configured to:
[0042] The difference between the first difference information and the second difference information is determined as the difference adjustment information.
[0043] In one embodiment of the present invention, the adjustment unit, when adjusting the first cost information of a product component based on the difference adjustment information to obtain the second cost information, is configured to:
[0044] The second cost information is obtained by overlaying the difference adjustment information on the first cost information.
[0045] In one embodiment of the present invention, the first cost information is obtained through an enterprise resource planning system;
[0046] The device also includes:
[0047] The storage unit is used to carry the value of the difference adjustment information through a first target parameter, carry the information type of the difference adjustment information through a second target parameter, and store the value and information type of the difference adjustment information in the enterprise resource planning system by transmitting the first target parameter and the second target parameter.
[0048] According to a third aspect of the present invention, a computing device is provided, the computing device including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to perform the operations performed by the information processing method provided in the first aspect and any embodiment of the first aspect.
[0049] According to a fourth aspect of the present invention, a computer-readable storage medium is provided, on which a program is stored, which, when executed by a processor, performs the operations performed by the information processing method provided in the first aspect and any embodiment of the first aspect.
[0050] According to a fifth aspect of the present invention, a computer program product is provided, the computer program product including a computer program, which, when executed by a processor, performs the operations performed by the information processing method provided in the first aspect and any embodiment of the first aspect.
[0051] This invention obtains first difference information—the difference between the standard cost of a product component and the first theoretical cost of the product component—and second difference information—the difference between the standard cost of a product component and the second theoretical cost of the product component. Based on the first and second difference information, difference adjustment information is determined. Then, based on the difference adjustment information, the first cost information obtained through the material ledger module is adjusted to obtain second cost information that is closer to the actual cost of the target product, thereby improving the accuracy of the calculated actual component cost and reducing the occurrence of distortion in the calculated actual component cost.
[0052] It should be understood that the above general description and the following detailed description are exemplary and explanatory only, and are not intended to limit the invention. Attached Figure Description
[0053] The accompanying drawings, which are incorporated in and form part of this specification, illustrate embodiments consistent with the invention and, together with the description, serve to explain the principles of the invention.
[0054] Figure 1This is a flowchart illustrating an information processing method according to an embodiment of the present invention.
[0055] Figure 2 This is a schematic diagram of the interface structure of the function "CKMMC_MANCHANG_AUTOMATED" according to an embodiment of the present invention.
[0056] Figure 3 This is a flowchart illustrating an information processing procedure according to an embodiment of the present invention.
[0057] Figure 4 This is a block diagram of an information processing apparatus according to an embodiment of the present invention.
[0058] Figure 5 This is a schematic diagram of the structure of a computing device according to an embodiment of the present invention. Detailed Implementation
[0059] Exemplary embodiments will now be described in detail, examples of which are illustrated in the accompanying drawings. When the following description relates to the drawings, unless otherwise indicated, the same numerals in different drawings denote the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present invention. Rather, they are merely examples of apparatuses and methods consistent with some aspects of the invention as detailed in the appended claims.
[0060] This invention provides an information processing method that can further adjust the first cost information calculated by the material ledger module of SAP ERP to obtain second cost information that is closer to the actual component costs of the enterprise. The above information processing method can be executed by a computing device, which can be a terminal device such as a desktop computer, laptop computer, tablet computer, smartphone, etc. Optionally, the computing device can also be a server, such as a single server, multiple servers, a server cluster, a cloud computing platform, etc. Furthermore, the computing device can be other types of terminal devices or servers. This invention does not limit the type or number of computing devices.
[0061] The computing device can be equipped with and run SAP ERP, enabling it to perform cost accounting for products through SAP ERP's Material Ledger module. The Material Ledger module is a crucial functional module in SAP ERP, providing features such as actual cost accounting and managing material prices in multiple currencies.
[0062] After the actual cost of the product (i.e., the first cost information) is calculated through the material ledger module, the first cost information calculated by the material ledger module can be further adjusted using the information processing method provided by this invention.
[0063] The technical terms involved in this invention are described below:
[0064] SAP ERP (System Application and Products in Data Processing, Enterprise Resource Planning): SAP's enterprise resource planning product.
[0065] Costing: The process of calculating and analyzing product costs over a period of time, such as raw material costs, labor costs, and administrative expenses.
[0066] Cost Components: The composition of product cost. For example, the cost of an LCD panel generally consists of the cost of the glass substrate, the cost of the upper / lower polarizer, the cost of the integrated circuit (IC) driver, and the cost of the photoresist.
[0067] Work in process (WIP): refers to products that have been put into production but have not yet been completed.
[0068] Work-in-process (WIP) Calculation: Calculate the quantity and cost of work-in-process based on the output of each process (the corresponding SAP ERP transaction code is KKAS).
[0069] Variance Calculation: During the period, the input, output, and scrap of materials are calculated based on the standard price approved at the beginning of the period. At the end of the period, the actual input, output, and scrap occurred during the period, and the difference between the actual value and the standard value is calculated.
[0070] Settlement: During the period, expenses incurred are collected using cost objects. At the end of the period, the differences on these objects and the cost of work in process are transferred to the financial module and the material ledger module (the corresponding SAP ERP transaction code is C088).
[0071] Standard Cost / Actual Cost: Chinese accounting standards stipulate that inventory accounting must use the historical cost method (i.e., actual cost method). If an enterprise uses the planned cost method (i.e., standard cost method) or the standard cost method for daily accounting, it should periodically transfer its cost differences and adjust the planned cost or standard cost to the actual cost. In SAP ERP, standard costs can be adjusted to actual costs through the material ledger module (the SAP ERP transaction code for restoring differences and generating actual costs is CKMLCP, and the transaction code for material price analysis is CKM3. Material price analysis includes displaying the receipt, issuance, and inventory of materials during the period, as well as analyzing standard prices, actual prices, and component costs).
[0072] Transaction Code: Function codes in SAP ERP products that enable the execution of corresponding functions.
[0073] After introducing the relevant terminology of this invention, the information processing method provided by this invention will be described in detail below.
[0074] Figure 1 This is a flowchart illustrating an information processing method according to an embodiment of the present invention. See also... Figure 1 The method includes:
[0075] Step 101: Obtain first difference information on the difference between the standard in-product cost of the product components and the first theoretical in-product cost of the product components, which characterizes the target product. The first theoretical in-product cost is determined based on the standard in-product cost of the product components, the standard in-product cost of the target product, and the total in-product cost of the target product.
[0076] The target product may include multiple product components. Taking the LCD panel as an example, the LCD panel as the target product may include multiple product components such as glass substrate, upper / lower polarizer, driver IC and photoresist. Each product component corresponds to a first difference information, so that the target product can correspond to multiple first difference information.
[0077] Step 102: Obtain second difference information characterizing the difference between the standard product cost and the second theoretical product cost of the product component, whereby the second theoretical product cost is determined based on the input cost, output, and obsolescence of the product component.
[0078] Each product component corresponds to a second difference information, thus allowing the target product to have multiple second difference information.
[0079] Step 103: Determine the difference adjustment information based on the first difference information and the second difference information.
[0080] Step 104: Based on the difference adjustment information, adjust the first cost information of the product components to obtain the second cost information. The first cost information is obtained through the material ledger module.
[0081] The first cost information can be calculated using the material ledger module of SAP ERP. In some embodiments, the process of determining the first cost information through the material ledger module may include the following steps:
[0082] Step 1: Work-in-process calculation: Based on the output of each process reported at the end of the period, calculate the quantity of work-in-process for each product component of the target product and the total work-in-process cost of the target product.
[0083] Step 2, Difference Calculation: Based on the work-in-process quantity of each product component calculated during the work-in-process calculation process and the standard component cost of the corresponding product component, determine the standard work-in-process cost of each product component.
[0084] In one possible implementation, the standard work-in-process cost of each product component can be obtained by multiplying the quantity of each product component calculated during the work-in-process calculation by the standard component cost of the corresponding product component. That is, for any product component, the standard work-in-process cost of that product component = the quantity of that product component in work-in-process × the standard component cost of that product component.
[0085] Step 3, Settlement: For any product component, based on the total work-in-process cost of the target product, calculate the first theoretical work-in-process cost of the product component according to the ratio of "work-in-process cost of the product component / standard cost of the target product". Thus, based on the standard work-in-process cost of each product component and the first theoretical work-in-process cost of each product component, determine the first discrepancy information.
[0086] In one possible implementation, for any product component, the total work-in-process cost of the target product calculated in the work-in-process calculation process can be multiplied by the ratio of "work-in-process cost of the product component / standard product cost of the target product" to obtain the first theoretical work-in-process cost of the product component. That is, the first theoretical work-in-process cost of the product component can be calculated using the formula "first theoretical work-in-process cost of any product component = work-in-process cost of the product component / standard product cost of the target product * total work-in-process cost of the target product".
[0087] After calculating the first theoretical work-in-process cost of each product component through the above process, the first difference information of each product component can be calculated using the formula: "First difference information corresponding to any product component = First theoretical work-in-process cost of the product component - Standard work-in-process cost of the product component".
[0088] Step 4: Add the first difference information calculated in Step 3 to the first theoretical work-in-process cost of each component to obtain the actual work-in-process cost of each component, which is the first cost information.
[0089] By pre-calculating the initial cost information, adjustments can be made directly to the calculated initial cost information after the variance adjustment information is determined. During the calculation of the initial cost information, the initial theoretical work-in-process cost has already been adjusted based on the initial variance information. Further adjustments are made to the initial cost information obtained after the variance adjustment information is determined, thereby further improving the accuracy of the determined cost information.
[0090] This invention obtains first difference information—the difference between the standard cost of a product component and the first theoretical cost of the product component—and second difference information—the difference between the standard cost of a product component and the second theoretical cost of the product component. Based on the first and second difference information, difference adjustment information is determined. Then, based on the difference adjustment information, the first cost information obtained through the material ledger module is adjusted to obtain second cost information that is closer to the actual cost of the target product, thereby improving the accuracy of the calculated actual component cost and reducing the occurrence of distortion in the calculated actual component cost.
[0091] After introducing the basic implementation process of the present invention, various non-limiting embodiments of the present invention will be described in detail below.
[0092] It should be noted that the first difference information has already been calculated during the calculation of the first cost information. To avoid duplicate calculation, the first cost information can be calculated before step 101 so that the calculation of the first difference information can be completed before step 101.
[0093] Optionally, the computing device can pre-calculate the first difference information of each product component of the target product and store the first difference information so that the stored first difference information can be directly obtained in step 101.
[0094] In one possible implementation, the first difference information can be stored in the target database, so that the first difference information can be obtained from the target database in step 101.
[0095] Optionally, the first difference information can be stored in the first table of the target database. For example, the first difference information can be stored in the first target field of the first table, so that in step 101, the first difference information located in the first target field can be obtained from the first table of the target database.
[0096] It should be noted that the target database can be a database associated with a computing device, enabling the computing device to perform data read and write operations on the target database. The target database may include multiple tables for storing different types of information. For example, the target database may include a first table, which could be used to store the initial differences between the various product components of the target product.
[0097] The first table can be a database table MLDOCCCS. In the database table MLDOCCCS, the table field ELEMENT can be used to store various product components, and the table field TOT can be used to store the specific value of the first difference information. The table field TOT is the first target field.
[0098] In some embodiments, retrieving the first difference information located at the first target field from a first table in the target database may include the following steps:
[0099] Step 1011: Based on the business information in the second table associated with the first table and the component information in the third table associated with the first table, determine the product components that meet the first set conditions.
[0100] It should be noted that, in addition to the first table, the target database may also include a second table and a third table. Both the second and third tables can be related to the first table. The second table can be the database table MLDOC, and the third table can be the database table CKMLHD. The second table can be used for business information, such as business transactions, transaction types, and reference processes. The third table can be used to store component information related to the target product, such as which product components the target product includes.
[0101] In one possible implementation, the component information in the third table associated with the first table can be used to determine which product components the target product includes, and then the business information in the second table associated with the first table can be used to determine which of these product components meet the first set conditions.
[0102] The first condition can be:
[0103] Business transaction (table field GLVOR) equals "KOAE", transaction type (table field VGART) equals "UP", reference procedure (table field AWTYP) equals "AUAK"; or,
[0104] Business transaction (table field GLVOR) equals "RMBL", transaction type (table field VGART) equals "MA", and reference procedure (table field AWTYP) equals "PRCHG".
[0105] Step 1012: Obtain the first difference information corresponding to the product component that meets the first set condition from the first target field of the first table.
[0106] It should be noted that after determining which product components meet the first set conditions through the above step 1011, the first difference information corresponding to the product components that meet the first set conditions can be obtained from the first target field of the first table.
[0107] The above is only an introduction to the process of obtaining the first difference information of the target product. The process of obtaining the second difference information of the target product will be introduced below.
[0108] In some embodiments, the second difference information corresponding to each product component of the target product can be pre-calculated before step 102, and the calculated second difference information can be stored so that the stored second difference information can be directly obtained in step 102. Optionally, the second cost information of each product component can be calculated when calculating the first cost information. For example, the second difference information corresponding to each product component can be calculated during the difference calculation process when calculating the first cost information, that is, in step two.
[0109] In one possible implementation, when calculating the second difference information of the target product, the second difference information of each product component can be calculated using the formula: "Second difference information of any product component = input cost of the product component - output of the product component - scrap of the product component - standard work-in-process cost of the product component".
[0110] The input cost of the product component refers to the resources actually invested in the production process of the product component, such as how much money was actually invested in the production process of the product component; the output of the product component refers to the resources of the successfully produced product component, such as the price of the successfully produced product component; the scrapping of the product component refers to the resources of the product component that failed to be produced, such as the price of the product component that failed to be produced; for the work-in-process cost of the product component, the first cost information of the product component can be used as the work-in-process cost of the product component, or the standard work-in-process cost of the product component can be used as the work-in-process cost of the product component, or the theoretical work-in-process cost of the product component can be used as the work-in-process cost of the product component, and this invention does not limit this.
[0111] In one possible implementation, after the second difference information is calculated through the above process, the second difference information can be stored in the target database, so that the second difference information can be obtained from the target data in step 102.
[0112] Optionally, the second difference information can be stored in the fourth table of the target database. For example, the second difference information can be stored in the second target field of the target database, so that in step 102, the second difference information located in the second target field can be obtained from the fourth table of the target database.
[0113] The fourth table is a table included in the target database. This fourth table can be a database table COSB. Within the COSB table, the HRKFT field can be used to store various product components, and the WOGO field... <xx>It can be used to store the specific values of the second difference information; the table field WOGO <xx>This is the second target field.
[0114] In some embodiments, retrieving the second difference information located at the second target field from the fourth table of the target database can be achieved through the following process:
[0115] Obtain the second difference information corresponding to the product component that meets the second set conditions from the second target field of the fourth table.
[0116] The second condition can be:
[0117] The value type (table field is WRTTP) is "31", the business transaction (table field is VRGNG) is "KVAR", and the freeze during the period (table field is PERBL) is "016".
[0118] The computing device can determine which product components' second difference information needs to be obtained from the fourth table according to the second set conditions mentioned above, and thus obtain the second difference information of the product components that meet the second set conditions from the second set field.
[0119] After obtaining the first difference information and the second difference information through the above process, the difference adjustment information can be determined based on the first difference information and the second difference information through step 103.
[0120] In some embodiments, when determining the difference adjustment information based on the first difference information and the second difference information in step 103, it can be implemented in the following manner:
[0121] In one possible implementation, the difference between the first difference information and the second difference information can be determined as the difference adjustment information. That is, the difference adjustment information can be determined using the formula "Difference Adjustment Information = First Difference Information - Second Difference Information".
[0122] After determining the difference adjustment information through the above process, the first cost information can be adjusted based on the determined difference adjustment information.
[0123] In some embodiments, when adjusting the first cost information based on the difference adjustment information to obtain the second cost information in step 104, it can be implemented in the following way:
[0124] In one possible implementation, difference adjustment information can be superimposed on the first cost information to obtain the second cost information.
[0125] It should be noted that, since the second cost information is obtained by adjusting the first cost information determined by the material ledger module of the enterprise resource planning system based on the difference adjustment information, before step 104, the value of the difference adjustment information can be carried by the first target parameter, and the information type of the difference adjustment information can be carried by the second target parameter. The value and information type of the difference adjustment information are stored in the enterprise resource planning system by transmitting the first target parameter and the second target parameter, so that the computing device can read the difference adjustment information after obtaining the first cost information by running the material ledger module, and then further adjust the first cost information based on the difference adjustment information.
[0126] The first target parameter can be "IT_CCS", and the second target parameter can be "I_MLCCT". When the value carried by the second target parameter (i.e., "I_MLCCT") is E, the computing device can determine that the value carried by the first target parameter is the value of the difference adjustment information. In other words, the value carried by the second target parameter can serve as a certificate for the difference adjustment information, so that when the value carried by the second target parameter is E, the computing device can store the value of the difference adjustment information carried by the first target parameter into the enterprise resource planning system, thereby realizing the entry of the difference adjustment information into the system.
[0127] Optionally, the function "CKMMC_MANCHANG_AUTOMATED" can be called to transfer the first and second target parameters. The interface structure of the function "CKMMC_MANCHANG_AUTOMATED" can be found in [link to documentation]. Figure 2 , Figure 2 This is a schematic diagram of the interface structure of the function "CKMMC_MANCHANG_AUTOMATED" according to an embodiment of the present invention. Figure 2 The information displayed shows the differences in the adjustment of product components corresponding to KST001 to KST040.
[0128] The information processing procedures provided in the above embodiments can be found in [reference needed]. Figure 3 , Figure 3 This is a flowchart illustrating an information processing procedure according to an embodiment of the present invention, such as... Figure 3 As shown, the first difference information calculated during the settlement process and the second difference information calculated during the difference calculation process are obtained respectively. Then, according to the formula "difference adjustment information = first difference information - second difference information", the difference adjustment information is determined based on the first difference information and the second difference information. The difference adjustment information is then entered into the system through voucher entry so that the first cost information calculated by the material ledger module can be further adjusted based on the difference adjustment information to obtain the second cost information that is closer to the actual component cost.
[0129] The above Figure 3 The illustration shown is merely a procedural description of the present invention. Figure 3 The implementation process of each step can be found in the above embodiments, and will not be repeated here.
[0130] This invention provides a solution for further adjusting the first cost information calculated in the material ledger module. This solution does not require any changes to the standard functions of SAP ERP and can easily solve the problem of inaccurate calculation of actual component costs in the standard functions of SAP ERP. It also avoids the problem that it is difficult to fully understand the back-end implementation logic of the standard functions in custom development, and that the implementation workload is huge and prone to bugs.
[0131] Furthermore, experiments have shown that, during end-of-period cost accounting, the second cost information calculated using the solution provided by this invention is closer to the actual product component cost than the first cost information calculated by the material ledger module, thus improving the accuracy of component cost adjustments.
[0132] Embodiments of the present invention also provide an information processing apparatus, see [link to previous document]. Figure 4 , Figure 4 This is a block diagram of an information processing apparatus according to an embodiment of the present invention, the apparatus comprising:
[0133] The first acquisition unit 401 is used to acquire first difference information representing the difference between the standard in-product cost of the product component and the first theoretical in-product cost of the product component of the target product. The first theoretical in-product cost is determined based on the standard in-product cost of the product component, the standard in-product cost of the target product, and the total in-product cost of the target product.
[0134] The second acquisition unit 402 is used to acquire second difference information characterizing the difference between the standard product cost and the second theoretical product cost of the product component, wherein the second theoretical product cost is determined based on the input cost, output and scrap of the product component.
[0135] The determining unit 403 is used to determine the difference adjustment information based on the first difference information and the second difference information;
[0136] Adjustment unit 404 is used to adjust the first cost information of product components based on the difference adjustment information to obtain the second cost information. The first cost information is obtained through the material ledger module.
[0137] In one embodiment of the present invention, the first acquisition unit 401, when acquiring first difference information between the standard in-product cost of a product component characterizing a target product and the first theoretical in-product cost of the product component, is used to:
[0138] Retrieve the first difference information located at the first target field from the first table of the target database.
[0139] In one embodiment of the present invention, the first acquisition unit 401, when acquiring first difference information located at a first target field from a first table in a target database, is configured to:
[0140] Based on the business information in the second table associated with the first table and the component information in the third table associated with the first table, product components that meet the first set conditions are determined.
[0141] Obtain the first difference information corresponding to the product component that meets the first set conditions from the first target field of the first table.
[0142] In one embodiment of the present invention, the second acquisition unit 402, when acquiring second difference information characterizing the difference between the standard in-product cost of the product component and the second theoretical in-product cost of the product component, is used to:
[0143] Retrieve the second difference information located in the second target field from the fourth table of the target database.
[0144] In one embodiment of the present invention, the second acquisition unit 402, when acquiring second difference information located at the second target field from the fourth table of the target database, is used to:
[0145] Obtain the second difference information corresponding to the product component that meets the second set conditions from the second target field of the fourth table.
[0146] In one embodiment of the present invention, the determining unit 403, when determining difference adjustment information based on the first difference information and the second difference information, is configured to:
[0147] The difference between the first difference information and the second difference information is determined as the difference adjustment information.
[0148] In one embodiment of the present invention, the adjustment unit 404, when adjusting the first cost information of a product component based on the difference adjustment information to obtain the second cost information, is configured to:
[0149] The second cost information is obtained by overlaying the difference adjustment information on the first cost information.
[0150] In one embodiment of the present invention, the first cost information is obtained through an enterprise resource planning system;
[0151] The device also includes:
[0152] The storage unit is used to carry the value of the difference adjustment information through a first target parameter, carry the information type of the difference adjustment information through a second target parameter, and store the value and information type of the difference adjustment information in the enterprise resource planning system by transmitting the first target parameter and the second target parameter.
[0153] The specific implementation process of the functions and roles of each unit in the above device can be found in the implementation process of the corresponding steps in the above method, and will not be repeated here.
[0154] For the apparatus embodiments, since they basically correspond to the method embodiments, the relevant parts can be referred to in the description of the method embodiments. The apparatus embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of the solution in this specification according to actual needs. Those skilled in the art can understand and implement this without creative effort.
[0155] The present invention also provides a computing device, see [link to relevant documentation]. Figure 5 , Figure 5 This is a schematic diagram of the structure of a computing device according to an embodiment of the present invention. Figure 5 As shown, the computing device includes a processor 510, a memory 520, and a network interface 530. The memory 520 stores computer program code that can run on the processor 510. The processor 510 is used to implement the information processing method provided in any embodiment of the present invention when executing the computer program code. The network interface 530 is used to implement input / output functions. In more possible implementations, the computing device may also include other hardware, which is not limited by the present invention.
[0156] This invention also provides a computer-readable storage medium, which can take many forms, such as RAM (Random Access Memory), volatile memory, non-volatile memory, flash memory, storage drives (e.g., hard disk drives), solid-state drives, any type of storage disk (e.g., optical discs, DVDs), or similar storage media, or combinations thereof. Specifically, the computer-readable medium can also be paper or other suitable media capable of printing programs. A computer program is stored on the computer-readable storage medium, and when executed by a processor, the computer program implements the information processing method provided in any embodiment of this invention.
[0157] The present invention also provides a computer program product, including a computer program that, when executed by a processor, implements the information processing method provided in any embodiment of the present invention.
[0158] In this invention, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance. The term "multiple" refers to two or more unless otherwise expressly defined.
[0159] Other embodiments of the invention will readily occur to those skilled in the art upon consideration of the specification and practice of the disclosure herein. The invention is intended to cover any variations, uses, or adaptations of the invention that follow the general principles of the invention and include common knowledge or customary techniques in the art not disclosed herein. The specification and examples are to be considered exemplary only, and the true scope and spirit of the invention are indicated by the following claims.
[0160] It should be understood that the present invention is not limited to the precise structure described above and shown in the accompanying drawings, and various modifications and changes can be made without departing from its scope. The scope of the invention is limited only by the appended claims.< / xx> < / xx>
Claims
1. An information processing method, characterized in that, The method includes: Obtain first difference information about the difference between the standard in-product cost of a product component characterizing a target product and the first theoretical in-product cost of the product component, wherein the first theoretical in-product cost is determined based on the standard in-product cost of the product component, the standard in-product cost of the target product, and the total in-product cost of the target product. Obtain second difference information characterizing the difference between the standard in-product cost of the product component and the second theoretical in-product cost of the product component, the second theoretical in-product cost being determined based on the input cost, output, and scrap of the product component; Based on the first difference information and the second difference information, difference adjustment information is determined; Based on the difference adjustment information, the first cost information of the product component is adjusted to obtain the second cost information. The first cost information is obtained through the material ledger module of the enterprise resource planning system. Before adjusting the first cost information of the product component based on the difference adjustment information to obtain the second cost information, the method further includes: The difference adjustment information is carried by a first target parameter, and the information type of the difference adjustment information is carried by a second target parameter. The difference adjustment information is stored in the enterprise resource planning system by transmitting the first target parameter and the second target parameter. The information type of the difference adjustment information carried by the second target parameter is a specified parameter value.
2. The method according to claim 1, characterized in that, The first difference information obtained by acquiring the difference between the standard product cost of the product component characterizing the target product and the first theoretical product cost of the product component includes: Retrieve the first difference information located at the first target field from the first table of the target database.
3. The method according to claim 2, characterized in that, The step of retrieving the first difference information located at the first target field from the first table of the target database includes: Based on the business information in the second table associated with the first table and the component information in the third table associated with the first table, product components that meet the first set conditions are determined. Obtain the first difference information corresponding to the product component that meets the first set condition from the first target field of the first table.
4. The method according to claim 1, characterized in that, The acquisition of second difference information, which characterizes the difference between the standard cost of the product component and the second theoretical cost of the product component, includes: Retrieve the second difference information located in the second target field from the fourth table of the target database; The step of obtaining the second difference information located at the second target field from the fourth table of the target database includes: From the second target field of the fourth table, obtain the second difference information corresponding to the product component that meets the second set conditions.
5. The method according to claim 1, characterized in that, The step of determining the difference adjustment information based on the first difference information and the second difference information includes: The difference between the first difference information and the second difference information is determined as the difference adjustment information.
6. The method according to claim 1, characterized in that, The step of adjusting the first cost information of the product component based on the difference adjustment information to obtain the second cost information includes: The difference adjustment information is superimposed on the first cost information to obtain the second cost information.
7. An information processing device, characterized in that, The device includes: The first acquisition unit is used to acquire first difference information about the difference between the standard in-product cost of the product component representing the target product and the first theoretical in-product cost of the product component, wherein the first theoretical in-product cost is determined based on the standard in-product cost of the product component, the standard in-product cost of the target product, and the total in-product cost of the target product. The second acquisition unit is used to acquire second difference information characterizing the difference between the standard in-product cost of the product component and the second theoretical in-product cost of the product component, wherein the second theoretical in-product cost is determined based on the input cost, output and scrap of the product component; The determining unit is configured to determine difference adjustment information based on the first difference information and the second difference information; An adjustment unit is used to adjust the first cost information of the product component based on the difference adjustment information to obtain second cost information. The first cost information is obtained through the material ledger module of the enterprise resource planning system. The storage unit is used to carry the value of the difference adjustment information through a first target parameter, carry the information type of the difference adjustment information through a second target parameter, and store the value and information type of the difference adjustment information in the enterprise resource planning system by transmitting the first target parameter and the second target parameter. The information type of the difference adjustment information carried by the second target parameter is a specified parameter value.
8. A computing device, characterized in that, The computing device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to perform the operations performed by the information processing method as described in any one of claims 1 to 6.
9. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a program that, when executed by a processor, performs the operations performed by the information processing method as described in any one of claims 1 to 6.
Citation Information
Patent Citations
Method for generating cost control information, device and data management system thereof
CN101710397A