Introduction:
This document describes the important procedure which is required in performing the reconstruction of the Lost/missing queues (LBWQ) for the Logistics applications.
In our day to day activities we might having issues with the queues where some of the queues might be missing for several reasons like Database error, Problems with RFC, an Accidental deletion of queue Or some other reasons..
Document explains the procedure to retrieve the missing data from the queues without needing the re-initialization and the down time.
SAP has delivered a transaction - LBWR and table – MCEX_DELTA_BACK in order to support this functionality with the OSS - Note 1008250 .
Procedure Steps:
Start the transaction – LBWR
i] Enter the name of the application for which the backup needs to be considered. Update the section as MCEX<nn> where nn stands for Application number. If the application is Purchasing then use the Queue name as MCEX02 for Sales MCEX11 and etc.,
ii] Use “Customizing Changes Only” in the Reconstruction Extraction Queue section. Initially the customization is required to update the tables in order to update the back-up tables.
iii] Under Customizing section fill the below entries -
- No. of Collective Processing
- No. of Days with the Backup Data
For Example:
If you enter -
If the periodicity of the collective runs changes, this period can also change. However, it always amounts to at least two days because of the setting for BACKUP_DAYS.
Settings can be viewed using the report - RMBWV3RE as well.
Note: If a value for BACKUP_DAYS (number of days for which the backup data is to be retained) was also defined, the larger number of entries in the backup table is retained.
Reconstructing the data:
Execute the report - RMBWV3RE or the transaction LBWR.
Update the processing Mode as – 'Reconstruct the Queue from the Backup Table'.
Update the Time stamp or the No. Coll. Processing’s to be extracted from Backup tables to the queue and press F8 based on the initial analysis of which data is missing in the target systems in order avoid duplicates in BW.
OR
Say Yes to the below message.
This will bring the data for the last 4 days due to the number of collective runs (assuming the collective run has 1 hr periodicity)
Once done, check the update in LBWQ
The Queue name is marked as MCEX12_BACK which represents that this has come from the Backup tables of the reconstruction tables.
With the execution, the entries from the backup table has come to the LBWQ which can further used to push the data to the Delta Queue once the V3 runs.
Entries from the MCEX12_BACK.
This will be moved to RSA7 for further extraction to BW.
Display data from the backup tables:
You can view the data in LBWR transaction with the below settings -
Select the kind of data to be viewed either Header, Item or schedule line in the given list and you can choose the number of records for the output and then hit the results:
Entry from Backup table:
Precautions:
Applications in Scope:
1. All logistics application. Initially the feature was not available for Global Trade Management (46) but the same has been updated with the OSS Note – 1570406.
Reference Notes:
1. Note 1570406 - GTM: Backup table for queue MCEX_46
2. Note 1008250 - Backup table for the queues of logistics extraction into BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 |