sap数据抽取方法.docx

《sap数据抽取方法.docx》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、DevelopingSAPQueryforTaskListDataExtractionByShoyebAhamad,WiproInfotechPurpose:TocreateanSAPquerytoextracttasklistdatafromsystem.Scope:AlltasklistspertainingtoProductionandPlanning;Routing(N),MasterRecipe(2),RateRouting(R)Procedure: Followtheprocedurestepbystep: TransactionCodeS

2、QVIMenupathTools>Utilities>SQVI-QuickViewerCreatenewQuickview Writetheappropriatenameofquery Afteryouclickoncreatebutton,systemwillpopulatethefollowingwindow,completethedetailswithrightinformationOnceyouhavedonewithabovestepsyouwillget“ChooseDataSource”screen.Hereinthefollowings

3、tepyouneedtoconnectdifferenttablesproperlyinordertogettasklistdata.WearestartingwithMAPL(AssignmentofTaskListstoMaterials)table.Similarly,weneedtotakefollowingtablesinordertogettheappropriateinformation.PLKO(Tasklist–header)PLPO(Tasklist-operation/activity)PLAS(Tasklist-selectio

4、nofoperations/activities)CRHD(WorkCenterHeader)CRTX(TextfortheWorkCenterorProductionResource/Tool)MARA(GeneralMaterialData)MAKT(MaterialDescriptions) BetweenPLPOandCRHD,thedefaultlinkiswithfieldOBJTY.YouneedtodeletethislinkandcreatewithPLPO-ARBIDandCRHD-OBJID.ForthisclickonARBID

5、inPLPOtableanddragthecursortowardsOBJIDinCRHDtable.AfterwardsitshouldlikeAfteryoufinishwithaboveactivitiesthescreenwilllooklike Followingtablesexplainthelinkdetailsbetweendifferenttablesusedabove:Table1MAPLTable2PLKOTable3MARAPLNTYPLNTY PLNNRPLNNR PLNALPLNAL MATNR MATNRPLKOPLAS 

6、PLNTYPLNTY PLNNRPLNNR PLNALPLNAL PLASPLPO PLNTYPLNTY PLNNRPLNNR PLNKNPLNKN PLPOCRHD ARBIDOBJID CRHDCRTX OBJIDOBJID MARAMAKT MATNRMATNR Inthefollowingsteps,mainlyyouneedtoselectwhichfieldsyouwanttoseeinselectionscreenandwhichoneinoutput.BetweenPLPOandCRHD,thedefaultlinkiswithfiel

7、dOBJTY.YouneedtodeletethislinkandcreatewithPLPO-ARBIDandCRHD-OBJID.ForthisclickonARBIDinPLPOtableanddragthecursortowardsOBJIDinCRHDtable.AfterwardsitshouldlikeAfteryoufinishwithaboveactivitiesthescreenwilllooklike Followingtablesexplainthelinkdetailsbetweendifferenttablesusedabo

8、ve:Table1MAPLTable2PLKOTable3MARAPLNTYPLNTY PLN