SAP ABAP IMG Activity BW_DELTAQUEUE (Check Delta Queue)
Hierarchy
☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ BC-BW (Application Component) BW Service API
     ⤷ RSAI (Package) Release-Dependent Objects for OLTP IMG
IMG Activity
ID BW_DELTAQUEUE Check Delta Queue  
Transaction Code S_AX7_53000019   IMG Activity: BW_DELTAQUEUE 
Created on 20000612    
Customizing Attributes BW_DELTAQUEUE   Check Delta Queue 
Customizing Activity BW_DELTAQUEUE   Check Delta Queue 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name BW_DELTAQUEUE    

The delta queue is a data store in the source system, in which data records are either written automatically using an update process (for example, with FI documents) or by extraction using a function module following a data request from BW (for example, LIS extraction for BWs earlier than BW 2.0).

The data records are transferred from the BW scheduler into BW when a delta request takes place.

The data is compressed in the delta queue. It can be requested by more than one BW system. The delta queue can also be repeated, meaning that data from the most recent extraction process is stored in the delta queue. The repeat mode of the delta queue is target system-specific.

If changes have been made to the extract structure of a DataSource between writing the data to the delta queue and reading the queue data (for example, as a result of an upgrade) you can see from the data stored in the queue which structure the changes have been written to in the delta queue. In the queue monitor, fields that were previously empty, are now filled, and previously filled fields are now empty.

In this step you examine the delta queue.

Activities

The status symbol indicates whether the update in a delta queue is activated for a DataSource. If the status symbol is green, the delta queue is activated, meaning it is filled with data records when an update process or a data request from BW is running. A prerequisite for the delta update is the successful completion of the delta process initialization in the BW scheduler.

Displaying data records

  1. To check whether and how many data a delta queue contains, select the delta queue and choose Display data records.
  2. You get to a dialog box where you to specify how you want the data records to be displayed.
    1. You can choose the data packets containing the data records that you want to see.
    2. You can choose to display particular data records in a data packet.
    3. You can use a simulation of the extraction parameters to choose how you want the data records displayed.
  3. Choose Execute to display the data records.

Displaying current status of the delta-relevant field

For DataSources that support generic delta, you can display the current value of the delta-relevant field in the delta queue. In the column, choose Detail to do this. The value displayed contains the largest value of the delta-relevant field for the last extraction. It acts as the lower limit for the next extraction.

Refresh

If you choose Refresh,

  1. recently activated delta queues are displayed,
  2. data records recently written to the delta queue are taken into account, and
  3. data records that were deleted when reading the data records are no longer displayed.

Deleting queue data

If you want to delete the data in a delta queue for a DataSource, select the delta queue, and choose Delete Data from the context menu (right mouse-click).

If you delete the data in a delta queue, you do not have to reinitialize the delta process before you are able to write the data records of the DataSource to the delta queue.

Note:
Please note that data that has not yet been read from the delta queue is also deleted. This invalidates an existing delta update. Use this function only if you are aware of the consequences this will have.

Deleting queues

You delete the entire queue by choosing Queue -> Delete Queue. To write data records from the corresponding DataSource into a delta queue, you need to reinitialize the delta process.

Business Attributes
ASAP Roadmap ID 201   Make global settings 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
IMGDUMMY D - Dummy object RSA7 Check Delta Queue 
History
Last changed by/on SAP  20000612 
SAP Release Created in