Merged report generation method and device based on SAP system, electronic equipment and storage medium

Abstract

The invention discloses a merged report generation method and device based on an SAP system, electronic equipment and a storage medium, and belongs to the technical field of data processing.The method comprises the steps that a preset merged report template is obtained in response to a triggered merged report generation instruction; importing the combined report template into an SAP system, triggering the SAP system to read a preset combined report configuration table, and updating the combined report data to the combined report template; and generating a merged report based on the merged report data and the merged report template. According to the method, data articulation calculation on the SAP system is completed through the preset merged report template, so that the merged report is generated, the learning, implementation and maintenance cost is effectively reduced, subsequent secondary development is facilitated, the method is simple and easy to implement, the generation efficiency of the merged report is improved, and the use experience of a user is improved.

Description

Technical Field

[0001] The present application relates to the field of data processing technology, and in particular to a method, device, electronic device, and storage medium for generating a consolidated report based on a SAP system. Background Art

[0002] Consolidated financial statements refer to the combination of the financial statements of the parent company and all its subsidiaries into a comprehensive set of financial statements in accordance with certain accounting standards and methods to reflect the financial status and operating results of the entire enterprise group under a unified entity. Currently, consolidated reporting systems are gradually being integrated more closely with ERP systems and other data sources to meet the consolidated reporting needs of complex enterprises.

[0003] In related technologies, the SAP BPC system is often used to prepare consolidated financial statements. However, in actual applications, the SAP BPC system's architecture and functionality are relatively complex, increasing the learning curve and user experience. Enterprises also need to invest significant manpower and material resources to ensure the system's normal operation and continuous optimization, resulting in high implementation and maintenance costs. Furthermore, secondary development requires developers to possess in-depth programming and SAP system knowledge, further increasing development difficulty and costs.

[0004] In summary, the technical problems existing in the relevant technologies need to be improved. Summary of the Invention

[0005] The embodiments of the present application provide a method, device, electronic device, and storage medium for generating consolidated reports based on the SAP system, which can effectively reduce learning, implementation, and maintenance costs, facilitate subsequent secondary development, are simple and easy to implement, and help improve the efficiency of generating consolidated reports and enhance the user experience.

[0006] In one aspect, an embodiment of the present application provides a method for generating a consolidated report based on a SAP system, the method comprising the following steps:

[0007] In response to the triggered consolidated report generation instruction, obtaining a preset consolidated report template;

[0008] Importing the consolidated report template into the SAP system, triggering the SAP system to read a preset consolidated report configuration table, and updating the consolidated report data into the consolidated report template;

[0009] A consolidated report is generated based on the consolidated report data and the consolidated report template.

[0010] Optionally, the consolidated report configuration table includes a consolidated report company code comparison table, a consolidated report transaction unit comparison table, and a consolidated report parameter configuration table;

[0011] The step of importing the merged report template into the SAP system, triggering the SAP system to read a preset merged report configuration table, and updating the merged report data into the merged report template includes:

[0012] Importing the consolidated report template into the SAP system, triggering the SAP system to read the preset consolidated report company code comparison table, consolidated report transaction unit comparison table, and consolidated report parameter configuration table;

[0013] Converting the company code in the SAP report data of the SAP system into the consolidated report company code according to the consolidated report company code comparison table;

[0014] According to the consolidated statement transaction unit comparison table, the customer code in the SAP report data of the SAP system is converted into the consolidated statement transaction unit code;

[0015] Based on the consolidated report parameter configuration table, the consolidated report company code, and the consolidated report transaction unit code, the SAP report data is converted into consolidated report data, and the consolidated report data is updated to the consolidated report template.

[0016] Optionally, the file format of the merged report template is Excel report format.

[0017] Optionally, the merged report template in the Excel report format includes a first tab page, a second tab page, and a third tab page;

[0018] The third tab page is used as a parameter maintenance interface to store the matching relationship between the fields of the SAP report data and the columns of the Excel report;

[0019] The second tab page is used to receive and store consolidated report data;

[0020] The first tab page is used to summarize and calculate the consolidated report data according to a preset calculation formula and display the consolidated report.

[0021] Optionally, generating a consolidated report based on the consolidated report data and the consolidated report template includes:

[0022] Based on the data reading formula preset in the first tab page, read the consolidated report data received in the second tab page and update it in the first tab page;

