SAP BW如何避免增强的字段失去增量机制
- 格式：docx
- 大小：328.97 KB
- 文档页数：5
How 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 Name
We 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 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
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 doesn't 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 and copy the Original Data and activate it.
We create one DSO to store these two data Source data , that also can avoid the Delta update disable occurring .。
