CN105404442B - Selection screen configuration method and system based on SAP platforms - Google Patents
Selection screen configuration method and system based on SAP platforms Download PDFInfo
- Publication number
- CN105404442B CN105404442B CN201510617688.2A CN201510617688A CN105404442B CN 105404442 B CN105404442 B CN 105404442B CN 201510617688 A CN201510617688 A CN 201510617688A CN 105404442 B CN105404442 B CN 105404442B
- Authority
- CN
- China
- Prior art keywords
- selection screen
- sap
- report
- field
- fields
- 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.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 18
- 238000012216 screening Methods 0.000 claims abstract description 5
- 101150082840 SM30 gene Proteins 0.000 claims description 6
- 238000012986 modification Methods 0.000 claims description 4
- 230000004048 modification Effects 0.000 claims description 4
- 238000012423 maintenance Methods 0.000 claims description 3
- 238000010276 construction Methods 0.000 claims 2
- 238000004088 simulation Methods 0.000 claims 2
- 230000003068 static effect Effects 0.000 claims 2
- 238000011161 development Methods 0.000 abstract description 4
- 238000012360 testing method Methods 0.000 abstract description 3
- 230000009286 beneficial effect Effects 0.000 abstract description 2
- 230000004913 activation Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000003252 repetitive effect Effects 0.000 description 1
Landscapes
- User Interface Of Digital Computer (AREA)
Abstract
本发明公开了一种基于SAP平台的选择屏幕配置方法与系统,包括:收集所有可能出现在查询条件里的字段,将所述字段转换成客户端能够使用的屏幕元素;静态构建查询语句;通过SAP提供的功能模块IAC_GET_DYNPRO_INFO读取所有出现在报表中的屏幕元素的内部标识;在SAP平台上创建选择屏幕配置表,将读取到的内部标识存储在配置表中;进行结果筛选并判断所述选择屏幕配置表中的字段是否需要显示。本发明有益效果:在报表显示规则频繁调整时,只需要在生产系统中维护规则库表,即可立即实现报表显示调整的要求,免去了开发系统到测试系统再到生产系统的中间环节,既节省了人力成本和时间成本的同时,数据实时性也得到大幅提高。
The invention discloses a selection screen configuration method and system based on a SAP platform, comprising: collecting all fields that may appear in query conditions, converting the fields into screen elements that can be used by the client; statically constructing query sentences; The function module IAC_GET_DYNPRO_INFO provided by SAP reads the internal identification of all screen elements appearing in the report; creates a selection screen configuration table on the SAP platform, stores the read internal identification in the configuration table; performs result screening and judges the Select whether the fields in the screen configuration table need to be displayed. The invention has beneficial effects: when the report display rules are frequently adjusted, only the rule base table needs to be maintained in the production system, and the report display adjustment requirements can be realized immediately, eliminating the intermediate links from the development system to the test system and then to the production system. While saving labor costs and time costs, the real-time performance of data has also been greatly improved.
Description
技术领域technical field
本发明涉及信息处理领域,尤其涉及一种基于SAP平台的选择屏幕配置方法与系统。The invention relates to the field of information processing, in particular to a selection screen configuration method and system based on an SAP platform.
背景技术Background technique
SAP(systems applications and products in data processing)是一款用于企业资源计划ERP(enterprise resource planning)管理的软件。SAP (systems applications and products in data processing) is a software for enterprise resource planning (ERP) (enterprise resource planning) management.
SAP普遍采用开发系统、测试系统、生产系统相互分离,通过各系统打包的方式实现系统修改操作。SAP generally separates the development system, test system, and production system from each other, and implements system modification operations through the packaging of each system.
SAP系统在在实际的报表开发过程中,需要根据业务顾问的需求对固定的搜索条件字段进行新增、删除,同一个字段可能出现多次的激活与取消操作,导致大量的重复代码的编写,浪费了大量的人力与时间,并且,由于在报表业务需求进行调整时,需要进行大量的代码编写,导致报表显示的实时性变差,影响了企业的运营成本以及报表使用的实时性。In the actual report development process of the SAP system, it is necessary to add and delete fixed search condition fields according to the needs of business consultants. The same field may have multiple activation and cancellation operations, resulting in a large amount of repetitive code writing. A lot of manpower and time were wasted, and because of the need to write a lot of code when adjusting the business requirements of the report, the real-time performance of the report display deteriorated, which affected the operating costs of the enterprise and the real-time performance of the use of the report.
发明内容Contents of the invention
本发明的目的就是为了解决上述问题,提出了一种基于SAP平台的选择屏幕配置方法与系统,该方法及系统将频繁调整的报表显示规则设置为易于用户维护的配置表,操作简单,数据实时性好。The purpose of the present invention is exactly in order to solve above-mentioned problem, has proposed a kind of selection screen configuration method and system based on SAP platform, and this method and system set the frequently adjusted report display rule as the configuration table that is easy for user to maintain, simple operation, real-time data Good sex.
为了实现上述目的,本发明采用如下技术方案:In order to achieve the above object, the present invention adopts the following technical solutions:
一种基于SAP平台的选择屏幕配置方法,包括以下步骤:A selection screen configuration method based on SAP platform, comprising the following steps:
步骤1:根据用户需求收集所有可能出现在查询条件里的字段,将所述字段转换成客户端能够使用的屏幕元素;Step 1: Collect all fields that may appear in the query condition according to user requirements, and convert the fields into screen elements that can be used by the client;
步骤2:静态构建查询语句,查询语句中涉及上述所有的字段,使用范围条件,对每一个字段变量使用range类型作为参照;Step 2: Statically build the query statement, involving all the above-mentioned fields in the query statement, use the range condition, and use the range type as a reference for each field variable;
步骤3:通过SAP提供的功能模块IAC_GET_DYNPRO_INFO读取所有出现在报表中的屏幕元素的内部标识;所述内部标识与屏幕元素为一一对应关系;Step 3: read the internal identification of all screen elements appearing in the report by the function module IAC_GET_DYNPRO_INFO that SAP provides; Described internal identification and screen element are one-to-one correspondence;
步骤4:在SAP平台上创建选择屏幕配置表,将读取到的内部标识存储在配置表中,并通过事务码SE55创建可通过SM30进行表条目维护的视图,模拟SAP配置界面;Step 4: Create the selection screen configuration table on the SAP platform, store the internal identification read in the configuration table, and create a view that can be maintained by SM30 through the transaction code SE55, simulating the SAP configuration interface;
步骤5:报表初始化时,读取步骤4创建的选择屏幕配置表,进行结果筛选并判断所述选择屏幕配置表中的字段是否需要显示。Step 5: When the report is initialized, read the selection screen configuration table created in step 4, perform result screening and judge whether the fields in the selection screen configuration table need to be displayed.
所述选择屏幕配置表中包括:字段名、屏幕元素及其对应的内部标识、是否需要显示。The selection screen configuration table includes: field names, screen elements and their corresponding internal identifiers, and whether they need to be displayed.
报表业务需求调整时,通过添加或删除需要显示的内部标识或者修改查询条件里的字段实现;When the report business needs are adjusted, it can be realized by adding or deleting the internal identifiers that need to be displayed or modifying the fields in the query conditions;
一种基于SAP平台的选择屏幕配置方法的系统,包括:A system based on a SAP platform-based selection screen configuration method, comprising:
用于根据用户需求收集所有可能出现在查询条件里的字段的单元;用于将所述字段转换成客户端能够使用的屏幕元素的单元;A unit for collecting all fields that may appear in query conditions according to user requirements; a unit for converting the fields into screen elements that can be used by the client;
用于静态构建查询语句的单元,所述查询语句中涉及所有的字段,使用范围条件,对每一个字段变量使用range类型作为参照;A unit for statically constructing a query statement, in which all fields are involved, a range condition is used, and a range type is used as a reference for each field variable;
用于通过SAP提供的功能模块IAC_GET_DYNPRO_INFO读取所有出现在报表中的屏幕元素的内部标识的单元;所述内部标识与屏幕元素为一一对应关系;A unit for reading the internal identifiers of all screen elements appearing in the report through the function module IAC_GET_DYNPRO_INFO provided by SAP; the internal identifiers have a one-to-one correspondence with the screen elements;
用于在SAP平台上创建选择屏幕配置表的单元,用于将读取到的内部标识存储在配置表中的单元,用于通过事务码SE55创建可通过SM30进行表条目维护的视图,模拟SAP配置界面的单元;The unit used to create the selection screen configuration table on the SAP platform, the unit used to store the read internal identifier in the configuration table, used to create a view that can be maintained by SM30 through transaction code SE55, simulating SAP The unit of the configuration interface;
用于报表初始化时,读取创建的选择屏幕配置表,进行结果筛选并判断所述选择屏幕配置表中的字段是否需要显示的字段。When the report is initialized, the created selection screen configuration table is read, the results are filtered and whether the fields in the selection screen configuration table need to be displayed is judged.
所述选择屏幕配置表中包括:字段名、屏幕元素及其对应的内部标识、是否需要显示。The selection screen configuration table includes: field names, screen elements and their corresponding internal identifiers, and whether they need to be displayed.
还包括:Also includes:
用于报表业务需求调整时,通过添加或删除需要显示的内部标识或者修改查询条件里的字段实现的单元。When adjusting the business requirements of the report, it is a unit realized by adding or deleting internal identifiers that need to be displayed or modifying the fields in the query conditions.
本发明的有益效果是:The beneficial effects of the present invention are:
本发明通过在SAP平台中创建选择屏幕配置表,将报表的屏幕元素对应的内部标识维护进配置表中,在报表显示规则频繁调整时,只需要在生产系统中维护规则库表,即可立即实现报表显示调整的要求,免去了开发系统到测试系统再到生产系统的中间环节,既节省了人力成本和时间成本的同时,数据实时性也得到大幅提高。The present invention maintains the internal identification corresponding to the screen elements of the report into the configuration table by creating a selection screen configuration table in the SAP platform. When the report display rules are frequently adjusted, only the rule library table needs to be maintained in the production system, and the user can immediately Realize the requirements of report display adjustment, eliminating the intermediate links from development system to test system to production system, which not only saves labor costs and time costs, but also greatly improves the real-time data performance.
附图说明Description of drawings
图1为本发明方法流程图;Fig. 1 is a flow chart of the method of the present invention;
图2为本发明配置表维护视图;Fig. 2 is a configuration table maintenance view of the present invention;
图3为本发明配置效果图。Fig. 3 is a configuration diagram of the present invention.
具体实施方式:Detailed ways:
下面结合附图与实施例对本发明做进一步说明:Below in conjunction with accompanying drawing and embodiment the present invention will be further described:
基于SAP平台的选择屏幕配置方法如图1所示,包括以下步骤:The selection screen configuration method based on the SAP platform is shown in Figure 1, including the following steps:
步骤1:根据用户需求收集所有可能出现在查询条件里的字段,将所述字段转换成客户端能够使用的屏幕元素;Step 1: Collect all fields that may appear in the query condition according to user requirements, and convert the fields into screen elements that can be used by the client;
步骤2:静态构建查询语句,查询语句中涉及上述所有的字段,使用范围条件,对每一个字段变量使用range类型作为参照;字段变量用于存储客户端输入的屏幕元素。Step 2: Statically construct a query statement, which involves all the above-mentioned fields, use range conditions, and use the range type as a reference for each field variable; the field variable is used to store the screen elements input by the client.
客户端用户输入的屏幕元素为单个字段时,查询结果为单个字段;当客户端输入的屏幕元素为范围条件时,查询结果为相应的一个字段范围。When the screen element input by the client user is a single field, the query result is a single field; when the screen element input by the client is a range condition, the query result is a corresponding field range.
步骤3:通过SAP提供的功能模块IAC_GET_DYNPRO_INFO读取所有出现在报表中的屏幕元素的内部标识;所述内部标识与屏幕元素为一一对应关系;Step 3: read the internal identification of all screen elements appearing in the report by the function module IAC_GET_DYNPRO_INFO that SAP provides; Described internal identification and screen element are one-to-one correspondence;
选择屏幕配置表中包括:字段名、屏幕元素及其对应的内部标识、是否需要显示等信息,如图2所示。The selection screen configuration table includes information such as field names, screen elements and their corresponding internal identifiers, and whether they need to be displayed, as shown in Figure 2.
步骤4:在SAP平台上创建选择屏幕配置表,将读取到的内部标识存储在配置表中,并通过事务码SE55创建可通过SM30进行表条目维护的视图,模拟SAP配置界面;Step 4: Create the selection screen configuration table on the SAP platform, store the internal identification read in the configuration table, and create a view that can be maintained by SM30 through the transaction code SE55, simulating the SAP configuration interface;
步骤5:报表初始化时,读取步骤4创建的选择屏幕配置表,进行结果筛选并判断所述选择屏幕配置表中的字段是否需要显示。Step 5: When the report is initialized, read the selection screen configuration table created in step 4, perform result screening and judge whether the fields in the selection screen configuration table need to be displayed.
通过选择客户端需要显示的屏幕元素,实现报表界面的最终显示,具体效果如图3所示。By selecting the screen elements that the client needs to display, the final display of the report interface is realized, and the specific effect is shown in Figure 3.
报表业务需求调整时,通过添加或删除需要显示的内部标识或者修改查询条件里的字段实现;When the report business needs are adjusted, it can be realized by adding or deleting the internal identifiers that need to be displayed or modifying the fields in the query conditions;
一种基于SAP平台的选择屏幕配置方法的系统,包括:A system based on a SAP platform-based selection screen configuration method, comprising:
用于根据用户需求收集所有可能出现在查询条件里的字段的单元;用于将所述字段转换成客户端能够使用的屏幕元素的单元;A unit for collecting all fields that may appear in query conditions according to user requirements; a unit for converting the fields into screen elements that can be used by the client;
用于静态构建查询语句的单元,所述查询语句中涉及所有的字段,使用范围条件,对每一个字段变量使用range类型作为参照;A unit for statically constructing a query statement, in which all fields are involved, a range condition is used, and a range type is used as a reference for each field variable;
用于通过SAP提供的功能模块IAC_GET_DYNPRO_INFO读取所有出现在报表中的屏幕元素的内部标识的单元;所述内部标识与屏幕元素为一一对应关系;A unit for reading the internal identifiers of all screen elements appearing in the report through the function module IAC_GET_DYNPRO_INFO provided by SAP; the internal identifiers have a one-to-one correspondence with the screen elements;
用于在SAP平台上创建选择屏幕配置表的单元,用于将读取到的内部标识存储在配置表中的单元,用于通过事务码SE55创建可通过SM30进行表条目维护的视图,模拟SAP配置界面的单元;The unit used to create the selection screen configuration table on the SAP platform, the unit used to store the read internal identifier in the configuration table, used to create a view that can be maintained by SM30 through transaction code SE55, simulating SAP The unit of the configuration interface;
用于报表初始化时,读取创建的选择屏幕配置表,进行结果筛选并判断所述选择屏幕配置表中的字段是否需要显示的字段。When the report is initialized, the created selection screen configuration table is read, the results are filtered and whether the fields in the selection screen configuration table need to be displayed is judged.
还包括:Also includes:
用于报表业务需求调整时,通过添加或删除需要显示的内部标识或者修改查询条件里的字段实现的单元。When adjusting the business requirements of the report, it is a unit realized by adding or deleting internal identifiers that need to be displayed or modifying the fields in the query conditions.
上述虽然结合附图对本发明的具体实施方式进行了描述,但并非对本发明保护范围的限制,所属领域技术人员应该明白,在本发明的技术方案的基础上,本领域技术人员不需要付出创造性劳动即可做出的各种修改或变形仍在本发明的保护范围以内。Although the specific implementation of the present invention has been described above in conjunction with the accompanying drawings, it is not a limitation to the protection scope of the present invention. Those skilled in the art should understand that on the basis of the technical solution of the present invention, those skilled in the art do not need to pay creative work Various modifications or variations that can be made are still within the protection scope of the present invention.
Claims (6)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510617688.2A CN105404442B (en) | 2015-09-24 | 2015-09-24 | Selection screen configuration method and system based on SAP platforms |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201510617688.2A CN105404442B (en) | 2015-09-24 | 2015-09-24 | Selection screen configuration method and system based on SAP platforms |
Publications (2)
Publication Number | Publication Date |
---|---|
CN105404442A CN105404442A (en) | 2016-03-16 |
CN105404442B true CN105404442B (en) | 2018-09-18 |
Family
ID=55469955
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201510617688.2A Expired - Fee Related CN105404442B (en) | 2015-09-24 | 2015-09-24 | Selection screen configuration method and system based on SAP platforms |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105404442B (en) |
Families Citing this family (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109343767A (en) * | 2018-08-31 | 2019-02-15 | 湖南新云网科技有限公司 | A kind of method for deleting of electronic whiteboard |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
CN102073702A (en) * | 2010-12-30 | 2011-05-25 | 浪潮集团山东通用软件有限公司 | Personnel information dynamic-extension realizing method for human resource management information system |
CN102902767A (en) * | 2012-09-25 | 2013-01-30 | 北京科东电力控制系统有限责任公司 | Method and system for rapidly creating forms |
EP2660732A1 (en) * | 2012-04-30 | 2013-11-06 | Sap Ag | Unified table query processing |
EP2706494A1 (en) * | 2012-09-10 | 2014-03-12 | Sap Ag | Energy efficient display of control events of an industrial automation system |
CN104699681A (en) * | 2013-12-04 | 2015-06-10 | 航天信息股份有限公司 | Data processing method based on metadata base |
-
2015
- 2015-09-24 CN CN201510617688.2A patent/CN105404442B/en not_active Expired - Fee Related
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1588369A (en) * | 2004-09-06 | 2005-03-02 | 杭州恒生电子股份有限公司 | Relation type data base system and its search and report method |
CN102073702A (en) * | 2010-12-30 | 2011-05-25 | 浪潮集团山东通用软件有限公司 | Personnel information dynamic-extension realizing method for human resource management information system |
EP2660732A1 (en) * | 2012-04-30 | 2013-11-06 | Sap Ag | Unified table query processing |
EP2706494A1 (en) * | 2012-09-10 | 2014-03-12 | Sap Ag | Energy efficient display of control events of an industrial automation system |
CN102902767A (en) * | 2012-09-25 | 2013-01-30 | 北京科东电力控制系统有限责任公司 | Method and system for rapidly creating forms |
CN104699681A (en) * | 2013-12-04 | 2015-06-10 | 航天信息股份有限公司 | Data processing method based on metadata base |
Non-Patent Citations (2)
Title |
---|
企业SAP ERP系统用户权限管理解决方案;苏戎;《信息通信》;20150131(第1期);第111-113页 * |
基于SAP平台的电厂基建ERP管理系统的构建与应用;蔡薛辉;《江苏科技信息》;20130131(第1期);第54-56,64页 * |
Also Published As
Publication number | Publication date |
---|---|
CN105404442A (en) | 2016-03-16 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20220067194A1 (en) | Generation of a privilege graph to represent data access authorizations | |
CN104679488B (en) | A kind of flow custom development platform and flow custom development approach | |
US20130166602A1 (en) | Cloud-enabled business object modeling | |
CN106776995B (en) | Structured data tree-form acquisition method based on model-driven architecture | |
CN103020158A (en) | Report form creation method, device and system | |
CN104731588B (en) | Page layout document generating method and page layout file creating apparatus | |
CN103177329A (en) | Rule-based determination and validation in business object processing | |
CN105068809A (en) | PyQt-based platform for implementing automation project management and case execution | |
CN106055528A (en) | Automatic generation method and apparatus of documents | |
CN107273369B (en) | Table data modification method and device | |
CN106408435A (en) | Process compiling system and process compiling method | |
US9350561B1 (en) | Visualizing the flow of resources in an allocation model | |
CN109376153A (en) | System and method for writing data into graph database based on NiFi | |
CN104699863A (en) | Webpage data display system | |
CN105354141A (en) | EMT test case management system and method | |
CN109033157B (en) | Complex data retrieval method and system based on user-defined search condition tree | |
CN115840567A (en) | Application editing method and related equipment | |
US8291380B2 (en) | Methods for configuring software package | |
CN104462361A (en) | Method and device for matching data in data table | |
CN115291856B (en) | Flow establishing method and device and electronic equipment | |
CN116382643A (en) | A running system based on a low-code platform | |
US20150363711A1 (en) | Device for rapid operational visibility and analytics automation | |
CN105404442B (en) | Selection screen configuration method and system based on SAP platforms | |
CN103186384A (en) | Business-component-oriented software designing and analyzing system and using method thereof | |
CN104123394B (en) | Processing method for the report file of database |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP01 | Change in the name or title of a patent holder |
Address after: 250001 No. 150 Jing No. 2 Road, Jinan City, Shandong Province Patentee after: STATE GRID SHANDONG ELECTRIC POWER Co. Patentee after: ELECTRIC POWER RESEARCH INSTITUTE OF STATE GRID SHANDONG ELECTRIC POWER Co. Patentee after: Shandong luruan Digital Technology Co.,Ltd. Address before: 250001 No. 150 Jing No. 2 Road, Jinan City, Shandong Province Patentee before: STATE GRID SHANDONG ELECTRIC POWER Co. Patentee before: ELECTRIC POWER RESEARCH INSTITUTE OF STATE GRID SHANDONG ELECTRIC POWER Co. Patentee before: SHANDONG LUNENG SOFTWARE TECHNOLOGY Co.,Ltd. |
|
CP01 | Change in the name or title of a patent holder | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20180918 Termination date: 20210924 |
|
CF01 | Termination of patent right due to non-payment of annual fee |