SAP ERP data HANA view modeling analysis method and system

Abstract

The invention provides an SAP ERP data HANA view modeling analysis method and system. The method comprises the steps that a standard data source list is acquired; determining a matched data source according to the standard data source list; analyzing the structure of the matched data source to obtain analysis information; the analysis information at least comprises a first data table and a first association condition between the tables; performing analog data source access according to the matched data source, and determining access information; the access information at least comprises a second data table, a second association condition between the table and the front of the table, and an access specified condition list; determining information required by modeling according to the analysis information and the access information; the information required for modeling at least comprises the data table and the association condition list required for HANA view modeling, manual analysis is not needed, analysis of the importance of the HANA view modeling process by the SAP ERP standard function data source can be rapidly and accurately completed, the project implementation period can be shortened, and the cost and the implementation risk can be reduced.

Description

Technical Field

[0001] The present invention relates to the technical field of data processing and provides a business analysis method and system for converting a SAP ERP data source to a HANA view. Background Art

[0002] SAP ERP (Enterprise Resource Planning) is an integrated enterprise resource planning software. It helps enterprises integrate internal and external resources, optimize enterprise resource allocation, and improve management efficiency and decision-making level. SAP ERP system covers all aspects of enterprise operations, such as financial management, logistics management, production planning, human resources management, project management, etc.

[0003] In the process of promoting the implementation of SAP ERP projects, enterprises usually give priority to the standard functions of SAP ERP in order to more effectively integrate with the enterprise's operational processes and business process standardization. In addition, in order to meet specific business operation needs, enterprises often need to customize and develop some specific functions. This strategy of combining standards and customization is intended to ensure that the SAP ERP system can more accurately serve the unique needs of enterprises. In order to meet the needs of various industries, the logical relationship of data in the original design of SAP ERP standard functions is relatively complex, so secondary development and data analysis based on SAP ERP system will be more complicated. In order to meet the needs of various industries, the logical relationship of data in the original design of SAP ERP standard functions is relatively complex, so secondary development and data analysis based on SAP ERP system will be more complicated. Traditional implementation methods rely on manual analysis, which is labor-intensive and has the risk of missing analysis. Summary of the invention

[0004] The present invention provides a business analysis method and system for converting SAP ERP data source to HANA view, which is used to solve the defects of the prior art that it relies on manual analysis, has a large workload, and has the risk of missing analysis. The present invention does not require manual analysis, and can quickly and accurately complete the analysis of the importance of SAP ERP standard function data source to the HANA view modeling process, which can shorten the project implementation cycle and reduce costs and implementation risks.

[0005] The present invention provides a SAP ERP data HANA view modeling and analysis method, comprising: obtaining a standard data source list; the standard data source list is a data source list corresponding to SAP ERP standard functions; determining a matching data source according to the standard data source list; the matching data source is a data source corresponding to a business voucher; analyzing the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; simulating data source data acquisition according to the matching data source to determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables and a data acquisition specified condition list; determining information required for modeling according to the analysis information and the data acquisition information; the information required for modeling at least includes a data table required for HANA view modeling and a list of association conditions.

[0006] According to a SAP ERP data HANA view modeling and analysis method provided by the present invention, the obtaining of the standard data source list includes: obtaining predefined standard data source configuration information through an API interface call of the SAP ERP system; and filtering out a data source list related to the business voucher from the standard data source configuration information as the standard data source list according to business requirements.

[0007] According to a SAP ERP data HANA view modeling and analysis method provided by the present invention, determining a matching data source according to the standard data source list includes: using a preset matching rule to match the business credential with the items in the standard data source list; when the business credential matches multiple data sources, selecting the matching data source according to a preset business priority.

[0008] According to a SAP ERP data HANA view modeling and analysis method provided by the present invention, the structure of the matching data source is analyzed to obtain analysis information, including: using a database query language to execute a structure query command on the matching data source to obtain metadata of a data table; and analyzing the metadata to obtain the first data table and the first association condition between tables.

[0009] According to a SAP ERP data HANA view modeling and analysis method provided by the present invention, the data source data extraction is simulated according to the matching data source to determine the data extraction information, including: constructing a simulation query statement according to the business logic to simulate the actual data extraction process; executing the simulation query statement to capture the data flow and data dependency in the query process, and obtaining the second data table, the second association condition between tables, and the data extraction specified condition list.

[0010] According to a SAP ERP data HANA view modeling and analysis method provided by the present invention, determining the information required for modeling based on the analysis information and the data acquisition information includes: taking the intersection of the analysis information and the data acquisition information to obtain the data table and the association condition list required for the HANA view modeling.

[0011] The present invention also provides a SAP ERP data HANA view modeling and analysis system, comprising: an acquisition module, used to acquire a standard data source list; the standard data source list is a data source list corresponding to SAP ERP standard functions; a matching module, used to determine a matching data source according to the standard data source list; the matching data source is a data source corresponding to a business voucher; an analysis module, used to analyze the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; a data acquisition module, used to simulate data source data acquisition according to the matching data source to determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables and a data acquisition specified condition list; a modeling information determination module, used to determine information required for modeling according to the analysis information and the data acquisition information; the information required for modeling at least includes a data table required for HANA view modeling and a list of association conditions.

[0012] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, any one of the above-mentioned SAPERP data HANA view modeling and analysis methods is implemented.

[0013] The present invention also provides a non-transitory computer-readable storage medium having a computer program stored thereon, and when the computer program is executed by a processor, the SAP ERP data HANA view modeling and analysis method as described in any one of the above is implemented.

[0014] The present invention also provides a computer program product, comprising a computer program, wherein when the computer program is executed by a processor, the computer program implements any of the above-mentioned SAP ERP data HANA view modeling and analysis methods.

[0015] The present invention provides a SAP ERP data HANA view modeling and analysis method and system, the method comprising: obtaining a standard data source list; determining a matching data source according to the standard data source list; analyzing the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; simulating data source data acquisition according to the matching data source to determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables and a data acquisition specified condition list; determining information required for modeling according to the analysis information and the data acquisition information; the information required for modeling at least includes a data table and an association condition list required for HANA view modeling, without manual analysis, realizing fast and accurate completion of the analysis of the importance of SAP ERP standard functional data sources to the HANA view modeling process, and being able to shorten the project implementation cycle and reduce costs and implementation risks. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the technical solutions in the present invention or the prior art, the following briefly introduces the drawings required for use in the embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0017] Figure 1 It is a flow chart of the SAP ERP data HANA view modeling and analysis method provided by the present invention.

[0018] Figure 2 It is a schematic diagram of the principle of the SAP ERP data HANA view modeling and analysis method provided by the present invention.

[0019] Figure 3 It is a structural schematic diagram of the SAP ERP data HANA view modeling and analysis system provided by the present invention.

[0020] Figure 4 It is a structural schematic diagram of the electronic device provided by the present invention. DETAILED DESCRIPTION

[0021] The following embodiments of the present invention are described in further detail in conjunction with the accompanying drawings and examples. The following examples are used to illustrate the present invention, but are not intended to limit the scope of the present invention.

[0022] In the process of implementing SAP ERP projects, enterprises mainly apply SAP ERP standard business functions in order to better meet the needs of enterprise operation processes and business process standardization, and at the same time need to customize and develop some functions to meet the needs of enterprise business operations. Since SAP ERP's standard business functions are designed to cover the business needs of various industries, the logical relationship of data is relatively complex in the original design. Each standard business function is usually associated with multiple tables in the database. The number of these tables ranges from a few to dozens, and the number of fields contained in each table ranges from dozens to hundreds. Therefore, secondary development and data analysis based on the SAP ERP system will be more complicated.

[0023] The SAP HANA view modeling project is a data analysis project based on the data in the SAP ERP system. Implementing the SAP HANA view project involves synchronizing the data tables in the ERP system to HANA in real time through the ETL (Extract Transform Load) tool, applying the SAP HANA view modeling function according to certain business rules, completing the modeling task in HANA, and then providing the HANA view model to various applications or analysis systems. Therefore, before HANA view modeling, it is necessary to conduct in-depth research and careful planning on the data sources defined by the existing standard functions of SAP ERP, but these data sources cannot be used in HANA, so an effective tool is needed to actively analyze the tables in the data source and the relationships between the tables.

