19 SAP Performance
关注
分享
扫一扫
文章平均质量分 82
JackWu
安徽怀宁人高级程序员 系统分析员主要从事sap业务应用咨询，熟悉SD，BW，ABAP等模块（从业15年）
展开
-
1333417 - Performance problems when processing IDocs immediately
IDOC,ALE,EDI,SAP转载 2016-06-14 15:59:36 · 6727 阅读 · 0 评论 -
ABAP--两个提高ABAP代码效率的优化方法
一、利用内表缓冲减少数据库访问次数REPORT zmmi003.data: it_vbap type table of vbap,wa_vbap type vbap,it_makt type table of makt,wa_makt type makt.perform process.perform process_using_cursor.*&--------------------原创 2009-01-15 09:52:00 · 5399 阅读 · 3 评论 -
30个Oracle语句优化规则详解
1.选用适合的Oracle优化器Oracle的优化器共有3种：a.RULE(基于规则)b.COST(基于成本)c.CHOOSE(选择性)设置缺省的优化器，可以通过对init.ora文件中OPTIMIZER_MODE参数的各种声明，如RULE、COST、CHOOSE、ALL_ROWS、FIRST_ROWS。你当然也在SQL句级或是会话(session)级对其进行覆盖。转载 2009-01-13 13:33:00 · 12486 阅读 · 14 评论 -
ABAP--在查询条件只包含部分索引字段时，如何使用索引
One of the most important considerations when writing a select statement against a large table is the effective use of an index. However this is sometimes more easily said than done. Have you ever fou转载 2008-05-10 23:34:00 · 5016 阅读 · 0 评论 -
ABAP--如何快速从BSEG读取数据
由于bseg表很大，而且表的索引字段是：BUKRS - Company CodeBELNR - Accounting Document Number GJAHR - Fiscal Year BUZEI - Line Item Number 访问此表最佳的是包含所有的索引字段，但在实际应用是很少能达到的。但要有好的性能根据经验必须要有公司和凭证号作为查询条件。为了达到这一点，我可以根转载 2008-05-10 23:28:00 · 6546 阅读 · 1 评论 -
abap--一个改变程序性能的样例,给初学者一个编程的思路,请大家指点
Suppose you have the following program. What can you do to improve performance changing the fewest lines of code?tables: cooi, " Purchase Order Open Items ekbe.转载 2008-01-20 09:15:00 · 4176 阅读 · 0 评论 -
Improving Performance of FOR ALL ENTRIES QUERY
如何提高FOR ALL ENTRIES的查询性能主要从两个方面入手1 对FOR ALL ENTRIES的驱动表按比较关键字排序;2 删除FOR ALL ENTRIES的驱动表中比较关键字排序;REPORT ZEXIT_HELP no standard page heading.DATA: it_mara TYPE STANDARD TABLE OF mara,wa_mara TYP原创 2007-05-21 15:06:00 · 3031 阅读 · 0 评论 -
Performance: Customer developments in PP/PM(摘自SAP Note 187906)
SymptomCustomer programs and program enhancements ("user exits") have a bad performance. The bad performance can be seen when accessing the following SAP logistic tables:AFRU, AFKO, AUFK, CAUFV,转载 2007-01-26 16:38:00 · 3511 阅读 · 1 评论 -
Performance: Customer developments in SD(摘自SAP Note 185530)
SymptomCustomer-specific programs and program enhancements ("User Exits") have a bad performance. The bad performance is noticed during accesses to the following SAP SD tables: VBAK, VBAP, VMVA,转载 2007-01-26 15:25:00 · 7080 阅读 · 0 评论 -
Oracle SQL optimization(摘自SAP Note 766349)
Symptom1. What is SQL optimization?2. How important is SQL optimization?3. Which criteria are used to determine the load of an SQL statement?4. Where can I find information on the executed转载 2007-01-26 13:59:00 · 6163 阅读 · 0 评论 -
如何提高读取BSEG的性能（sap已清项和未清项的提取）
The FI-GL table BSEG, which is one of our biggest PR1 tables, is an example of a clustered table. At the database-level, there is no table called BSEG, but instead RFBLG is being used for the BSEG dat转载 2006-10-21 11:52:00 · 6070 阅读 · 0 评论 -
几个有用的SAP性能调整的NOTES连接
Work Processes [39412] How many work processes to configure [21960] Several instances/systems on one UNIX co原创 2006-08-07 16:41:00 · 3345 阅读 · 0 评论 -
如何调整ABAP程序的性能
1、使用where语句 不推荐 Select * from zflight. Check : zflight-airln = ‘LF’ and zflight-fligh = ‘BW222’. Endselect.推荐 Select * from zflight where airln = ‘LF’ and原创 2006-07-31 18:31:00 · 3901 阅读 · 3 评论