2 fields to the extractor ?

[Former Member]

Hello BW Experts,

We have an infocube up and running in production for couple of years, now have to add 2 fields in the extractor which are part of standard extractor 2lis_02_itm. We do not need the history data for the 2 fields added. We need the data for the two new fields going forward.

I am trying to find the procedure / sequence in to carry out in production envionment. Please correct me if i am wrong or missing something.

1) check if there are luws in rsa7 for 2lis_02_itm, then run the delta in bw two times ( 2 times just to make sure that we did not miss anything ).

2) deactivate the v3 update for 2lis_02_itm or all active Purchasing extractors ???

3) delete the logs lbwf for Purchasing

4) do we need to delete the setup tables in our case ???

5) do we need to lock the users in case we are not deleting the setup tables ???.

6) any to do in sm13 or sm14 ???

7) maintain the extract structure

😎 maintain the datasource

9) replicate the datasource

10) activate the extract structure

11) since we do not need the history i hope it is okay for not deleting or reloading the setup tables.

12) activate the v3 update for 2lis_02_itm.

13) activate the v3 update for other purchasing extractors (in case we have deactivated them in the above step 2)

wondering if any one has a document listing the things to be done in any document, that you guys followed in production, it would be of great help to me.

Any suggestions appreciated.

Thanks,

BWer

[Former Member · Accepted solution]

Hi,

There is some discussion has happen on this topic...

Please find the following link

Regards,

PRK

[Former Member · Accepted solution]

PRK,

the case they are discuss is regarding if the new objects have to be filled for the records which are already present in the cube. but in my requirement new objects need to be filled going forward.

Please suggest..

Thanks,

BWer

[Former Member]

Hi BWer,

1. First run job of V3 update at r/3 side and then do delta update that data in to bw after this delete initialization data source from T.code RSA7.

2. Deactivate the v3 update and modify your extract structure.

3. Hope if you had done 1st this against it's no need to deletion from LBWF

4. I need to check it out

5. no need to lock any users because you all ready deactivated the update methods at r/3.

6. No.

7. Yes.

8. Yes

9. Yes

10. Yes.

11. I need to check

12. Hope V3 update for all Extract structure

13. Yes

Regards,

PRK

[Former Member]

Thanks PRK,

in the step 2) do we need to deactivate all the v3 updates for the purchasing extractors or is it okay just to deactivate v3 update for the datasource 2lis_02_itm

Regards,

BWer

Message was edited by: BWer

[Former Member]

Hi,

Please give more inforamation weathere you are writing a user exit for thoese two new fields.

Regards,

PRK

[Former Member]

no user exit the fields are part of the standard extractor, before they were not selected in the maintain extractor structure in lbwe

[Former Member]

Hi,

Regarding your steps..

3. After deleting the log please update thoese records through T.code sm13.

Regards,

PRK

Message was edited by: PRK