[0024] For example, it is unknown which SAP standard data tables are accessed by standard procurement business data and which SAP standard data tables are accessed by outsourced procurement business data. Therefore, during the implementation of the SAP HANA view modeling project, it is necessary to analyze the data sources corresponding to the SAP ERP functions corresponding to the project scope. The analysis method is usually to conduct positioning analysis through business research combined with the experience of business consultants. However, this method depends to a large extent on the implementation experience of business consultants and the depth of business research. The workload of this work accounts for nearly half of the entire project cycle, and there may be risks of missing analysis. Any negligence may bring risks to the project.

[0025] Please refer to Figure 1 , Figure 1 A flow chart of the SAP ERP data HANA view modeling and analysis method provided by the present invention.

[0026] Please refer to Figure 2 , Figure 2 A schematic diagram of the principles of the SAP ERP data HANA view modeling and analysis method provided by the present invention.

[0027] The present invention provides a SAP ERP data HANA view modeling and analysis method, comprising: 101: Get the standard data source list; the standard data source list is the data source list corresponding to the SAP ERP standard functions; 102: Determine a matching data source according to the standard data source list; the matching data source is a data source corresponding to the business credential; 103: Analyze the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; 104: Perform data acquisition of a simulated data source according to the matched data source, and determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables, and a data acquisition specified condition list; 105: Determine the information required for modeling based on the analysis information and data acquisition information. The information required for modeling includes at least the data tables and association condition lists required for HANA view modeling.

[0028] In order to quickly and accurately complete the analysis of SAP standard business functions, the present invention provides a SAP ERP data HANA view modeling and analysis method, which is mainly applicable to SAP ERP data source to HANA view projects, and obtains the corresponding standard data source list according to different business modules defined in the SAP ERP system. According to the customer's business operation, the business voucher type corresponding to the SAPERP system standard is matched and the corresponding data source is matched. Based on the in-depth analysis of the matching data source, the structural information (analysis information) of the matching data source is obtained, which includes the first data table information, the first association condition between the table and the table, and the key field logic, etc. Combined with the business voucher provided by the customer as the input condition, the data source is simulated to obtain data, and the data table list involved in the data source acquisition process is obtained. According to the technical analysis, the association condition list between the data tables involved and the specified condition list when the data table is acquired, and the logic list of the corresponding field information are obtained, and then the development class is not related to the business module. Table, output data acquisition information, including the second data table, the second association condition between the data table and the table, and the specified condition list when the data table is acquired. Finally, according to the analysis information and the data acquisition information, the information required for modeling is determined, including the data table required for HANA view modeling, the association condition list between the table and the table, and the specified condition list when the data table is acquired.

[0029] The present invention is based on an in-depth analysis of the technical implementation of different data sources, and summarizes the project implementation experience to form an analysis strategy for the SAP ERP standard function corresponding table and table association conditions and specified conditions, and converts the analysis strategy into an intelligent analysis tool (modeling analysis system). Intelligent analysis tools replace manual analysis, and use intelligent analysis tools to quickly and accurately complete the analysis of the importance of SAP standard function data sources to the HANA view modeling process, parse the data table relationships and important business field logic involved in the standard data source, and quickly implement HANA view modeling based on the parsed key information. The present invention can quickly and accurately complete the analysis of the work from SAP ERP data source modeling to HANA view modeling, thereby achieving the purpose of shortening the project implementation cycle, reducing project implementation costs, and reducing project implementation risks.

[0030] As a preferred embodiment, obtaining a standard data source list includes: obtaining predefined standard data source configuration information through an API interface call of a SAP ERP system; and filtering out a data source list related to business credentials from the standard data source configuration information as a standard data source list according to business requirements.

[0031] In this embodiment, a corresponding standard data source list is obtained according to different business modules defined in the SAP ERP system. Specifically, first, a customized software script is written, which can interact with the API interface of the SAP ERP system. This script uses the function library provided by SAP to initiate API calls. Through these API calls, the data source configuration information in the SAP ERP system can be accessed, which is usually stored in the database or configuration table of the system. The script first calls the API interface to retrieve all predefined data source configurations. This configuration information includes the name, type, connection parameters of the data source and their association with the SAP ERP function module. Then, these data sources need to be filtered according to specific business requirements. For example, if the business requirement is to analyze sales data, the script will use a filtering function that selects relevant data sources based on preset business vouchers (such as sales order numbers). Through the above filtering process, a streamlined data source list is obtained, which only contains data sources related to specific business vouchers. This list will be used as a standard data source list for subsequent HANA view modeling and analysis processes.

[0032] What needs to be explained is: SAP standard data sources are predefined data sources in business content, covering multiple modules and business processes of the SAP system. Data sources follow SAP's standardized data models and business processes.

[0033] SAP business vouchers are important data used to record and process business transactions in the SAP ERP system. In the SAP system, business vouchers are closely integrated with financial vouchers to achieve integrated financial and business management.

[0034] As a preferred embodiment, determining a matching data source based on a list of standard data sources includes: using preset matching rules to match business credentials with items in the list of standard data sources; when the business credentials match multiple data sources, selecting a matching data source based on a preset business priority.

[0035] In this embodiment, the business voucher type of the SAP ERP system standard is matched according to the customer's business operation and the corresponding data source is matched. Specifically, a set of preset matching rules are defined, which are based on the business logic and the characteristics of the data source. For example, for a sales order, the matching rules may include finding a data source containing a specific customer number or material number. Then, by traversing the list of standard data sources, the matching rules are applied to each data source to determine which data sources match the given business voucher. For example, if the business voucher type is a sales order, it may be found that it matches multiple data sources, such as customer master data, sales contract data, and delivery order data. When dealing with multiple matching data sources, the concept of business priority is introduced. Each data source is assigned a priority value based on the business logic and the importance of the data. By calculating the priority value of each matching data source, the data source with the highest priority is selected as the final matching data source. This method ensures that when facing multiple potential data sources, reasonable choices can be made based on business needs and the importance of the data.

[0036] In practical applications, this embodiment allows the relevant data sources to be quickly and accurately determined based on business credentials, while ensuring that when multiple matching data sources exist, the best choice can be made based on business priorities. This not only improves the efficiency of data processing, but also ensures the relevance and accuracy of the analysis results. For example, for a specific sales order, it can quickly determine which data source needs to be selected from the customer master data, sales contract data, and delivery order data for further analysis, thereby laying a solid foundation for subsequent data processing and analysis.

[0037] As a preferred embodiment, the structure of the matching data source is analyzed to obtain analysis information, including: using a database query language to execute a structural query command on the matching data source to obtain metadata of the data table; analyzing the metadata to obtain a first data table and a first association condition between tables.

[0038] In this embodiment, the structural information (analysis information) of the matching data source is obtained based on the deep analysis of the matching data source, which includes table information, association conditions between tables, key field logic, etc. Specifically, first, SQL (Structured Query Language) is used as the database query language to execute structural query commands on the determined matching data sources. These commands are intended to obtain metadata of the data table, including table name, field name, field type, key information, index, etc. After obtaining the metadata, we analyze these data to identify the first data table and the association conditions between the data tables.

[0039] For example, the relationship between tables is determined by checking foreign key constraints. Assume that there are two data tables: a sales order table and a customer master data table. The following SQL command can be used to find the association condition between the two tables. During the analysis process, the business logic of the data table is also considered. For example, the material master data table may be associated with the inventory data table through the material number field. This embodiment can accurately identify the association relationship between data tables and provide necessary analysis information for subsequent HANA view modeling. This helps to optimize data query performance and ensure the accuracy, efficiency and reliability of data analysis.

[0040] As a preferred embodiment, data acquisition from a simulated data source is performed based on a matched data source to determine data acquisition information, including: constructing a simulated query statement based on business logic to simulate the actual data extraction process; executing the simulated query statement to capture the data flow and data dependency in the query process, and obtaining a second data table, a second association condition between tables, and a list of specified conditions for data acquisition.

[0041] In this embodiment, a simulated query statement is constructed according to the needs of the business logic. For example, if the business logic requires extracting all unfinished orders from the sales order table, an SQL query statement can be constructed to simulate the actual data extraction process, extract data from a hypothetical sales order table and customer table, and determine the association relationship between the two tables. Then execute the above simulated query statement. During the execution process, the data flow and data dependencies in the query process are captured. For example, it may be found that the sales order table depends on the material master data table to obtain the material information of each order item. By analyzing these data flows and dependencies, we can obtain a second data table (such as the material master data table), a second association condition between tables (such as the field association between the sales order table and the material master data table), and a list of specified conditions for data retrieval.

[0042] As a preferred embodiment, information required for modeling is determined according to analysis information and data acquisition information, including: taking the intersection of analysis information and data acquisition information to obtain data tables and association condition lists required for HANA view modeling.

[0043] In order to determine the information required for modeling, in this embodiment, the analysis information and the data acquisition information are intersected to obtain the data tables required for HANA view modeling, the list of association conditions between tables, and the list of specified conditions when acquiring data from the data tables.

[0044] For example, if the business document is a sales order, then by analyzing the intersection of information and data retrieval information, it can be determined that the sales order table, customer table, and material table, as well as the association conditions between them, need to be included, such as the customer ID association between the sales order table and the customer table, and the material number association between the sales order table and the material table.

[0045] In addition, the parameter settings of the modeling and analysis system are made configurable and support free selection to meet the data verification needs of various business modules in various complex scenarios.

[0046] The analysis result output includes the association conditions between data tables and the specified condition table when retrieving data from the data table.

[0047] The following is a comparison of the traditional HANA view modeling and the HANA modeling operation process implemented by the method based on the present invention.

[0048] The traditional HANA view modeling method is: user demand survey forms a demand document. Open the GUI software to log in to the ERP system, enter the ST05 transaction code in the operation interface to start tracking, and then you can perform business operations in the ERP system. This tracking can record the system update table and data flow path when each business data is saved, and form the data table corresponding to each business. Log in to the ERP system to operate related business processes based on the demand document. Take the purchase order business flow as an example. The specific operation process opens the GUI software to log in to the ERP system. First, confirm the corresponding transaction code (ME21N) according to the user's procurement needs. After executing ME21N, a new window will pop up. The interface defines the procurement-related information that needs to be maintained, and fill in the corresponding information such as: supplier, material, price, quantity, procurement organization, procurement group, company, factory, approver, etc. Then click Save. The ERP system will execute the system program based on the input information and procurement process and update the relevant data records to the data table. Enter the interface to end tracking. Querying the tracking information can obtain the data record table information and the association information between tables. Execute the SE16 transaction code in the ERP system, enter the table names obtained in step 4 in the query interface in sequence, query the corresponding field information and record it. Analyze the relationship between data tables involved in the business process based on experience and write development design documents. Perform modeling simulation tests in HANA Studio modeling tool based on the table list, field information, and table relationship information provided in the design document. It took two consultants two months to complete the task, which may lead to the risk of missing analysis.

[0049] The present invention first understands the real needs of customers based on the simple functional description provided by the user, and communicates with customers in the form of meetings on the problems in the needs, and records the meeting issues and discussion results, and forms a demand document through investigation. Simulate business process operations in the modeling and analysis system based on the needs. After the simulation operation is completed, the modeling and analysis system outputs the corresponding table list and field logic information of the relevant standard data source. Perform modeling simulation tests in the HANA Studio modeling tool based on the table list, field information, and table association information provided in the design document. One consultant can complete it in 30 minutes without the risk of missing analysis.

[0050] By comparison, it is found that the traditional HANA modeling method is time-consuming and laborious. In the actual procurement business, in addition to the purchase order, there are also a large number of business operations such as purchase application, application approval, supplier inquiry, supplier quotation, supplier price comparison, and procurement contract. The use of the traditional HANA modeling method will involve a lot of manpower costs, and the project cost will increase significantly. The HANA view modeling of the method of the present invention can greatly shorten the project implementation cycle in the demand analysis and logic combing links, save project implementation costs, and reduce the implementation risk of the project.