[0023] Based on the calculation formula preset in the first tab page, and according to the updated consolidated report data in the first tab page, the consolidated report data is summarized and calculated; wherein the preset calculation formula includes a horizontal amount summary calculation formula and a vertical amount summary calculation formula;

[0024] A consolidated report is generated based on the calculation result of the consolidated report data and the consolidated report template, and the consolidated report is displayed through the first tab page.

[0025] Optionally, the merged report template in the Excel report format is set to a locked mode.

[0026] Optionally, the method further includes:

[0027] In response to the triggered data update instruction, the merged report template and the merged report configuration table are updated.

[0028] On the other hand, an embodiment of the present application provides a device for generating a consolidated report based on a SAP system, the device comprising:

[0029] A template acquisition module, configured to acquire a preset consolidated report template in response to a triggered consolidated report generation instruction;

[0030] A data acquisition module, configured to import the consolidated report template into the SAP system, trigger the SAP system to read a preset consolidated report configuration table, and update the consolidated report data into the consolidated report template;

[0031] The report generation module is used to generate a consolidated report based on the consolidated report data and the consolidated report template.

[0032] On the other hand, an embodiment of the present application provides an electronic device, which includes a memory and a processor. The memory stores a computer program, and when the processor executes the computer program, the above-mentioned method for generating a consolidated report based on the SAP system is implemented.

[0033] On the other hand, an embodiment of the present application provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the above-mentioned method for generating a consolidated report based on the SAP system.

[0034] The embodiment of the present application uses a preset consolidated report template to complete the calculation of the data cross-reference relationship on the SAP system, thereby generating a consolidated report, effectively reducing the learning, implementation and maintenance costs, facilitating subsequent secondary development, being simple and easy, and helping to improve the efficiency of generating consolidated reports and enhance the user experience. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 This is a schematic diagram of an implementation environment of a method for generating a consolidated report based on a SAP system provided in an embodiment of the present application;

[0036] Figure 2This is a flow chart of a method for generating a consolidated report based on a SAP system provided in an embodiment of the present application;

[0037] Figure 3 This is a schematic diagram of the structure of a combined report generation device based on a SAP system provided in an embodiment of the present application;

[0038] Figure 4 This is a schematic diagram of the hardware structure of an electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0039] In order to make the purpose, technical solutions and advantages of the present application clearer, the present application is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are only used to explain the present application and are not intended to limit the present application. When the following description refers to the drawings, unless otherwise indicated, the same numbers in different drawings represent the same or similar elements. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the embodiments of the present application. They are merely examples of devices and methods consistent with some aspects of the embodiments of the present application as detailed in the appended claims.

[0040] It will be understood that the terms "first", "second", etc. used in this application may be used herein to describe various concepts, but unless otherwise specified, these concepts are not limited by these terms. These terms are only used to distinguish one concept from another. For example, without departing from the scope of the embodiments of the present application, the first information may also be referred to as the second information, and similarly, the second information may also be referred to as the first information. Depending on the context, the words "if" and "if" as used herein may be interpreted as "at the time of" or "when" or "in response to determining".

[0041] The terms "at least one", "plurality", "each", "any", etc. used in this application include "at least one", "two" or more, "plurality" or "each", "any" or "any one", "each" or "any one" in the context of the present invention, and "at least one" or "at least one" includes one, two or more, "plurality" or "any one" includes two or more, "each" or "each one" in the context of the present invention, and "any" or "any one

[0042] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by those skilled in the art to which this application pertains. The terms used herein are for the purpose of describing the embodiments of this application only and are not intended to limit this application.

[0043] Consolidated financial statements refer to the combination of the financial statements of the parent company and all its subsidiaries into a comprehensive set of financial statements in accordance with certain accounting standards and methods to reflect the financial status and operating results of the entire enterprise group under a unified entity. Currently, consolidated reporting systems are gradually being integrated more closely with ERP systems and other data sources to meet the consolidated reporting needs of complex enterprises.

[0044] In related technologies, the SAP BPC system is often used to prepare consolidated financial statements. However, in actual applications, the SAP BPC system's architecture and functionality are relatively complex, increasing the learning curve and user experience. Enterprises also need to invest significant manpower and material resources to ensure the system's normal operation and continuous optimization, resulting in high implementation and maintenance costs. Furthermore, secondary development requires developers to possess in-depth programming and SAP system knowledge, further increasing development difficulty and costs.

