CN108763586B - General data dictionary interface device based on SAP field search help - Google Patents
General data dictionary interface device based on SAP field search help Download PDFInfo
- Publication number
- CN108763586B CN108763586B CN201810601216.1A CN201810601216A CN108763586B CN 108763586 B CN108763586 B CN 108763586B CN 201810601216 A CN201810601216 A CN 201810601216A CN 108763586 B CN108763586 B CN 108763586B
- Authority
- CN
- China
- Prior art keywords
- module
- field
- sap
- data dictionary
- interface
- 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.)
- Active
Links
- 230000008676 import Effects 0.000 claims abstract description 18
- 238000012856 packing Methods 0.000 claims abstract description 10
- 238000000034 method Methods 0.000 claims description 18
- 238000001914 filtration Methods 0.000 claims description 7
- 238000009795 derivation Methods 0.000 claims description 6
- 238000004806 packaging method and process Methods 0.000 claims description 5
- 238000012986 modification Methods 0.000 description 4
- 230000004048 modification Effects 0.000 description 4
- 238000007726 management method Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000013519 translation Methods 0.000 description 1
- 230000014616 translation Effects 0.000 description 1
Images
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/01—Protocols
- H04L67/02—Protocols based on web technology, e.g. hypertext transfer protocol [HTTP]
Landscapes
- Engineering & Computer Science (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Computer And Data Communications (AREA)
Abstract
The invention discloses a general data dictionary interface device based on SAP field search help, which comprises an SAR RFC interface butted with an SAP system and an HTTP RESTful WebService service interface butted with a third-party information system, wherein a field import module, a general data dictionary generation module, a data packing module and a export module are sequentially connected between the SAR RFC interface and the HTTP RESTful WebService service interface, and the field import module, the general data dictionary generation module, the data packing module and the export module are respectively connected with a storage module. The invention develops a universal data interface device, which can lead the data dictionary of the SAP system into any other information system through the universal interface device, thereby greatly improving the working efficiency and saving a great deal of manpower and financial cost.
Description
Technical Field
The invention belongs to the field of computer communication, and particularly relates to a general data dictionary interface device based on SAP field search help.
Background
The SAP system is an ERP (enterprise management system) software system, and the SAP system continuously provides a comprehensive enterprise-level management software solution for enterprises in various industries around the world with application software, service and support. In an EPR system, a plurality of management boards are divided according to enterprise management functions, and a data dictionary (a data dictionary refers to defining and describing data items, data structures, data streams, data storage, processing logic, external entities and the like of data, and aims to describe each element in a data flow chart in detail, and is a simple modeling item by using the data dictionary.
When many services of the SAP system need to be integrated with a third-party application system, a large number of functions of the data dictionary in the SAP system are inevitably moved to the third-party application system, an independent SAP RFC interface needs to be developed for each data dictionary according to the existing method, and meanwhile, a corresponding interface calling module also needs to be developed for the third-party application system, so that the three-party application system is developed one by one, huge workload is inevitable, and great difficulty is increased for later operation and maintenance. Another problem is that: the data dictionary is used with high frequency, if the SAP interface is called in real time, the speed is slow, and the SAP is not stressed, moreover, the data dictionary is static generally, and the real-time calling is not necessary.
Therefore, the existing SAP interface needs to be further developed so that it can interface with various third party service platforms.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention provides the general data dictionary interface device based on SAP field search help, and the working efficiency is greatly improved.
The technical scheme of the invention is realized as follows: a general data dictionary interface device based on SAP field search help is characterized by comprising an SAR RFC interface butted with an SAP system and an HTTP RESTful WebService service interface butted with a third-party information system, wherein a field import module, a general data dictionary generation module, a data packing module and a derivation module are sequentially connected between the SAR RFC interface and the HTTP RESTful WebService service interface, and the field import module, the general data dictionary generation module, the data packing module and the derivation module are respectively connected with a storage module, wherein the process of butting the SAP system and the HTTP RESTful WebService service interface is as follows:
firstly, SAP table field name information is input into a third-party information system, the HTTP RESTful WebService service interface collects corresponding SAP table field name information and feeds the SAP table field name information back to the field import module, and the field import module returns to the SAP system according to the input SAP table field name to search and collect all field information of a search aid structure corresponding to the SAP table field, then stores the field information into the storage module and sends the field information to the universal data dictionary generating module;
after receiving the information, the universal data dictionary generating module generates a universal data dictionary by hiding the field which is not needed, modifying the description of the field and setting the filtering condition of the data to recombine;
the data packaging module is used for integrally packaging the general data dictionary;
and the export module imports the packaged general data dictionary into a third-party information system through the HTTP RESTful WebService service interface.
Preferably, the operation method for hiding the field which is not needed is as follows: the third-party information system selects required fields before importing, then reserves the selected fields according to the fields selected by the third-party information system, and finally hides the unselected fields.
Preferably, the description operation method of the modification field is as follows: fields that are clearly inaccurate in the derivation process are corrected.
Preferably, the operation method of the filtering condition of the setting field is as follows: and the third-party information system performs option selection according to requirements before importing, and field contents contained in options which are not selected are filtered according to the options selected by the third-party information system.
Preferably, the third party information system is an MES system, an SCM system, a BPM system, an OA system, a PDM system or an accessory barcode system.
The invention has the beneficial effects that: the invention develops a universal data interface device, which can lead the data dictionary of the SAP system into any other information system through the universal interface device, thereby greatly improving the working efficiency and saving a great deal of manpower and financial cost.
Drawings
FIG. 1 is a functional block diagram of a generic data dictionary interface device based on SAP field search assistance.
Detailed Description
The following further illustrates embodiments of the invention:
as shown in fig. 1, a generic data dictionary interface device based on SAP field search help includes a SAR RFC interface interfacing with an SAP system (RFC is an important and commonly used bi-directional interface technology between the SAP system and other (SAP or non-SAP) systems, and is also regarded as a basic protocol for SAP and external communication, in short, the RFC process is a system calling a program module outside the current system to implement a certain function, and at least one of the calling system and the called system must be an SAP ABAP system, and such remote function calling can also be performed inside the same system), and a HTTP RESTful WebService interface (a data interface) interfacing with a third-party information system, a field importing module, a storage module, a generic data dictionary generating module, a data packing module, and an exporting module are sequentially connected between the RFC interface and the HTTP RESTful WebService interface, the field import module, the general data dictionary generation module, the data packing module and the export module are respectively connected with the storage module, wherein,
firstly, inputting SAP table field name information in a third-party information system, wherein the HTTP RESTful WebService service interface acquires the corresponding SAP table field name information and feeds the SAP table field name information back to the field import module, and the field import module returns to the SAP system according to the input SAP table field name to search and collect all field information of a search help structure corresponding to the SAP table field, stores the field information in the storage module and sends the field information to the universal data dictionary generation module;
after receiving the information, the universal data dictionary generating module generates a universal data dictionary by hiding the field which is not needed, modifying the description of the field and setting the filtering condition of the data to recombine;
the operation method for hiding the field which is not needed comprises the following steps: the third-party information system selects required fields before importing, then reserves the selected fields according to the fields selected by the third-party information system, and finally hides the unselected fields.
For example, the search help is fixed in the output field of the SAP system (for example, the search help field of a country has a country ID, a country abbreviation, and a country full name), and after the data dictionary platform acquires these fields, only the required field (country abbreviation) is selected according to the requirement of a third party for calling the system (only the country abbreviation is needed), so the principle here is to look at the requirement of the third party for calling the system.
The description operation method of the modification field comprises the following steps: fields that are clearly inaccurate in the derivation process are corrected.
For example, often fields returned by SAP describe more technical or inaccurate translations, so the description needs to be revised; it may also be a special requirement of a third party invoking the system.
The operation method of the filtering condition of the setting field comprises the following steps: and the third-party information system performs selection of the options according to requirements before importing, and field contents contained in the options which are not selected are filtered according to the options selected by the third-party information system.
For example, if the third party system requires that only the national data dictionaries of all asian regions are needed, the filtering condition is set as follows: the region is asia.
The general data dictionary is a data dictionary compatible with all information systems.
The data packing module packs the general data dictionary integrally, so that the storage space can be further saved after packing, and the data can be led in and led out conveniently.
And the export module imports the packaged general data dictionary into a third-party information system through the HTTP RESTful WebService service interface.
The third-party information system is an MES system, an SCM system, a BPM system, an OA system, a PDM system or an accessory bar code system.
When the MES system imports the data dictionary from the SAP system, the method is utilized, wherein an SAR RFC interface is connected with the SAP system, an HTTP RESTful WebService service interface end is connected with the MES system, and then the data dictionary in the SAP system can be imported into the MES system through the cooperation of a field import module, a storage module, a general data dictionary generating module and a data packaging module, so that the method is convenient and fast, and the manpower and financial resources are greatly saved.
Variations and modifications to the above-described embodiments may occur to those skilled in the art, which fall within the scope and spirit of the above description. Therefore, the present invention is not limited to the specific embodiments disclosed and described above, and some modifications and variations of the present invention should fall within the scope of the claims of the present invention. Furthermore, although specific terms are employed herein, they are used in a generic and descriptive sense only and not for purposes of limitation.
Claims (2)
1. A general data dictionary interface device based on SAP field search help is characterized by comprising an SAR RFC interface butted with an SAP system and an HTTP RESTful WebService service interface butted with a third-party information system, wherein a field import module, a general data dictionary generation module, a data packing module and a derivation module are sequentially connected between the SAR RFC interface and the HTTP RESTful WebService service interface, and the field import module, the general data dictionary generation module, the data packing module and the derivation module are respectively connected with a storage module, wherein the process of butting the SAP system and the HTTP RESTful WebService service interface is as follows:
firstly, inputting SAP table field names needing to be imported into a third-party information system, wherein the HTTP RESTful WebService service interface acquires corresponding SAP table field name information and feeds the SAP table field name information back to the field import module, the field import module returns to the SAP system to search and collect all field information of search aid structures corresponding to the SAP table field according to the input SAP table field names, and stores search results into the storage module and simultaneously sends the search results to the universal data dictionary generation module;
after receiving the search result information, the universal data dictionary generating module operates by hiding the field which is not needed, and the operation method for hiding the field which is not needed comprises the following steps: the third-party information system selects required fields before importing, then reserves the selected fields according to the fields selected by the third-party information system, finally hides unselected fields, modifies description operation of the fields and recombines filtering condition operation of the fields to generate a universal data dictionary, the universal data dictionary is a data dictionary compatible with the information system, and the description operation method for modifying the fields is as follows: the field which is obviously inaccurate in the process of correcting and deriving is set by the operation method of the filtering condition of the field as follows: the third-party information system performs option checking according to requirements before importing, and field contents contained in options which are not checked are filtered according to the options checked by the third-party information system;
the data packaging module is used for integrally packaging the general data dictionary;
and the export module imports the packaged general data dictionary into a third-party information system through the HTTP RESTful WebService service interface.
2. The universal data dictionary interface device for SAP field search assist as claimed in claim 1 wherein said third party information system is MES system, SCM system, BPM system or OA system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810601216.1A CN108763586B (en) | 2018-06-12 | 2018-06-12 | General data dictionary interface device based on SAP field search help |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810601216.1A CN108763586B (en) | 2018-06-12 | 2018-06-12 | General data dictionary interface device based on SAP field search help |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108763586A CN108763586A (en) | 2018-11-06 |
| CN108763586B true CN108763586B (en) | 2022-07-05 |
Family
ID=64022271
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810601216.1A Active CN108763586B (en) | 2018-06-12 | 2018-06-12 | General data dictionary interface device based on SAP field search help |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108763586B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111143379A (en) * | 2019-11-12 | 2020-05-12 | 望海康信(北京)科技股份公司 | Dictionary information interaction system and method |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103116508A (en) * | 2013-01-18 | 2013-05-22 | 浙江吉利汽车研究院有限公司杭州分公司 | Universal interface and implement method of service access point (SAP) system |
| CN103399735A (en) * | 2013-07-12 | 2013-11-20 | 浙江吉利汽车研究院有限公司杭州分公司 | Method for developing intermediate layer of remote function call interface |
| CN105447069A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | BW platform based account checking platform data synchronization method and system |
| CN106843864A (en) * | 2017-01-09 | 2017-06-13 | 武汉开目信息技术股份有限公司 | A kind of and SAP integrated callback method |
| CN107977277A (en) * | 2017-12-21 | 2018-05-01 | 金蝶软件（中国）有限公司 | The method, apparatus and computer equipment of third party system are integrated in ERP system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| GB2520246A (en) * | 2013-11-12 | 2015-05-20 | Ibm | Method for accessing business object resources and machine-to-machine communication environment |
-
2018
- 2018-06-12 CN CN201810601216.1A patent/CN108763586B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103116508A (en) * | 2013-01-18 | 2013-05-22 | 浙江吉利汽车研究院有限公司杭州分公司 | Universal interface and implement method of service access point (SAP) system |
| CN103399735A (en) * | 2013-07-12 | 2013-11-20 | 浙江吉利汽车研究院有限公司杭州分公司 | Method for developing intermediate layer of remote function call interface |
| CN105447069A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | BW platform based account checking platform data synchronization method and system |
| CN106843864A (en) * | 2017-01-09 | 2017-06-13 | 武汉开目信息技术股份有限公司 | A kind of and SAP integrated callback method |
| CN107977277A (en) * | 2017-12-21 | 2018-05-01 | 金蝶软件（中国）有限公司 | The method, apparatus and computer equipment of third party system are integrated in ERP system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108763586A (en) | 2018-11-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112380213B (en) | Information acquisition method and device, computer equipment and storage medium | |
| CN105426394B (en) | Based on cross-platform mobile report form generation method and system | |
| CN102375731B (en) | Coding-free integrated application platform system | |
| CN111488145B (en) | Micro-service code generation system and method based on service domain data model library | |
| CN101661460B (en) | Method and device for generating management system report | |
| CN103425572B (en) | Code analysis methods and code analysis system | |
| CN110716951B (en) | Label configuration method, device and equipment convenient to configure and storage medium | |
| CN111026931B (en) | Data query method, device, equipment and medium | |
| CN108090154A (en) | A kind of isomerous multi-source data fusion querying method and device | |
| CN111198863B (en) | Rule engine and implementation method thereof | |
| CN102236672A (en) | Method and device for importing data | |
| CN106649488B (en) | Method and device for calling multi-data-source interactive interface | |
| WO2010139226A1 (en) | Service component and application software development method and system based on the service component | |
| CN107133233B (en) | Processing method and device for configuration data query | |
| WO2016141685A1 (en) | Telecommunications engineering drawing generation method and drawing design client | |
| CN115686850A (en) | Spark-based target task processing method and device and electronic equipment | |
| CN102779044B (en) | The dissection process system of expression formula and analyzing and processing method | |
| CN113641700A (en) | Data processing method and device based on Spring boot frame | |
| CN103399735A (en) | Method for developing intermediate layer of remote function call interface | |
| CN101211360A (en) | System and method for processing a plurality of data form of report forms data source | |
| CN105975489A (en) | Metadata-based online SQL code completion method | |
| US10324772B2 (en) | Method and system for data instance-based automatic message map construction | |
| CN110442647A (en) | Data consistency synchronous method, device and computer readable storage medium | |
| CN108804685B (en) | Asset hosting and monitoring task processing method and device | |
| CN111176660A (en) | Distributed architecture-oriented micro-service contract management method and device, computer 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |