《sap推薦樣例》word版

《《sap推薦樣例》word版》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

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