[0051] What needs to be explained is: SAP GUI (Graphical User Interface) is a graphical user interface software developed by SAP for accessing SAP systems. It is an important tool for enterprise users to operate and manage SAP systems. It provides a friendly user interface, allowing users to easily perform various operations and improve work efficiency.

[0052] SAP HANA Studio is a powerful tool developed by SAP for managing SAP HANA databases. It provides a variety of functions to help users easily perform database management, modeling development, monitoring and optimization operations.

[0053] The SAP ERP data HANA view modeling and analysis system provided by the present invention is described below. The SAP ERP data HANA view modeling and analysis system described below and the SAP ERP data HANA view modeling and analysis method described above can be referred to each other.

[0054] Please refer to Figure 3 , Figure 3 This is a structural diagram of the SAP ERP data HANA view modeling and analysis system provided by the present invention.

[0055] The present invention also provides a SAP ERP data HANA view modeling and analysis system, comprising: an acquisition module 1, used to acquire a standard data source list; the standard data source list is a data source list corresponding to SAP ERP standard functions; a matching module 2, used to determine a matching data source according to the standard data source list; the matching data source is a data source corresponding to a business voucher; an analysis module 3, used to analyze the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; a data acquisition module 4, used to simulate data source data acquisition according to the matching data source to determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables, and a data acquisition specified condition list; a modeling information determination module 5, used to determine information required for modeling according to the analysis information and the data acquisition information; the information required for modeling includes at least a data table required for HANA view modeling and a list of association conditions.

[0056] Figure 4 An example of a structural diagram of an electronic device is shown in FIG. Figure 4 As shown, the electronic device may include: a processor 410, a communication interface 420, a memory 430 and a communication bus 440, wherein the processor 410, the communication interface 420 and the memory 430 communicate with each other through the communication bus 440. The processor 410 may call the logic instructions in the memory 430 to execute the SAP ERP data HANA view modeling and analysis method, which includes: obtaining a standard data source list; the standard data source list is a data source list corresponding to the SAP ERP standard function; according to the standard data source list, determining a matching data source; the matching data source is a data source corresponding to the business voucher; analyzing the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; simulating data source data acquisition according to the matching data source to determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables and a data acquisition specified condition list; determining the information required for modeling according to the analysis information and the data acquisition information; the information required for modeling at least includes a data table required for HANA view modeling and a list of association conditions.

[0057] In addition, the logic instructions in the above-mentioned memory 430 can be implemented in the form of a software functional unit and can be stored in a computer-readable storage medium when it is sold or used as an independent product. Based on this understanding, the technical solution of the present invention, or the part that contributes to the relevant technology or the part of the technical solution, can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods of each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc. Various media that can store program codes.

[0058] An embodiment of the present invention discloses a computer program product, which includes a computer program stored on a non-transitory computer-readable storage medium. The computer program includes program instructions. When the program instructions are executed by a computer, the computer can execute the SAP ERP data HANA view modeling and analysis method provided by the above-mentioned method embodiments. The method includes: obtaining a standard data source list; the standard data source list is a data source list corresponding to SAP ERP standard functions; according to the standard data source list, determining a matching data source; the matching data source is a data source corresponding to a business voucher; analyzing the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; simulating data source data acquisition according to the matching data source to determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables, and a data acquisition specified condition list; determining information required for modeling according to the analysis information and the data acquisition information; the information required for modeling includes at least a data table required for HANA view modeling and a list of association conditions.

[0059] On the other hand, an embodiment of the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to execute the SAP ERP data HANA view modeling and analysis method provided in the above-mentioned embodiments, the method comprising: obtaining a standard data source list; the standard data source list is a data source list corresponding to SAP ERP standard functions; determining a matching data source based on the standard data source list; the matching data source is a data source corresponding to a business voucher; analyzing the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; simulating data source data acquisition based on the matching data source to determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables, and a data acquisition specified condition list; determining information required for modeling based on the analysis information and the data acquisition information; the information required for modeling includes at least data tables required for HANA view modeling and a list of association conditions.

