CN114356483A - SAP ERP system data processing method - Google Patents

SAP ERP system data processing method Download PDF

Info

Publication number
CN114356483A
CN114356483A CN202210008605.XA CN202210008605A CN114356483A CN 114356483 A CN114356483 A CN 114356483A CN 202210008605 A CN202210008605 A CN 202210008605A CN 114356483 A CN114356483 A CN 114356483A
Authority
CN
China
Prior art keywords
user
menu
service
sap erp
data
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.)
Granted
Application number
CN202210008605.XA
Other languages
Chinese (zh)
Other versions
CN114356483B (en
Inventor
蔡蔚
徐永伟
尚丹丹
费廷伟
范怡然
王新宇
石海烽
牛元元
姜明良
高晓琼
唱明旭
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Beijing Jinghang Computing Communication Research Institute
Original Assignee
Beijing Jinghang Computing Communication Research Institute
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Beijing Jinghang Computing Communication Research Institute filed Critical Beijing Jinghang Computing Communication Research Institute
Priority to CN202210008605.XA priority Critical patent/CN114356483B/en
Publication of CN114356483A publication Critical patent/CN114356483A/en
Application granted granted Critical
Publication of CN114356483B publication Critical patent/CN114356483B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Computer And Data Communications (AREA)

Abstract

The invention relates to a data processing method of an SAP ERP system, belongs to the technical field of data processing, and solves the problems that the automatic opening of an SAP ERP client and the automatic processing of service data are realized without parameter transmission in the prior art. Receiving parameters transmitted by a non-SAP system, wherein the parameters comprise an acquisition mode, a user identifier, a menu transaction code, service data and an execution operation button code, and the parameters are used as data to be acquired; checking whether the user exists in the SAP ERP according to the user identification, if so, acquiring a user name and a password, and adding data to be acquired; then, whether a corresponding menu exists in the SAP ERP, whether a user has a menu authority, and whether a service field and an execution operation button exist in service data are checked in sequence; after the verification is passed, if the acquisition mode is the CS mode, assembling the data to be acquired into a bat format character string, calling the bat format character string based on the ActiveXObject control, otherwise, assembling the data to be acquired into a request parameter, calling a Web end URL of an SAP ERP system, and entering the SAP ERP system for data processing.

Description

SAP ERP system data processing method
Technical Field
The invention relates to the technical field of data processing, in particular to a SAP ERP system data processing method.
Background
The SAP ERP system is a mature enterprise management software of the SAP company, and with the development of the IT technology, the appearance of an enterprise portal and a unified management platform, the SAP ERP system also faces the problem of integrating with a non-SAP system and receiving and processing data in the non-SAP system.
The existing non-SAP system generally transmits user information according to parameter transmission, so that single sign-on integration of the non-SAP system and an SAP ERP system is carried out, or a certain menu interface in the SAP ERP is entered, service data is not transmitted, and data processing cannot be carried out according to the received service data.
In the prior art, a non-SAP system directly transmits data to an SAP ERP system from a rear end in a bottom-layer data integration mode, such as an IDOC mode, a BAPI mode and an RFC mode, after the data are processed in the modes, the data need to enter the SAP ERP system, a user manually clicks to enter a related menu interface, the transmitted data are displayed after query is executed, and a plurality of unnecessary manual operations are increased.
Disclosure of Invention
In view of the foregoing analysis, an embodiment of the present invention aims to provide a data processing method for an SAP ERP system, so as to solve the problems that automatic opening of an SAP ERP client and automatic processing of service data are not achieved through parameter transfer in the prior art.
In one aspect, an embodiment of the present invention provides a data processing method for an SAP ERP system, including the following steps:
receiving parameters delivered by a non-SAP system, the parameters comprising: acquiring a mode, a user identifier, a menu transaction code, service data and an execution operation button code as data to be acquired;
according to the user identification, checking whether a corresponding user exists in the SAP ERP, if so, acquiring a user name and a password of the user, and adding data to be acquired; checking whether a corresponding menu exists in the SAP ERP or not and whether a user has menu authority or not in sequence according to the menu transaction code and the user name, and checking whether a service field and an execution operation button in service data exist in the SAP ERP or not according to the menu transaction code, the service data and the execution operation button code after the checks are passed;
after the verification is passed, identifying an acquisition mode in the parameters, if the acquisition mode is a CS mode, assembling data to be acquired into a bat format character string, calling the bat format character string based on an ActiveXObject control, and entering an SAP ERP system for data processing; otherwise, the data to be acquired is assembled into request parameters, the Web end URL of the SAP ERP system is called, and the SAP ERP system is entered for data processing.
Based on the further improvement of the method, the service data comprises a plurality of groups of service fields and service values which appear in pairs, wherein each group is divided into "; "end, format is: the service field 1 is the service value 1; the service field 2 is the service value 2; … …, respectively; the service field n is the service value n; n is greater than or equal to 1; and the service value is used for displaying in a menu interface corresponding to the menu transaction code.
Based on the further improvement of the method, the data processing in the SAP ERP system comprises the following steps:
after logging in according to a user name and a password in the data to be acquired, the SAP ERP system executes a menu transaction code in the data to be acquired, enters a corresponding menu interface, analyzes service data in the data to be acquired, acquires a plurality of service fields and corresponding service values, displays the corresponding service values in the interface fields which are the same as the service fields in the menu interface, executes an execution operation button code in the data to be acquired, inquires, newly adds or updates the service values, and displays the processed interface.
Based on the further improvement of the method, whether the corresponding user exists in the SAP ERP is verified according to the user identification, and the method comprises the following steps:
matching with the user identifier in the SAP ERP user information table according to the user identifier, and returning the abnormal information of the current user if the completely consistent user identifier does not exist;
otherwise, acquiring a user name and a user state according to the user identifier, and returning the user name and the reset password of the user after resetting the user password if the user state is offline; otherwise, returning the abnormal information of the current user state.
Based on the further improvement of the method, whether the corresponding menu exists in the SAP ERP and whether the user has the menu authority or not is sequentially verified according to the menu transaction code and the user name, and the method comprises the following steps:
matching with a menu transaction code in an SAP ERP menu list according to the menu transaction code, and returning abnormal information without the menu transaction code if the menu transaction code is completely consistent;
otherwise, acquiring a menu transaction code list with the corresponding user having the authority from a user authority information table, a menu transaction code table and an association relation table of the SAP ERP according to the user name; and identifying whether the menu transaction code exists in the menu transaction code list, if not, returning the abnormal information that the current user does not have the menu authority, otherwise, checking to pass.
Based on the further improvement of the method, whether the service field and the execution operation button in the service data exist in the SAP ERP is verified according to the menu transaction code, the service data and the execution operation button code, and the method comprises the following steps:
acquiring a program name from a menu transaction code program corresponding table according to the menu transaction code;
acquiring an execution operation button code list from a service program processing table according to the program name;
identifying whether the code of the execution operation button exists in the code list of the execution operation button, if not, returning abnormal information that the execution operation button does not exist;
otherwise, acquiring a service field list from the program interface information table according to the program name; splitting the service data according to the connector in the service data, and obtaining a service field in the service data and putting the service field into a field array to be checked; traversing the field arrays to be checked, sequentially identifying whether the fields to be checked exist in the service field list, and if any one of the fields does not exist, returning abnormal information of the fields which do not exist; otherwise, the check passes.
Based on a further improvement of the above method, the bat format string includes: SAP ERP executes the command, the command attributes and the attribute values; spacing the SAP execution command and the command attribute with a space; each command attribute is preceded by a "-"; the command attributes are connected with the corresponding attribute values in a mode of "═ connection, and space intervals are formed among the command attributes;
the command attributes include: the method comprises the following steps of (1) interface maximization attribute, user name attribute, password attribute, login language attribute, system identification attribute, system description attribute, client number attribute, target system attribute and command line attribute;
based on ActiveXObject control, calling bat format character string to enter SAP ERP system, including:
shell object is created based on ActiveXObject control;
calling a bat format character string through a run function of a WScript.
Executing SAP ERP execution commands in the bat format character string; if the execution is successful, starting an SAP ERP client program, and automatically logging in to an SAP ERP system according to a user name and a password in the bat format character string; otherwise, prompting abnormal information.
Based on the further improvement of the method, the command line attribute is-command, the corresponding attribute value starts with "+", and the menu transaction code, the blank space, the service data and the DYNP _ OKCODE are sequentially spliced, namely the operation button code is executed.
Based on the further improvement of the method, the request parameters comprise: request parameter names and request parameter values;
the request parameter name includes: a username parameter, a password parameter, a client number parameter, a login language parameter, a login topic parameter, and a transaction execution parameter.
Based on the further improvement of the method, the transaction execution parameter is-transaction, the corresponding request parameter value starts with "+", and the menu transaction code, the blank space, the service data and the DYNP _ OKCODE are sequentially spliced, namely the execution operation button code.
Compared with the prior art, the invention can realize at least one of the following beneficial effects:
1. the SAP ERP system receives the service data transmitted by the non-SAP system and automatically processes the data, two modes are provided to directly enter the SAP ERP system, the service data in the parameters are received by matching the menu transaction code and entering the corresponding menu interface, and the received service data is processed according to the transmitted execution operation button, so that the user service application requirements of inquiry, addition, modification and the like are realized, the user click times are reduced, and the user operation friendliness is improved;
2. the transmitted parameters are sequentially checked by a user, a menu, service data and an execution operation button, the data accuracy is improved through the preposed check, and the data error is prevented from being found after the data enters an SAP ERP system, so that the processing efficiency is not influenced;
3. the transmitted parameters are dynamically packaged into the bat format character strings, so that the bat files are prevented from being saved and read, and the program execution efficiency is improved.
In the invention, the technical schemes can be combined with each other to realize more preferable combination schemes. Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and drawings.
Drawings
The drawings are only for purposes of illustrating particular embodiments and are not to be construed as limiting the invention, wherein like reference numerals are used to designate like parts throughout.
Fig. 1 is a flowchart of a data processing method of an SAP ERP system in an embodiment of the present invention.
Detailed Description
The accompanying drawings, which are incorporated in and constitute a part of this application, illustrate preferred embodiments of the invention and together with the description, serve to explain the principles of the invention and not to limit the scope of the invention.
The invention discloses a data processing method of an SAP ERP system, which comprises the steps of receiving, verifying and processing parameters transmitted by a non-SAP system by the SAP ERP system. It should be noted that there are many ways to transmit parameters in the non-SAP system, including but not limited to: the parameters are directly transmitted through hyperlinks of a front-end interface in a non-SAP system, a button of the front-end interface is clicked to trigger data transmission, or an HttpClient object is created at the back end, and the parameters are transmitted through HttpPost.
Considering that a plurality of non-SAP systems may be involved, preferably, a single Java middleware is deployed between the plurality of non-SAP systems and the SAP ERP system, the plurality of non-SAP systems and the SAP ERP system are connected through the Java middleware, the plurality of non-SAP systems firstly transmit data to the Java middleware, the parameters are received through the Java middleware, the parameters are assembled according to interface specifications or calling specifications of the SAP ERP system, the parameters are forwarded to the SAP ERP system, and the returned results of the SAP ERP system are forwarded to the plurality of non-SAP systems.
The embodiment is not limited to the non-SAP system, the SAP ERP system and the deployment form therebetween, and focuses on a specific processing method, as shown in fig. 1, including the following steps:
s11: receiving parameters delivered by a non-SAP system, the parameters comprising: acquiring a mode, a user identifier, a menu transaction code, service data and an execution operation button code as data to be acquired;
it should be noted that the acquisition mode includes a CS mode (Client/Server mode) and a BS mode (Browser/Server mode); the user identification is used for matching users in the SAP ERP system; the menu transaction code is used for finding a corresponding menu interface in the SAP ERP system; the service data is used for displaying in a menu interface corresponding to the menu transaction code and comprises a plurality of groups of service fields and service values which appear in pairs, wherein each group is expressed as "; "end, format is: the service field 1 is the service value 1; the service field 2 is the service value 2; … …, respectively; the service field n is the service value n; n is greater than or equal to 1; and executing the operation button codes to execute relevant operations according to the service values on the menu interface.
S12: according to the user identification, checking whether a corresponding user exists in the SAP ERP, if so, acquiring a user name and a password of the user, and adding data to be acquired; checking whether a corresponding menu exists in the SAP ERP or not and whether a user has menu authority or not in sequence according to the menu transaction code and the user name, and checking whether a service field and an execution operation button in service data exist in the SAP ERP or not according to the menu transaction code, the service data and the execution operation button code after the checks are passed;
it should be noted that, the SAP ERP checks the received parameters, including user check, menu transaction code check, service data check, and operation button check, encapsulates these check programs into interfaces, and calls the non-SAP system or the Java middleware through WebService or by using the JCO package of the SAP. Specifically, the verification process is as follows:
firstly, the user verification is to verify whether a corresponding user exists in the SAP ERP according to the user identifier, and comprises the following steps:
matching with the user identifier in the SAP ERP user information table according to the user identifier, and returning the abnormal information of the current user if the completely consistent user identifier does not exist;
otherwise, acquiring a user name and a user state according to the user identifier, and returning the user name and the reset password of the user after resetting the user password if the user state is offline; and if the user state is not offline, returning the abnormal information of the user state. Wherein, the non-offline state of the user comprises: online, locked, and maintained.
It should be noted that the SAP ERP USER information table is USER _ ADDR, and is used for storing USER information. In the user verification process, the password resetting is carried out on the offline user, so that the risk caused by illegally obtaining the password in parameter transmission when the cross-system enters the SAP ERP system is avoided, and the data security is improved.
Verifying the menu transaction code, namely sequentially verifying whether a corresponding menu exists in SAP ERP and whether a user has menu authority or not according to the menu transaction code and the user name, wherein the step comprises the following steps:
matching with a menu transaction code in an SAP ERP menu list according to the menu transaction code, and returning abnormal information without the menu transaction code if the menu transaction code is completely consistent;
otherwise, acquiring a menu transaction code list with authority of the corresponding user from a user authority information table and a role and menu transaction code association information table of SAP ERP according to the user name; and identifying whether the menu transaction code exists in the menu transaction code list, if not, returning the abnormal information that the current user does not have the menu authority, otherwise, checking to pass.
Specifically, the user permission information table is AGR _ USERS, and is used for storing the information related to the user and the role; the role and menu transaction code association information table is AGR _ TCODES, and is used for storing role and menu transaction code association information.
Checking whether the service data and the execution operation button exist in the service data and the execution operation button in the SAP ERP according to the menu transaction code, the service data and the execution operation button code, and the checking comprises the following steps:
acquiring a program name from a menu transaction code program corresponding table according to the menu transaction code; the menu transaction code program corresponding table is TSTC, which is used for storing transaction codes and corresponding program names;
acquiring an execution operation button code list from a service program processing table according to the program name; the service program processing table is a user-defined table ZPROCEDUREDDEEAL and is used for storing program names and corresponding execution operation button codes.
Identifying whether the code of the execution operation button exists in the code list of the execution operation button, if not, returning abnormal information that the execution operation button does not exist;
otherwise, acquiring a service field list from the program interface information table according to the program name; splitting the service data according to the connector in the service data, and obtaining a service field in the service data and putting the service field into a field array to be checked; traversing the field arrays to be checked, sequentially identifying whether the fields to be checked exist in the service field list, and if any one of the fields does not exist, returning abnormal information of the fields which do not exist; otherwise, the check passes. The program interface information table is a user-defined table ZPROCEDURESELEE and is used for storing program names and corresponding business fields.
Illustratively, the received menu transaction code is SU01, the service field in the service data is SUID _ ST _ BNAME-BNAME, the execution operation button code is CHAN, then the program name obtained according to the menu transaction code is SAPMSUU0, and the corresponding execution operation button code list obtained in the service program processing table according to the program name includes: creating CREA, modifying CHAN, deleting DELE and locking LOCK, wherein the CREA, the modifying CHAN, the deleting DELE and the locking LOCK comprise received execution operation button codes; and acquiring a service field list in a program interface information table according to the program name, wherein the service field list comprises the SUID _ ST _ BNAME-BNAME of the received service data.
In the step, the transmitted parameters are sequentially checked by a user, a menu, service data and an execution operation button, the data accuracy is improved through the preposed check, and the data error is prevented from being found after the data enters an SAP ERP system, so that the processing efficiency is prevented from being influenced.
S13: after the verification is passed, identifying an acquisition mode in the parameters, if the acquisition mode is a CS mode, assembling data to be acquired into a bat format character string, calling the bat format character string based on an ActiveXObject control, and entering an SAP ERP system for data processing; otherwise, the data to be acquired is assembled into request parameters, the Web end URL of the SAP ERP system is called, and the SAP ERP system is entered for data processing.
It should be noted that, the premise of implementing the CS mode client for automatically opening the SAP ERP is that the SAP ERP client program is locally installed, and the premise of implementing the BS mode access for the SAP ERP is that the Web side access interface for the SAP is released by activating its (internet Transaction server) service of the SAP.
The CS mode of SAP ERP has low network communication quantity and high response speed, is beneficial to processing a large amount of data, automatically brings service fields into an interface and executes corresponding processing, provides shortcut keys and a history input memory function, and is convenient for realizing the quick use of a user. The use of the BS mode of the SAP ERP can enter the SAP ERP system through a browser without installing an additional program, so that the automatic processing of the service data is realized.
Specifically, if the acquisition mode is the CS mode, the data to be acquired is assembled into a bat format string including: SAP ERP executes the command, the command attributes and the attribute values; spacing the SAP execution command and the command attribute with a space; each command attribute is preceded by a "-"; the command attributes are connected with the corresponding attribute values in a mode of "═ connection, and space intervals are formed among the command attributes;
the command attributes include: interface maximize attribute-maxgui, username attribute-user, password attribute-pw, login language attribute-language, SYSTEM identification attribute-SYSTEM, SYSTEM description attribute-sysname, client number attribute-client, target SYSTEM attribute-guiplac, and command line attribute-command. Wherein the values of the target system attributes include: SAP ERP system IP address and example number; the attribute value corresponding to the command line attribute begins with "+", and the menu transaction code, the blank space, the service data and the DYNP _ OKCODE are sequentially spliced, namely the operation button code is executed.
It should be noted that the login language attribute, the system identifier attribute, the system description attribute, the client number attribute, and the target system attribute in the command attribute are related to the actual SAP ERP system configuration, and may be written into a preset configuration file according to the actual situation, and the preset configuration file is read during assembly to obtain the corresponding attribute value.
Illustratively, the string in bat format is: sapshcut-maxgui-user username-pw password-lan login language-SAP target SYSTEM-SYSTEM identifier-sysname ═ SAP SYSTEM description-Client ═ SAP Client number-command ═ menu transaction code service field 1 ═ service value 1; the service field 2 is the service value 2; DYNP _ okdose is an execution operation button code.
Based on ActiveXObject control, calling bat format character string to enter SAP ERP system, including:
shell object is created based on ActiveXObject control;
calling a bat format character string through a run function of a WScript.
Executing SAP ERP execution commands in the bat format character string; if the execution is successful, starting an SAP ERP client program, and automatically logging in to an SAP ERP system according to a user name and a password in the bat format character string; otherwise, prompting abnormal information.
The abnormality information is: SAP ERP client has no installed configuration or the browser Active control setting is incorrect.
If the acquisition mode is the BS mode, calling a Web end URL of SAP ERP to assemble the data to be acquired into request parameters, wherein the request parameters comprise: request parameter names and request parameter values; wherein requesting the parameter name comprises: a user name parameter sap-user, a password parameter sap-password, a client identification parameter sap-client, a login language parameter sap-language, a login subject parameter sap-name and a transaction execution parameter-transaction. The request parameter value corresponding to the transaction execution parameter starts with "+", and the menu transaction code, the blank space, the service data and the DYNP _ OKCODE are sequentially spliced to form an execution operation button code.
The request parameters can be assembled differently according to a specific calling mode, if the request parameters are transmitted in a Get mode of HTTP, the request parameter names and the corresponding request parameter values are connected in ═ form, and after a plurality of groups of request parameters are connected in &, the parameters pass through? "spliced behind the Web-end URL, illustratively, http:// SAP address port number/SAP/bc/gui/SAP/its/webguinap-Client ═ SAP Client number & SAP-language ═ SAP login language & SAP-name ═ SAP subject & SAP-user ═ username & SAP-password & -transaction ═ menu transaction code service data field 1 ═ service value 1; the service data field 2 is equal to the service value 2; DYNP _ okdose is an execution operation button code.
If the request parameter is transmitted in the Post mode of HTTP, for example, in the Httppost mode of HttpClient, the request parameter name and the corresponding request parameter value can be set through the NameValuePair class, or the request parameter name and the corresponding request parameter value are assembled into Json format.
The process of entering the SAP ERP system for data processing through the CS mode or the BS mode comprises the following steps:
after logging in according to a user name and a password in the data to be acquired, the SAP ERP system executes a menu transaction code in the data to be acquired, enters a corresponding menu interface, analyzes service data in the data to be acquired, acquires a plurality of service fields and corresponding service values, displays the corresponding service values in the interface fields which are the same as the service fields in the menu interface, executes an execution operation button code in the data to be acquired, inquires, newly adds or updates the service values, and displays the processed interface.
Illustratively, the menu transaction code received by the SAP ERP system is FS00, a maintenance general ledger interface is entered, the received service data is general ledger and company codes, the execution operation button code is ACC _ MOD, that is, a modification operation is performed, and the SAP ERP performs the modification operation according to the general ledger and the company codes to display a corresponding subject information interface.
Compared with the prior art, the data processing method of the SAP ERP system provided by the embodiment is a method for receiving service data transmitted by a non-SAP system and automatically processing the data by the SAP ERP, supports two modes to directly enter the SAP ERP system, matches a menu transaction code to enter a corresponding menu interface, receives the service data in a parameter, processes the received service data according to a transmitted execution operation button, realizes user service application requirements of inquiry, addition, modification and the like, reduces user click times, and improves user operation friendliness; the transmitted parameters are sequentially checked by a user, a menu, service data and an execution operation button, the data accuracy is improved through the preposed check, and the data error is prevented from being found after the data enters an SAP ERP system, so that the processing efficiency is not influenced; the transmitted parameters are dynamically packaged into the bat format character strings, so that the bat files are prevented from being saved and read, and the program execution efficiency is improved.
Those skilled in the art will appreciate that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program, which is stored in a computer readable storage medium, to instruct related hardware. The computer readable storage medium is a magnetic disk, an optical disk, a read-only memory or a random access memory.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention.

Claims (10)

1. A SAP ERP system data processing method is characterized by comprising the following steps:
receiving parameters delivered by a non-SAP system, the parameters comprising: acquiring a mode, a user identifier, a menu transaction code, service data and an execution operation button code as data to be acquired;
according to the user identification, whether a corresponding user exists in SAP ERP is checked, if yes, a user name and a password of the user are obtained, and data to be obtained are added; checking whether a corresponding menu exists in SAP ERP or not in sequence according to the menu transaction code and the user name, and checking whether the user has the menu authority or not, and after the checking is passed, checking whether a service field and an execution operation button in the service data exist in SAP ERP or not according to the menu transaction code, the service data and the execution operation button code;
after the verification is passed, identifying an acquisition mode in the parameters, if the acquisition mode is a CS mode, assembling data to be acquired into a bat format character string, calling the bat format character string based on an ActiveXObject control, and entering an SAP ERP system for data processing; otherwise, the data to be acquired is assembled into request parameters, the Web end URL of the SAP ERP system is called, and the SAP ERP system is entered for data processing.
2. An SAP ERP system data processing method according to claim 1, wherein the business data includes sets of business fields and business values occurring in pairs, each set being in "; "end, format is: the service field 1 is the service value 1; the service field 2 is the service value 2; … …, respectively; the service field n is the service value n; n is greater than or equal to 1; and the service value is used for displaying in a menu interface corresponding to the menu transaction code.
3. The SAP ERP system data processing method of claim 2, wherein entering the SAP ERP system for data processing comprises:
after logging in according to the user name and the password in the data to be acquired, the SAP ERP system executes the menu transaction code in the data to be acquired, enters a corresponding menu interface, analyzes the service data in the data to be acquired, acquires a plurality of service fields and corresponding service values, displays the corresponding service values in the interface fields which are the same as the service fields in the menu interface, executes the execution operation button code in the data to be acquired, inquires, newly adds or updates the service values, and displays the processed interface.
4. The SAP ERP system data processing method of claim 1, wherein the verifying whether the SAP ERP has a corresponding user according to the user identifier comprises:
matching with the user identifier in the SAP ERP user information table according to the user identifier, and returning the abnormal information of the current user if no completely consistent user identifier exists;
otherwise, acquiring a user name and a user state according to the user identifier, and returning the user name and the reset password of the user after resetting the user password if the user state is offline; otherwise, returning the abnormal information of the current user state.
5. The SAP ERP system data processing method of claim 1, wherein the sequentially verifying whether a corresponding menu exists in SAP ERP and whether the user has the menu authority according to the menu transaction code and the user name comprises:
matching with the menu transaction code in the SAP ERP menu list according to the menu transaction code, and returning abnormal information without the menu transaction code if the completely consistent menu transaction code does not exist;
otherwise, acquiring a menu transaction code list with authority of the corresponding user from a user authority information table, a menu transaction code table and an association relation table of SAP ERP according to the user name; and identifying whether the menu transaction code exists in the menu transaction code list, if not, returning abnormal information that the current user does not have the menu authority, otherwise, checking to pass.
6. The SAP ERP system data processing method of claim 1, wherein the verifying whether the service field and the execution operation button in the service data exist in SAP ERP according to the menu transaction code, the service data and the execution operation button code comprises:
acquiring a program name from a menu transaction code program corresponding table according to the menu transaction code;
acquiring an execution operation button code list from a service program processing table according to the program name;
identifying whether the executing operation button code exists in the executing operation button code list, if not, returning abnormal information that the executing operation button does not exist;
otherwise, acquiring a service field list from a program interface information table according to the program name; splitting the service data according to a connector in the service data, and obtaining a service field in the service data and putting the service field into a field array to be checked; traversing the field arrays to be checked, sequentially identifying whether the fields to be checked exist in the service field list, and if any one of the fields does not exist, returning abnormal information of the fields which do not exist; otherwise, the check passes.
7. An SAP ERP system data processing method according to any one of claims 1-5, wherein the bat format string comprises: SAP ERP executes the command, the command attributes and the attribute values; spacing the SAP execution command and the command attribute with a space; each command attribute is preceded by a "-"; the command attributes are connected with the corresponding attribute values in a mode of "═ connection, and space intervals are formed among the command attributes;
the command attributes include: the method comprises the following steps of (1) interface maximization attribute, user name attribute, password attribute, login language attribute, system identification attribute, system description attribute, client number attribute, target system attribute and command line attribute;
the invoking of the bat format string based on the activexbject control to enter the SAP ERP system includes:
shell object is created based on ActiveXObject control;
calling a bat format character string through a run function of a WScript.
Executing SAP ERP execution commands in the bat format character string; if the execution is successful, starting an SAP ERP client program, and automatically logging in to an SAP ERP system according to a user name and a password in the bat format character string; otherwise, prompting abnormal information.
8. An SAP ERP system data processing method according to claim 7, wherein said command line attribute is-command, the corresponding attribute value starts with "+", and said menu transaction code, space, service data and DYNP _ OKCODE are sequentially spliced as an execution operation button code.
9. An SAP ERP system data processing method according to any one of claims 1-5, wherein the request parameters include: request parameter names and request parameter values;
the request parameter name includes: a username parameter, a password parameter, a client number parameter, a login language parameter, a login topic parameter, and a transaction execution parameter.
10. An SAP ERP system data processing method according to claim 9, wherein the transaction execution parameter is transaction, the corresponding request parameter value starts with "+", and the menu transaction code, the space, the service data, and the DYNP _ OKCODE are sequentially concatenated as an execution operation button code.
CN202210008605.XA 2022-01-05 2022-01-05 SAP ERP system data processing method Active CN114356483B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210008605.XA CN114356483B (en) 2022-01-05 2022-01-05 SAP ERP system data processing method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210008605.XA CN114356483B (en) 2022-01-05 2022-01-05 SAP ERP system data processing method

Publications (2)

Publication Number Publication Date
CN114356483A true CN114356483A (en) 2022-04-15
CN114356483B CN114356483B (en) 2023-04-21

Family

ID=81107320

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210008605.XA Active CN114356483B (en) 2022-01-05 2022-01-05 SAP ERP system data processing method

Country Status (1)

Country Link
CN (1) CN114356483B (en)

Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030131290A1 (en) * 1998-06-22 2003-07-10 Amir Weinberg Software system and methods for testing transactional servers
US20140067447A1 (en) * 2012-08-29 2014-03-06 Winshuttle, Llc Erp transaction recording to api system and method
CN103914526A (en) * 2014-03-27 2014-07-09 神华集团有限责任公司 Interface method and interface device for SAP ERP (enterprise resource planning) system and ORACLE ERP system
CN110162365A (en) * 2019-04-28 2019-08-23 苏宁云计算有限公司 A kind of method and system being automatically brought into operation SAP business software
CN110825362A (en) * 2019-11-04 2020-02-21 广东道一信息技术股份有限公司 Low-code application software development system and method
CN111339177A (en) * 2020-03-11 2020-06-26 南京金信通信息服务有限公司 SAP platform-based data export method and system
CN112241268A (en) * 2020-09-22 2021-01-19 合肥寰芯微电子科技有限公司 Keil engineering compiling method, system and equipment
CN112487402A (en) * 2020-11-30 2021-03-12 浪潮通用软件有限公司 Multi-tenant login method, equipment and medium based on ERP system
CN113076502A (en) * 2021-04-23 2021-07-06 南京始云网络科技有限公司 Parameter control method and system based on request identification
CN113506159A (en) * 2021-06-07 2021-10-15 广发银行股份有限公司 SAP HANA-based cost allocation method, SAP HANA-based cost allocation device, SAP HANA-based cost allocation equipment and SAP storage medium
CN113705167A (en) * 2021-08-31 2021-11-26 平安普惠企业管理有限公司 Character checking method, device, equipment and storage medium
CN113792285A (en) * 2021-08-05 2021-12-14 广东核电合营有限公司 Nuclear power station service authority control method and device and terminal equipment

Patent Citations (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030131290A1 (en) * 1998-06-22 2003-07-10 Amir Weinberg Software system and methods for testing transactional servers
US20140067447A1 (en) * 2012-08-29 2014-03-06 Winshuttle, Llc Erp transaction recording to api system and method
CN103914526A (en) * 2014-03-27 2014-07-09 神华集团有限责任公司 Interface method and interface device for SAP ERP (enterprise resource planning) system and ORACLE ERP system
CN110162365A (en) * 2019-04-28 2019-08-23 苏宁云计算有限公司 A kind of method and system being automatically brought into operation SAP business software
CN110825362A (en) * 2019-11-04 2020-02-21 广东道一信息技术股份有限公司 Low-code application software development system and method
CN111339177A (en) * 2020-03-11 2020-06-26 南京金信通信息服务有限公司 SAP platform-based data export method and system
CN112241268A (en) * 2020-09-22 2021-01-19 合肥寰芯微电子科技有限公司 Keil engineering compiling method, system and equipment
CN112487402A (en) * 2020-11-30 2021-03-12 浪潮通用软件有限公司 Multi-tenant login method, equipment and medium based on ERP system
CN113076502A (en) * 2021-04-23 2021-07-06 南京始云网络科技有限公司 Parameter control method and system based on request identification
CN113506159A (en) * 2021-06-07 2021-10-15 广发银行股份有限公司 SAP HANA-based cost allocation method, SAP HANA-based cost allocation device, SAP HANA-based cost allocation equipment and SAP storage medium
CN113792285A (en) * 2021-08-05 2021-12-14 广东核电合营有限公司 Nuclear power station service authority control method and device and terminal equipment
CN113705167A (en) * 2021-08-31 2021-11-26 平安普惠企业管理有限公司 Character checking method, device, equipment and storage medium

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
ELIZABETH E.GRANDON 等: ""Technology Acceptance Model Validation in an Educational Context:a Longitudinal Study of ERP System Use"" *
王淳: ""基于SAP的HR系统接口设计与实现"" *
郭雷兵;郭文静;樊涛;: "SAP系统业务数据批量传输方法应用及客户化实现" *
马语菡 费廷伟 徐永伟: ""航天企业主数据标准化治理的研究与应用"" *

Also Published As

Publication number Publication date
CN114356483B (en) 2023-04-21

Similar Documents

Publication Publication Date Title
US11706218B2 (en) Systems and methods for controlling sign-on to web applications
US9578027B1 (en) Multiple data store authentication
US7796742B1 (en) Systems and methods for simplified provisioning
US6728884B1 (en) Integrating heterogeneous authentication and authorization mechanisms into an application access control system
US6567852B2 (en) Web user interface session and sharing of session environment information
US6826700B1 (en) Method and apparatus for a web application server to automatically solicit a new password when an existing password has expired
US20020178138A1 (en) Synergistic directory-based information management system and method of using
CN110442326A (en) A kind of method and its system simplifying separation permission control in front and back end based on Vue
US8745088B2 (en) System and method of performing risk analysis using a portal
US20030022657A1 (en) Application provisioning over a wireless network
US6751618B1 (en) Method and apparatus for a web application server to upload multiple files and invoke a script to use the files in a single browser request
WO2021027600A1 (en) Single log-in method, apparatus and device, and computer-readable storage medium
WO2021068518A1 (en) Identity authentication method and system, electronic equipment and storage medium
US11722481B2 (en) Multiple identity provider authentication system
CN102064953A (en) System, device and method for configuring user right information of lightweight directory access protocol (ldap) server
CN110716743A (en) Aggregation API development method and system suitable for multi-party collaborative development
CN114172700A (en) Unified authentication system and method based on cloud platform and domain control server
CN111064725A (en) Code zero intrusion interface verification method and device
US20110066891A1 (en) Selective logging based on set parameter
CN113596226B (en) Interface display method, electronic device and readable storage medium
CN113568542A (en) Interface display method and electronic equipment
CN108683651A (en) A kind of single-point logging method, server-side and system
CN114356483B (en) SAP ERP system data processing method
US7203945B2 (en) Import/export utility and a method of processing data using the same
US20210021416A1 (en) Systems and methods for using automated browsing to recover secured key from a single data entry

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
GR01 Patent grant
GR01 Patent grant