sap bw如何避免增强的字段失去增量机制

《sap bw如何避免增强的字段失去增量机制》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、HongtianZhangeditedOn2012-08-14HowtoavoidthestandarddeltafunctiondisabledwhenwewanttoenhancenewfieldintheECCside?NowItakeonefieldasoneexampleasbelow:OurBWTeamreceivedonerequirementthatweneedaddonenewfieldinthestandardtablevizVBAKinECCside.WhenwelogonthesystemandInputT-code:se11andVBA

2、KtableNameWefindoutwehadenhancedthesetwofieldsinthestandardstructure.HongtianZhangeditedOn2012-08-14Sothatisourkeypointshowcanwekeepdeltaupdatecanbesuccessfulforthesetwonewaddedfields.Therearesomepointsneedtopayattentionasbelow:1.ForustokeepalldateaccurateandnomissinginProenvironment

3、,firstlyweneedcheckoutboundqueue,typeSMQ1.InthereyoucancheckallqueueiftheyarealreadyextractedbyzeroorthecolumnEntriesisstillfulfilledbydata.2.NextifwefoundalldataarestillfulfilledwithlotsofdataandweshoulddefinitelypushalldatatoDeltaqueue.InputLBWE.ClicktherelateddataSourceanddefineon

4、ejobtoexecuteandextractalldatafromoutboundqueuetoDeltaqueue.3.Afterexecuteallactionandturnbacktocheckoutboundqueueifithasbeenextractedtozero.Ifdone,thatisgreatandwecanreturntoBWsystemandextractalldatafromDeltaqueuefromECCside.HongtianZhangeditedOn2012-08-14Nowreturntoournormaltopican

5、ddiscusshowtokeepDeltaUpdateisavailablefornewaddedfields.Forourenhancementwecangottwokindsofsituations.ØOneisthattoenhanceonefieldormore,ifwedeterminetoenhanceonefiledintableVBAK,ifweobtainthisvalueofenhancedfieldbyselectingthestandardfieldinVBAK,thatisverygreatwecankeepthedeltaupdat

6、eenabledanyway.TableAField1Field2Field3Field4NewaddedFields(ColumnR)Eg.IfweaddedRfieldintheTableAbymakinguseofField1andField2andField3todetermineRField.Sointhiscase,Deltaupdatewillbestillavailableanyway.ØAnotheristhattoenhanceonefieldormore,ifwedeterminetoenhanceonefiledintableVBAK,i

7、fweobtainthisvalueofenhancedfieldbyselectingvaluefromanothertable,sothedeltaqueueisdisabledyoumustthinkofanothermethodtokeepdeltaextractingsuccessfully.TableAField1Field2Field3Field4NewaddedFields(ColumnR)TableBField1Field2Field3Field4Field5Eg.ifwewanttoenhanceRfieldinTableA,andwenee

8、dselectsomen