SAP BW如何避免增强的字段失去增量机制.docx

Hongtian Zhang edited On 2012-08-14How to avoid the standard delta function disabled when we want to enhance new field in the ECC side ?Now I take one field as one example as below: Our BW Team received one requirement that we need add one new field in the standard table viz VBAK in ECC side.When we logon the system and Input T-code : se11 and VBAK table NameWe find out we had enhanced these two fields in the standard structure.So that is our key points how can we keep delta update can be successful for these two new added fields. There are some points need to pay attention as below:1. For us to keep all date accurate and no missing in Pro environment, firstly we need check outbound queue, type SMQ1. In there you can check all queue if they are already extracted by zero or the column Entries is still fulfilled by data.2. Next if we found all data are still fulfilled with lots of data and we should definitely push all data to Delta queue. Input LBWE. Click the related data Source and define one job to execute and extract all data from outbound queue to Delta queue.3. After execute all action and turn back to check outbound queue if it has been extracted to zero. If done, that is great and we can return to BW system and extract all data from Delta queue from ECC side.Now return to our normal topic and discuss how to keep Delta Update is available for new added fields. For our enhancement we can got two kinds of situations. One is that to enhance one field or more, if we determine to enhance one filed in table VBAK, if we obtain this value of enhanced field by selecting the standard field in VBAK, that is very great we can keep the delta update enabled anyway.Table AField1Field2Field3Field4New added Fields(Column R)Eg. If we added R field in the Table A by making use of Field1 and Field2 and Field 3 to determine R Field. So in this case, Delta update will be still available anyway. Another is that to enhance one field or more, if we determine to enhance one filed in table VBAK, if we obtain this value of enhanced field by selecting value from another table, so the delta queue is disabled you must think of another method to keep delta extracting successfully.Table AField1Field2Field3Field4New added Fields(Column R)Table BField1Field2Field3Field4Field5Eg. if we want to enhance R field in Table A, and we need select some necessary Field from Table B by using major key or something additional condition. This kind of situation we usually choose to another method to implement Delta Extracting . Detailed Method is as below:A. If BW side have one standard Data Source is corresponding to the table A, input RSA5. And then active the related Data Source.B. If our BW side doesnt have any standard Data Source to correspond to the Table B. we can create one customized Data Source to align the Table B. input RSO2 And once standard Data Source and Customized Data Source had been active and , you can turn on the BW administrator Workbench