Promotion of modified LO Datasources to production.
We had noticed that the field shipping condition in the Delivery Note Lineitems ODS was not being populated since 23/Feb/2010.
On further analysis we realized that there were some changes made, as a result of which, the mapping for this field in the transfer rules were no longer present. This field alsp does not appear in the extract structure for the dataource in BW. In R3, though present, this field does not appear to be active in the structure for the extractor ( for datasource 2LIS_12_VCITM- direct delta) in LBWE.Though the datasource appears green - trying to reactivate throws the following error:
Units field WAERK for field NETPR of DataSource 2LIS_12_VCITM is hidden
Units field WAERK for field OIFEETOT of DataSource 2LIS_12_VCITM is hidden
Units field WAERK for field OITAXINV of DataSource 2LIS_12_VCITM is hidden
Units field WAERK for field OITAXISS of DataSource 2LIS_12_VCITM is hidden
Units field WAERK for field OITAXLOD of DataSource 2LIS_12_VCITM is hidden
We plan to remove these fields from the extract structure( since we dont need them) and reactivating the datasource in R3, replicating and mapping the VSBED (shipping condition) field.
When promoting these changes to production:
In R3 - we would need to promote the active datasource with the fields WAERK,NETPR,OIFEETOT,OITAXISS and OITAXLOD removed, when users are locked out of the system.
In BW we would transport the datasource and transfer rules. All ongoing loads would now have the shipping condition field filled. For historic loads since 23/Feb/2010 we would need to do a full repair - after having deleted and filled the setup tables with documents created since 23/Feb/2010 till date.
Please advise whether our approach is correct.