[0045] In view of this, the embodiments of the present application provide a method, device, electronic device and storage medium for generating a consolidated report based on the SAP system. The solution completes the calculation of the data cross-reference relationship on the SAP system through a preset consolidated report template, thereby generating a consolidated report, effectively reducing the learning, implementation and maintenance costs, facilitating subsequent secondary development, being simple and easy, and helping to improve the efficiency of generating consolidated reports and enhance the user experience.

[0046] It should be noted that in each specific embodiment of the present application, when it comes to the need to perform relevant processing based on data related to the user's identity or characteristics, such as user information, user behavior data, user historical data, and user location information, the user's permission or consent will be obtained first, and the collection, use, and processing of such data will comply with relevant laws, regulations, and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or by jumping to a confirmation page. After clearly obtaining the user's separate permission or consent, the necessary user-related data for the normal operation of the embodiment of the present application will be obtained.

[0047] The specific implementation of the embodiment of the present application is described in detail below with reference to the accompanying drawings. First, a method for generating a consolidated report based on a SAP system provided in the embodiment of the present application is described with reference to the accompanying drawings.

[0048] Please refer to Figure 1 , Figure 1 1 is a schematic diagram of an implementation environment of a method for generating a consolidated report based on a SAP system provided in an embodiment of the present application. In this implementation environment, the main hardware and software components involved include a terminal processor 110 and a server 120.

[0049] Specifically, the terminal processor 110 may be installed with a control program for a method for generating consolidated reports based on an SAP system, and the server 120 is the backend server for the control program. The terminal processor 110 and the backend server 120 are in communication with each other. The method for generating consolidated reports based on an SAP system provided in the embodiments of the present application may be executed on the terminal processor 110.

[0050] Server 120 can be an independent physical server, or a server cluster or distributed system composed of multiple physical servers. It can also be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN (Content Delivery Network), as well as big data and artificial intelligence platforms.

[0051] In addition, the server 120 may also be a node server in the blockchain network.

[0052] A communication connection can be established between the terminal processor 110 and the server 120 via a wireless network. The wireless network uses standard communication technologies and / or protocols. The network can be the Internet or any other network, including, but not limited to, a local area network (LAN), a metropolitan area network (MAN), a wide area network (WAN), a mobile network, or any combination of a wireless network, a private network, or a virtual private network. Furthermore, the aforementioned software and hardware entities can use the same or different communication connection methods, and this application does not impose any specific restrictions on this.

[0053] Of course, it is understandable that Figure 1 The implementation environment is only some optional application scenarios of the method for generating a consolidated report based on the SAP system provided in the embodiment of the present application. The actual application is not fixed to Figure 1 The software and hardware environment shown is not specifically limited in this application.

[0054] like Figure 2 As shown, Figure 2 This is a flowchart of a method for generating a consolidated report based on a SAP system provided in an embodiment of the present application, specifically including but not limited to steps 100 to 300.

[0055] Step 100: In response to a triggered consolidated report generation instruction, a preset consolidated report template is obtained.

[0056] In an embodiment of the present application, the merged report generation instruction can be generated by the user by clicking the merged report generation button as a trigger signal, or it can be automatically generated by the processor according to a certain time interval. After the merged report generation instruction is generated and sent to the processor of the corresponding merged report generation program, the processor of the relevant program will respond to the triggered merged report generation instruction and can obtain the preset merged report template based on the target information carried in the merged report generation instruction.

[0057] In actual applications, different companies can be pre-configured with different consolidated report templates. When you choose to generate a business report for any company, the triggered consolidated report generation instruction can carry the target information of any company and match and retrieve the corresponding consolidated report template from the preset consolidated report templates.

[0058] Step 200: Import the merged report template into the SAP system, trigger the SAP system to read the preset merged report configuration table, and update the merged report data into the merged report template.

[0059] In an embodiment of the present application, the acquired merged report template is imported into the SAP system, triggering the SAP system to read the pre-set merged report configuration table, and through the merged report configuration table, the relevant data from the SAP report data is updated as merged report data into the merged report template.

[0060] Specifically, as an optional implementation, the consolidated report configuration table includes a consolidated report company code comparison table, a consolidated report transaction unit comparison table, and a consolidated report parameter configuration table;

[0061] The step of importing the merged report template into the SAP system, triggering the SAP system to read a preset merged report configuration table, and updating the merged report data into the merged report template includes:

[0062] Importing the consolidated report template into the SAP system, triggering the SAP system to read the preset consolidated report company code comparison table, consolidated report transaction unit comparison table, and consolidated report parameter configuration table;

[0063] Converting the company code in the SAP report data of the SAP system into the consolidated report company code according to the consolidated report company code comparison table;

[0064] According to the consolidated statement transaction unit comparison table, the customer code in the SAP report data of the SAP system is converted into the consolidated statement transaction unit code;

[0065] Based on the consolidated report parameter configuration table, the consolidated report company code, and the consolidated report transaction unit code, the SAP report data is converted into consolidated report data, and the consolidated report data is updated to the consolidated report template.

[0066] In an embodiment of the present application, the preset consolidated report configuration table mainly includes a consolidated report company code comparison table, a consolidated report trade unit comparison table, and a consolidated report parameter configuration table. Among them, the consolidated report company code comparison table can be named ZFIMERGE1, which is mainly used to record and store the conversion relationship between the company code in the SAP system and the company code in the consolidated report of the group; the consolidated report trade unit comparison table can be named ZFIMERGE2, which is mainly used to record and store the conversion relationship between the internal customer code of the SAP system and the trade customer code in the consolidated report of the group; the consolidated report parameter configuration table can be named ZFIMERGE3, which is mainly used to store the configuration parameters of the consolidated report template, for example, it can include a report serial number, which can be set by the group headquarters, and can also include the template format of the consolidated report, including the top margin and the number of rows to be read. The top margin refers to the starting row number of the valid data in the consolidated report, which can effectively exclude the header. The number of rows to be read refers to the total number of rows of the preset trade units of the company. When there is an unmatched trade unit, the row number can be automatically located and added after the row number is read to facilitate recording the accounts receivable data of the unmatched trade units.

[0067] In actual application, the SAP system reads the preset consolidated report configuration table that determines the target company based on the target information in the consolidated report template, and converts the corresponding company code in the SAP report data into the consolidated report company code based on the consolidated report company code comparison table, and converts the corresponding customer code in the SAP report data into the consolidated report transaction unit code based on the consolidated report transaction unit comparison table. Finally, the format of the corresponding consolidated report template is determined based on the consolidated report parameter configuration table, the relevant SAP report data is converted into the consolidated report data format, and the consolidated report data is updated to the consolidated report template according to the relevant template format.

[0068] It is understandable that the consolidated report template can be pre-filled with relevant business units and company codes. After the SAP system converts the SAP report data into consolidated report data according to the configuration table, it can automatically match the row numbers of the relevant information based on the conversion relationship. For business unit data that cannot be matched, new row numbers can be automatically added based on the preset reading row number information, which is convenient for including business unit information data outside the statistical total range.

[0069] In actual application, you can locate the area that needs to be filled in the consolidated report template according to the pre-configured "top margin" and "number of rows to read" in the consolidated report parameter configuration table, and then read the detailed data extracted by the SAP system line by line. If a match can be found in the existing row according to the "merged customer code", the data will be written in the corresponding column of the row. If the match fails, a new row will be automatically appended according to the "top margin + predetermined number of rows" and a new trading unit row will be written.

[0070] Step 300: Generate a consolidated report based on the consolidated report data and the consolidated report template.

[0071] In an embodiment of the present application, after the consolidated report data is updated to the consolidated report template, the consolidated report data can be summarized and calculated according to the calculation formula preset in the consolidated report template. For example, the consolidated report data may include different detailed data such as the amount of general bad debt reserves, the amount of individual bad debt reserves, general bad debt reserves, individual bad debt reserves, etc., and can be divided into the beginning of the year and weekends according to the cycle, and can be divided into 0-3 months, 3 months-1 year, 1 year-2 years, 2 years-3 years and more than 3 years according to the time limit, so as to quickly calculate the financial data of different subsidiaries and meet the personalized needs of the group.

[0072] In actual applications, the Excel report format can be used as the file format of the consolidated report template, so as to effectively utilize the calculation formulas provided in the Excel report format and quickly complete the calculation of complex data cross-reference relationships in the consolidated report, thereby reducing project implementation and maintenance costs and truly achieving what you see is what you get in the Excel report.

[0073] Specifically, as an optional implementation, the merged report template in the Excel report format includes a first tab page, a second tab page, and a third tab page;

[0074] The third tab page is used as a parameter maintenance interface to store the matching relationship between the fields of the SAP report data and the columns of the Excel report;

[0075] The second tab page is used to receive and store consolidated report data;

[0076] The first tab page is used to summarize and calculate the consolidated report data according to a preset calculation formula and display the consolidated report.