[0060] The device embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separated, and the components displayed as units may or may not be physical units, that is, they may be located in one place, or they may be distributed on multiple network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative labor.

[0061] Through the description of the above implementation methods, those skilled in the art can clearly understand that each implementation method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be implemented by hardware. Based on this understanding, the above technical solution is essentially or the part that contributes to the relevant technology can be embodied in the form of a software product, and the computer software product can be stored in a computer-readable storage medium, such as ROM / RAM, a disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to execute the methods described in each embodiment or some parts of the embodiment.

[0062] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. However, these modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present invention.

Claims

1. A SAP ERP data HANA view modeling and analysis method, characterized in that: include: Get a list of standard data sources; The standard data source list is a data source list corresponding to SAP ERP standard functions; Determine a matching data source according to the standard data source list; The matching data source is a data source corresponding to the business credential; Analyze the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; According to the matching data source, simulate the data source to obtain data, and determine the data obtaining information; the data obtaining information at least includes the second data table, the second association condition between the tables, and the data obtaining specified condition list; According to the analysis information and the data acquisition information, information required for modeling is determined; the information required for modeling at least includes data tables and a list of associated conditions required for HANA view modeling.

2. The SAP ERP data HANA view modeling and analysis method according to claim 1, characterized in that: The obtaining of the standard data source list includes: Obtain predefined standard data source configuration information through the API interface call of the SAP ERP system; According to business requirements, a data source list related to the business credential is screened out from the standard data source configuration information as the standard data source list.

3. The SAP ERP data HANA view modeling and analysis method according to claim 1, characterized in that: The determining of a matching data source according to the standard data source list includes: Using a preset matching rule, matching the business credential with an item in the standard data source list; When the business credential matches multiple data sources, the matching data source is selected according to a preset business priority.

4. The SAP ERP data HANA view modeling and analysis method according to claim 1, characterized in that: The analyzing the structure of the matching data source to obtain analysis information includes: Using a database query language, executing a structure query command on the matching data source to obtain metadata of the data table; The metadata is analyzed to obtain the first data table and the first association condition between tables.

5. The SAP ERP data HANA view modeling and analysis method according to claim 1, characterized in that: The step of simulating data source data acquisition according to the matching data source to determine data acquisition information includes: According to the business logic, construct simulation query statements to simulate the actual data extraction process; The simulated query statement is executed to capture the data flow and data dependency in the query process, and the second data table, the second association condition between tables, and the data retrieval specified condition list are obtained.

6. The SAP ERP data HANA view modeling and analysis method according to any one of claims 1 to 5, characterized in that: Determining information required for modeling based on the analysis information and the data acquisition information includes: The analysis information and the data acquisition information are intersected to obtain the data table and the association condition list required for the HANA view modeling.

7. A SAP ERP data HANA view modeling and analysis system, characterized in that: include: The acquisition module is used to obtain a list of standard data sources; The standard data source list is a data source list corresponding to SAP ERP standard functions; A matching module, used to determine a matching data source according to the standard data source list; the matching data source is a data source corresponding to the business credential; An analysis module, configured to analyze the structure of the matching data source to obtain analysis information; the analysis information at least includes a first data table and a first association condition between tables; A data acquisition module, used to simulate data acquisition of the data source according to the matching data source, and determine data acquisition information; the data acquisition information at least includes a second data table, a second association condition between tables, and a data acquisition specified condition list; The modeling information determination module is used to determine the information required for modeling according to the analysis information and the data acquisition information; the information required for modeling at least includes the data table and the association condition list required for HANA view modeling.

8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the SAP ERP data HANA view modeling and analysis method according to any one of claims 1 to 6 is implemented.

9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the SAP ERP data HANA view modeling and analysis method according to any one of claims 1 to 6 is implemented.

10. A computer program product, comprising a computer program, characterized in that When the computer program is executed by a processor, the SAP ERP data HANA view modeling and analysis method according to any one of claims 1 to 6 is implemented.

Images