CN111339177A - SAP platform-based data export method and system - Google Patents
SAP platform-based data export method and system Download PDFInfo
- Publication number
- CN111339177A CN111339177A CN202010168284.0A CN202010168284A CN111339177A CN 111339177 A CN111339177 A CN 111339177A CN 202010168284 A CN202010168284 A CN 202010168284A CN 111339177 A CN111339177 A CN 111339177A
- Authority
- CN
- China
- Prior art keywords
- query
- sap
- data
- module
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/219—Managing data history or versioning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/602—Providing cryptographic facilities or services
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
Abstract
The invention discloses a data export method and a system based on an SAP platform.A peripheral system queries multi-table data of the SAP system by calling a self-defined RFC interface, selects a scene module according to the organization role of a user, limits the data query range and records the data record queried by the user; in the process, a user can directly inquire the data of the bottom layer table according to the dynamic configuration of different inquiry scenes, developers do not need to develop interfaces aiming at each scene, and rights management personnel do not need to distribute rights aiming at different interfaces. The external system calls the interface query request to call the SAP system according to the queue sequence to execute the query, so that the concurrent query amount of the SAP system can be reduced, SAP system resources and account resources are saved, and enterprise information and financial cost are reduced; and a universal data query interface is used, so that the code amount of secondary report development of the SAP system is greatly reduced. The whole data query and export process is encrypted, so that the safety of the system is enhanced.
Description
Technical Field
The invention belongs to the technical field of data interaction, and particularly relates to a data export method and system based on an SAP platform.
Background
SAP (systems applications and products in data processing) is software for enterprise resource planning, erp (enterprise resource planning) management, is an integrated enterprise resource planning system based on a client/server structure and an open system, and has functions covering various aspects of finance, logistics (engineering, purchasing, inventory, production, sales, quality and the like) and human resource management of enterprises.
The security requirement of the SAP system database is very high, the SAP system database is not allowed to be directly connected from the outside to capture data, if the data of the table is required to be inquired, the SAP system is required to be logged in, the standard function SE16 of the SAP system is used, the name of the data table and the inquiry condition are input, and the inquiry data is returned; when the multi-table associated data is inquired, a secondary development language ABAP/4(advanced development application programming) is provided in the SAP system, and a user can develop report form display data of the system by using the ABAP language through a development platform in the SAP system.
Remote Function Call (RFC): is an important and commonly used bi-directional interface technology between System Applications and Products (SAP) systems and other (SAP or non-SAP) systems, and is also considered as a basic protocol for SAP to communicate with the outside. In short, the RFC process is a process in which a system calls a program module outside the current system, thereby implementing a certain function. Such remote function calls may also be made within the same system (e.g., remote calls within a local SAP system), but typically the caller and callee are on different systems.
At present, single-table and multi-table associated query data are needed by a user to use more data, and a large amount of concurrent query requests occupy a large amount of memory and process resources of a system; moreover, SAP system account resources are charge items, a large amount of authority configuration is needed for configuring SAP system accounts for each user with query requirements, the financial cost of enterprise information is improved, and the account query is shared and does not meet the requirements of security and ISO audit; data are displayed through secondary report development, a large number of reports need to be developed according to users of different modules, developers are difficult to meet the query requirements of various changes of the users in real time, and meanwhile, the requirements of enterprise data safety management are difficult to meet. There is no good solution to the above problems in the prior art.
Disclosure of Invention
Aiming at the defects in the prior art, the invention provides a data export method based on an SAP platform.
In order to achieve the purpose, the invention adopts the following technical scheme: a data export method based on SAP platform includes the following steps:
s1, developing a database table to inquire a general RFC interface based on the SAP system, configuring the general RFC interface into a callable service module through an intermediate connector PI tool of the SAP system, and providing a WSDL address for an external system to call;
s2 module configuration of external system: respectively defining different service scene modules, and presetting type modules according to the different service scene modules; defining the name of each SAP table and the structure data of the tables in the type module, and presetting the association relation between different tables in each type module; presetting the corresponding relation between different service scene modules and the work function;
s3 inputs the query request: a user selects a corresponding service scene module and a corresponding type module in an external system according to needs, selects the structural data of a corresponding SAP table as a query condition parameter and an output result parameter, and inputs a limiting condition; if the query is a multi-table query, the correlation condition of the multi-table is also input;
s4 executes the query request: judging whether the user has the authority to inquire the selected service scene module data by the external system, if so, encrypting the request parameter input by the user, adding the inquiry request into a PI tool execution queue, waiting for calling RFC interface service, and continuing to step S5; if not, recording the query request in a query log of an external system;
s5, calling an RFC interface of the SAP system by the PI tool according to the queue sequence;
after receiving the query request, the SAP system of S6 decrypts the query request of the external system by using a private key, executes data query according to the sequence of the queue, encrypts a result data set of the callback external system and returns the result data set to the PI tool;
and S7, after the result data set returned by the PI tool is obtained by the external system, decrypting the result data set, outputting result parameters according to data input by a user in advance, displaying the data, storing files and recording the files into a query log.
In order to optimize the technical scheme, the specific measures adopted further comprise:
in step S1, developing a database table by using a secondary development language ABAP/4 language to inquire a general RFC interface, wherein the interface name is as follows: ZRFC _ READ _ tabs.
In step S2, the module configuration is dynamically set, and the association between different tables is used as the filtering condition for the user query result.
In step S3, the structural data of the SAP table selected by the user includes an item to be queried, a constraint, a lookup table field, a data output parameter, and a file storage parameter; the data output parameters comprise output data format parameters; the file saving parameters comprise an output file saving format; the external system includes a data query system.
In step S4, the external system verifies the job function of the user in the enterprise organization by accessing the AD domain authentication service of the enterprise, and determines whether the user has the right to query the selected scene data according to the preset comparison relationship between the service scene module and the job function.
In step S4, if the user has the authority to perform the query, the external system determines the SAP table name to be queried according to the preset service scene module corresponding relationship, and automatically maps the association relationship between the table and the table, and at the same time, combines the structure data of the SAP table into a parameter format acceptable by the SAP universal interface, encrypts the request parameter using the RSA public key provided by the SAP system, and sends the request to the PI tool to initiate a call request, and the PI tool adds the request into the PI tool execution queue after receiving the call request.
In step S4, the request parameters input by the user are encrypted using the RSA public key provided by the SAP system.
In step S6, the result data set of the callback external system is encrypted using the RSA private key.
In step S7, the result data set is decrypted using the RSA public key provided by the SAP system.
The invention also provides a data export system based on the SAP platform, which comprises: SAP system and external system, among them
1) SAP System: the system comprises a first decryption module, a second encryption module and a custom-developed database table query general RFC interface, wherein the RFC interface is used for
Custom developed database table query general RFC interfaces: the system is used for data transmission between an external system and the SAP system;
the first decryption module is used for decrypting the query request of the external system by using a private key after the SAP system receives the query request;
the second encryption module encrypts a result data set of the callback peripheral system by using an RSA private key;
2) external system: comprises an operation interface, an input module, an execution and judgment module, a calling module, a first encryption module, a second decryption module and a record generation module, wherein the operation interface, the input module, the execution and judgment module, the calling module, the first encryption module, the second decryption module and the record generation module are arranged in the operation interface
The operation interface is used for inputting query operation to a user and displaying a query result to the user;
the input module is used for inputting a series of parameters of the query request by a user;
the execution and judgment module is used for executing the query request and judging the query authority of the user;
a calling module: the multi-table query interface is used for calling the SAP system to perform data query;
the first encryption module encrypts a request parameter input by a user by using an RSA public key provided by an SAP system;
a second decryption module: the system is used for decrypting the SAP system request by using an RSA public key provided by the SAP system after the external system obtains a result data set returned by the PI tool;
and the record generating module is used for generating an execution process record and storing the record into a log.
The invention has the beneficial effects that:
1. the SAP is called through the interface, only one interface account is needed to be called, and an SAP account does not need to be created according to each user, so that SAP account resources are saved, and account authority configuration work of SAP authority management personnel is saved;
2. according to the method, the number of concurrent processes for calling the SAP system by the PI tool can be adjusted by querying data according to the queue, the problem that the efficiency of the database is reduced due to a large number of concurrent query requests on the SAP system in a short time is avoided, the load of the SAP system is effectively controlled and reduced, and the service execution efficiency of the SAP system is improved;
3. according to the invention, through a plurality of query scenes configured by an external webpage, a user can flexibly set query conditions and output columns, and save the query conditions and the output columns into various specified file formats according to the user requirements, and can finish various scene requirements only by using a universal data query interface, so that the code quantity of various reports developed on an SAP system by the user customized requirements is greatly reduced;
4. the external system of the invention can limit the unauthorized access and record the query request log according to the organization structure role verification provided by the AD domain service, and can transmit the interactive data encryption mode of the peripheral system and the SAP system by using the RSA asymmetric encryption technology, thereby meeting the enterprise data security management requirement.
Drawings
FIG. 1 is a flow chart of a data export method of the present invention.
FIG. 2 is a schematic diagram of a data export system of the present invention.
Detailed Description
The present invention will now be described in further detail with reference to the accompanying drawings.
Referring to fig. 1, the present invention provides a data export method based on SAP platform, which includes the following steps:
s1 is based on SAP system, using ABAP/4 language to develop database table to inquire general RFC interface, interface name: ZRFC _ READ _ tabs. The function of this interface is: when the external environment calls the interface, a plurality of data table names to be inquired, the incidence relation between the data tables and the tables, data table columns needing to be obtained, conditions for limiting the range of the inquired tables and the like are transmitted. When the RFC interface is called, according to the query parameters and the limited range conditions transmitted by the external environment, the multi-table association query of the database is executed, and the query data set is returned.
The RFC interface zffc _ READ _ packets is configured as a callable service module through an intermediate link PI tool (SAP process integration, which is an integrated technology and platform, provides integration between an SAP and a non-SAP, and supports synchronous and asynchronous communication modes), and provides a WSDL address (Web services description Language) for open use in an external environment for external system calls.
S2 module configuration of external system:
respectively defining different service scene modules on an external system (comprising a data query system), and presetting type modules according to the different service scene modules; defining the name of each SAP table and the structure data (such as commodity name, price and quantity) of the tables in the type module, and presetting the association relationship between different tables in each type module (such as the data in the table 1 comprises the commodity name and the price, the data in the table 2 comprises the commodity name and the quantity, and if the association relationship between the table 1 and the table 2 is set to be the same as the commodity name, only the commodity data with the same name in the table 1 and the table 2 is the data which accords with the search condition); the module configuration is dynamically set, and the incidence relation among different tables is used as a screening condition of the user query result; presetting the corresponding relation between different service scene modules and work functions (such as a commodity price inquiry scene, only a sales department has authority inquiry, but a production department has no inquiry authority);
the external query system develops a query webpage, the first-level query webpage displays various different service scene modules, and the second-level query webpage displays corresponding SAP table structure fields for a user to select according to type modules preset by service scenes.
S3 inputs the query request: a user logs in by using an enterprise authentication user name on a query webpage of an external system as required, selects a data query service scene, skips a secondary query page after the query scene is selected, the secondary query page displays a corresponding SAP table structure field for the user to check according to a type module preset by the service scene, wherein the SAP table structure field comprises an item to be queried, a limiting condition, a query table field, a data output parameter, a file storage parameter and the like, and the data output parameter comprises an output data format parameter; the file saving parameters comprise an output file saving format; the user can select which fields are used as query condition parameters, which fields are used as output result field parameters, and the query condition fields selected by the user input query limit conditions and range limit values; if the query is a multi-table query, the association condition of the multi-table is also input.
S4 executes the query request: after the user confirms that the query request is input correctly, the user clicks a query button, an external system accesses an enterprise AD domain authentication service (Active Directory domain authentication, which means that an AD system terminal agent uses a third party library to execute main authentication service) by using a user name according to the current login information of the user, verifies the work function of the user in enterprise organization, and automatically judges whether the user has the authority to query the selected service scene module data according to the preset corresponding relation between the service scene and the work function. For the query request meeting the query authority, determining the name of an SAP (service access point) table to be queried by an external system according to the preset corresponding relation of a scene module, automatically mapping the incidence relation between the table and the table, combining a query table field, a limiting condition and the like into a parameter format acceptable by an SAP (service access point) universal interface, encrypting the request parameter by using an RSA (rivest-Shamir-Adleman) public key provided by an SAP (System), sending the encrypted request parameter to a PI tool to initiate a call request, adding the request into a PI tool execution queue after the PI tool receives the call request, and waiting for calling RFC (radio; the inquiry request which does not satisfy the authority is recorded in the inquiry log table of the external system, and the user re-inputs the inquiry request.
The S5 PI tool calls the RFC interfaces of the SAP system in sequence according to the queue sequence. The PI tool supports multithreading and calls the SAP system at the same time, and can meet the requirement that multiple users on an external system initiate query requests at the same time.
And after receiving the query request, the SAP system of S6 decrypts the query request of the external system by using the private key, executes data query according to the calling sequence, encrypts a result data set of the callback peripheral system by using the RSA private key and returns the result data set to the PI tool.
And S7, after the external system obtains the result data set returned by the PI tool, the external system decrypts the SAP system request by using the RSA public key provided by the SAP system, displays the data according to the options of the output format, the file storage format and the like selected by the user on the query page, stores the file or selects the print file, and records the file to the user query log list.
The communication encryption mode used by the SAP system and the peripheral system is RSA asymmetric encryption:
asymmetric encryption algorithms require two keys: public key (publickey) and private key (privatekey). The public key and the private key are a pair, and if the public key is used for encrypting data, only the corresponding private key can be used for decrypting the data; if the data is encrypted with a private key, it can only be decrypted with the corresponding public key. This algorithm is called asymmetric encryption algorithm because two different keys are used for encryption and decryption. The basic process of realizing confidential information exchange by the asymmetric encryption algorithm is as follows: the first party (SAP system) generates a pair of keys and discloses one of them as a public key to the other party; the party B (external system) obtaining the public key encrypts the confidential information by using the key and then sends the encrypted confidential information to the party A (SAP system); the first party (SAP system) then decrypts the encrypted information using another private key stored by the first party. The asymmetric encryption system can complete secret communication without requiring the two communication parties to transmit keys in advance or having any agreement, and the keys are convenient to manage and can prevent counterfeiting and repudiation, so that the asymmetric encryption system is more suitable for secret communication requirements in network communication and improves the safety of data transmission when used in the invention.
The following is illustrated for one specific query scenario:
the user puts forward a query demand, and needs to query the selling price change information of a certain commodity within a period of time.
The existing method comprises the following steps: a developer enters an SAP system development environment, newly builds a self-defined report according to user requirements, captures data from a commodity sales price table, and submits a self-defined report version to an SAP formal environment to take effect after report development and test are completed; informing SAP authority management personnel to endow the inquiry authority of the new report form to the account role of the user; the user logs in the SAP system, inputs the query condition to execute report query, and the SAP system returns the query data. If a user needs multi-table associated data query, a large number of concurrent query requests occupy a large number of memory and process resources of the system, data are displayed through secondary report development, a large number of reports need to be developed according to users of different modules, and developers are difficult to meet query requirements of various changes of the users in real time.
An embodiment of a data derivation method employing the present invention is as follows:
the developer configures the SAP system and the external system in advance:
based on SAP system, use ABAP/4 language development database table to inquire general RFC interface, interface name: ZRFC _ READ _ tabs. The general RFC interface ZRFC _ READ _ TABLES is configured into a callable service module through an intermediate connector PI tool of the SAP system, and provides WSDL addresses to be opened to the external environment for use and called by the external system.
Respectively defining different service scene modules on an external system, and presetting type modules according to the different service scene modules; defining the name and the structure data (such as commodity name, price and quantity) of each SAP table in the type module, and presetting the association relationship between different tables in each type module (for example, the data in the table 1 comprises the commodity name and the price, the data in the table 2 comprises the commodity name and the quantity, and if the association relationship between the table 1 and the table 2 is set to be the same as the commodity name, only the commodity data with the same name in the table 1 and the table 2 is the data meeting the search condition); presetting the corresponding relation between different service scene modules and the work function;
the external query system develops a query webpage, the first-level query webpage displays various different service scene modules, and the second-level query webpage displays corresponding SAP table structure fields for a user to select according to type modules preset by service scenes.
When a user needs to inquire commodity price data, the user selects a commodity price inquiry scene on an external platform inquiry interface (namely a primary inquiry webpage), an external system jumps to a secondary inquiry page to display a plurality of tables corresponding to the commodity inquiry scene, the user selects a corresponding commodity price SAP table, the user selects a commodity code and date as inquiry conditions and limits the code and date range (at the moment, the incidence relation among the tables is that the code and date are the same, namely only the code and date in each table are the same, and the commodity meeting the limited range is an object needing to inquire the sale price), an output column of the inquiry result is selected as the commodity code, the date, the commodity name and the commodity sale price, the storage format of the output result is selected, the user clicks an inquiry button after the inquiry condition and the output result format are set, and the external system uses the user name to access the enterprise AD domain authentication service according to the current login information of the user, verifies the work function of the user in the enterprise organization, and automatically judges whether the user has the authority to inquire the business scene module data according to the preset scene and function comparison relation. After the authority check is passed, according to a commodity price query scene selected by a user, obtaining the SAP table name to be queried according to the preset corresponding relation, automatically mapping the corresponding relation among a plurality of SAP tables, forming the query parameters acceptable by the SAP self-defined universal interface according to the commodity code and date conditions filled by the user, the query table column and the like, encrypting the parameters by using an RSA encryption mode, sending the parameters to a PI tool to initiate a calling request, after receiving the calling request, adding the request into an execution queue of the PI tool, and waiting for calling RFC interface service. The PI tool calls SAP RFC interfaces in sequence according to the queue sequence, after receiving a query request, the SAP system decrypts the request of the peripheral system by using a private key, executes query after decrypting parameters, returns database table data (the code and the date are the same, the code and the date both meet the limited range, the output column is the commodity code, the date, the commodity name and the commodity sales price) meeting the query condition, generates a report according to the output format selected by a user and displays the report on a webpage, and simultaneously generates a specified file storage format to be provided for the user to store, or selects a print file and records the print file to a user query log table.
In summary, the existing external system calls the SAP system interface, and can only execute a specific function, such as creating an order, etc., but the invention provides that the external system queries the multi-table data of the SAP system by calling the custom RFC interface, and according to the role of the user organized in the enterprise and the scene module selected by the user, the data query range can be limited, and simultaneously, the data record queried by the user is recorded, and the security management of the enterprise data is enhanced; in the process, a user can dynamically configure according to different query scenes, developers do not need to develop interfaces/reports aiming at each scene, rights management personnel do not need to distribute rights aiming at different interfaces/reports, and data of a bottom layer table is directly queried. The external system calls the SAP system to execute the query according to the queue sequence by the interface query request, so that the concurrent query amount of the SAP system can be reduced, the SAP system resources and account resources are greatly saved, the enterprise information and financial cost are reduced, and the code amount of secondary report development of the SAP system is greatly reduced by using a universal data query interface. The whole data query and export process is encrypted, so that the security of the system is enhanced, and the requirement of confidential communication in network communication is better met.
Referring to fig. 2, the present invention further provides a data export system based on the SAP platform, including: the SAP system is connected to an external system,
1) SAP System: the system comprises a first decryption module, a second encryption module and a custom-developed database table query general RFC interface, wherein the RFC interface is used for
Custom developed database table query general RFC interfaces: the system is used for data transmission between an external system and the SAP system;
the first decryption module is used for decrypting the query request of the external system by using a private key after the SAP system receives the query request;
the second encryption module encrypts a result data set of the callback peripheral system by using an RSA private key;
2) external system: comprises an operation interface, an input module, an execution and judgment module, a calling module, a first encryption module, a second decryption module and a record generation module, wherein the operation interface, the input module, the execution and judgment module, the calling module, the first encryption module, the second decryption module and the record generation module are arranged in the operation interface
The operation interface is used for inputting query operation to a user and displaying a query result to the user;
the input module is used for inputting a series of parameters of the query request by a user;
the execution and judgment module is used for executing the query request and judging the query authority of the user;
a calling module: the system comprises a database table, a general RFC interface, a database management server and a database management server, wherein the database table is used for calling the SAP system to inquire the general RFC interface and carry out data inquiry;
the first encryption module encrypts a request parameter input by a user by using an RSA public key provided by an SAP system;
a second decryption module: the system is used for decrypting the SAP system request by using an RSA public key provided by the SAP system after the external system obtains a result data set returned by the PI tool;
and the record generating module is used for generating an execution process record and storing the record into a log.
By the system, data are inquired and exported, the concurrent inquiry amount of the SAP system is reduced, SAP system resources and account resources are saved, the development amount of a user-defined report of the SAP system is reduced under the condition of meeting the inquiry requirements of a user, and the safety of enterprise information data is ensured.
The above is only a preferred embodiment of the present invention, and the protection scope of the present invention is not limited to the above-mentioned embodiments, and all technical solutions belonging to the idea of the present invention belong to the protection scope of the present invention. It should be noted that modifications and embellishments within the scope of the invention may be made by those skilled in the art without departing from the principle of the invention.
Claims (10)
1. A data export method based on SAP platform is characterized by comprising the following steps:
s1, developing a database table to inquire a general RFC interface based on the SAP system, configuring the general RFC interface into a callable service module through an intermediate connector PI tool of the SAP system, and providing a WSDL address for an external system to call;
s2 module configuration of external system: respectively defining different service scene modules, and presetting type modules according to the different service scene modules; defining the name of each SAP table and the structure data of the tables in the type module, and presetting the association relation between different tables in each type module; presetting the corresponding relation between different service scene modules and the work function;
s3 inputs the query request: a user selects a corresponding service scene module and a corresponding type module in an external system according to needs, selects the structural data of a corresponding SAP table as a query condition parameter and an output result parameter, and inputs a limiting condition; if the query is a multi-table query, the correlation condition of the multi-table is also input;
s4 executes the query request: judging whether the user has the authority to inquire the selected service scene module data by the external system, if so, encrypting the request parameter input by the user, adding the inquiry request into a PI tool execution queue, waiting for calling RFC interface service, and continuing to step S5; if not, recording the query request in a query log of an external system;
s5, calling an RFC interface of the SAP system by the PI tool according to the queue sequence;
after receiving the query request, the SAP system of S6 decrypts the query request of the external system by using a private key, executes data query according to the sequence of the queue, encrypts a result data set of the callback external system and returns the result data set to the PI tool;
and S7, after the result data set returned by the PI tool is obtained by the external system, decrypting the result data set, outputting result parameters according to data input by a user in advance, displaying the data, storing files and recording the files into a query log.
2. The data exporting method based on SAP platform of claim 1, wherein in step S1, the secondary development language ABAP/4 language is used to develop the database table for querying the RFC interface, interface name: ZRFC _ READ _ tabs.
3. The data exporting method according to claim 1, wherein in step S2, the module configuration is dynamically configured, and the association relationship between different tables is used as the filtering condition for the user query result.
4. The SAP platform-based data export method of claim 1, wherein in step S3, the structure data of the SAP table selected by the user includes the items to be queried, the definition, the lookup table fields, the data output parameters, and the file storage parameters; the data output parameters comprise output data format parameters; the file saving parameters comprise an output file saving format; the external system includes a data query system.
5. The data exporting method according to claim 4, wherein in step S4, the external system verifies the job function of the user in the enterprise organization by accessing the AD domain authentication service of the enterprise, and determines whether the user has the right to query the selected scenario data according to the preset comparison relationship between the business scenario module and the job function.
6. The data exporting method according to claim 4, wherein in step S4, if the user has the right to query, the external system determines the SAP table name to be queried according to the preset service scene module corresponding relationship, and automatically maps the association relationship between the table and the table, and at the same time, the structural data of the SAP table is combined into a parameter format acceptable by the SAP universal interface, the request parameter is encrypted by using the RSA public key provided by the SAP system, and sent to the PI tool to initiate the call request, and the PI tool adds the request into the PI tool execution queue after receiving the call request.
7. The data exporting method according to claim 4, wherein in step S4, the RSA public key provided by the SAP system is used to encrypt the request parameters inputted by the user.
8. The data exporting method according to claim 1, wherein in step S6, the result data set of the callback external system is encrypted by using RSA private key.
9. The data derivation method based on SAP platform as claimed in claim 1, wherein in step S7, the result data set is decrypted using RSA public key provided by SAP system.
10. A data export system based on SAP platform, comprising: SAP system and external system, among them
1) SAP System: the system comprises a first decryption module, a second encryption module and a custom-developed database table query general RFC interface, wherein the RFC interface is used for
Custom developed database table query general RFC interfaces: the system is used for data transmission between an external system and the SAP system;
the first decryption module is used for decrypting the query request of the external system after the SAP system receives the query request;
the second encryption module is used for encrypting the result data set of the callback peripheral system;
2) external system: comprises an operation interface, an input module, an execution and judgment module, a calling module, a first encryption module, a second decryption module and a record generation module, wherein the operation interface, the input module, the execution and judgment module, the calling module, the first encryption module, the second decryption module and the record generation module are arranged in the operation interface
The operation interface is used for inputting query operation to a user and displaying a query result to the user;
the input module is used for inputting a series of parameters of the query request by a user;
the execution and judgment module is used for executing the query request and judging the query authority of the user;
a calling module: the multi-table query interface is used for calling the SAP system to perform data query;
the first encryption module is used for encrypting the request parameters input by the user;
a second decryption module: the system is used for decrypting the SAP system request after the external system obtains a result data set returned by the PI tool;
and the record generating module is used for generating an execution process record and storing the record into a log.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010168284.0A CN111339177A (en) | 2020-03-11 | 2020-03-11 | SAP platform-based data export method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010168284.0A CN111339177A (en) | 2020-03-11 | 2020-03-11 | SAP platform-based data export method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111339177A true CN111339177A (en) | 2020-06-26 |
Family
ID=71185985
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010168284.0A Pending CN111339177A (en) | 2020-03-11 | 2020-03-11 | SAP platform-based data export method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111339177A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109165085A (en) * | 2018-08-07 | 2019-01-08 | 江苏电力信息技术有限公司 | A kind of large-scale report backstage execution method based on SAP platform |
| CN113792285A (en) * | 2021-08-05 | 2021-12-14 | 广东核电合营有限公司 | Nuclear power station service authority control method and device and terminal equipment |
| CN114356483A (en) * | 2022-01-05 | 2022-04-15 | 北京京航计算通讯研究所 | SAP ERP system data processing method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102376016A (en) * | 2010-08-13 | 2012-03-14 | 捷达世软件（深圳）有限公司 | Process integration server and method for realizing system integration by utilizing same |
| CN106022584A (en) * | 2016-05-13 | 2016-10-12 | 成都镜杰科技有限责任公司 | Resource management method for small enterprises |
| CN109951375A (en) * | 2019-02-25 | 2019-06-28 | 南京金信通信息服务有限公司 | Method and system based on mailing system triggering SAP system business function |
| CN110046287A (en) * | 2019-03-19 | 2019-07-23 | 厦门市美亚柏科信息股份有限公司 | A kind of the data query method, apparatus and storage medium unrelated with type of database |
-
2020
- 2020-03-11 CN CN202010168284.0A patent/CN111339177A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102376016A (en) * | 2010-08-13 | 2012-03-14 | 捷达世软件（深圳）有限公司 | Process integration server and method for realizing system integration by utilizing same |
| CN106022584A (en) * | 2016-05-13 | 2016-10-12 | 成都镜杰科技有限责任公司 | Resource management method for small enterprises |
| CN109951375A (en) * | 2019-02-25 | 2019-06-28 | 南京金信通信息服务有限公司 | Method and system based on mailing system triggering SAP system business function |
| CN110046287A (en) * | 2019-03-19 | 2019-07-23 | 厦门市美亚柏科信息股份有限公司 | A kind of the data query method, apparatus and storage medium unrelated with type of database |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109165085A (en) * | 2018-08-07 | 2019-01-08 | 江苏电力信息技术有限公司 | A kind of large-scale report backstage execution method based on SAP platform |
| CN113792285A (en) * | 2021-08-05 | 2021-12-14 | 广东核电合营有限公司 | Nuclear power station service authority control method and device and terminal equipment |
| CN113792285B (en) * | 2021-08-05 | 2024-01-26 | 广东核电合营有限公司 | Nuclear power station service authority control method and device and terminal equipment |
| CN114356483A (en) * | 2022-01-05 | 2022-04-15 | 北京京航计算通讯研究所 | SAP ERP system data processing method |
| CN114356483B (en) * | 2022-01-05 | 2023-04-21 | 北京京航计算通讯研究所 | SAP ERP system data processing method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109447811B (en) | Method, accounting node and medium for inquiring transaction information in blockchain network | |
| US10673824B2 (en) | Electronic authorization system and method | |
| WO2021135169A1 (en) | Blockchain-based management method, terminal, apparatus, and storage medium | |
| AU2023274173A1 (en) | Systems for access control and system integration | |
| CN109684375B (en) | Method, accounting node and medium for querying transaction information in blockchain network | |
| CN111339177A (en) | SAP platform-based data export method and system | |
| CN109818935A (en) | User authority control method and device, storage medium, computer equipment | |
| CN110363542B (en) | Customer service system construction method and device, storage medium and electronic equipment | |
| CN111464499A (en) | Electronic warehouse receipt tracing method and device, computer equipment and storage medium | |
| CN101977184B (en) | Multi-identity selection landing device and service system | |
| CN109858273A (en) | Obtaining product information method, apparatus, computer equipment and storage medium | |
| CN111538757B (en) | Data storage method, query method, device, server and medium | |
| CN113297625A (en) | Data sharing system and method based on block chain and electronic equipment | |
| CN109697370A (en) | Database data encipher-decipher method, device, computer equipment and storage medium | |
| CN110851865A (en) | Resource data processing method, device, system and storage medium | |
| CN113407954A (en) | Data management method and device based on block chain | |
| CN106022706A (en) | Holographic presentation system of E-contract main body and correlation execution process information | |
| CN111259448A (en) | Data sharing method and device | |
| KR100988198B1 (en) | Coding method | |
| CN110766548A (en) | Block chain based information processing method and device, storage medium and electronic equipment | |
| CN116483919A (en) | Method, device, equipment and medium for tracing data uplink and tracing data query | |
| CN114265577A (en) | Service data processing method and device, computer equipment and storage medium | |
| US10970741B2 (en) | Method and system for integrating audience data with a social media site | |
| KR20090070218A (en) | Security and management device for database security and control method thereof | |
| CN112887087A (en) | Data management method and device, electronic equipment and readable storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |