LO Delta Extraction - 2LIS_11_VAITM

[Former Member]

Hi,

Currently we are using the SAP BW sales cube, which uses the standard 2LIS_11_VAITM as the BW data source, but due to the change in user requirements, we need to add 2 more extra fields (from SD contract table - VEDA) into the existing standard data source i.e 2LIS_11_VAITM.

Please let me know the procedure for adding the same.

Errors Encountered by Me are:-

1) Entries for application 11 still exists in extraction queue (message number MCEX 151)

2)End Phase 002 (message number D0 322)

Thanks & Regards

Rajiv

[Former Member]

Are you doing this is in development system. If yes then do an infopackage with no data transfer and delet the init package and this will clear the queue.

Do your enahancement and delete the setup tables again and then do the rerun and it shoudl work.

thanks

amit

[GFV]

We added some R/3 fields to the same Extractor following the procedure indicated in OSS Note 328181 "Changes to extract structures in Customizing Cockpit", and we had no problems. The complete procedure should be:

1. Stop postings in R/3

2. Execute RMBWV311

3. Load data in BW (so as not to loose pending changes)

4. De-Activate Job Control (set Update INACTIVE)

5. Modify Extract Structure (Import Changes from Quality)

6. Replicate DS

7. Modify InfoSource, Update, ... in BW

8. Execute Delta

9. Re-Start postings in R/3

Be aware that this way (without reloading the Cube, so new set-up, init and so on) previous recorded values will have "#" value ...

Hope it helps

GFV

[Former Member]

Thanks for ur help..

can you please provide more details on these steps along with transaction code & flow..

I am first trying on development server..so i guess there is no need to stop posting in R/3. please clarify.

Please help..

Rajiv

[GFV]

TCode to manage the Extractor is LBWE on R/3 side. Before executing Delta execute Report RMBWV311 (always in R/3) ... On BW side nothing particular.

Remember to stop postings: without this procedural step you will loose data ...

Search between Weblogs (on SDN): there are 3 good articles by Roberto Negro about LO Delta handling!

Hope it helps

GFV

[Former Member]

1.Do delta init without data transfer. That will pull all the records to the current into BW and this should clear the extracton queue.

2. Delte the init infopackage and this will clear the entry from RSA7.

3. Go to SE11 and select the structure MCV11VAOITM.

4. Click on append structure and the system will suggest and append. Click on ok.

5. Add the field name and data element if required together with the table from where you want.

6. Go to SE37 and type exit_saplrsap_001.

7. Write your abap code and activate.

8.Go to datasource and you will see the fields on the right hand side and it will ask for customizing request.

9. Go to maintenance and pull the fields from left to right hand side.

10. Go to RSA6 and remove the tick marks on the hide and last row , so that it shows on the datasource.

11.Go and delete the setup tables.

12. Reload the data.

13. Go to Bw and replicate the datasources.

You should see the fields.

Let me know if you need anything else.

thanks

amit

[Former Member]

Thanks Amit,

I have resolved the issue with ur given help on time..

Thanks a lot

Rajiv