資源描述：
《《sap推薦樣例》word版》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在應(yīng)用文檔-天天文庫。
1、Performance:MMPPSDPerformance:CustomerdevelopmentsinMM/WMSAPNoteNumber??SymptomCustomer-specificprogramsandprogramenhancements("userexits")haveapoorperformance.ThepoorperformancewasobservedwhenthefollowingSAPMM/WMtableswereaccessed:MSEG,LTAP,EBAN,RSEG.Ad
2、ditionalkeywordsCauseandpreconditionsHowever,notethefollowingwarnings:·Beforeyouproductivelyusethealternativesproposedhere,youmustcarefullycheckyourprogramwithrespecttofunctionalcorrectness.Payattentiontothefollowingnote:Inthefollowingexamplesyoucanoften
3、findaccessestoseveraltablesExample:SELECT*FROMLEINWHERE=...SELECT*FROMLTAPWHERELGNUM=LEIN-LGNUMandTANUM=LEIN-BTANR...Itmightbemorefavorable,withregardtotheperformance,todefineaselectionviewonthecorrespondingtables(here:LEINandLTAP)inordertocombineaccesse
4、stothesetwotablesinoneaccess.Solution1.Accessestotransportrequestsa)viathestorageunitnumberIncorrect:SELECTFROMLTAPWHEREVLENR=....oderSELECTFROMLTAPWHERENLENR=...Correct:SELECTFROMLEINWHERELENUM=...SELECTFROMLTAPWHERELGNUM=LEIN-LGNUMandANDTANUM=LEIN-BTAN
5、RANDTAPOS=LEIN-BTAPS.b)viatheSDdeliverynoteIncorrect:SELECTFROMLTAPWHERENLPLA=LIPS-VBELNANDPOSNR=LIPS-POSNR.Correct:SELECTFROMVBFAWHEREVBELV=LIPS-VBELNANDPOSNV=LIPS-POSNRANDVBTYP_N='Q'.SELECTFROMLTAPWHERELGNUM=LIPS-LGNUMANDTANUM=VBFA-VBELNANDTAPOS=VBFA-P
6、OSNN.Remark:ThisaccessmodeonlyexistsifthetransportorderswerecreatedonaccountofdeliveriesinSalesandDistribution.InthiscasetherespectivetransportorderscanbedeterminedviathedocumentflowtableVBFA.ThefieldLTAP-NLPLAisfilledwiththedeliverynotenumberviathedynam
7、icstoragebinassignment.ThisautomaticassignmentcanbedeactivatedinWMCustomizing(seemovementtypesinWMS).ThissideeffectmustbeconsideredwhenfieldNLPLAisusedfordataselection.2.Accesstomaterialdocumentsa)viathepurchaseordernumberIncorrect:SELECTFROMMSEGWHEREEBE
8、LN=...andEBELP=...Correct:SELECTFROMEKBEWHEREEBELN=..ANDEBELP=...ANDVGABEIN(1,6,7,8,9).SELECTFROMMSEGWHEREMBLNR=EKBE-BELNRANDMJAHR=EKBE-GJAHRANDZEILE=EKBE-BUZEI.Remark:Thefiscalyearmustbespecifiedsothatthesystemhaseffectiv