[0077] In the embodiment of the present application, the Excel report format is used as the file format of the consolidated report template, which not only allows the calculation of the consolidated report data to be quickly processed through the calculation formulas provided by the Excel report, but also allows different business functions to be implemented using different tabs of the Excel report.

[0078] The Excel report format consolidated report template includes the first, second, and third tabs. The first tab is primarily used to summarize and calculate consolidated report data based on preset calculation formulas, display the consolidated report, and carry the final report layout, summary formulas, and format. For example, for detail-level amounts, a fill color can be used, while for parent unit and group summary data, the corresponding row or column data can be highlighted with a background color to facilitate users to quickly locate relevant consolidated report data. The second tab is used to receive and store consolidated report data updated by the SAP system. All detail-level amounts can be written to this page first, and the first tab can subsequently read the relevant data through positioning matching. The third tab serves as a parameter maintenance interface, storing the matching relationship between SAP report data fields and Excel report column items. In other words, after the SAP system determines the relevant row number information based on the consolidated report company code comparison table and the consolidated report trade unit comparison table, it can search for the corresponding column number signal in the third tab based on the SAP output field name, convert the corresponding SAP report data into consolidated report data, and fill it into the corresponding rows and columns in the second tab.

[0079] Therefore, this application uses the Excel report format as a template for the consolidated report. All formulas in the template are written in "relative reference" or "named area" mode, and do not rely on hard-coded row numbers. When the field name or column items to be output change, only the third tab page needs to be modified and adjusted. Different companies only need to pre-configure the corresponding consolidated report template to achieve seamless access. Subsequent program logic does not need to be modified, which can greatly reduce the cost of secondary development.

[0080] In actual application, the generation of a consolidated report based on the consolidated report data and the consolidated report template includes:

[0081] Based on the data reading formula preset in the first tab page, read the consolidated report data received in the second tab page and update it in the first tab page;

[0082] Based on the calculation formula preset in the first tab page, and according to the updated consolidated report data in the first tab page, the consolidated report data is summarized and calculated; wherein the preset calculation formula includes a horizontal amount summary calculation formula and a vertical amount summary calculation formula;

[0083] A consolidated report is generated based on the calculation result of the consolidated report data and the consolidated report template, and the consolidated report is displayed through the first tab page.

[0084] In an embodiment of the present application, the detailed data of all subsidiaries can be stored in the second tab page, and the consolidated report data received in the second tab page can be read based on the preset data reading formula in the first tab page through the "relative reference" or "named area" method, and updated to the first tab page, and then the consolidated report data can be summarized and calculated through the preset calculation formula in the first tab page, so as to obtain and display the final consolidated report. Among them, the preset calculation formula includes a horizontal amount summary calculation formula and a vertical amount summary formula. The horizontal amount summary calculation formula is mainly used to summarize and calculate the consolidated report data of each sub-group, such as the book amount at the beginning of the year, the book value at the beginning of the year, the book amount at the end of the period, and the book value at the end of the period; the vertical amount summary company is mainly used to summarize the consolidated report data of different superior units, as well as the final subtotal within the scope of consolidation, the subtotal outside the scope of consolidation, and the total data, so as to form the final consolidated report data.

[0085] Therefore, this application uses a preset consolidated report template to generate consolidated reports based on the SAP system. Operators do not need to learn new development platforms and languages, and the learning cost is low. The complex data cross-reference relationship calculations of the consolidated reports are completed based on preset calculation formulas, effectively reducing implementation and maintenance costs.

[0086] Specifically, as an optional implementation, the merged report template in the Excel report format is set to a locked mode.

[0087] In an embodiment of the present application, the merged report template in Excel report format can be set to a locked mode, for example, the protection mode of the tab page, data area and cell can be set to locked, and the user is not allowed to modify it, thereby protecting the authenticity and validity of the data.

[0088] Specifically, as an optional implementation manner, the method further includes:

[0089] In response to the triggered data update instruction, the merged report template and the merged report configuration table are updated.

[0090] In the embodiment of the present application, the consolidated report template and the consolidated report configuration table can also be updated and optimized regularly, which helps to better summarize and calculate the detailed data of all subsidiaries.

[0091] For example, the consolidated report template of the parent company can be adjusted once a year, mainly to add trading units. Therefore, this can be done by modifying the top margin parameters and the number of rows read in the consolidated report configuration table. The relevant report generation program automatically calculates the detailed data of the trading units based on the configuration parameters. For trading units that do not match, the starting row number of the additional data is calculated based on the Excel top margin + Excel read row number, thus ensuring the continuity of the trading report data.

