CN105404501B - Rule base analytic method and system based on SAP platform - Google Patents
Rule base analytic method and system based on SAP platform Download PDFInfo
- Publication number
- CN105404501B CN105404501B CN201510617555.5A CN201510617555A CN105404501B CN 105404501 B CN105404501 B CN 105404501B CN 201510617555 A CN201510617555 A CN 201510617555A CN 105404501 B CN105404501 B CN 105404501B
- Authority
- CN
- China
- Prior art keywords
- rule
- data
- page
- rule base
- unit
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of rule base analytic methods and system based on SAP platform, comprising: the page created to needs is numbered, while carrying out rule numbers to rule, and rule base table is created in SAP platform；The difference that data are shown according to the page, is subdivided into rules unit for the data acquisition rule of respective page, the rules unit can be safeguarded in rule base table；The rules unit segmented in step 2 is safeguarded into rule base table；When the corresponding data of the page needed for obtaining user, corresponding rule numbers are obtained from rule base according to page number, then each rules unit is combined according to the rule numbers, composition obtains the Where condition of data, obtains corresponding page data.The invention has the advantages that: the intermediate links for eliminating development system to test macro and arriving again production system, and while both having saved human cost and time cost, real-time property is also largely increased.
Description
Technical field
The present invention relates to field of information processing more particularly to a kind of rule base analytic methods and system based on SAP platform.
Background technique
SAP (systems applications and products in data processing) is a for looking forward to
The software of industry resource planning ERP (enterprise resource planning) management.
SAP generallys use development system, test macro, production system and is separated from each other, real in such a way that each system is packaged
Existing system modification operation.
SAP system generallys use business personnel and modifies configuration or developer's modification code when encountering business reorganization
After generate patch, then install patch to production system mode.But be directed to business rule frequently adjust and also rule dimension
The little situation of difficulty is protected, when above-mentioned maintenance mode will generate human cost substantial increase (maintenance personnel's expense) and realize
Between lag (generate patch installation patch time), the real-time for affecting the operation cost of enterprise and using.
Summary of the invention
The purpose of the present invention is to solve the above-mentioned problems, proposes a kind of rule base parsing side based on SAP platform
Method and system, this method and system set the business rule frequently adjusted to be easy to the rule base of user maintenance, and data are real-time
Property is good.
To achieve the goals above, the present invention adopts the following technical scheme:
A kind of rule base analytic method based on SAP platform, comprising the following steps:
Step 1: the page created to needs is numbered, while carrying out rule numbers to rule, creates in SAP platform
Rule base table；
Step 2: the difference of data is shown according to the page, and the data acquisition rule of respective page is subdivided into rules unit,
The rules unit can be safeguarded in rule base table；
Step 3: the rules unit segmented in step 2 is safeguarded into rule base table；
Step 4: when the corresponding data of the page needed for obtaining user, being obtained from rule base according to page number corresponding
Then rule numbers combine each rules unit according to the rule numbers, composition obtains the Where condition of data, obtain
Corresponding page data.
The rule base table created in the step 1 includes: rule numbers, is applicable in page number, rules unit number, tables of data
Name, data sheet field name, comparison operators and compare data.
The data acquisition rule of respective page includes: the data source for obtaining data, the item for obtaining data in the step 2
Part and intermediate variable value.
The rules unit that will have been segmented, which is safeguarded, to be realized into rule base table by the Tcode:SM30 technology of SAP.
When business rule adjusts, is realized by modification production system maintenance regulation library table configuration, specifically include: increasing or delete
Except rules unit, alteration ruler unit, the sequence of alteration ruler unit.
A kind of system of the rule base analytic method based on SAP platform, comprising: the page for creating to needs is compiled
Number,
Rule numbers are carried out to rule simultaneously, the device of rule base table is created in SAP platform；
For showing the difference of data according to the page, the data acquisition rule of respective page is subdivided into rules unit, institute
State the device that rules unit can be safeguarded in rule base table；
For safeguarding the rules unit segmented into the device in rule base table；
When data corresponding for the page needed for obtaining user, corresponding rule are obtained from rule base according to page number
It then numbers, then each rules unit is combined according to the rule numbers, composition obtains the Where condition of data, acquisition pair
The device for the page data answered.
The rule base table of the creation includes: rule numbers, is applicable in page number, rules unit number, data table name, data
Literary name section name, comparison operators and compare data.
The data acquisition rule of the respective page includes: the data source for obtaining data, the condition for obtaining data, Yi Jizhong
Between variate-value.
The rules unit that will have been segmented is safeguarded real by the Tcode:SM30 technology of SAP into the device in rule base table
It is existing.
Further include, when for business rule adjustment, the device realized by modification production system maintenance regulation library table configuration,
It specifically includes: the device of increase or deletion rule unit, the device of alteration ruler unit, the dress of the sequence of alteration ruler unit
It sets.
The beneficial effects of the present invention are:
The data subdividing of the page is that rules unit is safeguarded into rule by creating rule base table in SAP platform by the present invention
Then in the table of library, when business rule frequently adjusts, user only needs the maintenance regulation library table in production system, can realize immediately
The requirement of business reorganization eliminates the intermediate link that development system arrives production system to test macro again, both saved manpower at
While this is with time cost, real-time property is also largely increased.
Detailed description of the invention
Fig. 1 is the method for the present invention flow chart.
Specific embodiment:
The present invention will be further described with embodiment with reference to the accompanying drawing:
Rule base analytic method based on SAP platform is as shown in Figure 1, comprising the following steps:
Step 1. pair needs the page created to be numbered, while carrying out rule numbers to rule, then passes through in SAP
Tcode:SE11 creates rule base table, the corresponding relationship of rule and the page convenient for safeguarding, and the pass of rule and rules unit number
It is in the table comprising rule numbers, applicable page number, rules unit number, data table name, data sheet field name, comparison operators, ratio
It is specific as shown in table 1 compared with data (constant or page variable).
Table 1
Step 2. is analyzed the data acquisition rule of respective page, carefully according to the difference of the display data of each page
It is divided into rules unit, each rules unit can be safeguarded in rule list by reaching.Citing: rule is to obtain the price of A factory
Higher than the bill of materials of the page input amount of money (variable V AR1), so that it may segment are as follows: rules unit 1:A factory corresponds to table TAB1's
Field1 field is A factory；It is > VAR1 that 2: greater than page of rules unit input amount of money material, which corresponds to the Field2 field of table TAB2,
Step 3. is by the Tcode:SM30 of SAP, by the regular organizational maintenance analyzed in step 2 into rule base table；
Step 4. is by the dynamic programming of SAP, when user uses the page, is obtained from rule base according to page number pair
Then the rule numbers answered combine each rules unit according to the rule numbers, composition obtains the Where condition of data,
Corresponding data can be obtained.Citing: when user executes page A, need to obtain the corresponding rule of the page from rule list
Then number: then rule 1 connects the condition of the specific literary name section in the rules unit of rule 1: TAB1~Field1=
' A ' and TAB2~Field2 > VAR1 composition chooses the condition of data, adds the selection item when reading data with SQL statement
Part.
When business rule adjusts, is realized by modification production system maintenance regulation library table configuration, specifically include: increasing or delete
Except rules unit, alteration ruler unit, the sequence of alteration ruler unit.
When carrying out regular dynamic configuration,
The adjustment field under each rule numbers is determined first；
Rule configuration list is established in SAP platform, and rule numbers and its corresponding adjustment field are safeguarded into rule and matched
Set table；
The rule according to needed for business transfers rule numbers in the rule configuration list and adjusts field accordingly, will not
Same rule numbers and corresponding adjustment field are combined, and are configured to final rule.
A kind of system of the rule base analytic method based on SAP platform, comprising:
The page for creating to needs is numbered, while carrying out rule numbers to rule, and rule are created in SAP platform
The then device of library table；
For showing the difference of data according to the page, the data acquisition rule of respective page is subdivided into rules unit, institute
State the device that rules unit can be safeguarded in rule base table；
For safeguarding the rules unit segmented into the device in rule base table；
When data corresponding for the page needed for obtaining user, corresponding rule are obtained from rule base according to page number
It then numbers, then each rules unit is combined according to the rule numbers, composition obtains the Where condition of data, acquisition pair
The device for the page data answered.
The rule base table of the creation includes: rule numbers, is applicable in page number, rules unit number, data table name, data
Literary name section name, comparison operators and compare data.
The data acquisition rule of the respective page includes: the data source for obtaining data, the condition for obtaining data, Yi Jizhong
Between variate-value.
The rules unit that will have been segmented is safeguarded real by the Tcode:SM30 technology of SAP into the device in rule base table
It is existing.
Further include, when for business rule adjustment, the device realized by modification production system maintenance regulation library table configuration,
It specifically includes: the device of increase or deletion rule unit, the device of alteration ruler unit, the dress of the sequence of alteration ruler unit
It sets.
Above-mentioned, although the foregoing specific embodiments of the present invention is described with reference to the accompanying drawings, not protects model to the present invention
The limitation enclosed, those skilled in the art should understand that, based on the technical solutions of the present invention, those skilled in the art are not
Need to make the creative labor the various modifications or changes that can be made still within protection scope of the present invention.
Claims (6)
1. a kind of rule base analytic method based on SAP platform, characterized in that the following steps are included:
Step 1: the page created to needs is numbered, while carrying out rule numbers to rule, and rule is created in SAP platform
Library table；The rule base table of creation includes: rule numbers, is applicable in page number, rules unit number, data table name, data sheet field
Name and compares data at comparison operators；
Step 2: the difference of data is shown according to the page, and the data acquisition rule of respective page is subdivided into rules unit, it is described
Rules unit can be safeguarded in rule base table；
Step 3: the rules unit segmented in step 2 is safeguarded into rule base table；
Step 4: when the corresponding data of the page needed for obtaining user, obtaining corresponding rule from rule base according to page number
Number, then combines each rules unit according to the rule numbers, and composition obtains the Where condition of data, obtains and corresponds to
Page data；
When business rule adjusts, is realized by modification production system maintenance regulation library table configuration, specifically include: increasing or delete rule
Then unit, alteration ruler unit, the sequence of alteration ruler unit；When carrying out regular dynamic configuration, it is first determined each rule
Adjustment field under number；
Rule configuration list is established in SAP platform, and rule numbers and its corresponding adjustment field are safeguarded into rule configuration list；
The rule according to needed for business transfers rule numbers in the rule configuration list and adjusts field accordingly, will be different
Rule numbers and corresponding adjustment field are combined, and are configured to final rule.
2. a kind of rule base analytic method based on SAP platform as described in claim 1, characterized in that phase in the step 2
The data acquisition rule for answering the page includes: the data source for obtaining data, the condition and intermediate variable value for obtaining data.
3. a kind of rule base analytic method based on SAP platform as described in claim 1, characterized in that described to segment
Rules unit safeguard and realized into rule base table by the Tcode:SM30 technology of SAP.
4. a kind of system of the rule base analytic method based on SAP platform as described in claim 1, characterized in that include:
The page for creating to needs is numbered, while carrying out rule numbers to rule, creates rule base in SAP platform
The device of table；
The rule base table of the creation includes: rule numbers, is applicable in page number, rules unit number, data table name, data literary name
Section and compares data at name, comparison operators；
For showing the difference of data according to the page, the data acquisition rule of respective page is subdivided into rules unit, the rule
The then device that unit can be safeguarded in rule base table；
For safeguarding the rules unit segmented into the device in rule base table；
When data corresponding for the page needed for obtaining user, corresponding rule is obtained from rule base according to page number and is compiled
Number, then each rules unit is combined according to the rule numbers, composition obtains the Where condition of data, obtains corresponding
The device of page data；
When for business rule adjustment, the device realized by modification production system maintenance regulation library table configuration specifically includes: increasing
Add or the device of deletion rule unit, the device of alteration ruler unit, the device of the sequence of alteration ruler unit.
5. a kind of system of the rule base analytic method based on SAP platform as claimed in claim 4, characterized in that the phase
The data acquisition rule for answering the page includes: the data source for obtaining data, the condition and intermediate variable value for obtaining data.
6. a kind of system of the rule base analytic method based on SAP platform as claimed in claim 4, characterized in that described to incite somebody to action
The rules unit segmented is safeguarded into the device in rule base table and is realized by the Tcode:SM30 technology of SAP.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510617555.5A CN105404501B (en) | 2015-09-24 | 2015-09-24 | Rule base analytic method and system based on SAP platform |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510617555.5A CN105404501B (en) | 2015-09-24 | 2015-09-24 | Rule base analytic method and system based on SAP platform |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105404501A CN105404501A (en) | 2016-03-16 |
| CN105404501B true CN105404501B (en) | 2019-02-01 |
Family
ID=55470004
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510617555.5A Expired - Fee Related CN105404501B (en) | 2015-09-24 | 2015-09-24 | Rule base analytic method and system based on SAP platform |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105404501B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106503162B (en) * | 2016-10-31 | 2019-12-24 | 山东鲁能软件技术有限公司 | SAP platform based page dynamic generation method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| CN102456004A (en) * | 2010-10-18 | 2012-05-16 | 金蝶软件（中国）有限公司 | Query control method and system of page data |
| CN102541529A (en) * | 2010-12-30 | 2012-07-04 | 北京亿阳信通软件研究院有限公司 | Query page generating device and method |
| JP5579140B2 (en) * | 2011-09-05 | 2014-08-27 | 日本電信電話株式会社 | Document search apparatus, method, and program |
| CN104331295A (en) * | 2014-11-05 | 2015-02-04 | 北京中科辅龙信息技术有限公司 | Page generation method and system |
-
2015
- 2015-09-24 CN CN201510617555.5A patent/CN105404501B/en not_active Expired - Fee Related
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101739453A (en) * | 2009-12-17 | 2010-06-16 | 中国电力科学研究院 | Method and device for carrying out condition query on database table |
| CN102456004A (en) * | 2010-10-18 | 2012-05-16 | 金蝶软件（中国）有限公司 | Query control method and system of page data |
| CN102541529A (en) * | 2010-12-30 | 2012-07-04 | 北京亿阳信通软件研究院有限公司 | Query page generating device and method |
| JP5579140B2 (en) * | 2011-09-05 | 2014-08-27 | 日本電信電話株式会社 | Document search apparatus, method, and program |
| CN104331295A (en) * | 2014-11-05 | 2015-02-04 | 北京中科辅龙信息技术有限公司 | Page generation method and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105404501A (en) | 2016-03-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102760059B (en) | Automatic generating method for standardized test scripts of relay protection device of electrical system | |
| CN108628964B (en) | Intelligent scene-based enterprise big data system | |
| CN102467728A (en) | Multi-party transaction system and transaction method | |
| CN105930174B (en) | A kind of graphical page program comparison in difference method and system | |
| US10963963B2 (en) | Rule based hierarchical configuration | |
| CN110389998A (en) | Build the quick composing exes of project, system and computer readable storage medium in pricing | |
| CN105404501B (en) | Rule base analytic method and system based on SAP platform | |
| CN103327123A (en) | File synchronization method, client, server side and equipment | |
| CN102857949A (en) | Method and device for planning data consistency guarantees | |
| CN104700187A (en) | Bill generation method | |
| CN106844490A (en) | The structuring of BIM non-geometry information databases and the method and system for interacting | |
| CN106156187A (en) | Content search method and searching system | |
| CN106503162B (en) | SAP platform based page dynamic generation method and system | |
| Somsuk et al. | Determining and classifying drivers of sustainable competitive advantages in green supply chain management: Resource-based and relational views | |
| Abd Rahman et al. | Establishment of traceability practices through halal assurance system (HAS) implementation | |
| CN106202106A (en) | Method and system is recommended in a kind of efficient data analysis | |
| CN103874100A (en) | Dynamic configuration method for operator business dial testing system based on rule engine | |
| Yu et al. | A study on the effect of yield uncertainty in price-setting newsvendor models with additive-multiplicative demand | |
| CN105404442B (en) | Selection screen configuration method and system based on SAP platforms | |
| Weisman | Safe harbor input prices and market exclusion | |
| Gómez-Gasquet et al. | A makespan minimization in an m-stage flow shop lot streaming with sequence dependent setup times: Milp model and experimental approach | |
| CN108984204A (en) | A kind of amending method of embedded equipment association definite value | |
| Kumar et al. | Challenges for Effective and Efficient Supply Chain Management for Fast Moving Electrical Goods (FMEG): A Case Study | |
| Sanyal et al. | Burning the midnight oil: Transmission of edible oil import tariffs along supply chain in India | |
| Del Valle et al. | A systems study on the vermicast production of Kahariam Reality and Farms, Inc. |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20190201 Termination date: 20200924 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |