欢迎来到天天文库
浏览记录
ID:33977517
大小:358.27 KB
页数:5页
时间:2019-03-02
《sapbw如何避免增强的字段失去增量机制》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、HongtianZhangeditedOn2012-08-14HowtoavoidthestandarddeltafunctiondisabledwhenwewanttoenhancenewfieldintheECCside?NowItakeonefieldasoneexampleasbelow:OurBWTeamreceivedonerequirementthatweneedaddonenewfieldinthestandardtablevizVBAKinECCside.Whenwelogonthesyste
2、mandInputT-code:se11andVBAKtableNameWefindoutwehadenhancedthesetwofieldsinthestandardstructure.HongtianZhangeditedOn2012-08-14Sothatisourkeypointshowcanwekeepdeltaupdatecanbesuccessfulforthesetwonewaddedfields.Therearesomepointsneedtopayattentionasbelow:1.Fo
3、rustokeepalldateaccurateandnomissinginProenvironment,firstlyweneedcheckoutboundqueue,typeSMQ1.InthereyoucancheckallqueueiftheyarealreadyextractedbyzeroorthecolumnEntriesisstillfulfilledbydata.2.Nextifwefoundalldataarestillfulfilledwithlotsofdataandweshouldde
4、finitelypushalldatatoDeltaqueue.InputLBWE.ClicktherelateddataSourceanddefineonejobtoexecuteandextractalldatafromoutboundqueuetoDeltaqueue.3.Afterexecuteallactionandturnbacktocheckoutboundqueueifithasbeenextractedtozero.Ifdone,thatisgreatandwecanreturntoBWsys
5、temandextractalldatafromDeltaqueuefromECCside.HongtianZhangeditedOn2012-08-14NowreturntoournormaltopicanddiscusshowtokeepDeltaUpdateisavailablefornewaddedfields.Forourenhancementwecangottwokindsofsituations.ØOneisthattoenhanceonefieldormore,ifwedeterminetoen
6、hanceonefiledintableVBAK,ifweobtainthisvalueofenhancedfieldbyselectingthestandardfieldinVBAK,thatisverygreatwecankeepthedeltaupdateenabledanyway.TableAField1Field2Field3Field4NewaddedFields(ColumnR)Eg.IfweaddedRfieldintheTableAbymakinguseofField1andField2and
7、Field3todetermineRField.Sointhiscase,Deltaupdatewillbestillavailableanyway.ØAnotheristhattoenhanceonefieldormore,ifwedeterminetoenhanceonefiledintableVBAK,ifweobtainthisvalueofenhancedfieldbyselectingvaluefromanothertable,sothedeltaqueueisdisabledyoumustthin
8、kofanothermethodtokeepdeltaextractingsuccessfully.TableAField1Field2Field3Field4NewaddedFields(ColumnR)TableBField1Field2Field3Field4Field5Eg.ifwewanttoenhanceRfieldinTableA,andweneedselectsomen
此文档下载收益归作者所有