[0092] Furthermore, when the consolidated report template needs to be adjusted and optimized, only the relevant calculation formulas need to be adjusted and optimized, without any changes to the program. Furthermore, implementing the consolidated report solution for a new company only requires completing the configuration parameters and setting up the Excel template to obtain the final data of the consolidated report, which is simple and easy to implement and helps improve the user experience.

[0093] The following is a detailed introduction and description of the method for generating a consolidated report based on the SAP system provided in the present invention, in conjunction with a specific application implementation process:

[0094] In an embodiment of the present application, a method for generating a consolidated report based on a SAP system is provided. This method can be applied to a consolidated report generation scenario. By using a preset consolidated report template, the cross-reference relationship calculation of data on the SAP system is completed, thereby generating a consolidated report, effectively reducing learning, implementation, and maintenance costs, facilitating subsequent secondary development, being simple and easy to implement, and helping to improve the efficiency of generating consolidated reports and enhance the user experience.

[0095] Specifically, the merged report generation instruction can be generated by the user by clicking the merged report generation button as a trigger signal, or it can be automatically generated by the processor according to a certain time interval. After the merged report generation instruction is generated and sent to the processor of the corresponding merged report generation program, the processor of the relevant program will respond to the triggered merged report generation instruction and can obtain the preset merged report template based on the target information carried in the merged report generation instruction.

[0096] Furthermore, the obtained consolidated report template is imported into the SAP system, triggering the SAP system to read the pre-set consolidated report configuration table, and through the consolidated report configuration table, update the consolidated report template with relevant data from the SAP report data as consolidated report data.

[0097] In actual applications, the pre-set consolidated report configuration tables mainly include the consolidated report company code comparison table, the consolidated report trade unit comparison table, and the consolidated report parameter configuration table. The consolidated report company code comparison table, which can be named ZFIMERGE1, is primarily used to record and store the conversion relationship between company codes in the SAP system and company codes in the group's consolidated reports. The consolidated report trade unit comparison table, which can be named ZFIMERGE2, is primarily used to record and store the conversion relationship between customer codes within the SAP system and trade unit codes in the group's consolidated reports. The consolidated report parameter configuration table, which can be named ZFIMERGE3, is primarily used to store configuration parameters for the consolidated report template. These parameters include, for example, the report sequence number (which can be set by the group headquarters), the consolidated report template format, the top margin, and the number of rows to read. The top margin refers to the starting row number for valid data in the consolidated report, effectively eliminating the header. The number of rows to read refers to the total number of rows for the company's trade units. If there are unmatched trade units, the system can automatically locate and append row numbers after reading the row number to facilitate recording the accounts receivable data of the unmatched trade units.

[0098] In actual application, the SAP system reads the preset consolidated report configuration table that determines the target company based on the target information in the consolidated report template, and converts the corresponding company code in the SAP report data into the consolidated report company code based on the consolidated report company code comparison table, and converts the corresponding customer code in the SAP report data into the consolidated report transaction unit code based on the consolidated report transaction unit comparison table. Finally, the format of the corresponding consolidated report template is determined based on the consolidated report parameter configuration table, the relevant SAP report data is converted into the consolidated report data format, and the consolidated report data is updated to the consolidated report template according to the relevant template format.

[0099] Furthermore, you can use the Excel report format as the file format of the consolidated report template, so as to effectively use the calculation formulas in the Excel report format to quickly complete the complex data cross-reference relationship calculation of the consolidated report, thereby reducing the cost of project implementation and maintenance. The consolidated report template in the Excel report format includes the first tab page, the second tab page and the third tab page. The first tab page is mainly used to summarize and calculate the consolidated report data according to the preset calculation formula, display the consolidated report, and carry the layout, summary formula and format of the final report. For example, for the detailed level amount, you can use the no fill color processing method, and for the superior unit and group summary data, you can use the background color to highlight the corresponding row data or column data for easy use Users can quickly locate relevant consolidated report data; the second tab page is used to receive and store consolidated report data updated by the SAP system. All detail-level amounts can be written to this page first, and the first tab page can then read the relevant data through positioning and matching. The third tab page serves as a parameter maintenance interface, storing the matching relationship between SAP report data fields and Excel report column items. In other words, after the SAP system determines the relevant row number information based on the consolidated report company code comparison table and the consolidated report transaction unit comparison table, it can search for the corresponding column number signal in the third tab page according to the SAP output field name, convert the corresponding SAP report data into consolidated report data, and fill in the corresponding rows and columns in the second tab page.

[0100] Therefore, this application uses the Excel report format as a template for the consolidated report. All formulas in the template are written in "relative reference" or "named area" mode, and do not rely on hard-coded row numbers. When the field name or column items to be output change, only the third tab page needs to be modified and adjusted. Different companies only need to pre-configure the corresponding consolidated report template to achieve seamless access. Subsequent program logic does not need to be modified, which can greatly reduce the cost of secondary development.

[0101] In practice, you can lock down Excel report templates for consolidated reports. For example, you can lock down tabs, data areas, and cells, preventing users from modifying them. This helps protect the authenticity and validity of data. Furthermore, you can regularly update and optimize the consolidated report template and its configuration table to better aggregate and calculate detailed data for all subsidiaries.

[0102] See also Figure 3 , Figure 3 : is a schematic diagram of the structure of a combined report generation device based on a SAP system provided in an embodiment of the present application. The embodiment of the present application also provides a combined report generation device based on a SAP system, which can implement the above-mentioned combined report generation method based on a SAP system. The device includes:

[0103] The template acquisition module 310 is configured to acquire a preset consolidated report template in response to a triggered consolidated report generation instruction;

[0104] The data acquisition module 320 is used to import the consolidated report template into the SAP system, trigger the SAP system to read the preset consolidated report configuration table, and update the consolidated report data into the consolidated report template;

[0105] The report generation module 330 is configured to generate a consolidated report based on the consolidated report data and the consolidated report template.

[0106] It can be understood that the contents of the above method embodiments are all applicable to the present device embodiments, the functions specifically implemented by the present device embodiments are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0107] See also Figure 4 , Figure 4 : This is a hardware structure diagram of an electronic device provided in an embodiment of the present application. The electronic device includes:

[0108] The processor 401 may be implemented as a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is configured to execute relevant programs to implement the technical solutions provided in the embodiments of the present application.

[0109] Memory 402 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). Memory 402 can store an operating system and other application programs. When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program code is stored in memory 402 and is called by processor 401 to execute the method for generating consolidated reports based on the SAP system in the embodiments of this application.

[0110] Input / output interface 403, used to implement information input and output;

[0111] Communication interface 404, used to implement communication interaction between this device and other devices, which can be achieved through wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WiFi, Bluetooth, etc.);

[0112] Bus 405 , which transmits information between various components of the device (e.g., processor 401 , memory 402 , input / output interface 403 , and communication interface 404 );

[0113] The processor 401 , the memory 402 , the input / output interface 403 and the communication interface 404 are connected to each other in communication within the device via a bus 405 .

[0114] An embodiment of the present application further provides a computer-readable storage medium storing a computer program, which, when executed by a processor, implements the above-mentioned method for generating a consolidated report based on the SAP system.

[0115] It can be understood that the contents of the above method embodiments are all applicable to the present storage medium embodiment, the functions specifically implemented by the present storage medium embodiment are the same as those of the above method embodiments, and the beneficial effects achieved are also the same as those achieved by the above method embodiments.

[0116] The memory, as a non-transient computer-readable storage medium, can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory may include a high-speed random access memory and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely arranged relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0117] The embodiments of the present application provide a method, device, electronic device, and storage medium for generating a consolidated report based on a SAP system. The method calculates the cross-reference relationship of data on the SAP system through a preset consolidated report template, thereby generating a consolidated report. This effectively reduces learning, implementation, and maintenance costs, facilitates subsequent secondary development, is simple and easy to implement, and helps to improve the efficiency of generating consolidated reports and enhance the user experience.

[0118] The embodiments described in the embodiments of this application are intended to more clearly illustrate the technical solutions of the embodiments of this application and do not constitute a limitation on the technical solutions provided by the embodiments of this application. Those skilled in the art will appreciate that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided in the embodiments of this application are also applicable to similar technical problems.

[0119] Those skilled in the art will understand that the technical solutions shown in the figures do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than shown in the figures, or a combination of certain steps, or different steps.

[0120] The device embodiments described above are merely illustrative. The units described as separate components may or may not be physically separate, i.e., they may be located in one place or distributed across multiple network units. Some or all of the modules may be selected based on actual needs to achieve the objectives of this embodiment.

[0121] Those skilled in the art will appreciate that all or some of the steps in the methods, systems, and functional modules / units in the devices disclosed above may be implemented as software, firmware, hardware, or appropriate combinations thereof.

