Performance: Customer developments in PP/PM(摘自SAP Note 187906)

最新推荐文章于 2024-09-02 21:27:11 发布

原创最新推荐文章于 2024-09-02 21:27:11 发布 · 499 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#performance #sap #access #search #warnings #table

本文针对SAP系统中用户退出程序及增强程序性能不佳的问题，提供了优化建议。通过对关键物流表如AFRU、AFKO等的访问路径进行调整，可以有效提高系统运行效率。

Symptom

Customer 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, RESB

Additional key words

Cause and prerequisites

The R/3 System does not contain secondary indexes to the most important PP / PM flow tables.
To access them effectively you need a basic knowledge of the SAP data model. This notes contains information on the most important errors and provides alternatives.

However, note the following WARNINGS:
- Before you use the suggested alternatives check your program for functional correctness.

Pay attention to the following NOTES:
In the following examples, you often find accesses to several
e.g..:
SELECT aufnr FROM resb WHERE rsnum =
SELECT ..... FROM afko WHERE aufnr =
To increase the performance you should define a selection view on the corresponding tables (here: resb and afko) to combine the accesses to both table into one.

Solution

1. Access to order confirmation (table AFRU)

a) Search for confirmation of orders (field AFRU-AUFNR):
Incorrect:
  SELECT FROM afru WHERE aufnr = ...
Correct:
  SELECT aufpl FROM afko WHERE aufnr =
    SELECT rueck FROM afvc WHERE aufpl =
      SELECT ..... FROM afru WHERE rueck =
Caution:
From table AFVC, you receive one value per operation for "RUECK".

2. Access to PPS orders (tables AFKO, CAUFV, AUFK)

a) Find orders for reservation (field AFKO-RSNUM; CAUFV-RSNUM):
Incorrect:
  SELECT FROM afko WHERE rsnum = ...
Correct:
  SELECT aufnr FROM resb WHERE rsnum =
    SELECT ..... FROM afko WHERE aufnr =
Note:
The same access path applies to CAUFV and AUFK.
Search for sales orders (tables VBAP-VBELN, VBAP-POSNR; VBFA-VBELN, VBFA-POSNN; and so on.)
Incorrect:
  SELECT FROM AUFK WHERE KDAUF =
                    AND KDPOS =
Correct:
   SELECT FROM AFPO WHERE KDAUF =
                      AND KDPOS =
    SELECT FROM AUFK WHERE AUFNR = AFPO-AUFNR.
Note:
The tables AFKO and CAUFV can be selected analogously to the AUFK access using order number AUFNR.

3. Access to reservations and dependent requirement (table: RESB, MDRS ATP _RESB)

a) Search for reservation for PPS orders (field RESB-AUFNR):
Incorrect:
  SELECT FROM resb WHERE AUFNR = ...
Correct:
  SELECT rsnum FROM afko WHERE aufnr =
    SELECT ..... FROM resb WHERE rsnum =
Note:
The same access path applies to MDRS and ATP_RESB.

b) Search for reservation for Planned orders (field RESB-PLNUM):
Incorrect:
  SELECT FROM resb WHERE PLNUM = ...
Correct:
  SELECT rsnum FROM plaf WHERE plnum =
    SELECT ..... FROM resb WHERE rsnum =
Note:
The same access path applies to MDRS and ATP_RESB.

Trackback: http://tb.blog.youkuaiyun.com/TrackBack.aspx?PostId=1495008