sap推薦樣例word版-資料下載頁
2025-08-21 16:37本頁面
【正文】 = vbfavbeln Performance: Customer developments in PP and PM SAP Note Number 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, RESBAdditional key wordsCause and prerequisitesThe 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..:SELECT aufnr FROM resb WHERE rsnum = afkorsnumSELECT ..... FROM afko WHERE aufnr = resbaufnrTo increase the performance you should define a selection view on the corresponding tables (here: resb and afko) to bine the accesses to both table into one.Solution1. Access to order confirmation (table AFRU)a) Search for confirmation of orders (field AFRUAUFNR):Incorrect:SELECT FROM afru WHERE aufnr = ...Correct:SELECT aufpl FROM afko WHERE aufnr = afruaufnrSELECT rueck FROM afvc WHERE aufpl = afkoaufpl SELECT ..... FROM afru WHERE rueck = afvcrueckCaution: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 AFKORSNUM。 CAUFVRSNUM):Incorrect:SELECT FROM afko WHERE rsnum = ... Correct:SELECT aufnr FROM resb WHERE rsnum = afkorsnumSELECT ..... FROM afko WHERE aufnr = resbaufnrNote:The same access path applies to CAUFV and AUFK.Search for sales orders (tables VBAPVBELN, VBAPPOSNR。 VBFAVBELN, VBFAPOSNN。 and so on.)Incorrect:SELECT FROM AUFK WHERE KDAUF = VBAPVBELNAND KDPOS = VBAPPOSNRCorrect:SELECT FROM AFPO WHERE KDAUF = VBAPVBELNAND KDPOS = VBAPPOSNRSELECT FROM AUFK WHERE AUFNR = AFPOAUFNR.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 RESBAUFNR):Incorrect:SELECT FROM resb WHERE AUFNR = ...Correct:SELECT rsnum FROM afko WHERE aufnr = resbaufnrSELECT ..... FROM resb WHERE rsnum = afkorsnum Note:The same access path applies to MDRS and ATP_RESB.b) Search for reservation for Planned orders (field RESBPLNUM):Incorrect:SELECT FROM resb WHERE PLNUM = ... Correct:SELECT rsnum FROM plaf WHERE plnum = resbplnumSELECT ..... FROM resb WHERE rsnum = plafrsnumNote:The same access path applies to MDRS and ATP_RESB.Source code corrections
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1