[0122] The terms "first", "second", "third", "fourth", etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequential order. It should be understood that the data used in this way can be interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0123] It should be understood that in this application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following items" or similar expressions refers to any combination of these items, including any combination of single items or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0124] In the several embodiments provided in this application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are merely schematic. For example, the division of the above-mentioned units is only a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0125] The units described above 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 these units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0126] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing unit, or each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.

[0127] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes multiple instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to execute all or part of the steps of the methods of various embodiments of the present application. The aforementioned storage medium includes: various media that can store programs, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0128] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but are not intended to limit the scope of the present invention. Any modifications, equivalent substitutions, and improvements made by those skilled in the art without departing from the scope and essence of the present invention should be within the scope of the present invention.

Claims

1. A method for generating a consolidated report based on a SAP system, characterized in that: The method comprises the following steps: In response to the triggered consolidated report generation instruction, obtaining a preset consolidated report template; Importing the consolidated report template into the SAP system, triggering the SAP system to read a preset consolidated report configuration table, and updating the consolidated report data into the consolidated report template; A consolidated report is generated based on the consolidated report data and the consolidated report template.

2. The method for generating a consolidated report based on the SAP system according to claim 1, characterized in that: The consolidated report configuration table includes a consolidated report company code comparison table, a consolidated report transaction unit comparison table, and a consolidated report parameter configuration table; The step of importing the merged report template into the SAP system, triggering the SAP system to read a preset merged report configuration table, and updating the merged report data into the merged report template includes: Importing the consolidated report template into the SAP system, triggering the SAP system to read the preset consolidated report company code comparison table, consolidated report transaction unit comparison table, and consolidated report parameter configuration table; Converting the company code in the SAP report data of the SAP system into the consolidated report company code according to the consolidated report company code comparison table; According to the consolidated statement transaction unit comparison table, the customer code in the SAP report data of the SAP system is converted into the consolidated statement transaction unit code; Based on the consolidated report parameter configuration table, the consolidated report company code, and the consolidated report transaction unit code, the SAP report data is converted into consolidated report data, and the consolidated report data is updated to the consolidated report template.

3. The method for generating a consolidated report based on the SAP system according to claim 1, characterized in that: The file format of the consolidated report template is Excel report format.

4. The method for generating a consolidated report based on the SAP system according to claim 3, characterized in that: The merged report template in the Excel report format includes a first tab page, a second tab page, and a third tab page; The third tab page is used as a parameter maintenance interface to store the matching relationship between the fields of the SAP report data and the columns of the Excel report; The second tab page is used to receive and store consolidated report data; The first tab page is used to summarize and calculate the consolidated report data according to a preset calculation formula and display the consolidated report.

5. The method for generating a consolidated report based on the SAP system according to claim 4, characterized in that: The generating of a consolidated report based on the consolidated report data and the consolidated report template includes: Based on the data reading formula preset in the first tab page, read the consolidated report data received in the second tab page and update it in the first tab page; Based on the calculation formula preset in the first tab page, and according to the updated consolidated report data in the first tab page, the consolidated report data is summarized and calculated; wherein the preset calculation formula includes a horizontal amount summary calculation formula and a vertical amount summary calculation formula; A consolidated report is generated based on the calculation result of the consolidated report data and the consolidated report template, and the consolidated report is displayed through the first tab page.

6. The method for generating a consolidated report based on the SAP system according to claim 3, characterized in that: The merged report template in the Excel report format is set to locked mode.

7. The method for generating a consolidated report based on the SAP system according to claim 1, characterized in that: The method further comprises: In response to the triggered data update instruction, the merged report template and the merged report configuration table are updated.

8. A combined report generation device based on SAP system, characterized in that: The device comprises: A template acquisition module, configured to acquire a preset consolidated report template in response to a triggered consolidated report generation instruction; A data acquisition module, configured to import the consolidated report template into the SAP system, trigger the SAP system to read a preset consolidated report configuration table, and update the consolidated report data into the consolidated report template; The report generation module is used to generate a consolidated report based on the consolidated report data and the consolidated report template.

9. An electronic device, characterized in that: The electronic device includes a memory and a processor, the memory stores a computer program, and the processor implements the method for generating a consolidated report based on the SAP system according to any one of claims 1 to 7 when executing the computer program.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the method for generating a consolidated report based on the SAP system according to any one of claims 1 to 7 is implemented.

Images