Skip to Content

Applies to:

SAP NetWeaver Business Warehouse (formerly BI). This has been tested and working fine on SAP BI 7.0 version.

Applicable for other BW versions as well.

Summary :

This document will show how the MCEX queues are cleared by the V3 jobs and move the data to RSA7 (Bw Delta Queue).

Author: Arpit Khandelwal.

Company: Accenture Services Pvt. Ltd.

Author Bio:

apk.PNG

Arpit Khandelwal is a SAP BI Consultant currently working with Accenture Services Private Limited. He has 2.7 years of experience in  BW/BI implementation and support projects. He has been particularly involved in SAP BW Archiving Activities. Major area of work involves with the extraction of R/3 data from LO and FI datasources.



Basic Scenario ::


Basically the new system which has been handed to you has lot of data already in MCEX queues. This data needs to be pulled in BW system after the loading of Historical data via set-up tables.



Initially, we have the following records in SMQ1 (Outbound Queue).


/wp-content/uploads/2014/02/111_379913.png

To run the V3 job, go to LBWE ; click on Job Control.


112.JPG


Click on Start Date.

113.JPG


Select the next option as per requirement. In our case, we went for immediate.

114.JPG


Check and save the setting. Now click on Print Parameters option and assign the Local Printer for the printing.

It will show a warning but you can click to proceed ahead.


115.JPG




Click on Schedule job toschedule the V3 job. In our case, it was done for Plant Maintenance flow (17).

Showing the three phases of the job run to showcase the movement of data from MCEX queue to RSA7 queue.


Phase 1::


/wp-content/uploads/2014/02/116_379930.png


Phase 2::


/wp-content/uploads/2014/02/117_379934.png


Phase 3 ::


/wp-content/uploads/2014/02/118_379936.png

Through observing the three phases we come to know that MCEX queue will be always receiving some amount of data anytime because user postings are not stopped in the system.


When the V3 job is initiated, it will start with that moment for the number of records in the MCEX queue and start pulling the records from the MCEX queue to RSA7 queue.


Once the job gets completed, there will be gradual rise in the LUW’s available in the RSA7 by the data moved from the MCEX queue which in turn will keep the MCEX queue not overloaded. Ultimately, the data from RSA7 can be moved to BW (through delta loads).

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. M Tibollo

    this info is already available on the net. Multiple docs like this one  can be found. Next time check the content of SDN before posting a doc.

    Br,

    M.

    (0) 

Comments are closed.