Performance: Customer developments in PP/PM (from SAP note 187906)

Source: Internet
Author: User

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, resb Additional key words Cause and prerequisitesThe R/3 system does not contain secondary indexes to the most important PP/PM flow tables.
To access them extends tively 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 = <afko-rsnum>
Select... from afko where aufnr = <resb-aufnr>
To increase the performance you shoshould define a selection view on the corresponding tables (here: resb and afko) to combine the accesses to both table into one.Solution1. 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 = <afru-aufnr>
Select rueck from afvc where aufpl = <afko-aufpl>
Select... from afru where rueck = <afvc-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 = <afko-rsnum>
Select... from afko where aufnr = <resb-aufnr>
Note:
The same access path applies to caufv and aufk.
Search for sales orders (Tables VBAP-VBELN, VBAP-POSNR; VBFA-VBELN; and so on .)
Incorrect:
Select from aufk where kdauf = <VBAP-VBELN>
And kdpos = VBAP-POSNR>
Correct:
Select from afpo where kdauf = <VBAP-VBELN>
And kdpos = VBAP-POSNR>
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)) search for reservation for PPS orders (field RESB-AUFNR ):
Incorrect:
Select from resb where aufnr =...
Correct:
Select rsnum from afko where aufnr = <resb-aufnr>
Select... from resb where rsnum = <afko-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 = <resb-plnum>
Select... from resb where rsnum = <plaf-rsnum>
Note:
The same access path applies to mdrs and atp_resb.

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.